← Back to exam page

COF-R02 – SnowPro Core Recertification Exam

Loading demo links...

Showing 10–12 of 15 questions

Question 10 (Exam pool C)

What is the recommended compressed file size range for continuous data loads using Snowpipe?

Select an option, then click Submit answer.

  • ○

    8-16 MB
  • ○

    16-24 MB
  • ○

    10-99 MB
  • ○

    100-250 MB
Question 11 (Exam pool C)

Which statement describes pruning?

Select an option, then click Submit answer.

  • ○

    The filtering or disregarding of micro-partitions that are not needed to return a query.
  • ○

    The return of micro-partitions values that overlap with each other to reduce a query's runtime.
  • ○

    A service that is handled by the Snowflake Cloud Services layer to optimize caching.
  • ○

    The ability to allow the result of a query to be accessed as if it were a table.
Question 12 (Exam pool C)

What happens to historical data when the retention period for an object ends?

Select an option, then click Submit answer.

  • ○

    The data is cloned into a historical object.
  • ○

    The data moves to Fail-safe
  • ○

    Time Travel on the historical data is dropped.
  • ○

    The object containing the historical data is dropped.