- (Exam Topic 3)
What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

1. A. Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 30 day
2. B. Fail Safe retention time is 1 day.
3. C. Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 365 day
4. D. Fail Safe retention time is 7 days.
5. E. Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 90 day
6. F. Fail Safe retention time is 7 days.
7. G. Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 90 day
8. H. Fail Safe retention time is 7 days.
9. I. Default Time Travel Retention is set to 7 days.Maximum Time Travel Retention is 1 da
10. J. Fail Safe retention time is 90 days.
11. K. Default Time Travel Retention is set to 90 days.Maximum Time Travel Retention is 7 day
12. L. Fail Safe retention time is 356 days.

Correct Answer: D

- (Exam Topic 3)
Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

1. A. Files
2. B. External tables
3. C. Secure User-Defined Functions (UDFs)
4. D. Sequences
5. E. Streams

Correct Answer: BC

- (Exam Topic 3)
Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

1. A. SELECT SUM (ORDER_AMT) FROM SALES;
2. B. SELECT AVG(ORDER_QTY) FROM SALES;
3. C. SELECT MIN(ORDER_AMT) FROM SALES;
4. D. SELECT ORDER_AMT * ORDER_QTY FROM SALES;

Correct Answer: B

- (Exam Topic 3)
The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

1. A. In the metadata of the target table for 14 days
2. B. In the metadata of the pipe for 14 days
3. C. In the metadata of the target table for 64 days
4. D. In the metadata of the pipe for 64 days

Correct Answer: A

- (Exam Topic 1)
In which layer of its architecture does Snowflake store its metadata statistics? Select one.

1. A. Storage Layer
2. B. Compute Layer
3. C. Database Layer
4. D. Cloud Service Layer

Correct Answer: D
Reference: https://hevodata.com/blog/snowflake-architecture-cloud-data-warehouse/