- All Exams Instant Download
True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.
True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.A . TrueB . FalseView AnswerAnswer: A Explanation: Snowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and global services layers that are physically separated but logically integrated.
Which statements are true of micro-partitions? Choose 2 answers
Which statements are true of micro-partitions? Choose 2 answersA . They are approximately 16MB in sizeB . They are stored compressed only if COMPRESS=TRUE on TableC . They are ImmutableD . They are only encrypted in the Enterprise edition and aboveView AnswerAnswer: A,C Explanation: Reference: https://medium.com/weareservian/seeing-snow-for-the-first-time-snowflake-adventures-part-1-731ddc983c69
What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answers
What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answersA . On-premise availabilityB . SimplicityC . Open source basedD . ConcurrencyE . PerformanceView AnswerAnswer: B,D,E
What happens when a virtual warehouse is resized?
What happens when a virtual warehouse is resized?A . When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affectedB . When reducing the size of a warehouse the compute resources are removed only when they are no longer...
Which of the following statements are true about Schemas in Snowflake? (Choose two.)
Which of the following statements are true about Schemas in Snowflake? (Choose two.)A . A Schema may contain one or more DatabasesB . A Database may contain one or more SchemasC . A Schema is a logical grouping of Database ObjectsD . Each Schema is contained within a WarehouseView AnswerAnswer:...
Which type of table corresponds to a single Snowflake session?
Which type of table corresponds to a single Snowflake session?A . TemporaryB . TranslentC . ProvisionalD . PermanentView AnswerAnswer: A Explanation: Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist...
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
Which data types does Snowflake support when querying semi-structured data? (Select TWO)A . VARIANTB . ARRAYC . VARCHARD . XMLE . BLOBView AnswerAnswer: A,B Explanation: https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY. The maximum length of...
Which of the following describes how clustering keys work in Snowflake?
Which of the following describes how clustering keys work in Snowflake?A . Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.B . Clustering keys sort the designated columns over time, without blocking DML operationsC . Clustering keys create a distributed, parallel data structure...
Which of the following statements is true of data loading?
Which of the following statements is true of data loading?A . Resizing the virtual warehouse from x-Small to Small will process a single file twice as fastB . The "deal file size for loading is 16MB to match micro-partition sizeC . Marry files in the 10-lOOMB range tend to land...
Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answers
Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answersA . Their default role should be set to SYSTEMADMIN (the lower of the two)B . They should not set up multi_Factor Authentication (MFA)―as administrator they may need to change the MFA settings and those...
