SnowPro Core Recertification Exam (COF-R02) Free Practice Test

Question 1

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

A. Scaling up a warehouse

B. Snowpipe

C. Execute a COPY command

D. AUTOMATIC__CLUSTERING

E. Updating data

Correct Answer: C,D

Question 2

What is a responsibility of Snowflake's virtual warehouses?

A. Query parsing and optimization

B. Metadata management

C. Query execution

D. Management of the storage layer

E. Infrastructure management

Correct Answer: C

Question 3

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.
Which SQL command should be used to delete the files?

A. REMOVE

B. MODIFY

C. DELETE

D. PURGE

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

Which of the following is the Snowflake Account_Usage.Metering_History view used for?

A. Calculating the funds left on an account's contract

B. Gathering the hourly credit usage for an account

C. Compiling an account's average cloud services cost over the previous month

D. Summarizing the throughput of Snowpipe costs for an account

Correct Answer: B

Question 5

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

A. Set the Minimum Clusters and Maximum Clusters settings to the different values

B. Configure the Maximum Clusters setting to "Auto-Scale"

C. Set the Minimum Clusters and Maximum Clusters settings to the same value

D. Set the Warehouse type to "Auto"

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

A. Bytes sent over network

B. Partitions scanned

C. Bytes spilled to local storage

D. Percentage scanned from cache

E. Partitions total

Correct Answer: B,D

Question 7

Which command is used to unload data from a Snowflake table into a file in a stage?

A. WRITE

B. COPY INTO

C. GET

D. EXTRACT INTO

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 8

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

A. SELECT AVG(ORDER_QTY) FROM SALES;

B. SELECT SUM (ORDER_AMT) FROM SALES;

C. SELECT MIN(ORDER_AMT) FROM SALES;

D. SELECT ORDER_AMT * ORDER_QTY FROM SALES;

Correct Answer: A

Question 9

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

A. All of the above

B. The REFRESH parameter is set to TRUE

C. The Pipe load history is reset to empty

D. Previously loaded files will be ignored

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 10

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

A. Incoming data can be joined with other tables

B. Row level access can be defined

C. Columns can be reordered

D. Data can be filtered by an optional where clause

E. Columns can be omitted

Correct Answer: C,E

Question 11

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

A. Partitions scanned is equal to partitions total

B. An AggregateOperacor node is present

C. A single join node uses more than 50% of the query time

D. The query is spilling to remote storage

Correct Answer: D

Question 12

What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

A. VIEWS_HISTORY

B. ACCESS_HISTORY

C. OBJECT_HISTORY

D. LOGIN_HISTORY

Correct Answer: B

Question 13

What privileges are required to create a task?

A. The role must have access to the target schema and the create task privilege on the schema itself.

B. Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.

C. The global privilege create task is required to create a new task.

D. Tasks are created at the Application level and can only be created by the Account Admin role.

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 14

Which of the following describes how clustering keys work in Snowflake?

A. Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns

B. Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

C. Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

D. Clustering keys sort the designated columns over time, without blocking DML operations

Correct Answer: D

Welcome to TestSimulate

Snowflake SnowPro Core Recertification (COF-R02) Free Practice Test