SnowPro-Core Free Practice Test

- (Exam Topic 3)
How would a user run a multi-cluster warehouse in maximized mode?

1. A. Configure the maximum clusters setting to "Maximum."
2. B. Turn on the additional clusters manually after starting the warehouse.
3. C. Set the minimum Clusters and maximum Clusters settings to the same value.
4. D. Set the minimum clusters and maximum clusters settings to different values.

Correct Answer: D

- (Exam Topic 1)
Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what? Select one.

1. A. More micro-partitions
2. B. Better query scheduling
3. C. Double the numbers of servers In the compute duster
4. D. Higher storage costs

Correct Answer: C

- (Exam Topic 2)
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

1. A. An FTP server with TLS encryption
2. B. An HTTPS server with WebDAV
3. C. A Google Cloud storage bucket
4. D. A Windows server file share on Azure

Correct Answer: C

- (Exam Topic 3)
Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

1. A. If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.
2. B. A Data Exchange allows groups of accounts to share data privately among the accounts.
3. C. A Data Exchange allows accounts to share data with third, non-Snowflake parties.
4. D. Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.
5. E. The sharing of data in a Data Exchange is bidirectiona
6. F. An account can be a provider for some datasets and a consumer for others.

Correct Answer: B

- (Exam Topic 1)
True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.

1. A. True
2. B. False

Correct Answer: B
Reference: https://blog.knoldus.com/ksnow-time-travel-and-fail-safe-in-snowflake/