Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1311:

  What is a key benefit of using organizations in Snowflake?

  A. Ability to use ACCOUNT_USAGE views
  B. Ability to use zero-copy cloning across accounts
  C. Ability to consolidate account management and billing
  D. Ability to access new releases for testing and validation purposes
  C. Ability to consolidate account management and billing

  ---

  Explanation

• Question 1312:

  What is the most granular object that the Time Travel retention period can be defined on?

  A. Account
  B. Database
  C. Schema
  D. Table
  D. Table

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-time-travel.html#data-retention-period

• Question 1313:

  Which function unloads data from a relational table to JSON?

  A. TRUNC(ID_NUMBER, -6)
  B. TRUNC(ID_NUMBER, 5)
  C. ID_NUMBER * 100
  D. TO_CHAR(ID_NUMBER)
  D. TO_CHAR(ID_NUMBER)

  ---

  Explanation

  To unload data from a relational table to JSON format, you can use the TO_JSON function, not TO_CHAR. The TO_JSON function converts relational data, including numbers and strings, into a valid JSON format. TO_CHAR is typically used for formatting numbers or dates into string formats but is not used directly for JSON serialization. Therefore, TO_JSON or OBJECT_CONSTRUCT would be more appropriate for unloading data to JSON.

  References: Snowflake Documentation: TO_JSON Function Snowflake Documentation: OBJECT_CONSTRUCT Function

• Question 1314:

  What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?

  A. View
  B. Secure view
  C. Materialized view
  D. External table
  C. Materialized view

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/views-materialized

• Question 1315:

  Which Snowflake feature enables loading data from cloud storage as soon as files are available in a stage?

  A. COPY_INTO command
  B. Data replication
  C. Snowpipe
  D. Direct share
  C. Snowpipe

  ---

  Explanation

• Question 1316:

  What is the recommended way to disable Multi-Factor Authentication (MFA) for 30 minutes to support a user?

  A. Turn off the ALLOW_CLIENT_MFA_CACHING parameter.
  B. Set the MINS_TO_BYPASS_MFA = 30 parameter at the user level.
  C. Set the DISABLE_MFA = TRUE at the user level.
  D. Temporarily pause the approved MFA methods.
  B. Set the MINS_TO_BYPASS_MFA = 30 parameter at the user level.

  ---

  Explanation

• Question 1317:

  What is the purpose of using the OBJECT_CONSTRUCT function with the COPY INTO command?

  A. Reorder the rows in a relational table and then unload the rows into a file.
  B. Convert the rows in a relational table to a single VARIANT column and then unload the rows into a file.
  C. Reorder the data columns according to a target table definition and then unload the rows into the table.
  D. Convert the rows in a source file to a single VARIANT column and then load the rows from the file to a variant table.
  B. Convert the rows in a relational table to a single VARIANT column and then unload the rows into a file.

  ---

  Explanation

• Question 1318:

  What is the default authentication method while using the JDBC driver connection in Snowflake?

  A. externalbrowser
  B. snowflake
  C. username_password_mfa
  D. snowflake_jwt
  B. snowflake

  ---

  Explanation

  The default authentication mechanism for Snowflake clients (including JDBC) is the snowflake method, which uses username and password authentication.

  Snowflake Docs: JDBC Driver ?Authentication

• Question 1319:

  Which key access control concept does Snowflake descibe as a defined level of access to an object?

  A. Grant
  B. Privilege
  C. Role
  D. Session
  B. Privilege

  ---

  Explanation

• Question 1320:

  How is table data compressed in Snowflake?

  A. Each column is compressed as it is stored in a micro-partition.
  B. Each micro-partition is compressed as it is written into cloud storage using GZIP.
  C. The micro-partitions are stored in compressed cloud storage and the cloud storage handles compression.
  D. The text data in a micro-partition is compressed with GZIP but other types are not compressed.
  A. Each column is compressed as it is stored in a micro-partition.

  ---

  Explanation