Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 261:

  A virtual warehouse is created using the following command: Create warehouse my_WH with warehouse_size = MEDIUM min_cluster_count = 1 max_cluster_count = 1 auto_suspend = 60 auto_resume = true; The image below is a graphical representation of the warehouse utilization across two days.

  

  What action should be taken to address this situation?

  A. Increase the warehouse size from Medium to 2XL.
  B. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
  C. Configure the warehouse to a multi-cluster warehouse.
  D. Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.
  B. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

• Question 262:

  How can a row access policy be applied to a table or a view? (Choose two.)

  A. Within the policy DDL
  B. Within the create table or create view DDL
  C. By future APPLY for all objects in a schema
  D. Within a control table E. Using the command ALTER ADD ROW ACCESS POLICY ;
  B. Within the create table or create view DDL
  D. Within a control table E. Using the command ALTER ADD ROW ACCESS POLICY ;

• Question 263:

  Which of the following are true of multi-cluster Warehouses? Select all that apply below.

  A. A multi-cluster Warehouse can add clusters automatically based on query activity
  B. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity
  C. A multi-cluster Warehouse can scale down when query activity slows
  D. A multi-cluster Warehouse can automatically turn itself on when a query is executed against it
  A. A multi-cluster Warehouse can add clusters automatically based on query activity
  B. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity
  C. A multi-cluster Warehouse can scale down when query activity slows
  D. A multi-cluster Warehouse can automatically turn itself on when a query is executed against it

• Question 264:

  Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

  A. CREATE_SHARE on the account
  B. SHARE on databases and schemas
  C. SELECT on tables used by the secure view
  D. REFERENCE_USAGE on databases
  C. SELECT on tables used by the secure view

• Question 265:

  When unloading to a stage, which of the following is a recommended practice or approach?

  A. Set SINGLE: = true for larger files
  B. Use OBJECT_CONSTRUCT ( * ) when using Parquet
  C. Avoid the use of the CAST function
  D. Define an individual file format
  C. Avoid the use of the CAST function

• Question 266:

  What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

  A. The ability to scale up warehouses
  B. The use of warehouse auto scaling
  C. The ability to resize warehouses
  D. Use of multi-clustered warehouses
  E. The use of warehouse indexing
  B. The use of warehouse auto scaling
  D. Use of multi-clustered warehouses

• Question 267:

  For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

  A. CHECK_OPTION
  B. IS_SECURE
  C. IS_UPDATEABLE
  D. TABLE_NAME
  B. IS_SECURE

• Question 268:

  Will data cached in a warehouse be lost when the warehouse is resized?

  A. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
  B. Yes. because the compute resource is replaced in its entirety with a new compute resource.
  C. No. because the size of the cache is independent from the warehouse size
  D. Yes. became the new compute resource will no longer have access to the cache encryption key
  A. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

• Question 269:

  What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

  A. Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 30 days. Fail Safe retention time is 1 day.
  B. Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 365 days. Fail Safe retention time is 7 days.
  C. Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.
  D. Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.
  E. Default Time Travel Retention is set to 7 days. Maximum Time Travel Retention is 1 day. Fail Safe retention time is 90 days.
  F. Default Time Travel Retention is set to 90 days. Maximum Time Travel Retention is 7 days. Fail Safe retention time is 356 days.
  D. Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.

• Question 270:

  Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

  A. Load files that are approximately 25 MB or smaller.
  B. Remove all dates and timestamps.
  C. Load files that are approximately 100-250 MB (or larger)
  D. Avoid using embedded characters such as commas for numeric data types
  E. Remove semi-structured data types
  C. Load files that are approximately 100-250 MB (or larger)
  D. Avoid using embedded characters such as commas for numeric data types

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html