Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1351:

  How does Snowflake describe its unique architecture?

  A. A single-cluster shared data architecture using a central data repository and massively parallel processing (MPP)
  B. A multi-duster shared nothing architecture using a soloed data repository and massively parallel processing (MPP)
  C. A single-cluster shared nothing architecture using a sliced data repository and symmetric multiprocessing (SMP)
  D. A multi-cluster shared nothing architecture using a siloed data repository and symmetric multiprocessing (SMP)
  B. A multi-duster shared nothing architecture using a soloed data repository and massively parallel processing (MPP)

  ---

  Explanation

• Question 1352:

  What is a recommended best practice when loading data into Snowflake?

  A. Combine smaller files into larger tiles before loading.
  B. When loading a single large file split it into multiple files before loading.
  C. Set the DATA_RETENTION_TIME_IN_DAYS on the table to 0 before loading.
  D. Make sure the files in the stage are either all compressed or all uncompressed.
  B. When loading a single large file split it into multiple files before loading.

  ---

  Explanation

  To optimize parallelism and maximize performance, large files should be split into multiple smaller files (ideally 100?50 MB compressed) before loading. This allows Snowflake to load files in parallel using multiple threads or clusters.

  Snowflake Docs: Best Practices for Data Loading

• Question 1353:

  Which function will return a row for each for each object in a VARIANT, OBJECT, or ARRAY column?

  A. CAST
  B. FLATTEN
  C. GET
  D. PARSE_JSON
  B. FLATTEN

  ---

  Explanation

• Question 1354:

  Select the different types of Internal Stages: (Choose three.)

  A. Named Stage
  B. User Stage
  C. Table Stage
  D. Schema Stage
  A. Named Stage
  B. User Stage
  C. Table Stage

  ---

  Explanation

  https://dwgeek.com/type-of-snowflake-stages-how-to-create-and-use.html/#Snowflake-Internal-Named-Stage

• Question 1355:

  What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?

  A. READ
  B. OWNERSHIP
  C. USAGE
  D. WRITE
  C. USAGE

  ---

  Explanation

• Question 1356:

  Which key governance feature in Snowflake allows users to identify data objects that contain sensitive data and their related objects?

  A. Object tagging
  B. Data classification
  C. Row access policy
  D. Column-level security
  A. Object tagging

  ---

  Explanation

• Question 1357:

  What services does Snowflake automatically provide for customer that they may have been responsible for with their on premise system? Select all the below that apply.

  A. Installing and configuring hardware
  B. Patching software
  C. Physical security
  D. Maintaining metadata and statists
  A. Installing and configuring hardware
  B. Patching software
  D. Maintaining metadata and statists

  ---

  Explanation

• Question 1358:

  Which process does Snowflake follow when a stored procedure with owner's rights is called within a session?

  A. The procedure will be run with the privileges of the caller.
  B. The owner can set the caller's session variables.
  C. The owner will inherit the caller's current virtual warehouse.
  D. The owner can view the caller's session variables.
  A. The procedure will be run with the privileges of the caller.

  ---

  Explanation

  Owner's Rights Stored Procedures: Why Other Options Are Incorrect:

  B. The owner can set the caller's session variables: Stored procedures cannot modify session variables of the caller.

  C. The owner will inherit the caller's current virtual warehouse: The procedure uses the session's current warehouse, not inherited settings.

  D. The owner can view the caller's session variables: Session variables are private to the caller and

  not visible to the owner.

  References:

  Stored Procedure Privileges Documentation

• Question 1359:

  When using the COPY INTO command to unload table data into a CSV file, which option would compress the file using the default algorithm?

  A. SNAPPY
  B. DEFLATE
  C. NONE
  D. AUTO
  D. AUTO

  ---

  Explanation

  When unloading data using the COPY INTO command, Snowflake offers options to compress files. The default behavior is governed by the COMPRESSION parameter. Setting COMPRESSION = AUTO allows Snowflake to

  automatically use its default compression algorithm, which is GZIP for most formats like CSV.

  Snowflake Docs: COPY INTO (unloading)

  Default: COMPRESSION = AUTO (GZIP for CSV)

• Question 1360:

  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

  ---

  Explanation