SnowPro-Core Free Practice Test

- (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/

- (Exam Topic 1)
What is the minimum duration charged when starting a virtual warehouse?

1. A. 1 second
2. B. 1 minute
3. C. 1 hour
4. D. 1 day

Correct Answer: B

- (Exam Topic 2)
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

1. A. True
2. B. False

Correct Answer: A
You can experiment the same with snowflake UI.

- (Exam Topic 1)
True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

1. A. True
2. B. False

Correct Answer: A
Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html