← Back to exam page

SnowPro-Core – SnowPro Core Certification Exam

Loading demo links...

Showing 1–3 of 20 questions

Question 1

Which of the following statements describe features of Snowflake data caching? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
  • ○

    When the data cache is full, the least-recently used data will be cleared to make room.
  • ○

    A user can only access their own queries from the query result cache.
  • ○

    A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
  • ○

    The RESULT_SCAN table function can access and filter the contents of the query result cache.
Question 2

What services does Snowflake automatically provide for customers that they may have been responsible for with their on-premise system? (Choose all that apply.)

Select all that apply, then click Submit answer.

  • ○

    Installing and configuring hardware
  • ○

    Patching software
  • ○

    Physical security
  • ○

    Maintaining metadata and statistics
Question 3

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