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
    :May 25, 2025

Snowflake Snowflake Certifications COF-C02 Questions & Answers

  • Question 51:

    When sharing data in Snowflake, what privileges does a Provider need to grant along with a share? (Choose two.)

    A. USAGE on the specific tables in the database.

    B. MODIFY on the specific tables in the database.

    C. SELECT on the specific tables in the database.

    D. USAGE on the database and the schema containing the tables to share.

    E. OPERATE on the database and the schema containing the tables to share.

  • Question 52:

    Which privilege grants the ability to set a column-level security masking policy on a table or view column?

    A. APPLY

    B. CREATE

    C. SET

    D. MODIFY

  • Question 53:

    What takes the highest precedence in Snowflake file format options, when specified in multiple locations during data loading?

    A. The stage definition

    B. The table definition

    C. The use of a copy into

    statement

    D. The use of a copy into statement

  • Question 54:

    What is the MINIMUM Snowflake edition that offers data protection for extremely sensitive data, such as Protected Health Information (PHI)?

    A. Standard

    B. Enterprise

    C. Business Critical

    D. Virtual Private Snowflake (VPS)

  • Question 55:

    What are the possible values within a METADATA$ACTION column in a Snowflake stream? (Choose two.)

    A. INSERT

    B. UPDATE

    C. DELETE

    D. TRUNCATE

    E. UPSERT

  • Question 56:

    What kind of authentication do Snowpipe REST endpoints use?

    A. OAuth

    B. Key-based

    C. Username and password

    D. Single Sign-On (SSO)

  • Question 57:

    Which data sharing option allows a Snowflake user to set up and manage a group of accounts and offer a share to that group?

    A. Free listing

    B. Paid listing

    C. Direct share

    D. Data Exchange

  • Question 58:

    Which data type can be used for floating-point numbers without losing precision?

    A. BINARY

    B. VARIANT

    C. INTEGER

    D. DOUBLE

  • Question 59:

    What optional properties can a Snowflake user set when creating a virtual warehouse? (Choose two.)

    A. Auto-suspend

    B. Cache size

    C. Default role

    D. Resource monitor

    E. Storage size

  • Question 60:

    Secured Data Sharing is allowed for which Snowflake database objects? (Choose two.)

    A. Tables

    B. User-Defined Table Functions (UDTFs)

    C. Secure views

    D. Stored procedures

    E. Worksheets

    • 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.