SnowPro-Core Free Practice Test

- (Exam Topic 3)
How can a row access policy be applied to a table or a view? (Choose two.)

1. A. Within the policy DDL
2. B. Within the create table or create view DDL
3. C. By future APPLY for all objects in a schema
4. D. Within a control table
5. E. Using the command ALTER <object> ADD ROW ACCESS POLICY ;

Correct Answer: BD

- (Exam Topic 3)
What is the default file size when unloading data from Snowflake using the COPY command?

1. A. 5 MB
2. B. 8 GB
3. C. 16 MB
4. D. 32 MB

Correct Answer: C

- (Exam Topic 1)
Select the different types of Internal Stages: (Choose three.)

1. A. Named Stage
2. B. User Stage
3. C. Table Stage
4. D. Schema Stage

Correct Answer: ABC
Reference: https://dwgeek.com/type-of-snowflake-stages-how-to-create-and-use.html/#Snowflake-Internal- Named-Stage

- (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)
True or False: You can resize a Virtual Warehouse while queries are running.

1. A. True
2. B. False

Correct Answer: A
Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html