SnowPro-Core Free Practice Test

- (Exam Topic 2)
Will data cached in a warehouse be lost when the warehouse is resized?

1. A. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
2. B. Ye
3. C. because the compute resource is replaced in its entirety with a new compute resource.
4. D. N
5. E. because the size of the cache is independent from the warehouse size
6. F. Ye
7. G. became the new compute resource will no longer have access to the cache encryption key

Correct Answer: A

- (Exam Topic 2)
Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

1. A. Each Snowflake account can be hosted in a different cloud vendor and region.
2. B. Each Snowflake account must be hosted in a different cloud vendor and region
3. C. All Snowflake accounts must be hosted in the same cloud vendor and region
4. D. Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

Correct Answer: B
https://docs.snowflake.com/en/user-guide/intro-regions.html

- (Exam Topic 1)
True or False: A single database can exist in more than one Snowflake account.

1. A. True
2. B. False

Correct Answer: B
Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html

- (Exam Topic 3)
How long is the Fail-safe period for temporary and transient tables?

1. A. There is no Fail-safe period for these tables.
2. B. 1 day
3. C. 7 days
4. D. 31 days
5. E. 90 days

Correct Answer: A
Reference: https://docs.snowflake.com/en/user-guide/tables-temp-transient.html

- (Exam Topic 1)
Which object allows you to limit the number of credits consumed within a Snowflake account? Select one.

1. A. Account usage Tracking
2. B. Resource Monitor
3. C. Warehouse Limit Parameter
4. D. Credit Consumption Tracker

Correct Answer: B
The time travel data retention can be overwritten at the table level "When creating a table, schema, or database, the account default can be overridden using the DATA_RETENTION_TIME_IN_DAYS parameter in the command."