Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 721:

  When connecting to Snowflake using SnowSQL, what are ways to explicitly specify the password? (Select TWO).

  A. Use public and private key pair authentication
  B. Run a web-based authorization flow
  C. Use an OAuth token
  D. Enter through an interactive prompt
  E. Specify using SNOWSQL_PWD environment variables
  D. Enter through an interactive prompt
  E. Specify using SNOWSQL_PWD environment variables

  ---

  Explanation

• Question 722:

  Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

  A. True
  B. False
  A. True

  ---

  Explanation

• Question 723:

  How can a Data Exchange Administrator provide a user with account access to a Data Exchange?

  A. Grant the user the USERADMIN role.
  B. Add the user to the Data Exchange.
  C. Enable the IMPORT SHARE privilege and grant this privilege to the user.
  D. Create a new database for the Data Exchange and provide access to the user.
  C. Enable the IMPORT SHARE privilege and grant this privilege to the user.

  ---

  Explanation

• Question 724:

  What privileges are required to activate a network policy for an individual user within a Snowflake account?

  A. A user with a role that has been granted the global ATTACH POLICY privilege
  B. A user with a role that has been granted the create session policy privilege
  C. A user with a role that has been granted the CREATE NETWORK POLICY privilege
  D. A user with a role that has been granted the ownership privilege on both the user and the network policy
  D. A user with a role that has been granted the ownership privilege on both the user and the network policy

  ---

  Explanation

  To activate a network policy for an individual user, the user must have ownership privileges on both: Why Other Options Are Incorrect:

  A. Global ATTACH POLICY privilege: Snowflake does not have such a privilege.

  B. Create session policy privilege: This privilege does not exist in Snowflake.

  C. CREATE NETWORK POLICY privilege: This is required for creating network policies, not for attaching them to users.

  References:

  Network Policies in Snowflake

• Question 725:

  Which permission on a Snowflake virtual warehouse allows the role to resize the warehouse?

  A. ALTER
  B. MODIFY
  C. MONITOR
  D. USAGE
  B. MODIFY

  ---

  Explanation

  https://stackoverflow.com/questions/67444656/how-do-you-restrict-a-warehouse-to-resize-to-role-in-snowflake

• Question 726:

  What does it mean when the sample function uses the Bernoulli sampling method?

  A. The data is based on sampling every row.
  B. The data is based on sampling 10% of the source data.
  C. The data is based on sampling blocks of the source data.
  D. The data is based on sampling 1000 rows of the source data.
  A. The data is based on sampling every row.

  ---

  Explanation

• Question 727:

  By default, which role can create resource monitors?

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

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/resource-monitors

• Question 728:

  Which of the following DML commands isn't supported by Snowflake?

  A. UPSERT
  B. MERGE
  C. UPDATE
  D. TRUNCATE TABLE
  A. UPSERT

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/sql-dml.html

• Question 729:

  What are Snowflake best practices when assigning the ACCOUNTADMIN role to users? (Choose two.)

  A. The ACCOUNTADMIN role should be assigned to at least two users.
  B. The ACCOUNTADMIN role should be used to create Snowflake objects.
  C. The ACCOUNTADMIN role should be used for running automated scripts.
  D. The ACCOUNTADMIN role should be given to any user who needs a high level of authority.
  E. All users assigned the ACCOUNTADMIN role should use Multi-Factor Authentication (MFA).
  A. The ACCOUNTADMIN role should be assigned to at least two users.
  E. All users assigned the ACCOUNTADMIN role should use Multi-Factor Authentication (MFA).

  ---

  Explanation

• Question 730:

  What does creating a resource monitor for a virtual warehouse allow a user to do?

  A. Schedule when the warehouse starts and stops.
  B. Track and control the credits consumed by the warehouse.
  C. Monitor the real-time performance of all queries running on the warehouse.
  D. Automatically adjust the settings of the warehouse based on the workload.
  B. Track and control the credits consumed by the warehouse.

  ---

  Explanation

  Resource monitors are used to track and control credit usage . They can trigger notifications or suspend compute resources when thresholds are exceeded.

  Snowflake Docs: Resource Monitors