- (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)
What is a limitation of a Materialized View?

1. A. A Materialized View cannot support any aggregate functions
2. B. A Materialized View can only reference up to two tables
3. C. A Materialized View cannot be joined with other tables
4. D. A Materialized View cannot be defined with a JOIN

Correct Answer: D
There are several limitations to using materialized views:
A materialized view can query only a single table.
Joins, including self-joins, are not supported.

- (Exam Topic 3)
What internal stages are available in Snowflake? (Choose three.)

1. A. Schema stage
2. B. Named stage
3. C. User stage
4. D. Stream stage
5. E. Table stage
6. F. Database stage

Correct Answer: ABE

- (Exam Topic 1)
On which of the following cloud platforms can a Snowflake account be hosted? (Choose three.)

1. A. Amazon Web Services
2. B. Private Virtual Cloud
3. C. Oracle Cloud
4. D. Microsoft Azure Cloud
5. E. Google Cloud Platform
6. F. Alibaba Cloud

Correct Answer: ADE

- (Exam Topic 3)
Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

1. A. Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
2. B. The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
3. C. SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
4. D. A user cannot specify a default warehouse when using the ODBC driver.
5. E. The default virtual warehouse size can be changed at any time.

Correct Answer: A