← Back to exam page

COF-C02 – SnowPro Core Certification Exam (COF-C02)

Loading demo links...

Showing 7–9 of 15 questions

Question 7 (Exam pool A)

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

Select all that apply, then click Submit answer.

  • ○

    When another warehouse is used to execute the query
  • ○

    When another user executes the query
  • ○

    When the underlying data has changed
  • ○

    When the warehouse used to execute the query is suspended
  • ○

    When it has been 24 hours since the last query
Question 8 (Exam pool A)

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option

What does the STRIP_OUTER_ARRAY file format do?

Select an option, then click Submit answer.

  • ○

    It removes the last element of the outer array.
  • ○

    It removes the outer array structure and loads the records into separate table rows,
  • ○

    It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns
  • ○

    It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records
Question 9 (Exam pool A)

How would you determine the size of the virtual warehouse used for a task?

Select an option, then click Submit answer.

  • ○

    Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
  • ○

    Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
  • ○

    If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
  • ○

    Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule