Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1551:

  What Snowflake privilege should be granted to allow a non-ACCOUNTADMIN access to billing information?

  A. OPERATE
  B. MONITOR USAGE
  C. OWNERSHIP
  D. USAGE
  B. MONITOR USAGE

  ---

  Explanation

• Question 1552:

  What is a benefit of using system tags?

  A. To manage compute resources
  B. To support data governance
  C. To increase query execution speed
  D. To control data backup frequency
  B. To support data governance

  ---

  Explanation

  System tags help enable data classification for governance, privacy, and compliance. For example, Snowflake uses system-defined tags like SNOWFLAKE.CORE.DATA_CLASSIFICATION to detect and label sensitive data (e.g., PII, financial

  info).

  Snowflake Docs: System Tags

• Question 1553:

  Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

  A. Schema Stage
  B. User Stage
  C. Database Stage
  D. Table Stage
  E. External Named Stage
  F. Internal Named Stage
  B. User Stage
  D. Table Stage
  F. Internal Named Stage

  ---

  Explanation

• Question 1554:

  Which command will indicate whether a materialized view is being used in a query?

  A. SHOW
  B. DESCRIBE
  C. EXPLAIN
  D. USE
  C. EXPLAIN

  ---

  Explanation

• Question 1555:

  Which of the following statements is true of Snowflake?

  A. It was built specifically for the cloud
  B. It was built as an on-premises solution and then ported to the cloud
  C. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
  D. It was built for Hadoop architecture
  E. It's based on an Oracle Architecture
  A. It was built specifically for the cloud

  ---

  Explanation

  https://www.stitchdata.com/resources/snowflake/

• Question 1556:

  Which operation can be performed on Snowflake external tables?

  A. INSERT
  B. JOIN
  C. RENAME
  D. ALTER
  B. JOIN

  ---

  Explanation

• Question 1557:

  What allows a user to limit the number of credits consumed within a Snowflake account?

  A. Tracking account usage
  B. Creating resource monitors
  C. Automatic virtual warehouse scaling
  D. Automatic clustering
  B. Creating resource monitors

  ---

  Explanation

• Question 1558:

  Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:

  A. Temporary Tables
  B. Transient Tables
  C. Provisional Tables
  D. Permanent Tables
  A. Temporary Tables
  B. Transient Tables

  ---

  Explanation

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

• Question 1559:

  Which schema-level objects allow the user to periodically perform an action under specific conditions, based on data within Snowflake?

  A. Alerts
  B. External tables
  C. Secure views
  D. Materialized views
  A. Alerts

  ---

  Explanation

  Alerts in Snowflake are schema-level objects that allow users to define conditions and actions to be performed automatically when those conditions are met. Alerts use a schedule to periodically evaluate a query result and take action if the

  condition evaluates to TRUE.

  Example:

  CREATE ALERT my_alert

  IF (SELECT COUNT(*) FROM my_table WHERE status = 'ERROR') > 0 SCHEDULE = '5 MINUTE'

  ACTION = CALL notify_error_procedure();

  Why Other Options Are Incorrect:

  B. External tables: Used to query external data but cannot trigger actions.

  C. Secure views: Ensure data privacy but do not perform actions.

  D. Materialized views: Improve performance by precomputing query results but do not perform

  periodic actions.

  References:

  Snowflake Alerts Documentation

• Question 1560:

  A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?

  A. ROW_NUMBER
  B. TABLE
  C. TABULAR
  D. VALUES
  B. TABLE

  ---

  Explanation