Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 381:

  What persistent data structures are used by the search optimization service to improve the performance of point lookups?

  A. Micro-partitions
  B. Clustering keys
  C. Equality searches
  D. Search access paths
  D. Search access paths

  ---

  Explanation

• Question 382:

  Which account usage view can be used to identify the masking policy assigned to an object?

  A. ACCESS_HISTORY
  B. OBJECT_DEPENDENCIES
  C. POLICY_REFERENCES
  D. TAG REFERENCES
  C. POLICY_REFERENCES

  ---

  Explanation

  The POLICY_REFERENCES view in the Account Usage schema is used to identify objects that have masking policies or row access policies applied. It provides details about the policies assigned to objects like tables and columns. Why Other Options Are Incorrect:

  A. ACCESS_HISTORY: Tracks data access but does not show policy references.

  B. OBJECT_DEPENDENCIES: Tracks dependencies between objects, unrelated to policies.

  D. TAG REFERENCES: Tracks object tags, not masking policies.

  References:

  POLICY_REFERENCES Documentation

• Question 383:

  Which kind of Snowflake table stores file-level metadata for each file in a stage?

  A. Directory
  B. External
  C. Temporary
  D. Transient
  A. Directory

  ---

  Explanation

  The kind of Snowflake table that stores file-level metadata for each file in a stage is called a directory table

  https://docs.snowflake.com/en/user-guide/data-load-dirtables

• Question 384:

  When sharing data in Snowflake, what privileges does a Provider need to grant along with a share? (Choose two.)

  A. USAGE on the specific tables in the database.
  B. MODIFY on the specific tables in the database.
  C. SELECT on the specific tables in the database.
  D. USAGE on the database and the schema containing the tables to share.
  E. OPERATE on the database and the schema containing the tables to share.
  C. SELECT on the specific tables in the database.
  D. USAGE on the database and the schema containing the tables to share.

  ---

  Explanation

• Question 385:

  A size 3X-Large multi-cluster warehouse runs one cluster for one full hour and then runs two clusters for the next full hour. What would be the total number of credits billed?

  A. 64
  B. 128
  C. 149
  D. 192
  D. 192

  ---

  Explanation

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

• Question 386:

  A user has created a dashboard in Snowflake and wants to share it with colleagues.

  How can the dashboard be shared?

  A. By creating a private Data Exchange
  B. By using the share option within Snowsight
  C. By using a Direct Share with another account
  D. By creating a listing on Snowflake Marketplace
  B. By using the share option within Snowsight

  ---

  Explanation

• Question 387:

  How do Snowflake data providers share data that resides in different databases?

  A. External tables
  B. Secure views
  C. Materialized views
  D. User-Defined Functions (UDFs)
  B. Secure views

  ---

  Explanation

• Question 388:

  For which use cases is running a virtual warehouse required? (Choose two.)

  A. When creating a table
  B. When loading data into a table
  C. When unloading data from a table
  D. When executing a SHOW command
  E. When executing a LIST command
  B. When loading data into a table
  C. When unloading data from a table

  ---

  Explanation

• Question 389:

  How can the Query Profile be used to identify the costliest operator of a query?

  A. Select any node in the operator tree and look at the number of micro-partitions scanned.
  B. Find the operator node with the highest fraction of time or percentage of total time.
  C. Select the TableScan operator node and look at the percentage scanned from cache.
  D. Look at the number of rows between operator nodes across the operator tree.
  B. Find the operator node with the highest fraction of time or percentage of total time.

  ---

  Explanation

• Question 390:

  Which Snowflake layer is associated with virtual warehouses?

  A. Cloud services
  B. Query processing
  C. Elastic memory
  D. Database storage
  B. Query processing

  ---

  Explanation