Snowflake SnowPro Core Certification Preparation - COF-C02

Explore the architectural evolution that led to Snowflake. Compare shared-disk and shared-nothing database architectures, understand their strengths and limitations, and discover how Snowflake's cloud-native design separates compute from storage to deliver scalable, high-performance analytics.

Discover how Snowflake combines the strengths of shared-disk and shared-nothing architectures. Learn how separating compute from storage enables independent scaling, workload isolation, massively parallel processing, and simplified data management in a cloud-native platform.

Explore Snowflake's Storage Layer, from its cloud-native foundation to the technologies that power fast analytics. Learn how columnar storage, micro-partitions, metadata, partition pruning, and automatic optimization work together to deliver scalable, high-performance, and low-maintenance data storage.

Discover how Snowflake's Compute Layer processes workloads using Virtual Warehouses. Learn how MPP architecture, independent compute clusters, workload isolation, elastic scaling, and pay-per-use computing deliver high performance, concurrency, and cost-efficient analytics.

Explore the Cloud Services Layer—the intelligence behind Snowflake. Learn how it authenticates users, enforces security, manages metadata, optimizes queries, provisions compute resources, coordinates execution, and enables features such as Time Travel, Zero-Copy Cloning, and Secure Data Sharing.

Discover how Snowgrid extends Snowflake beyond a single account. Learn how it securely connects Snowflake deployments across cloud providers and regions, enabling cross-cloud collaboration, replication, disaster recovery, secure data sharing, and globally distributed applications.

Explore what happens when data enters Snowflake. Learn how structured, semi-structured, and unstructured data is transformed into columnar format, divided into micro-partitions, compressed, encrypted, and enriched with metadata for efficient storage and querying.

Learn why Snowflake uses columnar storage instead of traditional row-based storage. Compare both approaches and discover how reading only the required columns improves query performance, increases compression, reduces I/O, and accelerates analytical workloads.

Review the key advantages of columnar storage in Snowflake. Learn how selective column access, high compression, reduced I/O, faster query execution, lower compute costs, and analytics-optimized design make it the foundation of Snowflake's performance.

See what a micro-partition looks like beneath the surface. Learn how each micro-partition is stored as a proprietary compressed file in cloud object storage and how these files, together with metadata, power many of Snowflake's advanced capabilities.

Learn how Snowflake automatically generates and maintains metadata for every micro-partition. Discover the statistics it stores, where the metadata is maintained, and how it enables intelligent query optimization through techniques such as partition pruning.

Learn how Snowflake uses micro-partition metadata to eliminate unnecessary data scans. Discover the principles of partition pruning and see how metadata allows Snowflake to identify the only micro-partitions that could satisfy a query.

Discover how Snowflake reduces storage and improves query performance through automatic data compression. Learn how columnar storage enables efficient column-level compression and how compressed micro-partitions further optimize storage and data transfer.

Learn how Snowflake protects data at rest through automatic encryption. Discover how every micro-partition is encrypted using AES-256, how encryption keys are managed and rotated by Snowflake, and how enterprise-grade security is delivered transparently.

Review the key concepts of Snowflake's Storage Layer, including cloud object storage, columnar format, micro-partitions, metadata, partition pruning, compression, encryption, and immutable storage.

Dive deeper into the workings of a virtual warehouse, learn about scaling a virtual warehouse up and down, suspending and resuming a virtual warehouse, and get introduced to the virtual warehouse cache

Let's create a new virtual warehouse and find out how easy it is to create a new compute engine in Snowflake

Discover how Snowflake clustering works through an intuitive library analogy. Follow the journey from natural clustering to single-column clustering, multi-column clustering, and re-clustering, while learning how organizing data to match query patterns reduces micro-partition scanning, improves query performance, and lowers compute costs.

This lecture discusses several Snowflake capabilities that provide security at various levels.

This lecture discusses how all client data in Snowflake is encrypted at rest.

This lecture elaborates on Snowflake's support for multi-factor authentication, which adds an extra layer of protection when users log in

Authentication control in Snowflake is not limited to MFA. This lecture talks about key-pair authentication, SSO / federated authentication, and password policies

Snowflake's access control is built on role-based access control (RBAC) and discretionary access control (DAC). This lecture explains both.

This lecture talks about the system roles that come out of the box with every Snowflake instance

This lecture discusses how administrators can use network policies to enable or prevent access to specific IP addresses.

Let's go through the summary of what we have learned so far about security in Snowflake