SnowPro-Core Free Practice Test

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

- (Exam Topic 1)
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

1. A. The validation_mode option is used when creating an Internal Stage
2. B. validation_mode=return_all_errors is a parameter of the copy command
3. C. The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
4. D. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

Correct Answer: BD
Reference: https://docs.snowflake.com/en/user-guide/data-load-bulk-ts.html

- (Exam Topic 3)
Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

1. A. Files
2. B. External tables
3. C. Secure User-Defined Functions (UDFs)
4. D. Sequences
5. E. Streams

Correct Answer: BC