Snowflake Certification Questions And Answers
What is Snowflake? (key features) - 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) - 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? - 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 - 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 - Answer- https://account_name.region[.provider]. example for AWS: -sou
Información del documento
- Subido en
- 16 de febrero de 2023
- Número de páginas
- 14
- Escrito en
- 2022/2023
- Tipo
- Examen
- Contiene
- Preguntas y respuestas
