Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1111:

  If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

  A. 4
  B. 8
  C. 16
  D. 32
  B. 8

  ---

  Explanation

  Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:

  

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

• Question 1112:

  At what levels can a network policy be configured in Snowflake? (Select TWO).

  A. Role level
  B. User level
  C. Account level
  D. Database level
  E. Virtual warehouse level
  B. User level
  C. Account level

  ---

  Explanation

  Network policies in Snowflake can be configured at the account level to apply globally or at the user level to apply to specific users. Account-level policies enforce access restrictions for all users under the account. User-level policies allow granular control for specific individuals.

  References: Snowflake Documentation: Network Policies Configuring Network Policies

• Question 1113:

  A user wants to upload a file to an internal Snowflake stage using a PUT command.

  Which tools and/or connectors could be used to execute this command? (Choose two.)

  A. SnowCD
  B. SnowSQL
  C. SQL API
  D. Python connector
  E. Snowsight worksheets
  B. SnowSQL
  D. Python connector

  ---

  Explanation

• Question 1114:

  Which of the following statements is true of data loading?

  A. Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast
  B. The "deal file size for loading is 16MB to match micro-partition size
  C. Marry files in the 10-lOOMB range tend to land In the 'sweet spot" for load parallelism Once loaded, there is no option to force a reload of an already loaded file
  C. Marry files in the 10-lOOMB range tend to land In the 'sweet spot" for load parallelism Once loaded, there is no option to force a reload of an already loaded file

  ---

  Explanation

• Question 1115:

  A directory table that references an external stage is being refreshed manually. What will happen to any scheduled automatic-refresh operations occurring at the same time as the manual-refresh operations?

  A. The manual-refresh operations and the automatic-refresh operations will both take place.
  B. The automatic-refresh operations will be aborted.
  C. The automatic-refresh operations will be performed more often.
  D. The automatic-refresh operations will continue on the established schedule.
  B. The automatic-refresh operations will be aborted.

  ---

  Explanation

  When a manual-refresh operation occurs on a directory table referencing an external stage, any scheduled automatic-refresh operations are aborted to avoid conflicts.

  Manual refresh overrides the automatic schedule.

  References:

  Snowflake Documentation: Directory Tables

  Snowflake Data Refresh Behavior

• Question 1116:

  Which SQL command will list the files in a named stage?

  A. list @~;
  B. get @%mytable;
  C. list @my_stage;
  D. get @my_stage;
  C. list @my_stage;

  ---

  Explanation

• Question 1117:

  How can performance be optimized for a query that returns a small amount of data from a very large base table?

  A. Use clustering keys
  B. Create materialized views
  C. Use the search optimization service
  D. Use the query acceleration service
  C. Use the search optimization service

  ---

  Explanation

• Question 1118:

  A company stores Personal Identifiable Information (PII) in Snowflake across multiple countries, including the United States, Canada, and the United Kingdom.

  How can Snowflake be used to automatically identify data, in order to support data governance requirements for each country?

  A. Tag all columns directly that contain PII.
  B. Create a custom User-Defined Function (UDF).
  C. Use semantic category classification.
  D. Implement a third-party service to protect the data.
  C. Use semantic category classification.

  ---

  Explanation

• Question 1119:

  What is the MINIMUM Snowflake edition required to add masking policies to selectively mask plain-text data in a table or in view columns at query time?

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

  ---

  Explanation

  Masking policies in Snowflake require a minimum of the Business Critical Edition. This feature enables dynamic masking of plain-text data at query time to meet compliance and security requirements.

  Example:

  sql

  CopyEdit

  CREATE MASKING POLICY ssn_mask AS (val STRING)

  RETURNS STRING ->

  CASE

  WHEN CURRENT_ROLE() IN ('DATA_ANALYST') THEN '***-**-****' ELSE val

  END;

  References:

  Snowflake Documentation: Dynamic Data Masking

  Snowflake Editions Comparison

• Question 1120:

  How can the ACCESS_HISTORY view in the ACCOUNT_USAGE schema be used to review the data governance settings for an account? (Choose two.)

  A. Identify queries run by a particular user.
  B. Identify access to the roles given to a user.
  C. Identify SQL statements that failed to run.
  D. Identify objects that were modified by a query.
  E. Identify object dependencies.
  A. Identify queries run by a particular user.
  D. Identify objects that were modified by a query.

  ---

  Explanation