Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 451:

  Which account usage view in Snowflake can be used to identify the most-frequently accessed tables?

  A. Access_History

  B. Object_Dependencies

  C. Table_Storage_Metrics

  D. Tables

  Correct Answer: A

• Question 452:

  A Snowflake account administrator has set the resource monitors as shown in the diagram, with actions defined for each resource monitor as "Notify and Suspend Immediately".

  

  What is the MAXIMUM limit of credits that Warehouse 2 can consume?

  A. 0

  B. 1500

  C. 3500

  D. 5000

  Correct Answer: D

  Warehouse 2 is controlled by policy on the account level and all five warehouses usage count toward this limit. Having limit on another warehouses (in this example: 3, 4, 5) just means that warehouse 3, 4, 5 can be suspended earlier when reaching their limits.

  The question ask for the MAXIMUM, so the best case scenario for warehouse 2 is that other warehouses doesn't consume ANY resources and in such case warehouse 2 can burn whole 5000 limit.

• Question 453:

  What are characteristics of Snowflake directory fables? (Choose two.)

  A. Directory tables are separate database objects.

  B. Directory tables can only be used with an external stage.

  C. Directory tables contain copies of staged files in binary format.

  D. Directory tables store file-level metadata about the data files in a stage.

  E. A directory table can be added to a stage when the stage is created, or later.

  Correct Answer: DE

  https://docs.snowflake.com/en/user-guide/data-load-dirtables

• Question 454:

  What operation can be performed using Time Travel?

  A. Restoring tables that have been dropped from a data share

  B. Extending a permanent table's retention duration from 90 to 100 days

  C. Creating a clone of an entire table at a specific point in the past from a permanent table

  D. Disabling Time Travel for a specific object by setting DATA_RETENTION_TIME_IN_DAYS to NULL

  Correct Answer: C

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

• Question 455:

  Which Snowflake table is an implicit object layered on a stage, where the stage can be either internal or external?

  A. Directory table

  B. Temporary table

  C. Transient table

  D. A table with a materialized view

  Correct Answer: A

• Question 456:

  What is a characteristic of the maintenance of a materialized view?

  A. Materialized views cannot be refreshed automatically.

  B. An additional set of scripts is needed to refresh data in materialized views.

  C. A materialized view is automatically refreshed by a Snowflake managed warehouse.

  D. A materialized view can be set up with the auto-refresh feature using the SQL SET command.

  Correct Answer: C

• Question 457:

  Which command should be used to implement a masking policy that was already created in Snowflake?

  A. ALTER MASKING POLICY

  B. APPLY MASKING POLICY

  C. CREATE MASKING POLICY

  D. SET MASKING POLICY

  Correct Answer: D

• Question 458:

  When using SnowSQL, which configuration options are required when unloading data from a SQL query run on a local machine? (Choose two.)

  A. echo

  B. quiet

  C. output_file

  D. output_format

  E. force_put_overwrite

  Correct Answer: CD

• Question 459:

  Which Snowflake view is used to support compliance auditing?

  A. ACCESS_HISTORY

  B. COPY_HISTORY

  C. QUERY_HISTORY

  D. ROW_ACCESS_POLICIES

  Correct Answer: A

• Question 460:

  How can a Snowflake user load duplicate files with a COPY INTO command?

  A. The COPY INTO options should be set to PURGE = FALSE

  B. The COPY INTO options should be set to FORCE = TRUE

  C. The COPY INTO options should be set to RETURN_FAILED_ONLY = FALSE

  D. The COPY INTO options should be set to ON_ERROR = CONTINUE

  Correct Answer: B