Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 161:

  Which security feature is available in all Snowflake editions?

  A. Data masking policies
  B. Object-level access control
  C. Object tagging
  D. Customer-managed encryption keys
  B. Object-level access control

  ---

  Explanation

  Object-level access control is available in all Snowflake editions. This feature allows administrators to grant and revoke permissions on specific objects (e.g., tables, schemas, databases) to control access at a granular level. Other features

  like data masking policies and customer-managed encryption keys are available only in higher Snowflake editions.

  References:

  Snowflake Documentation: Object-Level Access Control Snowflake Editions Comparison

• Question 162:

  Which interfaces can be used to create and/or manage Virtual Warehouses?

  A. The Snowflake Web Interface (UI)
  B. SQL commands
  C. Data integration tools
  D. All of the above
  D. All of the above

  ---

  Explanation

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

• Question 163:

  To use the OVERWRITE option on INSERT, which privilege must be granted to the role?

  A. TRUNCATE
  B. DELETE
  C. UPDATE
  D. SELECT
  B. DELETE

  ---

  Explanation

• Question 164:

  What is the Snowflake recommended Parquet file size when querying from external tables to optimize the number of parallel scanning operations?

  A. 1-16 MB
  B. 16-128 MB
  C. 100-250 MB
  D. 256-512 MB
  D. 256-512 MB

  ---

  Explanation

• Question 165:

  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
  D. Search Optimization Service

  ---

  Explanation

• Question 166:

  When a transient table in Snowflake is dropped, what happens to the table?

  A. The table is no longer available for use.
  B. The table can be undropped using Fail-safe.
  C. The table can be recovered for 1 day only and after that it is no longer available.
  D. The table can be recovered only with the assistance of Snowflake Support.
  A. The table is no longer available for use.

  ---

  Explanation

• Question 167:

  Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

  A. VARIANT
  B. VARRAY
  C. STRUCT
  D. ARRAY
  E. QUEUE
  A. VARIANT
  D. ARRAY

  ---

  Explanation

• Question 168:

  Why should a Snowflake user configure a secure view? (Choose two.)

  A. To encrypt the data in transit
  B. To execute faster than a standard view
  C. To protect hidden data from other users
  D. To improve the performance of a query
  E. To hide the view definition from other users
  C. To protect hidden data from other users
  E. To hide the view definition from other users

  ---

  Explanation

  Some of the internal optimizations for views require access to the underlying data in the base tables for the view. This access might allow data that is hidden from users of the view to be exposed through user code, such as user-defined functions, or other programmatic methods. Secure views do not utilize these optimizations, ensuring that users have no access to the underlying data.

  For security or privacy reasons, you might not wish to expose the underlying tables or internal structural details for a view. With secure views, the view definition and details are visible only to authorized users (i.e. users who are granted the role that owns the view).

• Question 169:

  How can customer data be restricted by country for a global company using a multi-tenant environment?

  A. Implement a new account structure and create sub-accounts for each country. Then replicate the required data.
  B. Implement a row-level security policy in the customer table that looks at a mapping table identifying which users should have access to what data.
  C. Implement a secure User-Defined Function (UDF) and use a secure data share for each country.
  D. Implement a column-level security policy in the customer table that restricts access based on the user's geographic location.
  B. Implement a row-level security policy in the customer table that looks at a mapping table identifying which users should have access to what data.

  ---

  Explanation

• Question 170:

  Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO)

  A. Load files that are approximately 25 MB or smaller.
  B. Remove all dates and timestamps.
  C. Load files that are approximately 100-250 MB (or larger)
  D. Avoid using embedded characters such as commas for numeric data types
  E. Remove semi-structured data types
  C. Load files that are approximately 100-250 MB (or larger)
  D. Avoid using embedded characters such as commas for numeric data types

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html