1. Home
  2. Snowflake
  3. COF-C02

Snowflake COF-C02 Online Practice Questions and Exam Preparation

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 431:

    What is the MINIMUM Snowflake edition that must be used in order to see the ACCESS_HISTORY view?

    A. Standard
    B. Enterprise
    C. Business Critical
    D. Virtual Private Snowflake (VPS)

  • Question 432:

    How often are the Account and Table master keys automatically rotated by Snowflake?

    A. 30 Days
    B. 60 Days
    C. 90 Days
    D. 365 Days.

  • Question 433:

    Which object type is granted permissions for reading a table?

    A. User
    B. Role
    C. Attribute
    D. Schema

  • Question 434:

    Which role has the HIGHEST precedence among roles that will serve as the owners of securable objects?

    A. USERADMIN
    B. SYSADMIN
    C. SECURITYADMIN
    D. ACCOUNTADMIN

  • Question 435:

    How many resource monitors can be applied to a single virtual warehouse?

    A. Zero
    B. One
    C. Eight
    D. Unlimited

  • Question 436:

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

    A. Execute a COPY command
    B. Updating data
    C. Snowpipe
    D. AUTOMATIC__CLUSTERING
    E. Scaling up a warehouse

  • Question 437:

    A table was created using this statement:

    CREATE TRANSIENT TABLE T1 (

    ID NUMERIC NOT NULL,

    NAME STRING COLLATE 'en-ci') WITH MASKING POLICY MP1

    )

    CLUSTER BY ID

    WITH ROW ACCESS POLICY AP1 ON (NAME)

    Which feature of this table will incur both compute and storage costs?

    A. The row access policy
    B. The Automatic Clustering
    C. The Dynamic Data Masking policy
    D. The not null constraint

  • Question 438:

    What is the MINIMUM size requirement when creating a Snowpark-optimized virtual warehouse?

    A. X-Small
    B. Small
    C. Medium
    D. Large

  • Question 439:

    Which of the following can be executed/called with Snowpipe?

    A. A User Defined Function (UDF)
    B. A stored procedure
    C. A single copy_into statement
    D. A single insert__into statement

  • Question 440:

    What are potential impacts of storing non-native values like dates and timestamps in a VARIANT column in Snowflake?

    A. Faster query performance and increased storage consumption
    B. Slower query performance and increased storage consumption
    C. Faster query performance and decreased storage consumption
    D. Slower query performance and decreased storage consumption

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.