- (Exam Topic 1)
If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:

1. A. All Snowflake sessions using the warehouse are terminated.
2. B. The last query using the warehouse completes.
3. C. There are no users loaned into Snowflake.
4. D. The Warehouse is inactive for a specified period of time.

Correct Answer: D
Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

- (Exam Topic 3)
Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

1. A. Data is live, ready-to-query, and can be personalized.
2. B. Data needs to be loaded into a cloud provider as a consumer account.
3. C. Data is not available for copying or moving to an individual Snowflake account.
4. D. Data is available without copying or moving.
5. E. Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.

Correct Answer: AD

- (Exam Topic 1)
True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

1. A. True
2. B. False

Correct Answer: B
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

- (Exam Topic 3)
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

1. A. Optimizes the virtual warehouse size and multi-cluster setting to economy mode
2. B. Allows a user to import the files in a sequential order
3. C. Increases the latency staging and accuracy when loading the data
4. D. Allows optimization of parallel operations

Correct Answer: D

- (Exam Topic 2)
Which services does the Snowflake Cloud Services layer manage? (Select TWO).

1. A. Compute resources
2. B. Query execution
3. C. Authentication
4. D. Data storage
5. E. Metadata

Correct Answer: CE
https://docs.snowflake.com/en/user-guide/intro-key-concepts.html
The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different components of Snowflake in order to process user requests, from login to query dispatch. The cloud services layer also runs on compute instances provisioned by Snowflake from the cloud provider.
Services managed in this layer include:
Authentication
Infrastructure management
Metadata management
Query parsing and optimization
Access control