Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 501:

  Which encryption type will enable client-side encryption for a directory table?

  A. AES
  B. AWS_CSE
  C. SNOWFLAKE_SSE
  D. SNOWFLAKE_FULL
  D. SNOWFLAKE_FULL

  ---

  Explanation

• Question 502:

  When unloading data from Snowflake to AWS, what permissions are required? (Choose two.)

  A. s3:DeleteObject
  B. s3:CopyObject
  C. s3:GetBucketAcl
  D. s3:PutObject
  E. s3:GetBucketLocation
  A. s3:DeleteObject
  D. s3:PutObject

  ---

  Explanation

  Snowflake requires the following permissions on an S3 bucket and folder to create new files in the folder (and any sub-folders):

  s3:DeleteObject s3:PutObject

  https://docs.snowflake.com/en/user-guide/data-unload-s3#configuring-an-s3-bucket-for-unloading-data

• Question 503:

  Which data types are valid in Snowflake? (Choose two.)

  A. BLOB
  B. Geography
  C. JSON
  D. CLOB
  E. Variant
  B. Geography
  E. Variant

  ---

  Explanation

• Question 504:

  Which Snowflake feature or tool helps troubleshoot issues in SQL query expressions that commonly cause performance bottlenecks?

  A. Persisted query results
  B. QUERY_HISTORY view
  C. Query acceleration service
  D. Query Profile
  D. Query Profile

  ---

  Explanation

• Question 505:

  Based on a review of a Query Profile, which scenarios will benefit the MOST from the use of a data clustering key? (Choose two.)

  A. A column that appears most frequently in ORDER BY operations
  B. A column that appears most frequently in WHERE operations
  C. A column that appears most frequently in GROUP BY operations
  D. A column that appears most frequently in AGGREGATE operations
  E. A column that appears most frequently in JOIN operations
  A. A column that appears most frequently in ORDER BY operations
  B. A column that appears most frequently in WHERE operations

  ---

  Explanation

• Question 506:

  Which Snowflake feature can be used to find sensitive data in a table or column?

  A. Masking policies
  B. Data classification
  C. Row level policies
  D. External functions
  B. Data classification

  ---

  Explanation

• Question 507:

  When unloading data from Snowflake using the COPY INTO command, what is a key consideration for handling NULL values?

  A. NULL values are automatically converted to empty strings.
  B. A string value should be specified to represent NULL values using the NULL_IF option.
  C. If a NULL value is detected during data loading, the process will stop and report an error.
  D. NULL values are automatically skipped during the unload process.
  A. NULL values are automatically converted to empty strings.

  ---

  Explanation

• Question 508:

  What should be used when creating a CSV file format where the columns are wrapped by single quotes or double quotes?

  A. BINARY_FORMAT
  B. ESCAPE_UNENCLOSED_FIELD
  C. FIELD_OPTIONALLY_ENCLOSED_BY
  D. SKIP_BYTE_ORDER_MARK
  C. FIELD_OPTIONALLY_ENCLOSED_BY

  ---

  Explanation

  Leave string fields unenclosed by setting the FIELD_OPTIONALLY_ENCLOSED_BY option to NONE (default) https://docs.snowflake.com/en/user-guide/data-unload-considerations#empty-strings-and-null-values

• Question 509:

  What JavaScript delimiters are available in Snowflake stored procedures? (Choose two.)

  A. Double quotes (")
  B. Single quote (')
  C. Double forward slash (//)
  D. Double backslash (\\)
  E. Double dollar sign ($$)
  B. Single quote (')
  E. Double dollar sign ($$)

  ---

  Explanation

• Question 510:

  Which statement accurately describes a characteristic of a materialized view?

  A. A materialized view can query only a single table.
  B. Data accessed through materialized views can be stale.
  C. Materialized view refreshes need to be maintained by the user.
  D. Querying a materialized view is slower than executing a query against the base table of the view.
  A. A materialized view can query only a single table.

  ---

  Explanation