Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 1:

  Which statement is true about running tasks in Snowflake?

  A. A task can be called using a CALL statement to run a set of predefined SQL commands.
  B. A task allows a user to execute a single SQL statement/command using a predefined schedule.
  C. A task allows a user to execute a set of SQL commands on a predefined schedule.
  D. A task can be executed using a SELECT statement to run a predefined SQL command.
  C. A task allows a user to execute a set of SQL commands on a predefined schedule.

• Question 2:

  Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

  A. Caching query results
  B. Running EXPLAIN and SHOW commands
  C. Cloning a database
  D. Running a custom query
  E. Running COPY commands
  A. Caching query results
  D. Running a custom query

• Question 3:

  When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

  A. 10-50 MB
  B. 100-250 MB
  C. 300-500 MB
  D. 1000-1500 MB
  B. 100-250 MB

• Question 4:

  Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

  A. Use the DROP command after the load completes.
  B. Specify the TEMPORARY option when creating the file format.
  C. Specify the PURGE copy option in the COPY INTO command.
  D. Use the REMOVE command after the load completes.
  E. Use the DELETE LOAD HISTORY command after the load completes.
  C. Specify the PURGE copy option in the COPY INTO command.
  D. Use the REMOVE command after the load completes.

• Question 5:

  A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.

  Which Snowflake feature will support this?

  A. Row access policies
  B. Data masking policies
  C. Data encryption
  D. Role based access control
  B. Data masking policies

• Question 6:

  What happens to historical data when the retention period for an object ends?

  A. The data is cloned into a historical object.
  B. The data moves to Fail-safe
  C. Time Travel on the historical data is dropped.
  D. The object containing the historical data is dropped.
  D. The object containing the historical data is dropped.

• Question 7:

  Which feature allows a user the ability to control the organization of data in a micro-partition?

  A. Range Partitioning
  B. Search Optimization Service
  C. Automatic Clustering
  D. Horizontal Partitioning
  D. Horizontal Partitioning

• Question 8:

  What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

  A. The Pipe load history is reset to empty.
  B. The REFRESH command is executed.
  C. The stage will be purged.
  D. The destination table is truncated.
  B. The REFRESH command is executed.

• Question 9:

  If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

  A. The columns that are queried in the select clause.
  B. The columns with very high cardinality.
  C. The columns with many different values.
  D. The columns most actively used in the select filters.
  D. The columns most actively used in the select filters.

• Question 10:

  What is cached during a query on a virtual warehouse?

  A. All columns in a micro-partition
  B. Any columns accessed during the query
  C. The columns in the result set of the query
  D. All rows accessed during the query
  B. Any columns accessed during the query