Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 771:

  Other than ownership what privileges does a user need to view and modify resource monitors in Snowflake? (Choose two.)

  A. ALTER
  B. MONITOR
  C. MODIFY
  D. CREATE
  E. DROP
  B. MONITOR
  C. MODIFY

  ---

  Explanation

• Question 772:

  What are the main differences between the account usage views and the information schema views? (Choose two.)

  A. No active warehouse is needed to query account usage views but one is needed to query information schema views.
  B. Account usage views do not contain data about tables but information schema views do.
  C. Account usage views contain dropped objects but information schema views do not.
  D. Data retention for account usage views is 1 year but is 7 days to 6 months for information schema views, depending on the view.
  E. Information schema views are read-only but account usage views are not.
  C. Account usage views contain dropped objects but information schema views do not.
  D. Data retention for account usage views is 1 year but is 7 days to 6 months for information schema views, depending on the view.

  ---

  Explanation

• Question 773:

  Which tasks will help optimize virtual warehouse costs? (Select TWO)

  A. Enabling auto-suspend
  B. Limiting statement queue times
  C. Enabling multi-cluster warehouses
  D. Limiting statement timeout seconds
  E. Enabling auto-resume
  A. Enabling auto-suspend
  D. Limiting statement timeout seconds

  ---

  Explanation

  Auto-suspend ensures that a warehouse automatically suspends when idle, reducing compute costs. Statement timeout prevents long-running queries from consuming excessive credits.

  Snowflake Docs: Managing Warehouses Snowflake Docs: Statement Timeouts

• Question 774:

  Which Query Profile result indicates that a warehouse is sized too small?

  A. There are a lot of filter nodes.
  B. Bytes are spilling to external storage.
  C. The number of processed rows is very high.
  D. The number of partitions scanned is the same as partitions total.
  B. Bytes are spilling to external storage.

  ---

  Explanation

• Question 775:

  Which items are considered schema objects in Snowflake? (Choose two.)

  A. Pipe
  B. File format
  C. Resource monitor
  D. Storage integration
  E. Virtual warehouse
  A. Pipe
  B. File format

  ---

  Explanation

• Question 776:

  While clustering a table, columns with which data types can be used as clustering keys? (Choose two.)

  A. BINARY
  B. GEOGRAPHY
  C. GEOMETRY
  D. OBJECT
  E. VARIANT
  A. BINARY
  C. GEOMETRY

  ---

  Explanation

• Question 777:

  What does Snowflake recommend as a best practice for using secure views?

  A. Use sequence-generated values.
  B. Programmatically reveal the identifiers.
  C. Use secure views solely for query convenience.
  D. Do not expose the sequence-generated column(s).
  D. Do not expose the sequence-generated column(s).

  ---

  Explanation

• Question 778:

  What is the MINIMUM Snowflake edition that supports database replication?

  A. Standard
  B. Enterprise
  C. Business Critical
  D. Virtual Private Snowflake (VPS)
  C. Business Critical

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/db-replication-intro

• Question 779:

  What setting in Snowsight determines the databases, tables, and other objects that can be seen and the actions that can be performed on them?

  A. Active role
  B. Masking policy
  C. Column-level security
  D. Multi-Factor Authentication (MFA)
  A. Active role

  ---

  Explanation

• Question 780:

  How is role hierarchy established in Snowflake?

  A. By assigning users to roles
  B. By default when a role is created
  C. By granting one role to another role
  D. By transferring ownership of one role to another role
  C. By granting one role to another role

  ---

  Explanation