SnowPro Certification Study Guide Part 1 || with 100% Error-free Solutions.

Database Storage(Layer 3) correct answers Responsible - Data loaded into snowflake is reorganized into internal optimized/compressed/columnar format - Data objects stored by Snowflake are not directly visible nor accessible by customers - Manages all aspects of data(size,compression etc) Query Processing(Layer 2) correct answers Queries are processed using Virtual Warehouses - Each warehouse is an MPP compute cluster composed of compute nodes - Each warehouse is independent compute cluster that does no share compute resources Cloud Services(Layer 1) correct answers Services Include - Authentication - Infrastructure management § Metadata management § Query parsing and optimization § Access Control How are costs accumulated in Snowflake? correct answers - Based on Storage and compute resources used - Storage based on amount compressed data - Data retained for data recovery features - How big and long warehouse runs Snowflake is compliant with? correct answers - HIPPA - PCI DSS - SOC 1 - SOC 2 - FedRAMP Other factors that determine costs? correct answers - Region - On Demand Account - Capacity Account What is an On Demand account? correct answers Usage-based pricing with no long term licensing requirements What is an Capacity account? correct answers Discounted pricing based on an up-front capacity commitment VPS(Virtual Private Snowflake) accounts have different? correct answers Naming Conventions which results in different hostnames/URLs used to access VPS accounts Snowflake Connector Ecosystem scales what industries? correct answers -Data Integration