Snowflake Certification study guide question and answers latest 2023

Snowflake Certification study guide question and answers latest 2023 Which of the following are true of Multi-cluster warehouses? Select all that apply. 1) Adds clusters automatically based on query activity 2) Sizes each cluster optimally based on the queries 3) Scales down when query activity slows 4) Multi-cluster warehouses will never auto-suspend - correct answer 1) Adds clusters automatically based on query activity 3) Scales down when query activity slows Which of the following terms best describes Snowflake's data base architecture? 1) Columnar shared nothing 2) Shared disk 3) Multi-cluster shared data 4) Cloud-native shared memory - correct answer Multi-cluster shared data Which of the following are true about the variant data type in Snowflake? Select all that apply 1) Optimized storage based on repeated elements 2) Stored in a separate file format from structured data 3) Can be queried using JSON path notation 4) Requires a custom mapping for each record type - correct answer 1) Optimized storage based on repeated elements 3) Can be queried using JSON path notation Which type of Data Integration tools leverage Snowflake's scalable compute for data transformation? Select the best answer. 1) Database Replication 2) ELT 3) ETL 4) Streaming - correct answer 2) ELT What is the maximum number of consumer accounts that can be added to a Share object? 1) One 2) Unlimited 3) 10 4) 100 - correct answer 2) Unlimited What is the recommended approached for making a variant column accessible in a BI tool? 1) A pre-defined mapping 2) A view 3) Leveraging a JSON parser 4) There is no way to do this - correct answer 2) A view True or false: A table in Snowflake can contain both a variant columns and a timestamp. - correct answer TRUE What technique does Snowflake use to limit the number of micro-partitions scanned by each query? 1) Indexing 2) Pruning 3) Map Reduce 4) B-Tree - correct answer 2) Pruning The following factors affect data load rates: (select all that apply) 1) Physical location of the Stage 2) RAM on the Virtual Warehouse 3) Gzip compression efficiency