Snowflake Certification study guide with correct answers

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 answers1) 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 answersMulti-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 answers1) 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