Snowflake Certification Cheat Sheet exam 2023 with 100% correct answers

What is Snowflake? (key features) correct answersAnalytic data warehouse SaaS offering - No hardware/installation/patching - No ongoing maintenance/tuning - Can't run privately (on-prem/hosted) Runs completely in the Cloud (AWS, Azure, GCP) - Has its own VPC Decoupled compute and storage (scaled compute does not need scaled storage) Snowflake Pricing (what determines unit cost, pricing model, editions features) correct answersUnit costs for Credits and data storage determined by Region (not Cloud platform) Pricing model = on-demand or discounted upfront Editions: - Enterprise (or greater) => 90 days time-travel (default is 1 day) + materialized view + multi-cluster warehouse - Business Critical => more security (HIPAA, SOC 1&2, PCI DSS) - VPS Edition => own cloud service layer (not shared with accounts) Snowflake Regions - Is multi-region account supported? correct answersNo multi-region accounts supported - Each account can only be in one region