Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 341:

  Which configuration of the function PARSE_JSON () will retrieve a valid SQL HULL value?

  A. SELECT parse_json (NULL)
  B. SELECT parse_json('null*)
  C. SELECT parse_json('[ null ]')
  D. SELECT parse json('{"a": null)'):a
  B. SELECT parse_json('null*)

  ---

  Explanation

  The PARSE_JSON function converts a valid JSON string into a VARIANT type. Passing 'null' as the input will retrieve a valid SQL NULL value.

  Example:

  SELECT PARSE_JSON('null');

  This will return a valid SQL NULL.

  References:

  Snowflake Documentation: PARSE_JSON Function

• Question 342:

  Where can files be created when the data is going to be unloaded from Snowflake using a copy into command? (Select TWO).

  A. An internal stage
  B. An SFTP location
  C. An external stage
  D. A network share folder
  E. A local disk
  A. An internal stage
  C. An external stage

  ---

  Explanation

  The COPY INTO command in Snowflake is used to unload data from a table or query into a specific storage location. Valid locations where files can be created during the unload process are: Why Other Options Are Incorrect:

  B. SFTP Location: Snowflake does not directly support SFTP as a storage location.

  D. Network Share Folder: Network shares are not supported by Snowflake for data unloading.

  E. Local Disk: Snowflake does not allow unloading data directly to a local disk.

  References:

  COPY INTO Command

  Stages Documentation

• Question 343:

  A virtual warehouse query queuing time has been increasing due to a large number of users accessing the warehouse at the same time each day. Which warehouse configurations would address this issue MOST cost- effectively? (Select TWO).

  A. Scale-up the warehouse.
  B. Scale-out the warehouse.
  C. Run the warehouse in Auto-scale mode.
  D. Run the warehouse in Maximized mode.
  E. Run the warehouse using an Economy policy.
  B. Scale-out the warehouse.
  C. Run the warehouse in Auto-scale mode.

  ---

  Explanation

• Question 344:

  How often are encryption keys automatically rotated by Snowflake?

  A. 30 Days
  B. 60 Days
  C. 90 Days
  D. 365 Days
  A. 30 Days

  ---

  Explanation

  All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old. Active keys are retired, and new keys are created. When Snowflake determines the retired key is no longer needed, the key is automatically destroyed. https://docs.snowflake.com/en/user-guide/security-encryption-manage.html#:~:text=All%20Snowflake%2Dmanaged%20keys%20are,the%20key%20is% 20automatically%20destroyed.

• Question 345:

  The following SQL statements have been executed:

  

  What will the output be of the last select statement?

  A. 3
  B. 4
  C. 7
  D. 8
  C. 7

  ---

  Explanation

• Question 346:

  Which actions can be performed using a resource monitor in Snowflake? (Choose two.)

  A. Monitor the performance of individual queries in real-time.
  B. Automatically allocate more storage space to a virtual warehouse.
  C. Modify the queries being executed within a virtual warehouse.
  D. Suspend a virtual warehouse when its credit usage reaches a defined limit.
  E. Trigger a notification to account administrators when credit usage reaches a specified threshold.
  D. Suspend a virtual warehouse when its credit usage reaches a defined limit.
  E. Trigger a notification to account administrators when credit usage reaches a specified threshold.

  ---

  Explanation

• Question 347:

  What impact does dropping a column from a table have on the micro-partitions of that table?

  A. The data associated with the dropped column will be removed from all existing micro-partitions.
  B. New micro-partitions will be created containing only the data for the remaining columns.
  C. The existing micro-partitions will not be affected.
  D. The current micro-partitions will not be available for Time Travel, and new micro-partitions will be created.
  C. The existing micro-partitions will not be affected.

  ---

  Explanation

• Question 348:

  How does Snowflake support the use of structured and semi-structured data? (Select TWO)

  A. Structured data is supported through the use of traditional relational database tables, organized into rows and columns.
  B. Structured and semi-structured data are stored in separate physical storage locations; users must choose which type of data to use when creating a table.
  C. Semi-structured data is supported through the use of automatically indexed database tables.
  D. All semi-structured data is automatically converted into structured data when it is loaded into Snowflake.
  E. Users can load and query semi-structured data using SQL using the SQL semi-structured data handling functions.
  A. Structured data is supported through the use of traditional relational database tables, organized into rows and columns.
  E. Users can load and query semi-structured data using SQL using the SQL semi-structured data handling functions.

  ---

  Explanation

  Snowflake supports structured data in standard tables and semi-structured data in VARIANT, OBJECT, and ARRAY columns. Users can load and query both using standard SQL functions , without schema constraints for semi- structured formats.

  Snowflake Docs: Semi-Structured Data Overview

• Question 349:

  Which Snowflake objects can process staged files in parallel? (Select TWO)

  A. User-Defined Functions (UDFs)
  B. User-Defined Table Functions (UDTFs)
  C. Stored procedures
  D. Snowpipes
  E. Tasks
  B. User-Defined Table Functions (UDTFs)
  D. Snowpipes

  ---

  Explanation

• Question 350:

  Which of the following describes a Snowflake stored procedure?

  A. They can be created as secure and hide the underlying metadata from the user.
  B. They can only access tables from a single database.
  C. They can contain only a single SQL statement.
  D. They can be created to run with a caller's rights or an owner's rights.
  D. They can be created to run with a caller's rights or an owner's rights.

  ---

  Explanation