Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 941:

  Bulk unloading of data from Snowflake supports the use of a SELECT statement.

  A. True
  B. False
  A. True

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide-data-unload.html

• Question 942:

  Which of the following statements are true about Schemas in Snowflake? (Choose two.)

  A. A Schema may contain one or more Databases
  B. A Database may contain one or more Schemas
  C. A Schema is a logical grouping of Database Objects
  D. Each Schema is contained within a Warehouse
  B. A Database may contain one or more Schemas
  C. A Schema is a logical grouping of Database Objects

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-sharing-mutiple-db.html

• Question 943:

  How can a Snowflake user automate virtual warehouse operations for optimal credit consumption? (Select TWO).

  A. Auto-resume when a query is in a queue.
  B. Auto-resume after a set time period.
  C. Auto-suspend while the query is being written.
  D. Auto-suspend after a set time period.
  E. Auto-suspend after a specified period of inactivity.
  A. Auto-resume when a query is in a queue.
  E. Auto-suspend after a specified period of inactivity.

  ---

  Explanation

  To automate virtual warehouse operations for optimal credit consumption:

  References:

  Snowflake Documentation: Virtual Warehouse Automation Warehouse Auto-Suspend and Auto-Resume

• Question 944:

  What happens to event notifications that are received when an automated Snowpipe is paused?

  A. They are immediately dropped from the internal metadata.
  B. They are stored indefinitely in the internal metadata until the pipe is manually resumed.
  C. They are permanently stored in the internal metadata and processed once the pipe is resumed.
  D. They enter a retention period of 14 days, after which they are dropped from the internal metadata.
  C. They are permanently stored in the internal metadata and processed once the pipe is resumed.

  ---

  Explanation

• Question 945:

  Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

  A. Materialized views
  B. Sequences
  C. Procedures
  D. Tables
  E. Secure User Defined Functions (UDFs)
  D. Tables
  E. Secure User Defined Functions (UDFs)

  ---

  Explanation

  Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared: Tables External tables Secure views Secure materialized views Secure UDFs

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

• Question 946:

  What costs are associated with sharing Snowflake data with a reader account ?

  A. The data provider incurs costs for the data storage costs, and the data consumer incurs compute costs.
  B. The data provider incurs costs for compute, and the data consumer incurs costs for data storage.
  C. The data provider does not incur costs when sharing data; the data consumer incurs costs for data storage and compute.
  D. The data consumer does not incur costs when accessing shared data; the data provider incurs costs for data storage and compute.
  D. The data consumer does not incur costs when accessing shared data; the data provider incurs costs for data storage and compute.

  ---

  Explanation

  With reader accounts , the provider pays for:

  Storage of shared data

  Compute used by the reader account

  The consumer does not pay , as the infrastructure is provisioned and managed by the provider.

  Snowflake Docs: Reader Accounts and Costs

• Question 947:

  What activities can a user with the ORGADMIN role perform? (Choose two.)

  A. Create INFORMATION_SCHEMA in a database.
  B. View usage information for all accounts in the organization.
  C. Enable database cloning for an account in the organization.
  D. Enable database replication for an account in the organization.
  E. View micro-partition information for all accounts in the organization.
  B. View usage information for all accounts in the organization.
  D. Enable database replication for an account in the organization.

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/organizations

• Question 948:

  What does the average_overlaps in the output of SYSTEM$CLUSTERING_INFORMATION refer to?

  A. The average number of micro-partitions stored in Time Travel.
  B. The average number of partitions physically stored in the same location.
  C. The average number of micro-partitions which contain overlapping value ranges.
  D. The average number of micro-partitions in the table associated with cloned objects.
  C. The average number of micro-partitions which contain overlapping value ranges.

  ---

  Explanation

• Question 949:

  What general guideline does Snowflake recommend when setting the auto-suspension time limit?

  A. Set tasks for immediate suspension.
  B. Set tasks for suspension after 5 minutes.
  C. Set query warehouses for suspension after 15 minutes.
  D. Set query warehouses for suspension after 30 minutes.
  B. Set tasks for suspension after 5 minutes.

  ---

  Explanation

• Question 950:

  Why is a federated environment used for user authentication in Snowflake?

  A. To enhance data security and privacy
  B. To provide real-time monitoring of user activities
  C. To separate user authentication from user access
  D. To enable direct integration with external databases
  C. To separate user authentication from user access

  ---

  Explanation

  In a federated environment, user authentication is separated from user access. https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-overview#what-is-a-federated-environment