Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 71:

  What parameter setting will maximize parallel processing when unloading data from Snowflake?

  A. SINGLE = TRUE
  B. SINGLE = FALSE
  C. DETAILED_OUTPUT
  D. DETAILED OUTPUT = TRUE/FALSE
  B. SINGLE = FALSE

  ---

  Explanation

  When SINGLE = FALSE is set during COPY INTO, Snowflake writes multiple output files , enabling parallelism . Setting SINGLE = TRUE forces one output file, reducing parallel processing.

  Snowflake Docs: COPY INTO Parameters

• Question 72:

  What is the maximum length of time travel available in the Snowflake Standard Edition?

  A. 1 Day
  B. 7 Days
  C. 30 Days
  D. 90 Days
  A. 1 Day

  ---

  Explanation

• Question 73:

  What is the recommended approach for unloading data to a cloud storage location from Snowflake?

  A. Use a third-party tool to unload the data to cloud storage.
  B. Unload the data directly to the cloud storage location.
  C. Unload the data to a local file system, then upload it to cloud storage.
  D. Unload the data to a user stage, then upload the data to cloud storage
  B. Unload the data directly to the cloud storage location.

  ---

  Explanation

• Question 74:

  Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

  A. Materialized view
  B. Sequence
  C. Secure view
  D. Transient table
  E. Clustered table
  A. Materialized view
  E. Clustered table

  ---

  Explanation

• Question 75:

  Who can access the data published in a Data Exchange?

  A. Only the data provider who published the data
  B. Any Snowflake user, regardless of their role or permissions
  C. Any user who has been provided with a unique Data Exchange URL
  D. Only the users that the data provider has invited to the Data Exchange
  D. Only the users that the data provider has invited to the Data Exchange

  ---

  Explanation

  Snowflake's Data Exchange allows data providers to publish data that is accessible only to users they explicitly invite. This mechanism ensures that only approved users or Snowflake accounts have access, adding a layer of security and control. Invited users can query the shared data directly within their Snowflake account without requiring data copies, reducing redundancy and enhancing data accessibility within controlled boundaries. This selective sharing feature is part of Snowflake's secure data-sharing capabilities.

• Question 76:

  While running a query on a virtual warehouse in auto-scale mode, additional clusters are started immediately if which setting is configured?

  A. MAX_CLUSTER_COUNT is increased and new_max_clusters is greater than running_clusters
  B. MAX_CLUSTER_COUNT is decreased and new_max_clusters is less than running_clusters
  C. MIN_CLUSTER_COUNT is increased and new_min_clusters is greater than running_clusters
  D. MIN_CLUSTER_COUNT is decreased and new_min_clusters is less than running_clusters
  A. MAX_CLUSTER_COUNT is increased and new_max_clusters is greater than running_clusters

  ---

  Explanation

• Question 77:

  When tracking data storage metrics, how can a user identify deleted bytes that are still accruing storage charges?

  A. Query the DATABASE_STORAGE_USAGE_HISTORY view in ACCOUNT_USAGE.
  B. Query the TABLE_STORAGE_METRICS view in the INFORMATION_SCHEMA.
  C. Query the STORAGE_USAGE view in ACCOUNT_USAGE.
  D. Use the DATABASE_STORAGE_USAGE_HISTORY table function.
  A. Query the DATABASE_STORAGE_USAGE_HISTORY view in ACCOUNT_USAGE.

  ---

  Explanation

• Question 78:

  What can be shared when the SECURE_OBJECTS_ONLY property is set to = FALSE?

  A. A view
  B. A stored procedure
  C. Storage integration access
  D. A User-Defined Function (UDF)
  C. Storage integration access

  ---

  Explanation

• Question 79:

  In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?

  A. Cloud Services
  B. Database Storage
  C. Query Processing
  D. Metadata Management
  B. Database Storage

  ---

  Explanation

• Question 80:

  What is an advantage of using database roles instead of granting privileges on objects directly to a share in Snowflake?

  A. Easier management of cross-region data sharing
  B. Greater flexibility in including objects from multiple databases
  C. More control over object-level access for different user groups
  D. Reduction in the number of shares required for different objects in the same database
  C. More control over object-level access for different user groups

  ---

  Explanation