Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 321:

  What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

  A. Reader
  B. Consumer
  C. Vendor
  D. Standard
  E. Personalized
  D. Standard
  E. Personalized

• Question 322:

  Which Snowflake architectural layer is responsible for a query execution plan?

  A. Compute
  B. Data storage
  C. Cloud services
  D. Cloud provider
  D. Cloud provider

• Question 323:

  Users are responsible for data storage costs until what occurs?

  A. Data expires from Time Travel
  B. Data expires from Fail-safe
  C. Data is deleted from a table
  D. Data is truncated from a table
  B. Data expires from Fail-safe

• Question 324:

  Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

  A. STRIP_NULL_VALUES
  B. SKIP_BYTE_ORDER_MARK
  C. REPLACE_INVALID_CHARACTERS
  D. VALIDATION_MODE
  D. VALIDATION_MODE

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS String (constant) that instructs the COPY command to validate the data files instead of loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified:

• Question 325:

  Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

  A. Materialized views
  B. Sequences
  C. Procedures
  D. Tables
  E. Secure User Defined Functions (UDFs)
  D. Tables
  E. Secure User Defined Functions (UDFs)

  ---

  Explanation/Reference:

  Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared: Tables External tables Secure views Secure materialized views Secure UDFs

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

• Question 326:

  Which of the following significantly improves the performance of selective point lookup queries on a table?

  A. Clustering
  B. Materialized Views
  C. Zero-copy Cloning
  D. Search Optimization Service
  A. Clustering

• Question 327:

  The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

  

  A user needs to extract the dealership information from the JSON.

  How can this be accomplished?

  A. select src:dealership from car_sales;
  B. select src.dealership from car_sales;
  C. select src:Dealership from car_sales;
  D. select dealership from car_sales;
  A. select src:dealership from car_sales;

• Question 328:

  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
  D. Transient table
  E. Clustered table

• Question 329:

  What can be used to view warehouse usage over time? (Select Two).

  A. The load HISTORY view
  B. The Query history view
  C. The show warehouses command
  D. The WAREHOUSE_METERING__HISTORY View
  E. The billing and usage tab in the Snowflake web Ul
  D. The WAREHOUSE_METERING__HISTORY View
  E. The billing and usage tab in the Snowflake web Ul

• Question 330:

  What file formats does Snowflake support for loading semi-structured data? (Choose three.)

  A. TSV
  B. JSON
  C. PDF
  D. Avro
  E. Parquet
  F. JPEG
  B. JSON
  D. Avro
  E. Parquet