Snowflake - test 1

Question 1

What is the most effective way to test if clustering a table helped performance?

Answer 1

Run a sample query before clustering and after clustering to compare the results.
Explanation:
Snowflake also recommends that you test a representative set of queries on the table to establish some performance baselines.

Question 2

Please choose the correct statements about Micro-Partitions (Select 2)

Answer 2

Snowflake automatically determines the most efficient compression algorithm for the columns in each micro-partition.
Snowflake micro-partitions are derived automatically.
Explanation:
Snowflake takes care of all compression algorithms. Micro-partitions can overlap in their range of values, which, combined with their uniformly small size, helps prevent skew.
The micro-partitions are small in size (50 to 500 MB, BEFORE compression).

Question 3

What are the types of Caches?

Answer 3

Results Cache, Metadata Cache.
Also, Warehouse Cache. Warehouse cache gets purged on suspension.

Question 4

How often does Snowflake release new features?

Answer 4

Weekly

Question 5

Auto-suspend and auto-resume apply only to the entire warehouse and not to the individual clusters in the warehouse (T/F)

Answer 5

True.
TRUE for both types of STANDARD and MULTI-CLUSTER Warehouses. For a multi-cluster warehouse: - Auto-suspend only occurs when the minimum number of clusters is running and there is no activity for the specified period of time. The minimum is typically 1 (cluster), but could be more than 1. - Auto-resume only applies when the entire warehouse is suspended (i.e. no clusters are running).