1. Home
  2. Snowflake
  3. COF-C02

SnowPro Core Certification (COF-C02)

Exam Details

  • Exam Code
    :COF-C02
  • Exam Name
    :SnowPro Core Certification (COF-C02)
  • Certification
    :Snowflake Certifications
  • Vendor
    :Snowflake
  • Total Questions
    :1332 Q&As
  • Last Updated
    :Jun 19, 2025

Snowflake Snowflake Certifications COF-C02 Questions & Answers

  • Question 881:

    Using variables in Snowflake is denoted by using which SQL character?

    A. @

    B. and

    C. $ D. #

  • Question 882:

    True or False: Snowpipe via REST API can only reference External Stages as source.

    A. True

    B. False

  • Question 883:

    Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

    A. STRIP_NULL_VALUES

    B. SKIP_BYTE_ORDER_MARK

    C. REPLACE_INVALID_CHARACTERS

    D. VALIDATION_MODE

  • Question 884:

    What is the default file size when unloading data from Snowflake using the COPY command?

    A. 5 MB

    B. 8 GB

    C. 16 MB

    D. 32 MB

  • Question 885:

    Which feature allows a user the ability to control the organization of data in a micro-partition?

    A. Range Partitioning

    B. Search Optimization Service

    C. Automatic Clustering

    D. Horizontal Partitioning

  • Question 886:

    Which SQL command can be used to see the CREATE definition of a masking policy?

    A. SHOW MASKING POLICIES

    B. DESCRIBE MASKING POLICY

    C. GET_DDL

    D. LIST MASKING POLICIES

  • Question 887:

    How can a row access policy be applied to a table or a view? (Choose two.)

    A. Within the policy DDL

    B. Within the create table or create view DDL

    C. By future APPLY for all objects in a schema

    D. Within a control table

    E. Using the command ALTER ADD ROW ACCESS POLICY ;

  • Question 888:

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

    A. The clone always stays in sync with the original table.

    B. The clone has better query performance.

    C. The clone is created almost instantly.

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

    E. The clone saves space by not duplicating storage.

  • Question 889:

    Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

    A. Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.

    B. The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.

    C. SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.

    D. A user cannot specify a default warehouse when using the ODBC driver.

    E. The default virtual warehouse size can be changed at any time.

  • Question 890:

    A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.

    Which Snowflake feature will support this?

    A. Row access policies

    B. Data masking policies

    C. Data encryption

    D. Role based access control

    • Related Exams:

    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.