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.

September 8, 2022 No Comments READ MORE +

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

September 8, 2022 No Comments READ MORE +

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

September 8, 2022 No Comments READ MORE +

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...

September 8, 2022 No Comments READ MORE +

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:...

September 8, 2022 No Comments READ MORE +

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...

September 8, 2022 No Comments READ MORE +

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...

September 8, 2022 No Comments READ MORE +

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...

September 7, 2022 No Comments READ MORE +

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...

September 7, 2022 No Comments READ MORE +

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...

September 7, 2022 No Comments READ MORE +