- (Exam Topic 3)
Users are responsible for data storage costs until what occurs?

1. A. Data expires from Time Travel
2. B. Data expires from Fail-safe
3. C. Data is deleted from a table
4. D. Data is truncated from a table

Correct Answer: B

- (Exam Topic 2)
Which data type can be used to store geospatial data in Snowflake?

1. A. Variant
2. B. Object
3. C. Geometry
4. D. Geography

Correct Answer: D
https://docs.snowflake.com/en/sql-reference/data-types-geospatial.html#:~:text=have%20SRID%3D4326.-,Geos

- (Exam Topic 1)
Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI)?
Choose 2 answers

1. A. SnowSQL
2. B. ODBC
3. C. R
4. D. HIVE

Correct Answer: AB
Reference: https://docs.snowflake.com/en/user-guide/connecting.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."

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