Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 441:

  What is the effect of configuring a virtual warehouse auto-suspend value to `0'?

  A. The warehouse will never suspend.

  B. The warehouse will suspend immediately upon work completion.

  C. The warehouse will not resume automatically.

  D. All clusters in the multi-cluster warehouse will resume immediately.

  Correct Answer: A

  Any integer 0 or greater, or NULL:

  Setting a value less than 60 is allowed, but might not result in the desired/expected behavior because the background process that suspends a warehouse runs approximately every 60 seconds and, therefore, is not intended for enabling

  exact control over warehouse suspension.

  Setting a 0 or NULL value means the warehouse never suspends.

• Question 442:

  Which SQL command will list the files in a named stage?

  A. list @~;

  B. get @%mytable;

  C. list @my_stage;

  D. get @my_stage;

  Correct Answer: C

• Question 443:

  If a size Small virtual warehouse costs two credits per hour, what is the credit cost per hour of a size Large virtual warehouse?

  A. 4

  B. 8

  C. 16

  D. 32

  Correct Answer: B

• Question 444:

  What column type does a Kafka connector store formatted information in a single column?

  A. ARRAY

  B. OBJECT

  C. VARCHAR

  D. VARIANT

  Correct Answer: D

  https://docs.snowflake.com/en/user-guide/kafka-connector-overview

• Question 445:

  Which privileges apply to stored procedures? (Choose two.)

  A. MODIFY

  B. MONITOR

  C. OPERATE

  D. OWNERSHIP

  E. USAGE

  Correct Answer: DE

  USAGE

  Enables calling a stored procedure.

  ALL [ PRIVILEGES ]

  Grants all privileges, except OWNERSHIP, on the stored procedure.

  OWNERSHIP

  Grants full control over the stored procedure; required to alter the stored procedure. Only a single role can hold this privilege on a specific object at a time. Note that in a managed access schema, only the schema owner (i.e. the role with the OWNERSHIP privilege on the schema) or a role with the MANAGE GRANTS privilege can grant or revoke privileges on objects in the schema, including future grants.

• Question 446:

  What metadata does Snowflake store concerning all rows stored in a micro-partition? (Choose two.)

  A. A count of the number of total values in the micro-partition

  B. The range of values for each partition in the micro-partition

  C. The range of values for each of the rows in the micro-partition

  D. The range of values for each of the columns in the micro-partition

  E. The number of distinct values for each column in the micro-partition

  Correct Answer: DE

  Snowflake stores metadata about all rows stored in a micro-partition, including the range of values for each of the columns in the micro-partition and the number of distinct values

• Question 447:

  What role has the privileges to create and manage data shares by default?

  A. ACCOUNTADMIN

  B. SECURITYADMIN

  C. SYSADMIN

  D. USERADMIN

  Correct Answer: A

• Question 448:

  Which function determines the kind of value stored in a VARIANT column?

  A. CHECK_JSON

  B. IS_ARRAY

  C. IS_JSON

  D. TYPEOF

  Correct Answer: D

  Reports the type of a value stored in a VARIANT column. The type is returned as a string. https://docs.snowflake.com/en/sql-reference/functions/typeof

• Question 449:

  What does the VARIANT data type impose a 16 MB size limit on?

  A. All rows

  B. All columns

  C. Individual rows

  D. Individual columns

  Correct Answer: C

  The VARIANT data type imposes a 16 MB size limit on individual rows. https://docs.snowflake.com/en/user-guide/semistructured-considerations

• Question 450:

  A user wants to unload data from a relational table into a CSV file in an external stage. The table must be named exactly as specified by the user.

  Which file format option MUST be used to do this?

  A. encoding

  B. escape

  C. file_extension

  D. single

  Correct Answer: D