SnowPro-Core Free Practice Test

- (Exam Topic 3)
Which Snowflake architectural layer is responsible for a query execution plan?

1. A. Compute
2. B. Data storage
3. C. Cloud services
4. D. Cloud provider

Correct Answer: D

- (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 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

- (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 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