Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 851:

  What is the recommended Snowflake data type to store semi-structured data like JSON?

  A. VARCHAR
  B. RAW
  C. LOB
  D. VARIANT
  D. VARIANT

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html

• Question 852:

  What objects can be cloned within Snowflake? (Choose two.)

  A. Schemas
  B. Users
  C. External tables
  D. Internal named stages
  E. External named stages
  A. Schemas
  E. External named stages

  ---

  Explanation

• Question 853:

  What actions can be performed by a consumer account on a shared database? (Choose two.)

  A. Cloning a shared table
  B. Modifying the data in a shared table
  C. Using Time Travel on a shared table
  D. Executing the SELECT statement on a shared table
  E. Joining the data from a shared table with another table
  D. Executing the SELECT statement on a shared table
  E. Joining the data from a shared table with another table

  ---

  Explanation

• Question 854:

  During data unloading, only JSON and CSV files can be compressed.

  A. True
  B. False
  B. False

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html

• Question 855:

  When is the result set cache no longer available? (Select TWO)

  A. When another warehouse is used to execute the query
  B. When another user executes the query
  C. When the underlying data has changed
  D. When the warehouse used to execute the query is suspended
  E. When it has been 24 hours since the last query
  C. When the underlying data has changed
  E. When it has been 24 hours since the last query

  ---

  Explanation

• Question 856:

  What would cause different results to be returned when running the same query twice?

  A. SAMPLE is used and the seed is set.
  B. SAMPLE is used and the seed is not set.
  C. Fraction-based sampling is used.
  D. Fixed-size sampling is used.
  B. SAMPLE is used and the seed is not set.

  ---

  Explanation

• Question 857:

  What Snowpark element represents a data set and provides ways to operate on the data?

  A. List
  B. Table
  C. Array
  D. DataFrame
  D. DataFrame

  ---

  Explanation

• Question 858:

  Which commands can a Snowflake user execute to specify a cluster key for a table? (Choose two.)

  A. CREATE
  B. UPDATE
  C. ALTER
  D. SET
  E. SHOW
  A. CREATE
  C. ALTER

  ---

  Explanation

• Question 859:

  A single database can exist in more than one Snowflake account.

  A. True
  B. False
  B. False

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/ddl-database.html

• Question 860:

  Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.

  A. True
  B. False
  B. False

  ---

  Explanation

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