Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 731:

  Which native data types are used for storing semi-structured data in Snowflake? (Choose two.)

  A. NUMBER
  B. OBJECT
  C. STRING
  D. VARCHAR
  E. VARIANT
  B. OBJECT
  E. VARIANT

  ---

  Explanation

• Question 732:

  Which semi-structured file format is a compressed, efficient, columnar data representation?

  A. Avro
  B. JSON
  C. TSV
  D. Parquet
  D. Parquet

  ---

  Explanation

• Question 733:

  Which SQL commands should be used to write a recursive query if the number of levels is unknown? (Choose two.)

  A. CONNECT BY
  B. LISTAGG
  C. MATCH RECOGNIZE
  D. QUALIFY
  E. WITH
  A. CONNECT BY
  E. WITH

  ---

  Explanation

• Question 734:

  What type of function can be used to estimate the approximate number of distinct values from a table that has trillions of rows?

  A. MD5
  B. Window
  C. External
  D. HyperLogLog (HLL)
  D. HyperLogLog (HLL)

  ---

  Explanation

• Question 735:

  An active warehouse is required to run a COPY INTO statement.

  A. True
  B. False
  A. True

  ---

  Explanation

• Question 736:

  A sales table FCT_SALES has 100 million records. The following Query was executed

  SELECT COUNT (1) FROM FCT__SALES;

  How did Snowflake fulfill this query?

  A. Query against the result set cache
  B. Query against a virtual warehouse cache
  C. Query against the most-recently created micro-partition
  D. Query against the metadata excite
  D. Query against the metadata excite

  ---

  Explanation

• Question 737:

  A Snowflake user needs to import a JSON file larger than 16 MB. What file format option could be used?

  A. trim_space = true
  B. compression = auto
  C. strip_outer_array = true
  D. strip_outer_array = false
  C. strip_outer_array = true

  ---

  Explanation

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

• Question 738:

  How can the COPY command be used to unload data from a table to an internal stage?

  A. COPY INTO
  B. COPY INTO
  C. COPY INTO with single-true
  D. COPY INTO S3://
  A. COPY INTO
  B. COPY INTO

  ---

  Explanation

• Question 739:

  Which statement describes pruning?

  A. The filtering or disregarding of micro-partitions that are not needed to return a query.
  B. The return of micro-partitions values that overlap with each other to reduce a query's runtime.
  C. A service that is handled by the Snowflake Cloud Services layer to optimize caching.
  D. The ability to allow the result of a query to be accessed as if it were a table.
  A. The filtering or disregarding of micro-partitions that are not needed to return a query.

  ---

  Explanation

• Question 740:

  A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:

  COPY INTO my__table FROM @my__stage;

  The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.

  If the user runs the same copy into command what will happen?

  A. All data from all of the files on the stage will be appended to the table
  B. Only data about new customers from the new files will be appended to the table
  C. The operation will fail with the error uncertain files in stage.
  D. All data from only the newly-added files will be appended to the table.
  D. All data from only the newly-added files will be appended to the table.

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-load-considerations-load.html#executing-parallel-copy-statements-that-reference-the-same-data-files