Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1221:

  Which statement describes how Snowflake supports reader accounts?

  A. A reader account can consume data from the provider account that created it and combine it with its own data.
  B. A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.
  C. The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.
  D. The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.
  D. The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/sql/show-managed-accounts.html

• Question 1222:

  As a best practice, all custom roles should be granted to which system-defined role?

  A. ACCOUNTADMIN
  B. ORGADMIN
  C. SECURITYADMIN
  D. SYSADMIN
  D. SYSADMIN

  ---

  Explanation

• Question 1223:

  What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

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

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/replication-intro.html#business-continuity-and-disaster-recovery

• Question 1224:

  Which Snowflake feature or service can be used with a standard materialized view?

  A. Time Travel
  B. Fail-safe
  C. Clustering
  D. Data sharing
  C. Clustering

  ---

  Explanation

• Question 1225:

  Which system function can be used to manage access to the data in a share and display certain data only to paying customers?

  A. SYSTEM$ALLOWLIST
  B. SYSTEM$ALLOWLIST_PRIVATELINK
  C. SYSTEM$AUTHORIZE_PRIVATELINK
  D. SYSTEM$IS_LISTING_PURCHASED
  D. SYSTEM$IS_LISTING_PURCHASED

  ---

  Explanation

  https://other-docs.snowflake.com/en/collaboration/provider-listings-preparing

• Question 1226:

  Which of the following view types are available in Snowflake? (Choose two.)

  A. Layered view
  B. Secure view
  C. External view
  D. Embedded view
  E. Materialized view
  B. Secure view
  E. Materialized view

  ---

  Explanation

• Question 1227:

  What type of NULL values are supported in semi-structured data? (Choose two.)

  A. Avro
  B. JSON
  C. ORC
  D. Parquet
  E. SQL
  B. JSON
  E. SQL

  ---

  Explanation

• Question 1228:

  How can a Snowflake user load duplicate files with a COPY INTO command?

  A. The COPY INTO options should be set to PURGE = FALSE
  B. The COPY INTO options should be set to FORCE = TRUE
  C. The COPY INTO options should be set to RETURN_FAILED_ONLY = FALSE
  D. The COPY INTO options should be set to ON_ERROR = CONTINUE
  B. The COPY INTO options should be set to FORCE = TRUE

  ---

  Explanation

• Question 1229:

  Which of the following are true of multi-cluster Warehouses?

  A. A multi-cluster Warehouse can add clusters automatically based on query activity
  B. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity
  C. A multi-cluster Warehouse can scale down when query activity slows
  D. A multi-cluster Warehouse can automatically turn itself on when a query is executed against it
  A. A multi-cluster Warehouse can add clusters automatically based on query activity
  B. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity
  C. A multi-cluster Warehouse can scale down when query activity slows
  D. A multi-cluster Warehouse can automatically turn itself on when a query is executed against it

  ---

  Explanation

• Question 1230:

  When an ACCOUNTADMIN grants a user a custom role, which additional privileges will the user have by default?

  A. The privileges that have been granted to the ACCOUNTADMIN role
  B. The privileges on objects held by the custom role
  C. The privileges accessed by the PUBLIC role
  D. The privileges accessed by the USERADMIN role
  B. The privileges on objects held by the custom role

  ---

  Explanation

  When a user is granted a custom role , they inherit only the privileges assigned to that role . This is aligned with the principle of least privilege in RBAC.

  Snowflake Docs: Understanding Roles and Privileges