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 02, 2025

Snowflake Snowflake Certifications COF-C02 Questions & Answers

  • Question 291:

    Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO)

    A. A user with an USERADMIN or higher role

    B. A user with a SECURITYADMIN or higher role

    C. A role that has been granted the ATTACH POLICY privilege

    D. A role that has the NETWORK_POLlCY account parameter set

    E. A role that has the CWKERSHIE of the network policy

  • Question 292:

    Given the statement template below, which database objects can be added to a share? (Choose two.)

    GRANT ON To SHARE ;

    A. Secure functions

    B. Stored procedures

    C. Streams

    D. Tables

    E. Tasks

  • Question 293:

    What data type is used to ingest semi-structured data into a Snowflake table?

    A. BOOLEAN

    B. NUMBER

    C. VARBINARY

    D. VARIANT

  • Question 294:

    Which security feature is used to connect or log in to a Snowflake account?

    A. Network policy

    B. SCIM

    C. Role-Based Access Control (RBAC)

    D. Key pair authentication

  • Question 295:

    What privilege is needed for a Snowflake user to see the definition of a secure view?

    A. OWNERSHIP

    B. MODIFY

    C. CREATE

    D. USAGE

  • Question 296:

    What general guideline does Snowflake recommend when setting the auto-suspension time limit?

    A. Set tasks for immediate suspension.

    B. Set tasks for suspension after 5 minutes.

    C. Set query warehouses for suspension after 15 minutes.

    D. Set query warehouses for suspension after 30 minutes.

  • Question 297:

    When does Snowflake automatically encrypt data that is loaded into Snowflake? (Choose two.)

    A. After the data is micro-partitioned.

    B. After loading the data into a table.

    C. After loading the data into an internal stage.

    D. After loading data into an external stage.

    E. Only when using an encrypted stage.

  • Question 298:

    When data is loaded into Snowflake, what formats does Snowflake use internally to store the data in cloud storage? (Choose two.)

    A. Key-value

    B. Columnar

    C. Graph

    D. Document

    E. Compressed

  • Question 299:

    What do temporary and transient tables have in common in Snowflake? (Choose two.)

    A. Both tables have no Fail-safe period.

    B. Both tables have data retention period maximums of one day.

    C. Both tables are visible only to a single user session.

    D. For both tables, the retention period ends when the tables are dropped.

    E. For both tables, the retention period does not end when the session ends.

  • Question 300:

    What are the least privileges needed to view and modify resource monitors? (Choose two.)

    A. SELECT

    B. OWNERSHIP

    C. MONITOR

    D. MODIFY

    E. USAGE

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