- (Exam Topic 1)
A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true?
Choose 2 answers

1. A. The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period
2. B. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within the previous 24 hour period
3. C. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous
4. D. The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed

Correct Answer: BD
The results cache will only be used if it's the same query AND the same role executing the query

- (Exam Topic 2)
What is the MOST performant file format for loading data in Snowflake?

1. A. CSV (Unzipped)
2. B. Parquet
3. C. CSV (Gzipped)
4. D. ORC

Correct Answer: A

- (Exam Topic 1)
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:
Choose 2 answers

1. A. Temporary Tables
2. B. Transient Tables
3. C. Provisional Tables
4. D. Permanent Tables

Correct Answer: AB
Reference: https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html

- (Exam Topic 2)
Which feature is only available in the Enterprise or higher editions of Snowflake?

1. A. Column-level security
2. B. SOC 2 type II certification
3. C. Multi-factor Authentication (MFA)
4. D. Object-level access control

Correct Answer: A
https://docs.snowflake.com/en/user-guide/intro-editions.html

- (Exam Topic 3)
If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

1. A. The columns that are queried in the select clause.
2. B. The columns with very high cardinality.
3. C. The columns with many different values.
4. D. The columns most actively used in the select filters.

Correct Answer: D