Snowflake Certification study guide || 100% Solved Correctly.

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 answers 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 answers 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 answers 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 answers 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 answers 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 answers 2) A view