- (Exam Topic 1)
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

1. A. The Pipe load history is reset to empty
2. B. The REFRESH parameter is set to TRUE
3. C. Previously loaded files will be ignored
4. D. All of the above

Correct Answer: A
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history "When a pipe is recreated, the load history is dropped."

- (Exam Topic 1)
What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answers

1. A. On-premise availability
2. B. Simplicity
3. C. Open source based
4. D. Concurrency
5. E. Performance

Correct Answer: BDE

- (Exam Topic 2)
Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

1. A. The user has the appropriate privileges on the objects associated with the query
2. B. Micro-partitions have been reclustered since the query was last run
3. C. The new query is run using the same virtual warehouse as the previous query
4. D. The query includes a User Defined Function (UDF)
5. E. The query has been run within 24 hours of the previously-run query

Correct Answer: AE

- (Exam Topic 2)
What is a responsibility of Snowflake's virtual warehouses?

1. A. Infrastructure management
2. B. Metadata management
3. C. Query execution
4. D. Query parsing and optimization
5. E. Management of the storage layer

Correct Answer: C

- (Exam Topic 1)
What is the most granular object that the Time Travel retention period can be defined on? Select one.

1. A. Account
2. B. Database
3. C. Schema
4. D. Table

Correct Answer: D
Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.html#data-retention-period