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

    Which privilege is required to use the search optimization service in Snowflake?

    A. GRANT SEARCH OPTIMIZATION ON SCHEMA TO ROLE
    B. GRANT SEARCH OPTIMIZATION ON DATABASE TO ROLE
    C. GRANT ADD SEARCH OPTIMIZATION ON SCHEMA TO ROLE
    D. GRANT ADD SEARCH OPTIMIZATION ON DATABASE TO ROLE

  • Question 92:

    Which command can be used to stage local files from which Snowflake interface?

    A. SnowSQL
    B. Snowflake classic web interface (Ul)
    C. Snowsight
    D. .NET driver

  • Question 93:

    A query is using more credits than expected. The Query Profile shows that a majority of the query execution is spent on remote disk I/O.

    How can this be prevented in the future?

    A. Convert the virtual warehouse to Maximized mode.
    B. Increase the size of the virtual warehouse.
    C. Increase the auto suspend time in the virtual warehouse.
    D. Increase the number of clusters in the virtual warehouse.

  • Question 94:

    Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

    A. True
    B. False

  • Question 95:

    Dynamic Data Masking can be used with which Snowflake objects? (Select TWO)

    A. Views
    B. Materialized views
    C. Tables
    D. External tables
    E. Future grants

  • Question 96:

    What compute resource is used when loading data using Snowpipe?

    A. Snowpipe uses virtual warehouses provided by the user.
    B. Snowpipe uses an Apache Kafka server for its compute resources.
    C. Snowpipe uses compute resources provided by Snowflake.
    D. Snowpipe uses cloud platform compute resources provided by the user.

  • Question 97:

    Which URL type permits temporary access to a staged file without granting privileges to the stage?

    A. Pre-signed URL
    B. Scoped URL
    C. File URL
    D. Build_Stage_File_URL

  • Question 98:

    What privileges are necessary for a consumer in the Data Exchange to make a request and receive data? (Choose two.)

    A. CREATE DATABASE
    B. IMPORT SHARE
    C. OWNERSHIP
    D. REFERENCE_USAGE
    E. USAGE

  • Question 99:

    Which operation will produce an error in Snowflake?

    A. Inserting duplicate values into a PRIMARY KEY column
    B. Inserting a NULL into a column with a NOT NULL constraint
    C. Inserting duplicate values into a column with a UNIQUE constraint
    D. Inserting a value to FOREIGN KEY column that does not match a value in the column referenced

  • Question 100:

    If queries start to queue in a multi-cluster virtual warehouse an additional compute cluster starts immediately under what setting?

    A. Auto-scale mode
    B. Maximized mode
    C. Economy scaling policy
    D. Standard scaling policy

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.