Snowpro Certification Exam; Questions and Answers
Rated A+
Which of the following are true of Multi-Cluster warehouses? Select all that apply. Correct
Ans-1.) Adds clusters automatically based on query activity
3.) scales down when query activity slows
What is the recommended approach for making a variant column accessible in a BI tool?
Correct Ans-2.) A view
True or false: virtual warehouses cannot be resized when queries are running. Correct Ans-
2.) False
True or False: The warehouse cache may be reset if a running warehouse is suspended and
then resumed. Correct Ans-1.) True
What technique does Snowflake use to limit the number of micro-partitions scanned by each
query? Correct Ans-2.) Pruning
Which type of data integration tools leverage Snowflake's scalable compute for data
transformation? Select the best answer. Correct Ans-2.) ELT (not ETL)
, Snowpro Certification Exam; Questions and Answers
Rated A+
True or false: Snowflake offers tools to extract data from source systems. Correct Ans-2.)
False
The Snowflake metadata repository contains which of the following? Select all that apply.
Correct Ans-1.) Table definitions
2.) References to all of the micro partition files for that table.
3.) Tracking of all versions of the table data within the data retention window.
True or False: The Query Profiler view is only available for completed queries. Correct Ans-
2.) False
Which of the following techniques can be used in Snowflake to improve query performance?
Correct Ans-2.) Cluster Keys/Reclustering
True or false: Snowflake caches are automatically invalidated if the underlying data changes.
Correct Ans-1.) True
Rated A+
Which of the following are true of Multi-Cluster warehouses? Select all that apply. Correct
Ans-1.) Adds clusters automatically based on query activity
3.) scales down when query activity slows
What is the recommended approach for making a variant column accessible in a BI tool?
Correct Ans-2.) A view
True or false: virtual warehouses cannot be resized when queries are running. Correct Ans-
2.) False
True or False: The warehouse cache may be reset if a running warehouse is suspended and
then resumed. Correct Ans-1.) True
What technique does Snowflake use to limit the number of micro-partitions scanned by each
query? Correct Ans-2.) Pruning
Which type of data integration tools leverage Snowflake's scalable compute for data
transformation? Select the best answer. Correct Ans-2.) ELT (not ETL)
, Snowpro Certification Exam; Questions and Answers
Rated A+
True or false: Snowflake offers tools to extract data from source systems. Correct Ans-2.)
False
The Snowflake metadata repository contains which of the following? Select all that apply.
Correct Ans-1.) Table definitions
2.) References to all of the micro partition files for that table.
3.) Tracking of all versions of the table data within the data retention window.
True or False: The Query Profiler view is only available for completed queries. Correct Ans-
2.) False
Which of the following techniques can be used in Snowflake to improve query performance?
Correct Ans-2.) Cluster Keys/Reclustering
True or false: Snowflake caches are automatically invalidated if the underlying data changes.
Correct Ans-1.) True
