SnowPro-Core Snowflake Exam Questions and Free Practice Test

- (Exam Topic 3)
What actions will prevent leveraging of the ResultSet cache? (Choose two.)

A. Removing a column from the query SELECT list

B. Stopping the virtual warehouse that the query is running against

C. Clustering of the data used by the query

D. Executing the RESULTS_SCAN() table function

E. Changing a column that is not in the cached query

Correct Answer:AD

- (Exam Topic 1)
When loading data into Snowflake, the COPY command supports: Choose 2 answers

A. Joins

B. Fitters

C. Data type conversions

D. Column reordering

E. Aggregates

Correct Answer:CD

- (Exam Topic 2)
Which of the following compute resources or features are managed by Snowflake? (Select TWO).

A. Execute a COPY command

B. Updating data

C. Snowpipe

D. AUTOMATIC__CLUSTERING

E. Scaling up a warehouse

Correct Answer:AD

- (Exam Topic 3)
The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

A. In the metadata of the target table for 14 days

B. In the metadata of the pipe for 14 days

C. In the metadata of the target table for 64 days

D. In the metadata of the pipe for 64 days

Correct Answer:A

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

A. 5 MB

B. 8 GB

C. 16 MB

D. 32 MB

Correct Answer:C

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

A. Standard

B. Premier

C. Enterprise

D. Business Critical Edition

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

START SnowPro-Core EXAM