Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 591:

  How does a scoped URL expire?

  A. When the data cache clears.
  B. When the persisted query result period ends.
  C. The encoded URL access is permanent.
  D. The length of time is specified in the expiration_time argument.
  B. When the persisted query result period ends.

  ---

  Explanation

• Question 592:

  The Snowflake VARIANT data type imposes a 16 MB size limit on what?

  A. An individual row
  B. An individual column
  C. A view
  D. A file in a stage
  A. An individual row

  ---

  Explanation

• Question 593:

  If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:

  A. All Snowflake sessions using the warehouse are terminated.
  B. The last query using the warehouse completes.
  C. There are no users loaned into Snowflake.
  D. The Warehouse is inactive for a specified period of time.
  D. The Warehouse is inactive for a specified period of time.

  ---

  Explanation

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

• Question 594:

  Which column data type is supported when defining a clustering key on a table?

  A. VARCHAR
  B. VARIANT
  C. OBJECT
  D. GEOGRAPHY
  A. VARCHAR

  ---

  Explanation

• Question 595:

  What function should be used to convert JSON NULL values to SQL NULL values when loading data into a Snowflake table?

  A. STRIP_OUTER_ARRAYS
  B. STRIP_NULL_VALUE
  C. FLATTEN
  D. PARSE_JSON
  B. STRIP_NULL_VALUE

  ---

  Explanation

• Question 596:

  What Snowflake recommendation is designed to ensure that staged data is only loaded once?

  A. Partitioning staged data files
  B. Loading only the most recently-staged data files
  C. Removing data files after loading
  D. Identifying and removing duplicates after each data load
  C. Removing data files after loading

  ---

  Explanation

• Question 597:

  Which Snowflake privilege is required on a pipe object to pause or resume pipes?

  A. OPERATE
  B. READ
  C. SELECT
  D. USAGE
  A. OPERATE

  ---

  Explanation

• Question 598:

  What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION?

  A. ACCOUNTADMIN
  B. SECURITYADMIN
  C. SYSADMIN
  D. ORGADMIN
  D. ORGADMIN

  ---

  Explanation

• Question 599:

  Which objects can be cloned in Snow ake? (Choose two.)

  A. Virtual warehouses
  B. Internal named stages
  C. External named stages
  D. Dynamic tables
  E. External tables
  B. Internal named stages
  E. External tables

  ---

  Explanation

• Question 600:

  What actions are supported by Snowflake resource monitors? (Choose two.)

  A. Alert
  B. Notify
  C. Notify and suspend
  D. Abort
  E. Suspend immediately
  B. Notify
  C. Notify and suspend

  ---

  Explanation