Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 171:

  During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

  A. STATEMENT_TIMEOUT__IN__SECONDS
  B. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
  C. MAX_CONCURRENCY__LEVEL
  D. QUERY_TIMEOUT_IN_SECONDS
  B. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

  ---

  Explanation/Reference:

  The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit. By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-Timeout-Parameters#:~:text=The%20parameter% 20STATEMENT_QUEUED_TIMEOUT_IN_SECO NDS%20sets%20the,indefinitely%20in%20the%20waiting%20queue.

• Question 172:

  Which Snowflake feature is used for both querying and restoring data?

  A. Cluster keys
  B. Time Travel
  C. Fail-safe
  D. Cloning
  B. Time Travel

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/data-availability.html#:~:text=Snowflake%20provides%20powerful%20CDP%20features,days%20through%20Snowflake%20Time%20Travel.

• Question 173:

  True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

  A. True
  B. False
  B. False

  ---

  Explanation/Reference:

  Reference: https://interworks.com/blog/bdu/2020/02/05/zero-to-snowflake-secure-data-sharing/

• Question 174:

  In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

  A. When the system has enough load for 2 minutes
  B. When the system has enough load for 6 minutes
  C. When the system has enough load for 8 minutes
  D. When the system has enough load for 10 minutes
  D. When the system has enough load for 10 minutes

• Question 175:

  Which of the following objects is not covered by Time Travel?

  A. Tables
  B. Schemas
  C. Databases
  D. Stages
  D. Stages

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.html

• Question 176:

  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 177:

  Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

  A. Tri-Secret Secure
  B. Time Travel
  C. Fail-safe
  D. Data encryption
  E. External stages
  B. Time Travel
  C. Fail-safe

• Question 178:

  Which file formats are supported for unloading data from Snowflake? (Choose two.)

  A. Avro
  B. JSON
  C. ORC
  D. XML
  E. Delimited (CSV, TSV, etc.)
  C. ORC
  E. Delimited (CSV, TSV, etc.)

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-The%20following%20fileandtext=Delimited%20(CSV%2C%20TSV%2C%20etc,is%20comma%20(i.e.%20CSV).andtext=File %20format%20options%20specify%20the,the%20 format%20of%20the%20data

• Question 179:

  The is the minimum Fail-safe retention time period for transient tables?

  A. 1 day
  B. 7 days
  C. 12 hours
  D. 0 days
  D. 0 days

• Question 180:

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

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