u/FondantVivid9013in r/dataengineering • Recommends
Describe and use the Snowflake architecture (COF-C03) Snowflake Architecture explained like you actually need it for the exam
removed
0:00 / 0:00
#snowflake#datawarehouse#shareddataarchitecture
Snowflake architect intro _ 1.1 Describe and use the Snowflake architecture (COF-C03)
The Business Intelligence team
85 subscribers • 3 videos on Hallway
- Recommended by 2 people: 2 in engineering communities.
Beginner. No background in the topic needed.
330 views6 months ago2 recommendations
Databases and dataCloud and DevOpsDatabase internalsData engineering and warehousesScaling and large-scale architecture
An introduction to Snowflake's multi-cluster shared data architecture, comparing it to legacy on-premise and shared-nothing systems.
SnowPro® Core (COF-C03) Video Study Guide I. Introduction & Exam Structure – | Introduction & Exam Guide Overview Presentation of the official SnowPro Core certification roadmap. Breakdown of the exam structure, focusing on key domains: Architecture, Data Storage, Data Loading, and Performance. – | Technical Foundations Transition into the deep dive regarding Snowflake’s unique platform foundations. II. Evolution of Data Warehousing – | Legacy Architectures & Traditional Barriers Analysis of "Old School" system limitations, specifically Concurrency issues and rigid Scalability. Comparative study of architectures: Legacy On-Premise, Shared Disk, and Shared Nothing (e.g., traditional Redshift). Introduction of Snowflake as the cloud-native solution designed to eliminate these physical and logical bottlenecks. III. The Snowflake Architecture – | Multi-Cluster Shared Data Architecture A high-level overview of the three integrated layers: Storage Layer: Centralized data repository leveraging cloud object storage (S3/Azure/GCS). Compute Layer: Independent Virtual Warehouses for query processing. Cloud Services: The "Brain" managing optimization, security, and metadata. IV. Layer Deep Dives & Exam Practice – | Storage Layer Details Technical explanation of Micro-partitions: how Snowflake automatically divides and manages data. Benefits of the Columnar Format for optimized data retrieval and compression. – | Exam Question #1 Analysis Walkthrough and explanation of a sample exam question related to data storage and micro-partitioning. – | Compute Layer (Virtual Warehouses) Detailed look at independent compute resources and "No Resource Contention." Explanation of "T-shirt sizing" (XS to 6XL) and how to scale for performance vs. throughput. – | Exam Question #2 Analysis Breakdown of a question focusing on Virtual Warehouse scaling and credit usage. – | Cloud Services Layer Exploring the service layer's role in Metadata Management, security infrastructure, and global query optimization. – | Exam Question #3 Analysis Quick analysis of a question regarding the responsibilities of the Cloud Services layer. V. Conclusion – | Summary & Final Takeaways #snowflakes #SnowProCore #COFC03 #CloudDataWarehouse #dataengineeringWhy it's here
2 people recommend thisu/KeyCandy4665in r/Database • Recommends
Let's dive into a beginner-friendly look at how Snowflake is actually built. This guide covers Objective 1.1 of the SnowPro Core exam, breaking down the 'magic' behind Snowflake's multi-cluster, shared data architecture so you can see how it works in practice.