Snowflake Certification Cheat Sheet || with 100% Error-free Answers

What is Snowflake? (key features) correct answers Analytic 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 answers Unit 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 answers No multi-region accounts supported - Each account can only be in one region Multiple regions supported for each cloud provider - AWS: 11 regions (US, EU, Asia-Pacific) - Azure: 8 regions (US, EU, Asia-Pacific) - GCP: 3 regions (US, EU) Options to Connect to Snowflake correct answers Web-based UI Command-Line client (SnowSQL) ODBC, JDBC (must download driver) Native connectors (Python, Spark, Kafka) Third-Party connectors (e.g., Matillion)