Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 101:

  What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

  A. Standard
  B. Premier
  C. Enterprise
  D. Business Critical Edition
  D. Business Critical Edition

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/intro-editions.html

• Question 102:

  Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?

  A. Resource monitor
  B. Account_usage.query_history
  C. Information_schema.warehouse_load_history
  D. Information_schema.warehouse_metering_history
  C. Information_schema.warehouse_load_history

  ---

  Explanation

• Question 103:

  What happens when a network policy includes values that appear in both the allowed and blocked IP address list?

  A. Those IP addresses are allowed access to the Snowflake account as Snowflake applies the allowed IP address list first.
  B. Those IP addresses are denied access lei the Snowflake account as Snowflake applies the blocked IP address list first.
  C. Snowflake issues an alert message and adds the duplicate IP address values lo both 'he allowed and blocked IP address lists.
  D. Snowflake issues an error message and adds the duplicate IP address values to both the allowed and blocked IP address list
  B. Those IP addresses are denied access lei the Snowflake account as Snowflake applies the blocked IP address list first.

  ---

  Explanation

• Question 104:

  Which database objects can be shared with Secure Data Sharing? (Select TWO).

  A. Views
  B. Materialized views
  C. External stages
  D. External tables
  E. Dynamic tables
  A. Views
  E. Dynamic tables

  ---

  Explanation

  Secure Data Sharing allows sharing the following objects:

  Other Notes:

  Materialized views (B): Cannot be directly shared. External stages (C): Cannot be shared through Secure Data Sharing. External tables (D): Data remains outside Snowflake and cannot be shared directly.

  References:

  Snowflake Documentation: Secure Data Sharing Objects Supported for Sharing

• Question 105:

  What columns are returned when performing a FLATTEN command on semi-structured data? (Choose two.)

  A. KEY
  B. NODE
  C. VALUE
  D. LEVEL
  E. ROOT
  A. KEY
  C. VALUE

  ---

  Explanation

• Question 106:

  Which file function generates a SnowFlake-hosted URL that must be authenticated when used?

  A. GET_STATE_LOCATION
  B. GET_PRESENT_URL
  C. BUILD_SCOPED_FILE_URL
  D. BUILD_STAGE_FILE_URL
  D. BUILD_STAGE_FILE_URL

  ---

  Explanation

• Question 107:

  The following settings are configured:

  

  For how many days will the data be retained at the object level?

  A. 2
  B. 3
  C. 5
  D. 7
  A. 2

  ---

  Explanation

• Question 108:

  How does the authorization associated with a pre-signed URL work tor an unstructured file?

  A. Anyone who has the URL can access the referenced file for the life of the token.
  B. Only the user who generates the URL can use the URL to access the referenced file.
  C. Only the users who have roles with sufficient privileges on the URL can access the referenced file.
  D. The role specified in the GET REST API call must have sufficient privileges on the stage to access the referenced file using the URL.
  A. Anyone who has the URL can access the referenced file for the life of the token.

  ---

  Explanation

  A pre-signed URL in Snowflake grants access to unstructured files (e.g., in external stages) without requiring additional authentication. The URL includes an embedded token that specifies the expiration time and access permissions.

  Key Point: Anyone who has the pre-signed URL can access the referenced file for the duration of the token's validity.

  Why Other Options Are Incorrect:

  B. Only the user who generates the URL can use it: The URL is shareable and not restricted to its creator.

  C. Users with roles and privileges: Pre-signed URLs bypass direct role or privilege checks.

  D. Role specified in GET REST API call: This is unrelated to pre-signed URL access.

  References:

  Pre-Signed URLs Documentation

• Question 109:

  A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.

  Which of the following statements will accommodate this request?

  A. ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
  B. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
  C. GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
  D. GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;
  B. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

  ---

  Explanation

• Question 110:

  What is the MINIMUM Snowflake edition that supports data sharing?

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

  ---

  Explanation