Free Snowflake SnowPro-Core Exam Dumps Questions & Answers

Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?

• A.Query pruning
• B.Caching
• C.Cluster depth
• D.Retrieval optimization

At what level is the MIN_DATA_RETENSION_TIME_IN_DAYS parameter set?

• A.Schema
• B.Database
• C.Table
• D.Account

Which Snowflake table supports unstructured data?

• A.Transient
• B.Permanent
• C.Directory
• D.Temporary

A user has unloaded data from Snowflake to a stage
Which SQL command should be used to validate which data was loaded into the stage?

• A.verify @file__stage
• B.show @file__stage
• C.view @file__stage
• D.list @file__stage

Which of the following describes how clustering keys work in Snowflake?

• A.Clustering keys sort the designated columns over time, without blocking DML operations
• B.Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.
• C.Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time
• D.Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns