Snowflake Certification Cheat Sheet Exam Questions And Answers

Snowflake Certification Cheat Sheet Exam Questions And Answers What is Snowflake? (key features) - ANS 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) - ANS 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? - ANS 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 - ANS Web-based UI Command-Line client (SnowSQL) ODBC, JDBC (must download driver) Native connectors (Python, Spark, Kafka)