← Back to exam page

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

Free demo downloads

Loading demo links...

Showing 1–3 of 15 questions

Question 1 (Exam pool B)

What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    The clone always stays in sync with the original table.
  • ○

    The clone has better query performance.
  • ○

    The clone is created almost instantly.
  • ○

    The clone will have time travel history from the original table.
  • ○

    The clone saves space by not duplicating storage.
Question 2 (Exam pool A)

Which of the following compute resources or features are managed by Snowflake? (Select TWO).

Select all that apply, then click Submit answer.

  • ○

    Execute a COPY command
  • ○

    Updating data
  • ○

    Snowpipe
  • ○

    AUTOMATIC__CLUSTERING
  • ○

    Scaling up a warehouse
Question 3 (Exam pool B)

What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

Select all that apply, then click Submit answer.

  • ○

    Authentication
  • ○

    Resource management
  • ○

    Virtual warehouse caching
  • ○

    Query parsing and optimization
  • ○

    Query execution
  • ○

    Physical storage of micro-partitions