QUESTION: 249

A sales table FCT_SALES has 100 million records.
The following query was executed:
SELECT COUNT (1) FROM FCT_SALES;
How did Snowflake fulfill this query?

Query against the result set cache
Query against a virtual warehouse cache
Query against the most-recently created micro-partition
Query against the metadata cache

Answer(s): D

Reveal Solution Next Question

QUESTION: 250

What happens when a virtual warehouse is resized?

When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected.
When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
Users who are trying to use the warehouse will receive an error message until the resizing is complete.

Answer(s): B

Reveal Solution Next Question