Free COF-R02 – SnowPro Core Recertification Exam Practice Test Question

Free demo downloads

Loading demo links...

Showing 4–6 of 15 questions

Question 4 (Exam pool C)

Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),

Select all that apply, then click Submit answer.

  • ○

    Snowflake data and services are deployed in a single availability zone within a cloud provider's region.

  • ○

    Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.

  • ○

    Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage

  • ○

    Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

  • ○

    All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

  • ○

    Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

Question 5 (Exam pool C)

Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

Select all that apply, then click Submit answer.

  • ○

    Schemas

  • ○

    Roles

  • ○

    Secure Views

  • ○

    Stored Procedures

  • ○

    Tables

  • ○

    Secure User-Defined Functions (UDFs)

Question 6 (Exam pool B)

Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

Select all that apply, then click Submit answer.

  • ○

    ORC

  • ○

    XML

  • ○

    Avro

  • ○

    Parquet

  • ○

    JSON