SnowPro-Core Free Practice Test

- (Exam Topic 3)
When loading data into Snowflake, how should the data be organized?

1. A. Into single files with 100-250 MB of compressed data per file
2. B. Into single files with 1-100 MB of compressed data per file
3. C. Into files of maximum size of 1 GB of compressed data per file
4. D. Into files of maximum size of 4 GB of compressed data per file

Correct Answer: A

- (Exam Topic 3)
Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

1. A. Caching query results
2. B. Running EXPLAIN and SHOW commands
3. C. Cloning a database
4. D. Running a custom query
5. E. Running COPY commands

Correct Answer: AD

- (Exam Topic 1)
What is the minimum Snowflake edition that provides data sharing?

1. A. Standard
2. B. Premier
3. C. Enterprise
4. D. Business Critical Edition

Correct Answer: A
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html#data-sharing

- (Exam Topic 1)
How a Snowpipe charges calculated?

1. A. Per-second/per Warehouse size
2. B. Per-second/per-core granularity
3. C. Number of Pipes in account
4. D. Total storage bucket size

Correct Answer: B
Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-billing.html

- (Exam Topic 3)
Assume there is a table consisting of five micro-partitions with values ranging from A to Z. Which diagram indicates a well-clustered table?

1. A. C:\Users\Admin\Desktop\Data\Odt data\Untitled.jpg
2. B. C:\Users\Admin\Desktop\Data\Odt data\Untitled.jpg
3. C. C:\Users\Admin\Desktop\Data\Odt data\Untitled.jpg
4. D. C:\Users\Admin\Desktop\Data\Odt data\Untitled.jpg

Correct Answer: A