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

    Structured data must be moved from a Snowflake table to an Amazon S3 bucket and transformed into JSON. What function should be used to do this?

    A. PARSE_JSON()
    B. ARRAY_CONSTRUCT()
    C. OBJECT_CONSTRUCT()
    D. GET

  • Question 1592:

    Which applications can use key pair authentication? (Choose two).

    A. Snowflake Marketplace
    B. SnowCD
    C. Snowsight
    D. SnowSQL
    E. Snowflake connector for Python

  • Question 1593:

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

    Which network policy has the HIGHEST precedence?

    A. Security Integration
    B. Account
    C. Database
    D. User

  • Question 1595:

    Which constraint is enforced in Snowflake?

    A. FOREIGN KEY
    B. NOT NULL
    C. PRIMARY KEY
    D. UNIQUE KEY

  • Question 1596:

    What metrics will the show tables command in Snowsight provide?

    A. Time Travel bytes
    B. Active bytes
    C. Fail-safe bytes
    D. Retained for clone bytes

  • Question 1597:

    When creating a virtual warehouse in Snowsight using a create warehouse statement, which properties are enabled by default? (Select TWO).

    A. ENABLE_QUERY_ACCELERATTON
    B. INITIALLY_SUSPENDED
    C. RES0URCE_M0NTTOR
    D. AUTO_RESUME
    E. AUTO_SUSPEND

  • Question 1598:

    Which of the following are characteristics of security in Snowflake?

    A. Account and user authentication is only available with the Snowflake Business Critical edition.
    B. Support for HIPAA and GDPR compliance is available for UI Snowflake editions.
    C. Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher
    D. Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

  • Question 1599:

    By default, which role has privileges to create tables and views in an account?

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

  • Question 1600:

    What causes objects in a data share to become unavailable to a consumer account?

    A. The DATA_RETENTION_IT parameter in the consumer account is set to 0.
    B. The consumer account runs the GRANT INPORTED PRIVILEGES command on the data share every 24 hours.
    C. The objects in the data share are being deleted and the grant pattern is not re-applied systematically.
    D. The consumer account acquires the data share through a private data exchange.

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.