Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1331:

  When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

  A. The Pipe load history is reset to empty
  B. The REFRESH parameter is set to TRUE
  C. Previously loaded files will be ignored
  D. All of the above
  A. The Pipe load history is reset to empty

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history "When a pipe is recreated, the load history is dropped."

• Question 1332:

  Which of the following is a data tokenization integration partner?

  A. Protegrity
  B. Tableau
  C. DBeaver
  D. SAP
  A. Protegrity

  ---

  Explanation

• Question 1333:

  Which command is used to unload data from a Snowflake table to an external stage?

  A. COPY INTO
  B. COPY INTO followed by GET
  C. GET
  D. COPY INTO followed by PUT
  A. COPY INTO

  ---

  Explanation

• Question 1334:

  What will be the output of the below query against the table name gold_data?

  select * from gold_data tablesample (100);

  A. It will return an empty sample.
  B. It will return a random 100 rows.
  C. It will return an entire table.
  D. It will produce an error message.
  C. It will return an entire table.

  ---

  Explanation

• Question 1335:

  When used with the UNLOAD command, which parameter specifies the destination of unloaded data?

  A. COPY INTO
  B. COPY INTO
  C. GET
  D. PUT
  B. COPY INTO

  ---

  Explanation

  In Snowflake, the COPY INTO syntax is used with the UNLOAD command to specify the target location where the data should be unloaded, typically a stage or cloud storage (such as Amazon S3 or Azure Blob Storage). This command unloads data from a Snowflake table into files within the specified destination, enabling easy export and external storage of data. GET and PUT commands are used for file management but are not related to unloading table data directly.

• Question 1336:

  Which Query Profile metrics can be used to determine if a query is pruning efficiently?

  A. Bytes read from result and Bytes written to result
  B. Partitions scanned and Partitions total
  C. Bytes spilled to local storage and Bytes spilled to remote storage
  D. Number of rows inserted and Number of rows updated
  B. Partitions scanned and Partitions total

  ---

  Explanation

• Question 1337:

  Which tile format option should be used when unloading data into a stage to create a CSV or a JSON file?

  A. PARSE_HEADER
  B. TRIM_SPACE
  C. FILE_EXTENSION
  D. SKIP_HEADER
  C. FILE_EXTENSION

  ---

  Explanation

  When unloading data into a stage, the FILE_EXTENSION option specifies the file format for output files (e.g., .csv, .json).

  Example for CSV file:

  COPY INTO @my_stage

  FROM my_table

  FILE_FORMAT = (TYPE = CSV, FILE_EXTENSION = '.csv'); Why Other Options Are Incorrect:

  A. PARSE_HEADER: No such option exists for unloading data.

  B. TRIM_SPACE: Removes leading/trailing spaces in strings but is unrelated to file naming.

  D. SKIP_HEADER: Used to skip header rows but does not define file extensions.

  References:

  File Format Options Documentation

• Question 1338:

  What are the three layers that make up Snowflake's architecture? (Choose three)

  A. Compute
  B. Tri-Secret Secure
  C. Storage
  D. Cloud Services
  A. Compute
  C. Storage
  D. Cloud Services

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

• Question 1339:

  How should a Snowflake user access a third-party SaaS service to process unstructured data?

  A. Use internal functions.
  B. Use external functions.
  C. Use process functions.
  D. Use an API gateway.
  B. Use external functions.

  ---

  Explanation

• Question 1340:

  Which Query Profile operator is considered a DML operator?

  A. ExternalScan
  B. Flatten
  C. Merge
  D. Sort
  C. Merge

  ---

  Explanation