Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 991:

  What Snowflake feature provides a data hub for secure data collaboration, with a selected group of invited members?

  A. Data Replication
  B. Secure Data Sharing
  C. Data Exchange
  D. Snowflake Marketplace
  C. Data Exchange

  ---

  Explanation

• Question 992:

  Which Snowflake objects use storage? (Select TWO).

  A. Regular table
  B. Regular view
  C. Cached query result
  D. Materialized view
  E. External table
  A. Regular table
  D. Materialized view

  ---

  Explanation

  Snowflake objects that use storage include:

  Other Notes:

  Regular view (B): Does not store data, as it is a logical object. Cached query result (C): Does not consume long-term storage; it is temporary. External table (E): Data is stored in external storage, not Snowflake.

  References:

  Snowflake Documentation: Tables

  Snowflake Documentation: Materialized Views

• Question 993:

  What causes objects in a data share to become unavailable to a consumer account?

  A. The DATA_RETENTION_TIME_IN_DAYS parameter in the consumer account is set to 0.
  B. The consumer account runs the GRANT INPORTED PRIVILEGES command on the data share every 24 hours.
  C. The objects in the data share are being deleted and the grant pattern is not re-applied systematically.
  D. The consumer account acquires the data share through a private data exchange.
  C. The objects in the data share are being deleted and the grant pattern is not re-applied systematically.

  ---

  Explanation

• Question 994:

  What does the :: operator do when used with a VARIANT value?

  A. It converts a VARIANT value into an object.
  B. It extracts the raw value from the VARIANT column.
  C. It casts the value from a VARIANT to a specified data type.
  D. It generates a random sample from the VARIANT column.
  C. It casts the value from a VARIANT to a specified data type.

  ---

  Explanation

• Question 995:

  Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

  A. A directory table is a separate database object.
  B. Directory tables store data file metadata.
  C. A directory table will be automatically added to a stage.
  D. Directory tables do not have their own grantable privileges.
  E. Directory table data can not be refreshed manually.
  B. Directory tables store data file metadata.
  D. Directory tables do not have their own grantable privileges.

  ---

  Explanation

• Question 996:

  Which models are supported for Snowflake access control? (Select TWO)

  A. UAC (User Access Control)
  B. RBAC (Role-Based Access Control)
  C. DAC (Discretionary Access Control)
  D. OAC (Object Access Control)
  E. EBAC (Entity-Based Access Control)
  B. RBAC (Role-Based Access Control)
  C. DAC (Discretionary Access Control)

  ---

  Explanation

  Snowflake primarily uses RBAC , where access is granted to roles, and roles are assigned to users. Snowflake also supports aspects of DAC , which allows privileges to be granted by users who have GRANT OPTION.

  Snowflake Docs: Understanding Access Control

• Question 997:

  Which table type is no longer available after the close of the session and therefore has no Fail-safe or Time Travel recovery option?

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

  ---

  Explanation

• Question 998:

  Which Snowflake table stores file-level metadata about unstructured data files in a stage, including size, last- modified timestamp, and Snowflake file URL?

  A. Directory table
  B. External table
  C. Dynamic table
  D. Iceberg table
  A. Directory table

  ---

  Explanation

  A Directory Table stores metadata about unstructured data files in a stage, such as size, last-modified timestamp, and file URL. This metadata helps query or track files without ingesting them into a table.

  Snowflake Docs: Directory Tables for Unstructured Data

• Question 999:

  Which type of workload traditionally benefits from the use of the query acceleration service?

  A. Workloads with a predictable data volume for each query
  B. Workloads that include on-demand data analyses
  C. Queries with small scans and non-selective filters
  D. Queries that do not have filters or aggregation
  B. Workloads that include on-demand data analyses

  ---

  Explanation

  The query acceleration service (QAS) can accelerate parts of the query workload in a warehouse. When it is enabled for a warehouse, it can improve overall warehouse performance by reducing the impact of outlier queries, which are queries that use more resources than the typical query. The query acceleration service does this by offloading portions of the query processing work to shared compute resources that are provided by the service.

• Question 1000:

  What does the client redirect feature in Snowflake enable?

  A. A redirect of client connections to Snowflake accounts in the same regions for business continuity.
  B. A redirect of client connections to Snowflake accounts in different regions for business continuity.
  C. A redirect of client connections to Snowflake accounts in different regions for data replication.
  D. A redirect of client connections to Snowflake accounts in the same regions for data replication.
  B. A redirect of client connections to Snowflake accounts in different regions for business continuity.

  ---

  Explanation