Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1081:

  Which step will reduce costs when backing up a table?

  A. Clone the table.
  B. Unload the table data to a stage.
  C. Share the table data with an account in another region.
  D. Copy the table using a CREATE TABLE AS SELECT (CTAS) statement.
  A. Clone the table.

  ---

  Explanation

• Question 1082:

  Which default warehouse con guration has the highest precedence whenever a new session is created by a user?

  A. Default warehouse for the user
  B. Default warehouse in the con guration le of the client utilities
  C. Default warehouse speci ed on a CLI or in drivers/connectors parameters
  D. Default warehouse of the role assigned to the user
  C. Default warehouse speci ed on a CLI or in drivers/connectors parameters

  ---

  Explanation

• Question 1083:

  Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)?

  A. Java
  B. JavaScript
  C. SQL
  D. Python
  A. Java
  B. JavaScript
  C. SQL
  D. Python

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/user-defined-functions.html

• Question 1084:

  What should an account administrator do to help a user log into Snowflake, if the user cannot authenticate using Multi-Factor Authentication (MFA)?

  A. Set DISABLE_MFA to TRUE for the user.
  B. Set MINS_TO_BYPASS_MFA equal to 0 for the user.
  C. Set ALLOW_ID_TOKEN to FALSE for the user.
  D. Set ALLOW_CLIENT_MFA_CACHING to FALSE for the user.
  A. Set DISABLE_MFA to TRUE for the user.

  ---

  Explanation

• Question 1085:

  What Snowflake function should be used to unload relational data to JSON?

  A. BUILD_STAGE_FILE_URL()
  B. OBJECT_CONSTRUCT()
  C. PARSE_JSON()
  D. TO_VARIANT()
  B. OBJECT_CONSTRUCT()

  ---

  Explanation

• Question 1086:

  How would you determine the size of the virtual warehouse used for a task?

  A. Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
  B. Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
  C. If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
  D. Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule
  C. If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

  ---

  Explanation

• Question 1087:

  Snowpipe via RFST API can only reference External Stages as source.

  A. True
  B. False
  B. False

  ---

  Explanation

  https://community.snowflake.com/s/article/Making-Transient-table-by-Default

• Question 1088:

  What is the data lineage feature used for in Snowflake?

  A. To track how records are read by a user
  B. To track dependencies at the object level
  C. To track how records have been transformed among columns
  D. To track how transformation processes have impacted individual records
  B. To track dependencies at the object level

  ---

  Explanation

• Question 1089:

  What is a fundamental characteristic of Snowflake micro-partitions?

  A. They can be read directly as files.
  B. They serve as an index for Snowflake tables.
  C. They are sized based on Time Travel requirements.
  D. Once established, they cannot be changed.
  D. Once established, they cannot be changed.

  ---

  Explanation

  Micro-partitions are immutable units of storage in Snowflake that underpin its architecture.

  Once created, they cannot be changed; instead, new micro-partitions are created when updates occur.

  This immutability ensures efficient storage, querying, and performance optimization.

  References:

  Snowflake Documentation: Micro-partitioning

  Snowflake Architecture Overview

• Question 1090:

  A size Small standard virtual warehouse running in auto-suspend mode is used for a production Business Intelligence (BI) reporting environment. The BI reports generate quickly in the early morning, but as the day progresses and there are more users, it takes longer to run the reports. How can this situation be addressed?

  A. Enable the query acceleration service.
  B. Increase the size of the virtual warehouse.
  C. Disable the auto-suspend mode.
  D. Change the standard warehouse to a multi-cluster warehouse.
  C. Disable the auto-suspend mode.

  ---

  Explanation