Snowflake SnowPro Certification Study Guide Exam Questions And Answers

Snowflake SnowPro Certification Study Guide Exam Questions And Answers What are the 3 Cloud Providers available for Snowflake - ANS 1) AWS - a provider since inception 2) Azure Cloud Platforms - generally available as of Sept. 2018 3) Google Cloud Platform - trialed late 2019 Snowflake is currently the only DW built for the cloud (T/F) - ANS True How does Snowflake describe their architecture? A) Multi-Cluster, Shared Data B) Single-Cluster, Shared Data - ANS A) Multi-Cluster, Shared Data What are the 3 components of Snowflake's architecture (both the name and descriptor) - ANS 1) Storage - Databases 2) Compute - Virtual Warehouses 3) Cloud Services - Front End What are the Cloud Object Storage options? - ANS 1) AWS S3 2) Azure Blobs 3) GCP How are storage costs calculated? - ANS A daily average of all compressed data storage, including data stored according to Time Travel retention policy and failsafe procedures Which Microsoft and Amazon systems does Compute leverage? - ANS 1) AWS EC2 2) Azure Compute Compute can't scale out as queries are running (T/F) - ANS False Which services does Cloud Services provide? - ANS 1) Security Management 2) Infrastructure Management 3) Metadata Management 4) Query Optimization Are Snowflake's Storage (DB) and Compute (WH) layers A) Separate and Independent B) Together and Dependent - ANS A) Separate and Independent In addition to multiple Virtual Warehouses, Multi-Cluster means individual Virtual Warehouses can... - ANS Scale up or down automatically Multi-Cluster turn off clusters when activity slows down (T/F) - ANS True Snowflake uses ANSI-SQL (T/F) - ANS True What is Snowflake's semi-structured data type called? - ANS VARIANT What are the three types of caching in Snowflake? - ANS 1) Warehouse 2) Metadata 3) Results All cache data are cleared if the underlying data changes (T/F) - ANS True What does Warehouse Caching do? When is the data invalidated? Where does it live? - ANS Stores data that's been loaded into Virtual Warehouses during querying. The data is invalidated if it's suspended. Lives in Compute. What does Metadata Caching do? Where does it live? - ANS It stores various info about tables. It lives in the Cloud Services layer. What does Results Caching do? Where does it live? - ANS It stores results of queries that have been executed within the past 24 hours (assuming underlying data hasn't changed). It lives in the Cloud Services Layer. A customer needs to have a preexisting account with AWS or Azure in order to have a Snowflake account (T/F) - ANS False