- (Exam Topic 3)
Which of the following are best practices for loading data into Snowflake? (Choose three.)

1. A. Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
2. B. Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.
3. C. Enclose fields that contain delimiter characters in single or double quotes.
4. D. Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
5. E. When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
6. F. Partition the staged data into large folders with random paths, allowing Snowflake to determine the bestway to load each file.

Correct Answer: BCE

- (Exam Topic 1)
What privileges are required to execute a task?

1. A. To execute a task, you need the EXECUTE TASK.
2. B. A task is an account-level object and can only be executed by the Account Admin role.
3. C. Tasks run automatically and do run under any rote.
4. D. Tasks are stored in a special database called the utility database and require EXECUTE TASK privilege in the utility database.

Correct Answer: A

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

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

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%20Proce

- (Exam Topic 3)
A materialized view should be created when which of the following occurs? (Choose two.)

1. A. There is minimal cost associated with running the query.
2. B. The query consumes many compute resources every time it runs.
3. C. The base table gets updated frequently.
4. D. The query is highly optimized and does not consume many compute resources.
5. E. The results of the query do not change often and are used frequently.

Correct Answer: CE

- (Exam Topic 1)
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

1. A. The Pipe load history is reset to empty
2. B. The REFRESH parameter is set to TRUE
3. C. Previously loaded files will be ignored
4. D. All of the above

Correct Answer: A
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history "When a pipe is recreated, the load history is dropped."