Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 741:

  Which function will convert semi-structured data to a relational data representation'?

  A. PARSE_JSON
  B. FLATTEN
  C. OBJECT_CONSTRUCT
  D. OBJECT AGG
  B. FLATTEN

  ---

  Explanation

  The FLATTEN function converts semi-structured data (e.g., JSON or XML) into a relational representation by expanding nested structures into rows.

  Example:

  SELECT FLATTEN(INPUT => PARSE_JSON('[{"key": "value1"}, {"key": "value2"}]'));

  References:

  Snowflake Documentation: FLATTEN Function

  Snowflake Semi-Structured Data Handling

• Question 742:

  Which of the following objects can be shared through secure data sharing?

  A. Masking policy
  B. Stored procedure
  C. Task
  D. External table
  D. External table

  ---

  Explanation

  Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared: Tables External tables Secure views Secure materialized views Secure UDFs Snowflake enables the sharing of databases through shares, which are created by data providers and "imported" by data consumers.

  https://docs.snowflake.com/en/user-guide/data-sharing-intro.html#:~:text=Secure%20Data%20Sharing%20enables%20sharing,External%20tables

• Question 743:

  Refer to the exhibit, which privileges has Role B been granted?

  

  A. Privileges 3 and 5
  B. Privileges 1, 2, 4 and 6
  C. Privileges 1, 2, 3, 4 and 5
  D. Privileges 1, 2, 3, 4, 5 and 6
  C. Privileges 1, 2, 3, 4 and 5

  ---

  Explanation

• Question 744:

  A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

  A. True
  B. False
  B. False

  ---

  Explanation

• Question 745:

  What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?

  A. 0 days
  B. 1 day
  C. 7 days
  D. 14 days
  A. 0 days

  ---

  Explanation

• Question 746:

  Which functions can be used to share unstructured data through a secure view? (Choose two.)

  A. BUILD_SCOPED_FILE_URL
  B. BUILD_STAGE_FILE_URL
  C. GET_ABSOLUTE_PATH
  D. GET_PRESIGNED_URL
  E. GET_RELATIVE_PATH
  A. BUILD_SCOPED_FILE_URL
  D. GET_PRESIGNED_URL

  ---

  Explanation

• Question 747:

  Which of the following statements is true of zero-copy cloning?

  A. Zero-copy clones objects inherit
  B. All zero-copy clone objects inherit the privileges of their original objects
  C. Zero-copy coning is licensed as an additional Snowflake feature
  D. At the instance/instance a clone is created, all micro-partitions in the original table and the clone are fully shared.
  D. At the instance/instance a clone is created, all micro-partitions in the original table and the clone are fully shared.

  ---

  Explanation

  https://community.snowflake.com/s/question/0D50Z00009D8VOd/zero-copy-cloning-base-data

• Question 748:

  Which Snowflake layer is always leveraged when accessing a query from the result cache?

  A. Metadata
  B. Data Storage
  C. Compute
  D. Cloud Services
  D. Cloud Services

  ---

  Explanation

• Question 749:

  What does the TableScan operator represent in the Query Profile?

  A. The access to a single table
  B. The access to data stored in stage objects
  C. The list of values provided with the VALUES clause
  D. The records generated using the TABLE(GENERATOR(...)) construct
  A. The access to a single table

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/functions/get_query_operator_stats

• Question 750:

  Which of the following accurately represents how a table fits into Snowflake's logical container hierarchy?

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

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/ddl-database.html