Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 311:

  Which commands are restricted in owner's rights stored procedures? (Choose two.)

  A. SHOW
  B. MERGE
  C. INSERT
  D. DELETE
  E. DESCRIBE
  A. SHOW
  E. DESCRIBE

  ---

  Explanation

• Question 312:

  In a Snowflake role hierarchy, what is the top-level role?

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

  ---

  Explanation

• Question 313:

  A user wants to add additional privileges to the system-defined roles for their virtual warehouse.

  How does Snowflake recommend they accomplish this?

  A. Grant the additional privileges to a custom role.
  B. Grant the additional privileges to the ACCOUNTADMIN role.
  C. Grant the additional privileges to the SYSADMIN role.
  D. Grant the additional privileges to the ORGADMIN role.
  A. Grant the additional privileges to a custom role.

  ---

  Explanation

• Question 314:

  Which function can be used with the COPY INTO statement to convert rows from a relational table to a single VARIANT column, and to unload rows into a JSON file?

  A. FLATTEN
  B. OBJECT_AS
  C. OBJECT_CONSTRUCT
  D. TO_VARIANT
  C. OBJECT_CONSTRUCT

  ---

  Explanation

• Question 315:

  What happens when a multi-cluster virtual warehouse is resized?

  A. The auto-suspend feature is automatically enabled for inactive clusters.
  B. The scaling policy of the warehouse is updated.
  C. The new size applies to all clusters within that warehouse con guration.
  D. The minimum and maximum number of clusters is automatically adjusted.
  C. The new size applies to all clusters within that warehouse con guration.

  ---

  Explanation

• Question 316:

  Snowflake is designed for which type of workloads? (Choose two.)

  A. OLAP (Analytics) workloads
  B. OLTP (Transactional) workloads
  C. Concurrent workloads
  D. On-premise workloads
  A. OLAP (Analytics) workloads
  C. Concurrent workloads

  ---

  Explanation

  https://blog.couchbase.com/its-the-workload-stupid/

  https://www.quora.com/Can-Snowflake-be-used-for-an-OLTP-system-or-is-it-only-best-suited-for-warehousing

• Question 317:

  What are value types that a VARIANT column can store? (Select TWO)

  A. STRUCT
  B. OBJECT
  C. BINARY
  D. ARRAY
  E. CLOB
  B. OBJECT
  D. ARRAY

  ---

  Explanation

  Characteristics of a VARIANT

  A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB. https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics%

  20of%20a%20VARIANT,a%20VARIANT%20is% 2016%20MB.

• Question 318:

  Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

  A. The user has the appropriate privileges on the objects associated with the query
  B. Micro-partitions have been reclustered since the query was last run
  C. The new query is run using the same virtual warehouse as the previous query
  D. The query includes a User Defined Function (UDF)
  E. The query has been run within 24 hours of the previously-run query
  A. The user has the appropriate privileges on the objects associated with the query
  E. The query has been run within 24 hours of the previously-run query

  ---

  Explanation

• Question 319:

  Which functions are used to manipulate semi-structured data? (Select TWO)

  A. WIDTH_BUCKET
  B. HASH_AGG
  C. ARRAY_APPEND
  D. OBJECT_INSERT
  E. LISTAGG
  C. ARRAY_APPEND
  D. OBJECT_INSERT

  ---

  Explanation

  Functions like ARRAY_APPEND() and OBJECT_INSERT() are system-defined for manipulating ARRAY and OBJECT types within VARIANT data structures.

  Snowflake Docs: Functions for Semi-Structured Data

• Question 320:

  You can define multiple columns within a clustering key on a table.

  A. True
  B. False
  A. True

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html