Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 901:

  How can a user change which columns are referenced in a view?

  A. Modify the columns in the underlying table

  B. Use the ALTER VIEW command to update the view

  C. Recreate the view with the required changes

  D. Materialize the view to perform the changes

  Correct Answer: C

  https://docs.snowflake.com/en/sql-reference/sql/alter-view.html#alter-view

• Question 902:

  Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

  A. Amazon Web Services

  B. Docker

  C. IBM Cloud

  D. Microsoft Azure Cloud

  E. Google Cloud Platform

  F. Oracle Cloud

  Correct Answer: ADE

• Question 903:

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

  A. Gathering the hourly credit usage for an account

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

  C. Summarizing the throughput of Snowpipe costs for an account

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

  Correct Answer: A

• Question 904:

  How are serverless features billed?

  A. Per second multiplied by an automatic sizing for the job

  B. Per minute multiplied by an automatic sizing for the job, with a minimum of one minute

  C. Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter

  D. Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

  Correct Answer: A

• Question 905:

  Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

  A. Schemas

  B. Roles

  C. Secure Views

  D. Stored Procedures

  E. Tables

  F. Secure User-Defined Functions (UDFs)

  Correct Answer: CEF

• Question 906:

  What is the minimum Snowflake edition required to use Dynamic Data Masking?

  A. Standard

  B. Enterprise

  C. Business Critical

  D. Virtual Private Snowflake (VPC)

  Correct Answer: B

• Question 907:

  A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.

  What will occur?

  A. No virtual warehouse will be used, data will be read from the result cache.

  B. No virtual warehouse will be used, data will be read from the local disk cache.

  C. The default virtual warehouse will be used to read all data.

  D. The virtual warehouse that is defined at the session level will be used to read all data.

  Correct Answer: A

• Question 908:

  Which of the following objects are contained within a schema? (Choose two.)

  A. Role

  B. Stream

  C. Warehouse

  D. External table

  E. User

  F. Share

  Correct Answer: BD

• Question 909:

  For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

  A. CHECK_OPTION

  B. IS_SECURE

  C. IS_UPDATEABLE

  D. TABLE_NAME

  Correct Answer: B

• Question 910:

  Which Snowflake architectural layer is responsible for a query execution plan?

  A. Compute

  B. Data storage

  C. Cloud services

  D. Cloud provider

  Correct Answer: C