Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 51:

  What does adding the PARTITION BY clause in the COPY INTO command do?

  A. It specifies which table partition will be used to copy data.
  B. It partitions unloaded table rows into separate files.
  C. It defines the partitioning scheme for the target table.
  D. It filters the rows to be unloaded based on partition values.
  B. It partitions unloaded table rows into separate files.

  ---

  Explanation

• Question 52:

  Which system_defined Snowflake role has permission to rename an account and specify whether the original URL can be used to access the renamed account?

  A. ACCOUNTADMIN
  B. SECURITYADMIN
  C. SYSADMIN
  D. ORGADMIN
  A. ACCOUNTADMIN

  ---

  Explanation

• Question 53:

  A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

  A. The tables are now orphaned
  B. The user that deleted the role
  C. SYSADMIN
  D. The assumed role that dropped the role
  D. The assumed role that dropped the role

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/sql/drop-role.html

• Question 54:

  Which Snowflake function will parse a JSON-null into a SQL-null?

  A. TO_CHAR
  B. TO_VARIANT
  C. TO_VARCHAR
  D. STRIP_NULL_VALUE
  D. STRIP_NULL_VALUE

  ---

  Explanation

• Question 55:

  Which command can be used to load data into an internal stage?

  A. LOAD
  B. copy
  C. GET
  D. PUT
  D. PUT

  ---

  Explanation

  https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internal-stages-7121cc3cc9

• Question 56:

  What is the MINIMUM permission needed to access a file URL from an external stage?

  A. MODIFY
  B. READ
  C. SELECT
  D. USAGE
  D. USAGE

  ---

  Explanation

• Question 57:

  What information does the Query Profile provide?

  A. Graphical representation of the data model
  B. Statistics for each component of the processing plan
  C. Detailed Information about I he database schema
  D. Real-time monitoring of the database operations
  B. Statistics for each component of the processing plan

  ---

  Explanation

• Question 58:

  What happens to the objects in a reader account when the DROP MANAGED ACCOUNT command is executed?

  A. The objects are dropped.
  B. The objects enter the Fail-safe period.
  C. The objects enter the Time Travel period.
  D. The objects are immediately moved to the provider account.
  A. The objects are dropped.

  ---

  Explanation

• Question 59:

  What is the lowest Snowflake edition that offers Time Travel up to 90 days?

  A. standard Edition
  B. Premier Edition
  C. Enterprise Edition
  D. Business Critical Edition
  C. Enterprise Edition

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-availability.html

• Question 60:

  Which Snowflake feature records changes made to a table so actions can be taken using that change data capture?

  A. Materialized View
  B. Pipe
  C. Stream
  D. Task
  C. Stream

  ---

  Explanation