Snowflake Certification study guide already graded A

Snowflake Certification study guide already graded A 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 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 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 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 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 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 2) A view True or false: A table in Snowflake can contain both a variant columns and a timestamp. 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 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 4) Thread size 1) Physical location of the Stage 3) Gzip compression efficiency Which of the following best describes Snowflake's processing engine? 1) Leverages Apache Spark 2) Based on Map Reduce 3) A derivative of Presto 4) Native SQL 4) Native SQL Which of the following are types of caching use by Snowflake? Select all that apply. 1) Warehouse caching 2) Index Caching 3) Metadata caching 4) Query result caching 1) Warehouse caching 3) Metadata caching 4) Query result caching True or false: You can point Snowflake at any S3 bucket to