Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 511:

  Which term is used to describe information about disk usage for operations where intermediate results cannot be accommodated in a Snowflake virtual warehouse memory?

  A. Pruning

  B. Spilling

  C. Join explosion

  D. Queue overloading

  Correct Answer: B

• Question 512:

  There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production.

  How can data be easily transferred from the production account to the non-production account?

  A. Clone the data from the production account to the non-production account.

  B. Create a data share from the production account to the non-production account.

  C. Create a subscription in the production account and have it publish to the non-production account.

  D. Create a reader account using the production account and link the reader account to the non-production account.

  Correct Answer: B

• Question 513:

  At what levels can a resource monitor be configured? (Choose two.)

  A. Account

  B. Database

  C. Organization

  D. Schema

  E. Virtual warehouse

  Correct Answer: AE

• Question 514:

  What activities can be monitored by a user directly from Snowsight's Activity tab without using the Account_Usage views? (Choose two.)

  A. Login history

  B. Query history

  C. Copy history

  D. Event usage history

  E. Virtual warehouse metering history

  Correct Answer: BC

• Question 515:

  What can a Snowflake user do with the information included in the details section of a Query Profile?

  A. Determine the total duration of the query.

  B. Determine the role of the user who ran the query.

  C. Determine the source system that the queried table is from.

  D. Determine if the query was on structured or semi-structured data.

  Correct Answer: A

• Question 516:

  How do Snowflake data providers share data that resides in different databases?

  A. External tables

  B. Secure views

  C. Materialized views

  D. User-Defined Functions (UDFs)

  Correct Answer: B

• Question 517:

  What operations can be performed while loading a simple CSV file into a Snowflake table using the COPY INTO command? (Choose two.)

  A. Performing aggregate calculations

  B. Reordering the columns

  C. Grouping by operations

  D. Converting the datatypes

  E. Selecting the first few rows

  Correct Answer: BD

• Question 518:

  Which commands support a multiple-statement request to access and update Snowflake data? (Choose two.)

  A. CALL

  B. COMMIT

  C. GET

  D. PUT

  E. ROLLBACK

  Correct Answer: BE

• Question 519:

  Why should a Snowflake user implement a secure view? (Choose two.)

  A. To store unstructured data

  B. To increase query performance

  C. To limit access to sensitive data

  D. To optimize query concurrency and queuing

  E. To hide view definition and details from unauthorized users

  Correct Answer: CE

• Question 520:

  At which point is data encrypted when using a PUT command?

  A. When it reaches the virtual warehouse

  B. When it gets micro-partitioned

  C. Before it is sent from the user's machine

  D. After it reaches the internal stage

  Correct Answer: C