Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 321:

  What step can reduce data spilling in Snowflake?

  A. Using a larger virtual warehouse

  B. Increasing the virtual warehouse maximum timeout limit

  C. Increasing the amount of remote storage for the virtual warehouse

  D. Using a Common Table Expression (CTE) instead of a temporary table

  Correct Answer: A

  Adjusting the available memory of a warehouse can improve performance because a query runs substantially slower when a warehouse runs out of memory, which results in bytes "spilling" onto storage. https://docs.snowflake.com/en/user-guide/performance-query-warehouse

• Question 322:

  When unloading data from Snowflake to AWS, what permissions are required? (Choose two.)

  A. s3:DeleteObject

  B. s3:CopyObject

  C. s3:GetBucketAcl

  D. s3:PutObject

  E. s3:GetBucketLocation

  Correct Answer: AD

  Snowflake requires the following permissions on an S3 bucket and folder to create new files in the folder (and any sub-folders):

  s3:DeleteObject s3:PutObject

  https://docs.snowflake.com/en/user-guide/data-unload-s3#configuring-an-s3-bucket-for-unloading-data

• Question 323:

  If a multi-cluster warehouse is using an economy scaling policy, how long will queries wait in the queue before another cluster is started?

  A. 1 minute

  B. 2 minutes

  C. 6 minutes

  D. 8 minutes

  Correct Answer: C

  Economy - 6 minutes Standard - immediately https://community.snowflake.com/s/article/Cluster-Spin-up-criteria-in-MCW

• Question 324:

  What does the TableScan operator represent in the Query Profile?

  A. The access to a single table

  B. The access to data stored in stage objects

  C. The list of values provided with the VALUES clause

  D. The records generated using the TABLE(GENERATOR(...)) construct

  Correct Answer: A

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

• Question 325:

  What is used during the FIRST execution of SELECT COUNT(*) FROM ORDER?

  A. Remote disk cache

  B. Virtual warehouse cache

  C. Cache result

  D. Metadata-based result

  Correct Answer: D

  https://community.snowflake.com/s/question/0D5Do00000IaCZlKAN/what-is-the-difference-between-metadata-cache-and-result-cache

• Question 326:

  What is the default access of a securable object until other access is granted?

  A. No access

  B. Read access

  C. Write access

  D. Full access

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/security-access-control-overview

• Question 327:

  From what stage can a Snowflake user omit the FROM clause while loading data into a table?

  A. The user stage

  B. The table stage

  C. The internal named stage

  D. The external named stage

  Correct Answer: B

  https://docs.snowflake.com/en/user-guide/data-load-local-file-system-copy

• Question 328:

  A Snowflake user wants to temporarily bypass a network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY. What should they do?

  A. Use the SECURITYADMIN role.

  B. Use the SYSADMIN role.

  C. Use the USERADMIN role.

  D. Contact Snowflake Support.

  Correct Answer: D

  https://docs.snowflake.com/en/user-guide/network-policies

• Question 329:

  What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?

  A. View

  B. Secure view

  C. Materialized view

  D. External table

  Correct Answer: C

  https://docs.snowflake.com/en/user-guide/views-materialized

• Question 330:

  When should a multi-cluster virtual warehouse be used in Snowflake?

  A. When queuing is delaying query execution on the warehouse

  B. When there is significant disk spilling shown on the Query Profile

  C. When dynamic vertical scaling is being used in the warehouse

  D. When there are no concurrent queries running on the warehouse

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/warehouses-multicluster#what-is-a-multi-cluster-warehouse