Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 811:

  Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

  A. Compute layer
  B. Storage layer
  C. Cloud infrastructure layer
  D. Cloud services layer
  D. Cloud services layer

  ---

  Explanation

• Question 812:

  What is the difference between a stored procedure and a User-Defined Function (UDF)?

  A. Stored procedures can execute database operations while UDFs cannot.
  B. Returning a value is required in a stored procedure while returning values in a UDF is optional.
  C. Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.
  D. Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.
  A. Stored procedures can execute database operations while UDFs cannot.

  ---

  Explanation

• Question 813:

  Users are responsible for data storage costs until what occurs?

  A. Data expires from Time Travel
  B. Data expires from Fail-safe
  C. Data is deleted from a table
  D. Data is truncated from a table
  B. Data expires from Fail-safe

  ---

  Explanation

• Question 814:

  What entity is responsible for hosting and sharing data in Snowflake?

  A. Data provider
  B. Data consumer
  C. Reader account
  D. Managed account
  A. Data provider

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-sharing-intro#about-providers

• Question 815:

  Which of the following commands sets the Virtual Warehouse for a session?

  A. COPT WAREHOUSE FROM
  B. SET warehouse = ;
  C. USE WAREHOUSE ;
  D. USE VIRTUAL_WAREHOUSE ;
  C. USE WAREHOUSE ;

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/warehouses-tasks.html

• Question 816:

  What technique does Snowflake recommend for determining which virtual warehouse size to select?

  A. Always start with an X-Small and increase the size if the query does not complete in 2 minutes
  B. Experiment by running the same queries against warehouses of different sizes
  C. Use the default size Snowflake chooses
  D. Use X-Large or above for tables larger than 1 GB
  B. Experiment by running the same queries against warehouses of different sizes

  ---

  Explanation

• Question 817:

  A Snowflake user needs to optimize the definition of a secure view, but the user cannot see the view.

  Which of the LEAST-PRIVILEGED access or role that should be granted to the user to complete this task?

  A. Grant the user the AYSADMIN role.
  B. Grant the user the ownership privilege on the secure view.
  C. Grant the user the imported privileges privilege on the database.
  D. Grant the user the SHOWFLAKE. object viewer database role.
  D. Grant the user the SHOWFLAKE. object viewer database role.

  ---

  Explanation

• Question 818:

  What strategies can be used to optimize the performance of a virtual warehouse? (Choose two.)

  A. Reduce queuing.
  B. Allow memory spillage.
  C. Increase the MAX_CONCURRENCY_LEVEL parameter.
  D. Increase the warehouse size.
  E. Suspend the warehouse frequently.
  A. Reduce queuing.
  D. Increase the warehouse size.

  ---

  Explanation

  Optimizing Warehouses for Performance:

  1-Reduce queues (if WH is not multi cluster make it multi cluster else add another WH) 2-Resolve memory spillage ( scale up or convert it to Snowpark-optimized WH) 3-Increase warehouse size (Scale up) 4-Trying Query Acceleration - set

  ENABLE_QUERY_ACCELERATION = true

  5-Optimizing the Warehouse Cache (by increasing Auto-suspension)

  6-Limiting Concurrently Running Queries (Decrease the MAX_CONCURRENCY_LEVEL)

  https://docs.snowflake.com/en/user-guide/performance-query-warehouse

• Question 819:

  Which clustering indicator will show if a large table in Snowflake will benefit from explicitly defining a clustering key?

  A. Percentage
  B. Depth
  C. Ratio
  D. Total partition count
  B. Depth

  ---

  Explanation

• Question 820:

  Which Snowflake features can be enabled by calling the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function by a user with the ORGADMIN role? (Choose two.)

  A. Clustering
  B. Client redirect
  C. Fail-safe
  D. Search optimization service
  E. Account and database replication
  B. Client redirect
  E. Account and database replication

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/functions/system_global_account_set_parameter