← Back to exam page

Free COF-C02 – SnowPro Core Certification Exam (COF-C02) Practice Test Question

Free demo downloads

Loading demo links...

Showing 4–6 of 15 questions

Question 4 (Exam pool A)

What data is stored in the Snowflake storage layer? (Select TWO).

Select all that apply, then click Submit answer.

  • ○

    Snowflake parameters
  • ○

    Micro-partitions
  • ○

    Query history
  • ○

    Persisted query results
  • ○

    Standard and secure view results
Question 5 (Exam pool B)

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Removing a column from the query SELECT list
  • ○

    Stopping the virtual warehouse that the query is running against
  • ○

    Clustering of the data used by the query
  • ○

    Executing the RESULTS_SCAN() table function
  • ○

    Changing a column that is not in the cached query
Question 6 (Exam pool A)

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

Select all that apply, then click Submit answer.

  • ○

    Internal stages
  • ○

    Incremental backups
  • ○

    Time Travel
  • ○

    Zero-copy clones
  • ○

    Fail-safe