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
    :Jul 10, 2026

Snowflake COF-C02 Online Questions & Answers

  • Question 21:

    Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

    A. Amazon Web Services
    B. Docker
    C. IBM Cloud
    D. Microsoft Azure Cloud
    E. Google Cloud Platform
    F. Oracle Cloud

  • Question 22:

    Which object or feature can be used to monitor access to shared data?

    A. Resource monitor
    B. Access control
    C. QUERY_HISTORY view
    D. ACCESS_HISTORY view

  • Question 23:

    When snaring data in Snowflake. what privileges does a Provider need to grant along with a share? (Select TWO).

    A. USAGE on the specific tables in the database.
    B. USAGE on the specific tables in the database.
    C. MODIFY on 1Mb specific tables in the database.
    D. USAGE on the database and the schema containing the tables to share
    E. OPEBATE on the database and the schema containing the tables to share.

  • Question 24:

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

    How can a Data Exchange Administrator provide a user with account access to a Data Exchange?

    A. Grant the user the USERADMIN role.
    B. Add the user to the Data Exchange.
    C. Enable the IMPORT SHARE privilege and grant this privilege to the user.
    D. Create a new database for the Data Exchange and provide access to the user.

  • Question 26:

    Snowflake enforces unique, primary key, and foreign key constraints during DML operations.

    A. True
    B. False

  • Question 27:

    What unit of storage supports efficient query processing in Snowflake?

    A. Blobs
    B. JSON
    C. Block storage
    D. Micro-partitions

  • Question 28:

    How should the SPLIT_TO_TABLE(, ) function be called?

    A. SELECT SPLIT_TO_TABLE(COL1, '.') FROM DUAL;
    B. SELECT SPLIT_TO_TABLE('a.b.c', '.');
    C. SELECT * FROM TABLE(SPLIT_TO_TABLE('a.b.c', '.'));
    D. SELECT * FROM SPLIT_TO_TABLE('a.b.c', '.');

  • Question 29:

    Which type of Snowflake virtual warehouse provides 16 times the memory for each node, and is recommended for larger workloads like Machine Learning (ML) training?

    A. A size 6XL warehouse
    B. A standard warehouse
    C. A multi-cluster warehouse
    D. A Snowpark-optimized warehouse

  • Question 30:

    If a virtual warehouse runs for 30 seconds after it is provisioned, how many seconds will the customer be billed for?

    A. 30 seconds
    B. 60 seconds
    C. 121 seconds
    D. 1 hour

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