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

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