Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1131:

  When creating a le format to load JSON data into Snow ake, what command will remove brackets ([]) from the data?

  A. STRIP_NULL_VALUES = TRUE
  B. REPLACE_INVALID_CHARACTERS = TRUE
  C. TRIM_SPACE = TRUE
  D. STRIP_OUTER_ARRAY = TRUE
  D. STRIP_OUTER_ARRAY = TRUE

  ---

  Explanation

• Question 1132:

  What is the MINIMUM Snowflake edition that supports the periodic rekeying of encrypted data?

  A. Standard
  B. Enterprise
  C. Business Critical
  D. Virtual Private Snowflake (VPS)
  C. Business Critical

  ---

  Explanation

• Question 1133:

  What is one of the benefits of using a multi-cluster virtual warehouse?

  A. It will speed up data loading.
  B. It will reduce the cost of running the warehouse.
  C. It will automatically increase the warehouse size as needed.
  D. It will automatically start and stop additional clusters as needed.
  D. It will automatically start and stop additional clusters as needed.

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/warehouses-multicluster

• Question 1134:

  Which role must be used to create resource monitors?

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

  ---

  Explanation

  The ACCOUNTADMIN role in Snowflake has the necessary privileges to create and manage resource monitors. Resource monitors are used to manage and monitor the usage of resources (such as compute credits) within the Snowflake account. The ACCOUNTADMIN role has the highest level of administrative privileges required to perform this task.

• Question 1135:

  Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

  A. ORC
  B. XML
  C. Avro
  D. Parquet
  E. JSON
  D. Parquet
  E. JSON

  ---

  Explanation

  Semi-structured JSON, Parquet

  https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-The%20following%20fileandtext=Delimited%20(CSV% 2C%20TSV%2C%20etc.)

• Question 1136:

  Which URL identi es the database, schema, stage, and le path to a set of files for accessing the unstructured data files in Snow ake?

  A. Scoped URL
  B. File URL
  C. Pre-signed URL
  D. HTTPS URL
  B. File URL

  ---

  Explanation

• Question 1137:

  Which privilege is required to access a virtual warehouse load chart?

  A. MONITOR
  B. OPERATE
  C. USAGE
  D. READ
  B. OPERATE

  ---

  Explanation

• Question 1138:

  What happens to the privileges granted to Snowflake system-defined roles?

  A. The privileges cannot be revoked.
  B. The privileges can be revoked by an ACCOUNTADMIN.
  C. The privileges can be revoked by an ORGADMIN.
  D. The privileges can be revoked by any user-defined role with appropriate privileges.
  A. The privileges cannot be revoked.

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/security-access-control-overview

• Question 1139:

  How are micro-partitions enabled on Snowflake tables?

  A. Micro-partitioning requires a cluster key on a table.
  B. Micro-partitioning is automatically performed on a table.
  C. Micro-partitioning requires the use of the search optimization service.
  D. Micro-partitioning is defined by the user when a table is created.
  B. Micro-partitioning is automatically performed on a table.

  ---

  Explanation

• Question 1140:

  What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?

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

  ---

  Explanation