Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1231:

  Which virtual warehouse privilege is required to view a load-monitoring chart?

  A. MONTTOR
  B. MODIFY
  C. OPERATE
  D. USAGE
  A. MONTTOR

  ---

  Explanation

• Question 1232:

  What statement describes Snowflake data architecture?

  A. NoSQL warehouse as a service
  B. Single-node, isolated data
  C. Multi-cluster, shared data
  D. Centralized data storage and processing
  C. Multi-cluster, shared data

  ---

  Explanation

  Snowflake's data architecture is based on a multi-cluster, shared data model. It decouples compute and storage, enabling multiple virtual warehouses (clusters) to access the same shared data concurrently without impacting each other. This

  ensures scalability, concurrency, and high performance.

  References:

  Snowflake Documentation: Architecture Overview

• Question 1233:

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

  A. Bytes sent over network
  B. Percentage scanned from cache
  C. Partitions total
  D. Bytes spilled to local storage
  E. Partitions scanned
  C. Partitions total
  E. Partitions scanned

  ---

  Explanation

• Question 1234:

  Which Snowflake objects can execute both DDL and DML statements?

  A. External functions
  B. Stored procedures
  C. User-Defined Functions (UDFs)
  D. User-Defined Table Functions (UDTFs)
  B. Stored procedures

  ---

  Explanation

  Stored procedures can execute both DDL (Data Definition Language) and DML (Data Manipulation Language) statements.

  Example: A stored procedure can create a table (DDL) and insert data into it (DML) in the same execution block.

  Other objects like UDFs and UDTFs are limited to returning values or sets of rows, and cannot perform DDL/DML operations.

  References:

  Snowflake Documentation: Stored Procedures

• Question 1235:

  How do managed access schemas help with data governance?

  A. They log all operations and enable fine-grained auditing.
  B. They provide centralized privilege management with the schema owner.
  C. They enforce identical privileges across all tables and views in a schema.
  D. They require the use of masking and row access policies across every table and view in the schema.
  B. They provide centralized privilege management with the schema owner.

  ---

  Explanation

• Question 1236:

  Which Snowflake objects use storage? (Choose two.)

  A. Regular table
  B. Regular view
  C. Cached query result
  D. Materialized view
  E. External table
  A. Regular table
  D. Materialized view

  ---

  Explanation

• Question 1237:

  How do secure views compare to non-secure views in Snowflake?

  A. Secure views execute slowly compared to non-secure views.
  B. Non-secure views are preferred over secure views when sharing data.
  C. Secure views are similar to materialized views in that they are the most performant.
  D. There are no performance differences between secure and non-secure views.
  A. Secure views execute slowly compared to non-secure views.

  ---

  Explanation

• Question 1238:

  What kind of value does a User-De ned Function (UDF) return? (Choose two.)

  A. Dictionary
  B. List
  C. Object
  D. Scalar
  E. Tabular
  D. Scalar
  E. Tabular

  ---

  Explanation

• Question 1239:

  Which clause is used to define a function that may return different values for different rows?

  A. IMMUTABLE
  B. RETURNS
  C. COMMENT
  D. VOLATILE
  D. VOLATILE

  ---

  Explanation

  The VOLATILE clause is used to define functions that may return different values for different rows, even when provided with the same inputs. This clause is suitable for non-deterministic functions like those that involve random numbers or session-specific data.

  References: Snowflake Documentation: User-Defined Functions Snowflake SQL Functions

• Question 1240:

  Which multi-duster virtual warehouse setting will help process queued queries as quickly as possible?

  A. An economy scaling policy
  B. A standard scaling policy
  C. Maximized mode
  D. Auto-scale mode
  C. Maximized mode
  D. Auto-scale mode

  ---

  Explanation