Snowflake Certification Cheat Sheet question answers 2023 rated A+

Snowflake Certification Cheat Sheet question answers 2023 rated A+What is Snowflake? (key features) - correct answer 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 answer 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 answer 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 answer Web-based UI Command-Line client (SnowSQL) ODBC, JDBC (must download driver) Native connectors (Python, Spark, Kafka) Third-Party connectors (e.g., Matillion) Other (N, .Net) Connect URL Pattern - correct answer https://<account_name>.<region>[.provider]. example for AWS: Snowflake Architecture Overview - correct answer Hybrid of shared-disk db and shared-nothing db - Uses central data repo for persisted storage - all compute nodes have data access