- (Exam Topic 1)
True or False the longer the data retention period, the higher the resulting storage costs.

1. A. True
2. B. False

Correct Answer: A

- (Exam Topic 2)
Which command can be used to stage local files from which Snowflake interface?

1. A. SnowSQL
2. B. Snowflake classic web interface (Ul)
3. C. Snowsight
4. D. .NET driver

Correct Answer: A
https://docs.snowflake.com/en/user-guide/snowsql-use.html

- (Exam Topic 2)
What features does Snowflake Time Travel enable?

1. A. Querying data-related objects that were created within the past 365 days
2. B. Restoring data-related objects that have been deleted within the past 90 days
3. C. Conducting point-in-time analysis for Bl reporting
4. D. Analyzing data usage/manipulation over all periods of time

Correct Answer: B
Snowflake Time Travel enables accessing historical data (i.e. data that has been changed or deleted) at any point within a defined period. It serves as a powerful tool for performing the following tasks:
Restoring data-related objects (tables, schemas, and databases) that might have been accidentally or intentionally deleted.
Duplicating and backing up data from key points in the past.
Analyzing data usage/manipulation over specified periods of time.
https://docs.snowflake.com/en/user-guide/data-time-travel.html

- (Exam Topic 3)
How does Snowflake Fail-safe protect data in a permanent table?

1. A. Fail-safe makes data available up to 1 day, recoverable by user operations.
2. B. Fail-safe makes data available for 7 days, recoverable by user operations.
3. C. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
4. D. Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

Correct Answer: C

- (Exam Topic 3)
Which data type can store more than one type of data structure?

1. A. JSON
2. B. BINARY
3. C. VARCHAR
4. D. VARIANT

Correct Answer: D