Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 491:

  Which Snowflake tool or feature enables governed sharing of datasets with a selected group of consumers that are invited, internal or external, to a Snowflake user's company?

  A. Snowflake Marketplace
  B. Data Exchange
  C. Replication
  D. Snowpipe
  B. Data Exchange

  ---

  Explanation

• Question 492:

  What is one of the characteristics of data shares?

  A. Data shares support full DML operations.
  B. Data shares work by copying data to consumer accounts.
  C. Data shares utilize secure views for sharing view objects.
  D. Data shares are cloud agnostic and can cross regions by default.
  A. Data shares support full DML operations.

  ---

  Explanation

• Question 493:

  Which features are included in Snowsight? (Choose two.)

  A. Worksheet sharing
  B. Referencing SnowSQL
  C. Exploring the Snowflake Marketplace
  D. Changing the Snowflake account cloud provider
  E. Downloading query result data larger than 100 MB
  A. Worksheet sharing
  C. Exploring the Snowflake Marketplace

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/ui-snowsight-quick-tour

• Question 494:

  By default, the COPY INTO statement will separate table data into a set of output files to take advantage of which Snowflake feature?

  A. Query acceleration
  B. Query plan caching
  C. Parallel processing
  D. Time Travel
  C. Parallel processing

  ---

  Explanation

• Question 495:

  How does the search optimization service help Snowflake users improve query performance?

  A. It scans the micro-partitions based on the joins used in the queries and scans only join columns.
  B. It maintains a persistent data structure that keeps track of the values of the table's columns in each of its micro-partitions.
  C. It scans the local disk cache to avoid scans on the tables used in the query.
  D. It keeps track of running queries and their results and saves those extra scans on the table.
  B. It maintains a persistent data structure that keeps track of the values of the table's columns in each of its micro-partitions.

  ---

  Explanation

  To improve performance for point lookups, the search optimization service creates and maintains a persistent data structure called a search access path. The search access path keeps track of which values of the table's columns might be found in each of its micro-partitions, allowing some to be skipped when scanning the table.

  https://docs.snowflake.com/en/user-guide/search-optimization-service#how-does-the-search-optimization-service-work

• Question 496:

  Which TABLE function helps to convert semi-structured data to a relational representation?

  A. CHECK_JSON
  B. TO_JSON
  C. FLATTEN
  D. PARSE_JSON
  C. FLATTEN

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/functions/flatten.html

• Question 497:

  When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

  A. 10-50 MB
  B. 100-250 MB
  C. 300-500 MB
  D. 1000-1500 MB
  B. 100-250 MB

  ---

  Explanation

• Question 498:

  Which user object property requires contacting Snowflake Support in order to set a value for it?

  A. DISABLED
  B. MINS_TO_BYPASS MFA
  C. MINS_TO_BYPASS_NETWORK_POLICY
  D. MINS_TO_UNLOCK
  C. MINS_TO_BYPASS_NETWORK_POLICY

  ---

  Explanation

• Question 499:

  Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Choose two.)

  A. Search optimization service
  B. Automatic clustering
  C. Row access policies
  D. Multi-cluster virtual warehouses
  E. Secure views
  A. Search optimization service
  B. Automatic clustering

  ---

  Explanation

• Question 500:

  The Query Profile shows the metrics of a query that ran on a size Large virtual warehouse. What steps will improve the query performance? (Select TWO).

  A. Increase the MAX_CLUSTER_COUNT.
  B. Increase the WAREHOUSE_SIZE.
  C. Update the query WHERE clause.
  D. Increase the warehouse AUTO_SUSPEND duration.
  E. Run the warehouse in Maximized mode.
  B. Increase the WAREHOUSE_SIZE.
  C. Update the query WHERE clause.

  ---

  Explanation