snow7

In which layer of its architecture does Snowflake store its metadata statistics?

• Storage Layer

• Compute Layer

• Database Layer

• Cloud Services Layer

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

• Customers can change the size of the Warehouse after creation

• A Warehouse can be resized while running

• A Warehouse can be configured to suspend after a period of inactivity

• A Warehouse can be configured to auto-resume when new queries are submitted

Which statements are true of micro-partitions? (Choose two.)

• They are approximately 16MB in size

• They are stored compressed only if COMPRESS=TRUE on Table

• They are immutable

• They are only encrypted in the Enterprise edition and above

A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)

• The exact query will ALWAYS return the precomputed result set for the RESULT_CACHE_ACTIVE = time period

• The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within previous 24 hour period

• The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous 24 hour period

• The €24ג hourג€ timer on the precomputed results gets renewed every time the exact query is executed

Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

• Scaling rhythmically

• Scaling max

• Scaling out

• Scaling up

If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

• 4

• 16

• 32

• 3

Which of the following statements is true of zero-copy cloning?

• Zero-copy clones increase storage costs as cloning the table requires storing its data twice

• All zero-copy clone objects inherit the privileges of their original objects

• Zero-copy cloning is licensed as an additional Snowflake feature

• At the instance/instant a clone is created, all micro-partitions in the original table and the clone are fully shared

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

• Configure the Maximum Clusters setting to ‘Auto-Scale’

• Set the Warehouse type to ‘Auto’

• Set the Minimum Clusters and Maximum Clusters settings to the same value

• Set the Minimum Clusters and Maximum Clusters settings to the different values

Which of the following are options when creating a Virtual Warehouse? (Choose two.)

• Auto-drop

• Auto-resize

• Auto-resume

• Auto-suspend

Fail-safe is unavailable on which table types? (Choose two.)

• Temporary

• Transient

• Provisional

• Permanent