- (Exam Topic 3)
What happens to historical data when the retention period for an object ends?

1. A. The data is cloned into a historical object.
2. B. The data moves to Fail-safe
3. C. Time Travel on the historical data is dropped.
4. D. The object containing the historical data is dropped.

Correct Answer: D

- (Exam Topic 1)
Which of the following commands sets the Virtual Warehouse for a session?

1. A. COPT WAREHOUSE FROM <<Config file> ;
2. B. SET warehouse = <<warehouse name>>;
3. C. USE WAREHOUSE <<warehouse name>>;
4. D. USE VIRTUAL_WAREHOUSE <<warehouse name>>;

Correct Answer: C
Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html

- (Exam Topic 2)
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

1. A. Informatica
2. B. Power Bl
3. C. Adobe
4. D. Data Robot

Correct Answer: D
https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

- (Exam Topic 2)
What are ways to create and manage data shares in Snowflake? (Select TWO)

1. A. Through the Snowflake web interface (Ul)
2. B. Through the DATA_SHARE=TRUE parameter
3. C. Through SQL commands
4. D. Through the enable share=true parameter
5. E. Using the CREATE SHARE AS SELECT * TABLE command

Correct Answer: CD

- (Exam Topic 1)
Which of the following commands are not blocking operations? Choose 2 answers

1. A. UPDATE
2. B. INSERT
3. C. MERGE
4. D. COPY

Correct Answer: BD