1. Home
  2. Snowflake
  3. COF-R02

Snowflake COF-R02 Online Practice Questions and Exam Preparation

COF-R02 Exam Details

  • Exam Code
    :COF-R02
  • Exam Name
    :SnowPro Core Recertification (COF-R02)
  • Certification
    :Snowflake Certifications
  • Vendor
    :Snowflake
  • Total Questions
    :330 Q&As
  • Last Updated
    :May 31, 2026

Snowflake COF-R02 Online Questions & Answers

  • Question 141:

    Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

    A. Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
    B. The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
    C. SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
    D. A user cannot specify a default warehouse when using the ODBC driver.
    E. The default virtual warehouse size can be changed at any time.

  • Question 142:

    Which command sets the Virtual Warehouse for a session?

    A. COPY WAREHOUSE FROM ;
    B. SET WAREHOUSE = ;
    C. USE WAREHOUSE ;
    D. USE VIRTUAL_WAREHOUSE ;

  • Question 143:

    In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

    A. Bytes scanned
    B. Bytes sent over the network
    C. Number of partitions scanned
    D. Percentage scanned from cache
    E. External bytes scanned

  • Question 144:

    Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

    A. SHOW STORAGE BY TABLE;
    B. SHOW TABLES;
    C. Information Schema-> TABLE_HISTORY
    D. Information Schema-> TABLE_FUNCTION
    E. Information Schema-> TABLE_STORAGE_METRICS

  • Question 145:

    The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

    A. Local disk caching
    B. Authentication and access control
    C. Metadata management
    D. Query processing
    E. Database storage

  • Question 146:

    What tasks can be completed using the copy command? (Select TWO)

    A. Columns can be aggregated
    B. Columns can be joined with an existing table
    C. Columns can be reordered
    D. Columns can be omitted
    E. Data can be loaded without the need to spin up a virtual warehouse

  • Question 147:

    Which SQL command can be used to see the CREATE definition of a masking policy?

    A. SHOW MASKING POLICIES
    B. DESCRIBE MASKING POLICY
    C. GET_DDL
    D. LIST MASKING POLICIES

  • Question 148:

    Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

    A. grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;
    B. grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;
    C. grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;
    D. grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;
    E. grant SELECT on all tables in database DB1 to role MYROLE;
    F. grant SELECT on future tables in database DB1 to role MYROLE;

  • Question 149:

    In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

    A. Compute Credits = 50 Credits Cloud Services = 10
    B. Compute Credits = 80 Credits Cloud Services = 5
    C. Compute Credits = 10 Credits Cloud Services = 9
    D. Compute Credits = 120 Credits Cloud Services = 10
    E. Compute Credits = 200 Credits Cloud Services = 26

  • Question 150:

    A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?

    A. It removes the last element of the outer array.
    B. It removes the outer array structure and loads the records into separate table rows,
    C. It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns
    D. It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records