Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 451:

  The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

  A. Local disk caching
  B. Authentication and access control
  C. Metadata management
  D. Query processing
  E. Database storage
  B. Authentication and access control
  C. Metadata management

  ---

  Explanation

• Question 452:

  What are characteristics of reader accounts in Snowflake? (Choose two.)

  A. Reader account users cannot add new data to the account.
  B. Reader account users can share data to other reader accounts.
  C. A single reader account can consume data from multiple provider accounts.
  D. Data consumers are responsible for reader account setup and data usage costs.
  E. Reader accounts enable data consumers to access and query data shared by the provider.
  A. Reader account users cannot add new data to the account.
  E. Reader accounts enable data consumers to access and query data shared by the provider.

  ---

  Explanation

  Reader account belongs to the provider account who created it, it cannot consume data from multiple provider account

• Question 453:

  Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

  A. If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.
  B. A Data Exchange allows groups of accounts to share data privately among the accounts.
  C. A Data Exchange allows accounts to share data with third, non-Snowflake parties.
  D. Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.
  E. The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.
  B. A Data Exchange allows groups of accounts to share data privately among the accounts.
  E. The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.

  ---

  Explanation

• Question 454:

  How many shares can be consumed by single Data Consumer?

  A. 1
  B. 10
  C. 100, but can be increased by contacting support
  D. Unlimited
  D. Unlimited

  ---

  Explanation

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

• Question 455:

  Which table type stores a catalog of staged files in cloud storage?

  A. Transient table
  B. Directory table
  C. Temporary table
  D. Permanent table
  B. Directory table

  ---

  Explanation

• Question 456:

  Which objects will incur storage costs associated with Fail-safe?

  A. External tables
  B. Permanent tables
  C. Data files available in internal stages
  D. Data files available in external stages
  B. Permanent tables

  ---

  Explanation

• Question 457:

  Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

  A. Customers can change the size of the Warehouse after creation
  B. A Warehouse can be resized while running
  C. A Warehouse can be configured to suspend after a period of inactivity
  D. A Warehouse can be configured to auto-resume when new queries are submitted
  A. Customers can change the size of the Warehouse after creation
  B. A Warehouse can be resized while running
  C. A Warehouse can be configured to suspend after a period of inactivity
  D. A Warehouse can be configured to auto-resume when new queries are submitted

  ---

  Explanation

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

• Question 458:

  When should you consider disabling auto-suspend for a Virtual Warehouse? (Choose two)

  A. When users will be using compute at different times throughout a 24/7 period
  B. When managing a steady workload
  C. When the compute must be available with no delay or lag time
  D. When you don't want to have to manually turn on the Warehouse each time a user needs it
  B. When managing a steady workload
  C. When the compute must be available with no delay or lag time

  ---

  Explanation

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

• Question 459:

  How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?

  A. Review the granted privileges to the database object.
  B. Review the row access policy for the database object.
  C. Query the ACCESS_HISTORY view in the ACCOUNT_USAGE schema.
  D. Query the REPLICATION_USAGE_HISTORY view in the ORGANIZATION_USAGE schema.
  C. Query the ACCESS_HISTORY view in the ACCOUNT_USAGE schema.

  ---

  Explanation

• Question 460:

  What table functions in the Snowflake Information Schema can be queried to retrieve information about directory tables? (Choose two.)

  A. AUTO_REFRESH_REGISTRATION_HISTORY
  B. EXTERNAL_TABLE_FILE_REGISTRATION_HISTORY
  C. EXTERNAL_TABLE_FILES
  D. MATERIALIZED_VIEW_REFRESH_HISTORY
  E. STAGE_DIRECTORY_FILE_REGISTRATION_HISTORY
  A. AUTO_REFRESH_REGISTRATION_HISTORY
  E. STAGE_DIRECTORY_FILE_REGISTRATION_HISTORY

  ---

  Explanation