Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1521:

  A Snowflake user is creating a deployment pipeline for Snowflake objects. What interface should be used to automate object deployment?

  A. Snowflake Horizon Catalog
  B. SnowSQL
  C. ODBC driver
  D. SnowCD
  B. SnowSQL

  ---

  Explanation

• Question 1522:

  In addition to the SELECT privilege, what other privilege MUST a role have to SELECT from a table in database1.schema1?

  A. The USAGE privilege on the table.
  B. The OWNERSHIP privilege on the schema.
  C. The REFERENCES privilege on the table and the schema.
  D. The USAGE privilege on the database and the schema.
  D. The USAGE privilege on the database and the schema.

  ---

  Explanation

• Question 1523:

  Which Snowflake feature supports continuous, serverless data loading into tables as soon as new data arrives?

  A. Snowpark
  B. SnowSQL
  C. SnowCD
  D. Snowpipe
  D. Snowpipe

  ---

  Explanation

• Question 1524:

  Which of the following are benefits of micro-partitioning? (Select TWO)

  A. Micro-partitions cannot overlap in their range of values
  B. Micro-partitions are immutable objects that support the use of Time Travel.
  C. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
  D. Rows are automatically stored in sorted order within micro-partitions
  E. Micro-partitions can be defined on a schema-by-schema basis
  B. Micro-partitions are immutable objects that support the use of Time Travel.
  C. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

  ---

  Explanation

• Question 1525:

  Which table function should be used to view details on a Directed Acyclic Graph (DAG) run that is presently scheduled or is executing?

  A. TASK_HISTORY
  B. TASK_DEPENDENTS
  C. CURRENT_TASK_GRAPHS
  D. COMPLETE_TASK_GRAPHS
  C. CURRENT_TASK_GRAPHS

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/tasks-intro

• Question 1526:

  Which use case will always cause an exploding join in Snowflake?

  A. A query that has more than 10 left outer joins.
  B. A query that is using a UNION without an ALL.
  C. A query that has not specified join criteria for tables.
  D. A query that has requested too many columns of data.
  C. A query that has not specified join criteria for tables.

  ---

  Explanation

• Question 1527:

  To add or remove search optimization for a table, a user must have which of the following privileges or roles? (Choose two.)

  A. The MODIFY privilege on the table
  B. The OWNERSHIP privilege on the table
  C. A SECURITYADMIN role
  D. The ADD SEARCH OPTIMIZATION privilege on the schema that contains the table
  E. The SELECT privilege on the table
  B. The OWNERSHIP privilege on the table
  D. The ADD SEARCH OPTIMIZATION privilege on the schema that contains the table

  ---

  Explanation

• Question 1528:

  What does Snowflake's search optimization service support?

  A. External tables
  B. Materialized views
  C. Tables and views that are not protected by row access policies
  D. Casts on table columns (except for fixed-point numbers cast to strings)
  C. Tables and views that are not protected by row access policies

  ---

  Explanation

• Question 1529:

  Which JSON paths are considered to be equivalent in Snowflake? (Select TWO).

  A. src[' customer' J ['EMAIL']
  B. src['CUSTOMER'] ['Email*]
  C. SRC:Customer.Email
  D. src:customer.email
  E. SRC:customer.email
  A. src[' customer' J ['EMAIL']
  D. src:customer.email

  ---

  Explanation

  In Snowflake, JSON path equivalence occurs when different syntax representations refer to the same nested element in a JSON object.

  Correct Examples:

  Why Other Options Are Incorrect:

  B. src['CUSTOMER']['Email']: The case-sensitive mismatch causes this to be non- equivalent.

  C. SRC:Customer.Email: Case-sensitive mismatches with the key name.

  E. SRC:customer.email: Incorrect due to unnecessary uppercase in SRC.

  References:

  Snowflake JSON Path Documentation

• Question 1530:

  At what level can the ALLOW_CLIENT_MFA_CACHING parameter be set?

  A. Account
  B. Role
  C. Session
  D. User
  A. Account

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/security-mfa