Free SnowPro-Core – SnowPro Core Certification Exam Practice Test Question

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.

Select all that apply, then click Submit answer.

• ○

  Installing and configuring hardware

• ○

  Patching software

• ○

  Physical security

• ○

  Maintaining metadata and statistics
  
  

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