SnowPro-Core Free Practice Test

- (Exam Topic 3)
Which of the following accurately describes shares?

1. A. Tables, secure views, and secure UDFs can be shared
2. B. Shares can be shared
3. C. Data consumers can clone a new table from a share
4. D. Access to a share cannot be revoked once granted

Correct Answer: A

- (Exam Topic 1)
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

1. A. Concurrency
2. B. Performance

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

- (Exam Topic 3)
What type of query benefits the MOST from search optimization?

1. A. A query that uses only disjunction (i.e., OR) predicates
2. B. A query that includes analytical expressions
3. C. A query that uses equality predicates or predicates that use IN
4. D. A query that filters on semi-structured data types

Correct Answer: C
Reference: https://community.snowflake.com/s/article/Search-Optimization-When-How-To-Use

- (Exam Topic 1)
True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

1. A. True
2. B. False

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

- (Exam Topic 2)
What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

1. A. Data can be filtered by an optional where clause
2. B. Incoming data can be joined with other tables
3. C. Columns can be reordered
4. D. Columns can be omitted
5. E. Row level access can be defined

Correct Answer: CD