True or False: The user has to specify which cluster a query will run on in a multi-cluster Warehouse.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

True or False: The COPY command must specify a File Format in order to execute.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

• A.SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
• B.The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
• C.A user cannot specify a default warehouse when using the ODBC driver.
• D.Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
• E.The default virtual warehouse size can be changed at any time.

Comment: *

Name: *

Email: *

Verification: *

True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

Which of the following are benefits of micro-partitioning? (Select TWO)

• A.Micro-partitions cannot overlap in their range of values
• B.Micro-partitions are immutable objects that support the use of Time Travel.
• C.Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
• D.Rows are automatically stored in sorted order within micro-partitions
• E.Micro-partitions can be defined on a schema-by-schema basis

Comment: *

Name: *

Email: *

Verification: *