Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 681:

  What action should be taken if a large number of concurrent queries are queued in a virtual warehouse?

  A. Scale-up by resizing the warehouse.
  B. Scale-out with a multi-cluster warehouse.
  C. Disable auto-suspend on the warehouse.
  D. Enable auto-resume on the warehouse.
  B. Scale-out with a multi-cluster warehouse.

  ---

  Explanation

  When a large number of concurrent queries are queued in a virtual warehouse in Snowflake, the most effective action is to scale out using a multi-cluster warehouse.

  Here's why:

  Understanding the Problem:

  Scale-Out with Multi-Cluster Warehouse:

  Why Not Other Options?:

  Best Practices for Scaling with Multi-Cluster Warehouses:

  Steps to Implement Multi-Cluster Warehouse:

  References:

  Snowflake Documentation: Scaling a Multi-Cluster Warehouse Snowflake Documentation: Query Processing and Queuing Snowflake Best Practices for Warehouses

• Question 682:

  Which common query problems are identified by the Query Profile? (Select TWO.)

  A. Syntax error
  B. Inefficient pruning
  C. Ambiguous column names
  D. Queries too large to fit in memory
  E. Object does not exist or not authorized
  B. Inefficient pruning
  D. Queries too large to fit in memory

  ---

  Explanation

• Question 683:

  Which command should be used to load data incrementally based on column values that are specified in the source table or subquery?

  A. MERGE
  B. COPY INTO
  C. GET
  D. INSERT INTO
  A. MERGE

  ---

  Explanation

  The MERGE command in Snowflake is used for incremental loading based on column values in a source table or subquery. It enables the insertion, updating, or deletion of records in a target table depending on whether matching rows are found, making it ideal for loading data that changes incrementally, such as daily updates or modifications.

• Question 684:

  Which levels can apply network policies? (Choose two.)

  A. Account
  B. Database
  C. Role
  D. Schema
  E. User
  A. Account
  E. User

  ---

  Explanation

• Question 685:

  How should a data provider securely share Snowflake objects with a data consumer who does not have a Snowflake account?

  A. Give the consumer owner's rights on the provider's Snowflake account.
  B. Unload the data into the consumer's cloud storage.
  C. Create a reader account for the consumer.
  D. Create and replicate a share, then give the consumer access to the replication.
  B. Unload the data into the consumer's cloud storage.

  ---

  Explanation

• Question 686:

  A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

  A. True
  B. False
  A. True

  ---

  Explanation

  You can experiment the same with snowflake UI.

• Question 687:

  When creating a file format to load JSON data into Snowflake. 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

  When creating a file format to load JSON data into Snowflake, the STRIP_OUTER_ARRAY option is used to remove outer brackets ([ ]) from a JSON array. Key Use Case: This is particularly helpful when the JSON data contains a top-level array, and you want to treat its elements as separate records for loading into Snowflake. Example: sql CopyEdit CREATE FILE FORMAT my_json_format TYPE = JSON STRIP_OUTER_ARRAY = TRUE; Why Other Options Are Incorrect:

  A. STRIP_NULL_VALUES: Removes NULL values, not brackets.

  B. REPLACE_INVALID_CHARACTERS: Replaces invalid characters but does not remove brackets.

  C. TRIM_SPACE: Removes leading and trailing spaces, unrelated to JSON brackets.

  References:

  File Formats for JSON Data

• Question 688:

  Which task privilege does a Snowflake role need in order to suspend or resume a task?

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

  ---

  Explanation

• Question 689:

  Which security models are used in Snowflake to manage access control? (Choose two.)

  A. Discretionary Access Control (DAC)
  B. Identity Access Management (IAM)
  C. Mandatory Access Control (MAC)
  D. Role-Based Access Control (RBAC)
  E. Security Assertion Markup Language (SAML)
  A. Discretionary Access Control (DAC)
  D. Role-Based Access Control (RBAC)

  ---

  Explanation

• Question 690:

  What data-type constructs are used to create a hierarchy when organizing semi-structured data? (Select TWO).

  A. A VARIANT can hold a value of any other data type.
  B. An ARRAY or OBJECT holds a value of type INTEGER.
  C. An ARRAY or OBJECT holds a value of type VARIANT.
  D. An ARRAY or OBJECT holds a value of type VARCHAR.
  E. An ARRAY or OBJECT holds a value of type VECTOR.
  A. A VARIANT can hold a value of any other data type.
  C. An ARRAY or OBJECT holds a value of type VARIANT.

  ---

  Explanation