Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 961:

  Who can create and manage reader accounts? (Choose two.)

  A. A user with ACCOUNTADMIN role
  B. A user with SECURITYADMIN role
  C. A user with SYSADMIN role
  D. A user with ORGADMIN role
  E. A user with CREATE ACCOUNT privilege
  A. A user with ACCOUNTADMIN role
  E. A user with CREATE ACCOUNT privilege

  ---

  Explanation

• Question 962:

  When a transient table in Snowflake is dropped, what happens to the table?

  A. The table is no longer available for use.
  B. The table can be undropped using Fail-safe.
  C. The table can be recovered for 1 day only and after that it is no longer available.
  D. The table can be recovered only with the assistance of Snowflake Support
  A. The table is no longer available for use.

  ---

  Explanation

  Transient tables in Snowflake are designed for temporary storage with no Fail- safe.

  When a transient table is dropped:

  References:

  Snowflake Documentation: Transient Tables

  Snowflake Table Types Comparison

• Question 963:

  What is the LEAST-PRIVILEGED role that can enable replication for both source and target accounts by default?

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

  ---

  Explanation

• Question 964:

  A Snowflake table that is loaded using a Kafka connector has a schema consisting of which two VARIANT columns? (Choose two.)

  A. RECORD_TIMESTAMP
  B. RECORD_CONTENT
  C. RECORD_KEY
  D. RECORD_SESSION
  E. RECORD_METADATA
  B. RECORD_CONTENT
  C. RECORD_KEY

  ---

  Explanation

• Question 965:

  Which of the following can be used when unloading data from Snowflake? (Choose two.)

  A. When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.
  B. Use the ENCODING file format option to change the encoding from the default UTF-8.
  C. The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.
  D. By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.
  E. Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.
  C. The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.
  D. By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

  ---

  Explanation

• Question 966:

  Which Snowflake objects are supported by Snowpipe Streaming? (Select TWO)

  A. Temporary tables
  B. Permanent tables
  C. Tables with a default column that is not NULL
  D. Tables with columns containing the GEOMETRY datatype
  E. Tables using sequences to generate names for columns
  B. Permanent tables
  D. Tables with columns containing the GEOMETRY datatype

  ---

  Explanation

• Question 967:

  Which functions are used to aggregate values into an array? (Select TWO).

  A. ARRAY_AGG
  B. ARRAY_SLICE
  C. ARRAY_APPEND
  D. ARRAY_CONSTRUCT
  E. ARRAY_TO_STRING
  A. ARRAY_AGG
  D. ARRAY_CONSTRUCT

  ---

  Explanation

• Question 968:

  User A cloned a schema and overwrote a schema that User B was working on. User B no longer has access to their version of the tables. However, this all occurred within the Time Travel retention period defined at the database level.

  How should the missing tables be restored?

  A. Use an UNDROP TABLE statement.
  B. Use a CREATE TABLE AS SELECT statement
  C. Rename the cloned schema and use an UNDROP SCHEMA statement.
  D. Contact Snowflake Support to retrieve the data from Fail-safe
  C. Rename the cloned schema and use an UNDROP SCHEMA statement.

  ---

  Explanation

• Question 969:

  Which services does the Snowflake Cloud Services layer manage? (Choose two.)

  A. Compute resources
  B. Query execution
  C. Authentication
  D. Data storage
  E. Metadata
  C. Authentication
  E. Metadata

  ---

  Explanation

• Question 970:

  What action will change a customized schedule for a resource monitor back to the default schedule?

  A. Changing the monitoring frequency to the default value
  B. Changing the monitoring start timestamp to the default value
  C. Dropping and re-creating the monitor
  D. Cloning the monitor and then editing the cloned monitor schedule
  C. Dropping and re-creating the monitor

  ---

  Explanation

  Resource monitor schedules cannot be reset via update. The only way to restore the default schedule is to drop and recreate the monitor.

  Snowflake Docs: Resource Monitor Scheduling