- (Exam Topic 1)
What is the maximum compressed row size in Snowflake?

1. A. 8KB
2. B. 16MB
3. C. 50MB
4. D. 4000GB

Correct Answer: B
MAX size for compressed data for semi-structured data type is also 16 MB. That means if our table has a semi-structured data type column with 16MB data other columns will have NULL data.

- (Exam Topic 3)
When should a multi-cluster warehouse be used in auto-scaling mode?

1. A. When it is unknown how much compute power is needed
2. B. If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
3. C. If the runtime of the executed query is very slow
4. D. When a large number of concurrent queries are run on the same warehouse

Correct Answer: D

- (Exam Topic 3)
Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

1. A. Cloud services layer
2. B. Compute layer
3. C. Storage layer
4. D. Cloud agnostic layer

Correct Answer: B
Reference: https://www.projectpro.io/article/snowflake-architecture-what-does-snowflake-do/556

- (Exam Topic 2)
Which Snowflake technique can be used to improve the performance of a query?

1. A. Clustering
2. B. Indexing
3. C. Fragmenting
4. D. Using INDEX HINTS

Correct Answer: A
https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

- (Exam Topic 3)
What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

1. A. The shared objects are transferred.
2. B. The shared objects are copied.
3. C. The shared objects become accessible.
4. D. The shared objects can be re-shared.

Correct Answer: B