COF-C02 Exam Training Practice Tests (Snowflake SnowPro Core Certification)]

Question 1

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

A. The ability to resize warehouses B. The use of warehouse indexing C. Use of multi-clustered warehouses D. The ability to scale up warehouses E. The use of warehouse auto scaling

Correct Answer: C,E

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

Question 2

What can be interpreted based on the number of nodes reported in a Query Profile?

A. Query execution time B. Compute required for metadata management C. Network bandwidth during query execution D. Data spillage

Correct Answer: A

Question 3

What is a benefit of using system tags?

A. To control data backup frequency B. To increase query execution speed C. To manage compute resources D. To support data governance

Correct Answer: D

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

Question 4

A company strongly encourages all Snowflake users to self-enroll in Snowflake ' s default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?

A. Okta Verify B. Microsoft Authenticator C. Duo Mobile D. Google Authenticator

Correct Answer: C

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

Question 5

Which Snowflake storage object can be used to store data beyond a single session and will not incur Fail-safe costs?

A. External table B. Temporary table C. Transient table D. Permanent table

Correct Answer: C

Question 6

What COPY INTO SQL command should be used to unload data into multiple files?

A. MULTIPLE=FALSE B. SINGLE=FALSE C. MULTIPLE=TRUE D. SINGLE=TRUE

Correct Answer: B

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

Question 7

Which Snowflake feature or service can be used with a standard materialized view?

A. Clustering B. Time Travel C. Fail-safe D. Data sharing

Correct Answer: A

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

Question 8

What is the default value in the Snowflake Web Interface (Ul) for auto suspending a Virtual Warehouse?

A. 1 minutes B. 15 minutes C. 5 minutes D. 10 minutes

Correct Answer: D

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

Question 9

How many network policies can be assigned to an account or specific user at a time?

A. Unlimited B. Two C. Three D. One

Correct Answer: D

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

Question 10

A JSON document is stored in the source_colum of type VARIANT. The document has an array called elements. The array contains the name key that has a string value How can a Snowflake user extract the name from the first element?

A. Source_column.element[0]:name B. Source_column.element[1].name C. Source_column.element[1]:name D. Source_column.element[0]:name

Correct Answer: B

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

Question 11

From what stage can a Snowflake user omit the FROM clause while loading data into a table?

A. The table stage B. The internal named stage C. The external named stage D. The user stage

Correct Answer: A

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

Snowflake SnowPro Core Certification - COF-C02 Exam Practice Test