Snowflake SnowPro Certification Study Guide

What are the 3 Cloud Providers available for Snowflake - Answer- 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) - Answer- True How does Snowflake describe their architecture? A) Multi-Cluster, Shared Data B) Single-Cluster, Shared Data - Answer- A) Multi-Cluster, Shared Data What are the 3 components of Snowflake's architecture (both the name and descriptor) - Answer- 1) Storage - Databases 2) Compute - Virtual Warehouses 3) Cloud Services - Front End What are the Cloud Object Storage options? - Answer- 1) AWS S3 2) Azure Blobs 3) GCP How are storage costs calculated? - Answer- 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? - Answer- 1) AWS EC2 2) Azure Compute Compute can't scale out as queries are running (T/F) - Answer- False Which services does Cloud Services provide? - Answer- 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 - Answer- A) Separate and Independent In addition to multiple Virtual Warehouses, Multi-Cluster means individual Virtual Warehouses can... - Answer- Scale up or down automatically Multi-Cluster turn off clusters when activity slows down (T/F) - Answer- True Snowflake uses ANSI-SQL (T/F) - Answer- True What is Snowflake's semi-structured data type called? - Answer- VARIANT What