Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 11:

  What are the recommended steps to address poor SQL query performance due to data spilling? (Choose two.)

  A. Clone the base table.
  B. Fetch required attributes only.
  C. Use a larger virtual warehouse.
  D. Process the data in smaller batches.
  E. Add another cluster in the virtual warehouse.
  B. Fetch required attributes only.
  C. Use a larger virtual warehouse.

  ---

  Explanation

• Question 12:

  What objects in Snowflake are supported by Dynamic Data Masking? (Choose two.)

  A. Views
  B. Materialized views
  C. Tables
  D. External tables
  E. Future grants
  A. Views
  C. Tables

  ---

  Explanation

• Question 13:

  Which command can be used to list all network policies available in an account?

  A. DESCRIBE SESSION POLICY
  B. DESCRIBE NETWORK POLICY
  C. SHOW SESSION POLICIES
  D. SHOW NETWORK POLICIES
  D. SHOW NETWORK POLICIES

  ---

  Explanation

• Question 14:

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

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

  ---

  Explanation

• Question 15:

  A user needs to know the maximum value of a date field in a table, and runs the following query:

  SELECT MAX(date_field) FROM table_name;

  Which part of the Snowflake architecture will this query use?

  A. Database Storage
  B. Query Processing
  C. Cloud Services
  D. Compute
  B. Query Processing

  ---

  Explanation

• Question 16:

  Which function should be used to authorize users to access rows in a base table when using secure views with Secure Data Sharing?

  A. CURRENT_ACCOUNT()
  B. CURRENT_ROLE()
  C. CURRENT_SESSION()
  D. CURRENT_USER()
  A. CURRENT_ACCOUNT()

  ---

  Explanation

  CURRENT_ACCOUNT()

  Secure Views and Data Sharing

  When using secure views with Secure Data Sharing, use the CURRENT_ACCOUNT function to authorize users from a specific account to access rows in a base table.

  Note:

  When using the CURRENT_ROLE and CURRENT_USER functions with secure views that will be shared to other Snowflake accounts, Snowflake returns a NULL value for these functions. The reason is that the owner of the data being

  shared does not typically control the users or roles in the account with which the view is being shared.

  https://docs.snowflake.com/en/user-guide/views-secure#secure-views-and-data-sharing

• Question 17:

  What are the possible values within a METADATA$ACTION column in a Snowflake stream? (Choose two.)

  A. INSERT
  B. UPDATE
  C. DELETE
  D. TRUNCATE
  E. UPSERT
  A. INSERT
  C. DELETE

  ---

  Explanation

• Question 18:

  Snowflake allows its customers to directly access the micro-partition files that make up its tables.

  A. True
  B. False
  B. False

  ---

  Explanation

• Question 19:

  How does Snowflake Fail-safe protect data in a permanent table?

  A. Fail-safe makes data available up to 1 day, recoverable by user operations.
  B. Fail-safe makes data available for 7 days, recoverable by user operations.
  C. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
  D. Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.
  C. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.

  ---

  Explanation

• Question 20:

  How would you execute a series of SQL statements using Task?

  A. include the SQL statements in the body of the task create task mytask.. as insert into target1 select., from stream_s1 where .. INSERT INTO target2 SELECT .. FROM stream .s1 where ..
  B. A stored procedure can have only one DML statement per stored procedure invocation and therefore you should sequence stored procedures calls in the task definition CREATE TASK mytask.... AS call stored_prc1(); call stored_proc2t);
  C. A stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask.... AS call stored_proc_multiple_statements_inside():
  D. Create a task for each SQL statement (e.g. resulting in task1. task2, etc) and string the series of SQL statements by having a control task calling task 1, task 2 sequentially.
  C. A stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask.... AS call stored_proc_multiple_statements_inside():

  ---

  Explanation