- (Exam Topic 1)
Which of the following DML commands isn’t supported by Snowflake?
Correct Answer:A
Reference: https://docs.snowflake.com/en/sql-reference/sql-dml.html
- (Exam Topic 2)
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
Correct Answer:A
For query execution, Snowflake uses the Virtual Warehouse. The query processing layer is separated from the disk storage layer in the Snowflake data architecture. You can use the data from the storage layer to run queries in this layer
https://www.projectpro.io/article/snowflake-architecture-what-does-snowflake-do/556#:~:text=Query Proce
- (Exam Topic 2)
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
Correct Answer:A
Snowpipe enables loading data from files as soon as they’re available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches.
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
- (Exam Topic 1)
What is the minimum duration charged when starting a virtual warehouse?
Correct Answer:B
- (Exam Topic 1)
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:
Correct Answer:A
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html