Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 361:

  Which type of Snowflake security policy requires users to re-authenticate after a given period of inactivity?

  A. Network policy
  B. Password policy
  C. Authentication policy
  D. Session policy
  D. Session policy

  ---

  Explanation

  Session policies allow account administrators to define rules such as session timeout , requiring users to re- authenticate after inactivity . This is different from password or network policies, which manage login credentials and IP filtering.

  Snowflake Docs: Session Policies

• Question 362:

  Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

  A. To accommodate more queries
  B. To accommodate more users
  C. To accommodate fluctuations in workload
  D. To accommodate a more complex workload
  D. To accommodate a more complex workload

  ---

  Explanation

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

• Question 363:

  Which features can be used with the Snowflake Standard edition? (Select TWO).

  A. Materialized views
  B. External functions
  C. Multi-cluster virtual warehouses
  D. Fail-safe
  E. Row-level security
  A. Materialized views
  D. Fail-safe

  ---

  Explanation

  The Snowflake Standard Edition includes features such as: Why Other Options Are Incorrect:

  B. External Functions: Available only in Enterprise Edition and higher.

  C. Multi-cluster virtual warehouses: Available in Enterprise Edition and higher.

  E. Row-Level Security: Requires Enterprise Edition or Business Critical Edition.

  References: Snowflake Editions Materialized Views Documentation Fail-Safe Overview

• Question 364:

  Which database object can be created as temporary for a given session?

  A. View
  B. Stage
  C. Stored procedure
  D. User-Defined Function (UDF)
  B. Stage

  ---

  Explanation

• Question 365:

  All Snowflake table types include fail-safe storage.

  A. True
  B. False
  B. False

  ---

  Explanation

• Question 366:

  What is the only supported character set for loading and unloading data from all supported file formats?

  A. UTF-8
  B. UTF-16
  C. ISO-8859-1
  D. WINDOWS-1253
  A. UTF-8

  ---

  Explanation

• Question 367:

  Which virtual warehouse auto-suspend configurations will result in a warehouse that runs continually 24 hours a day, 7 days a week? (Select TWO).

  A. -1
  C. 86400
  D. 172800
  E. NULL
  C. 86400
  D. 172800

  ---

  Explanation

• Question 368:

  Which table type is used in the file processing pipeline to process unstructured data in Snowflake?

  A. Temporary
  B. Directory
  C. Standard
  D. Transient
  B. Directory

  ---

  Explanation

• Question 369:

  What action can a user take to address query concurrency issues?

  A. Enable the search optimization service.
  B. Enable the query acceleration service.
  C. Add additional clusters to the virtual warehouse.
  D. Resize the virtual warehouse to a larger instance size.
  C. Add additional clusters to the virtual warehouse.

  ---

  Explanation

• Question 370:

  Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO)

  A. A user with an USERADMIN or higher role
  B. A user with a SECURITYADMIN or higher role
  C. A role that has been granted the ATTACH POLICY privilege
  D. A role that has the NETWORK_POLlCY account parameter set
  E. A role that has the CWKERSHIE of the network policy
  B. A user with a SECURITYADMIN or higher role
  E. A role that has the CWKERSHIE of the network policy

  ---

  Explanation