Snowflake SnowPro Certification Study Guide || Already Graded A+

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