COF-C02 Exam Details

  • Exam Code
    :COF-C02
  • Exam Name
    :SnowPro Core Certification (COF-C02)
  • Certification
    :Snowflake Certifications
  • Vendor
    :Snowflake
  • Total Questions
    :1700 Q&As
  • Last Updated
    :May 31, 2026

Snowflake COF-C02 Online Questions & Answers

  • Question 1281:

    Which virtual warehouse con guration is recommended speci cally for a steady workload that has no execution lag?

    A. AUTO_RESUME = FALSE
    B. AUTO_SUSPEND = 0
    C. STATEMENT_TIMEOUT_IN_SECONDS = 3600
    D. MIN_CLUSTER_COUNT = 1 - MAX_CLUSTER_COUNT = 3

  • Question 1282:

    What will happen to partitions if a table is cloned and the original table type is then changed from permanent to transient?

    A. Old partitions will not be changed to transient, but any new partitions added to the clone will follow the transient lifecycle.
    B. Old partitions will be changed to transient, and any new partitions added to the clone will follow the transient lifecycle.
    C. Both old and new partitions will be changed to transient, but the original table will keep the original table type.
    D. Both old and new partitions will be changed to transient, and the original table type will change to transient.

  • Question 1283:

    This statement is run:

    SELECT { 'key' : { 'subkey': 'value' }} mycolumn;

    What notations will retrieve the 'value' from the VARIANT column? (Choose two.)

    A. mycolumn.key.subkey
    B. mycolumn.key:subkey
    C. mycolumn:key.subkey
    D. mycolumn['key'].subkey
    E. mycolumn:key:subkey

  • Question 1284:

    Which Snowflake storage object can be used to store data beyond a single session and will not incur Fail-safe costs?

    A. Permanent table
    B. External table
    C. Temporary table
    D. Transient table

  • Question 1285:

    Which view will show the MOST recent information about table-level storage utilization?

    A. The TABLE_STORAGE_METRICS view in a Snowflake data share
    B. The TABLE_STORAGE_METRICS view in the ACCOUNT_USAGE schema
    C. The TABLE_STORAGE_METRICS view in the INFORMATION_SCHEMA
    D. The STORAGE_USAGE_HISTORY view in the INFORMATION_SCHEMA

  • Question 1286:

    What privileges are required to execute a task?

    A. To execute a task, you need the EXECUTE TASK.
    B. A task is an account-level object and can only be executed by the Account Admin role.
    C. Tasks run automatically and do run under any rote.
    D. Tasks are stored in a special database called the utility database and require EXECUTE TASK privilege in the utility database.

  • Question 1287:

    Which VALIDATION_MODE value will return the errors across the files specified in a COPY command, including files that were partially loaded during an earlier load?

    A. RETURN_-1_ROWS
    B. RETURN_n_ROWS
    C. RETURN_ERRORS
    D. RETURN_ALL_ERRORS

  • Question 1288:

    How can data be shared in Snowflake with another account located in the same region without the need to copy or move the data?

    A. Use the Snowflake Marketplace
    B. Use a stream
    C. Use a Data Exchange
    D. Use a direct share

  • Question 1289:

    When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

    A. True
    B. False

  • Question 1290:

    A clustering key was defined on a table, but it is no longer needed. How can the key be removed?

    A. ALTER TABLE PURGE CLUSTERING KEY
    B. ALTER TABLE DELETE CLUSTERING KEY
    C. ALTER TABLE DROP CLUSTERING KEY
    D. ALTER TABLE REMOVE CLUSTERING KEY

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Snowflake exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your COF-C02 exam preparations and Snowflake certification application, do not hesitate to visit our Vcedump.com to find your solutions here.