SNOWFLAKE-1

Snowpro Core Subject Area Breakdown

Detailed Subject Area

Overview of Key Features (docs)
- Introduction to Semi-Structured Data (docs)
- Bringing Together Structured and Semi-Structured Data (docs)
- Semi-Structured Data Types (docs)
- Querying Semi-Structured Data (docs)
- Continuous Data Protection (docs)
- Snowflake Fast Clone
- A Quick Look at Zero-copy Cloning
- Using Persisted Query Results
- Snowflake Pricing & Regions (video)
- Snowflake Regions (docs)
- Snowflake Editions & Pricing (docs)
- Snowflake Release (docs)
Snowflake Architecture
- Database Storage (docs)
- Query Processing (docs)
- Cloud Services (docs)
- Cloud Platform (docs)
- Data Lifecycle (docs)
- Data Protection (docs)
Interface & Connectivity
- Snowflake WebUI (docs)
- SnowSQL (CLI) (docs)
- Connector Ecosystem (docs)
- Partner Connector Ecosystem (docs)
Catalog & Objects
- Database & Schema (docs)
- Tables (docs)
- Views (docs)
- Data Types (docs)
Data Sharing
- Sharing Configuration & Access Control options
- Secure Data Sharing
- Providers, Consumers & Reader Accounts
- Creating & Managing Shares

2.Snowflake Virtual Warehouses: 18%

Compute
- Warehouses & Types (docs)
- Warehouse Sizing & Scaling (docs)
- Credit Usage
- Warehouse Management
- Warehouse Caching
- Warehouse Monitoring

3.Snowflake Storage and Protection: 15%

Storage
- Micro partitions
- Metadata
- Clustering
- Data Storages – Cost & Retention
- Table Types, File Formats
- Storage Monitoring
Continuous Data Protection
- Time Travel, Fail Safe
- Data Encryption
- Security – Network Policies
- Multi-Factor-Authentication (MFA)
- Federated Authentication & SSO

4.Data Movement (Loading and Unloading): 14%

Data Loading
- Stages, file format,pipe (docs)
- Loading Consideration & Load Management (docs)
- Continuous Load Options – Snowpipe (docs) (video)
- Error handling & Troubleshooting
Data Unloading
- Unloading data from Snowflake to External Cloud Storage (S3,GCS,AZURE BLOB) (docs)
- Unloading data from Snowflake to Internal Snowflake Storage (docs)
- Unloading data from Snowflake to Local / Network (docs)
- Drive Data Unloading Considerations (docs)

5.Semi-Structured: 4%

Semi Structured Data
- Different Formats, Variant Table Type (docs)
- Native Syntax, Flattening Data (docs)

6.Snowflake Performance and Tuning: 9%

Performance Management
- Query Performance & Analysis (docs)
- SQL optimization (docs)
- Load Testing (docs)
- Clustering (docs)
- Query Profile (docs)
- Caching (docs)

7.Snowflake Account and Security: 12%

Account Management
- Managing Your Snowflake Account (docs)
- WAREHOUSE & Storage credit usage (docs)
- Materialized Views (docs)
- Auto /Re Clustering (docs)
- DR & Replication (docs)
- Information Schema (docs)
- Differences Between Account Usage and Information Schema (docs)
Security
- Access Control (docs)
- Role Hierarchy and Privilege Inheritance (docs)
- Multi-Factor Authentication (MFA) (docs)
- Data Encryption (docs)
- Network Security & Policies (docs)
- Federated Authentication & SSO (docs)

Snowflake Overview and Architecture: 28%

Overview of Key Features (docs)
- Introduction to Semi-Structured Data (docs)
- Bringing Together Structured and Semi-Structured Data (docs)
- Semi-Structured Data Types (docs)
- Querying Semi-Structured Data (docs)
- Continuous Data Protection (docs)
- Snowflake Fast Clone
- A Quick Look at Zero-copy Cloning
- Using Persisted Query Results
- Snowflake Pricing & Regions (video)
- Snowflake Regions (docs)
- Snowflake Editions & Pricing (docs)
- Snowflake Release (docs)
Snowflake Architecture
- Database Storage (docs)
- Query Processing (docs)
- Cloud Services (docs)
- Cloud Platform (docs)
- Data Lifecycle (docs)
- Data Protection (docs)
Interface & Connectivity
- Snowflake WebUI (docs)
- SnowSQL (CLI) (docs)
- Connector Ecosystem (docs)
- Partner Connector Ecosystem (docs)
Catalog & Objects
- Database & Schema (docs)
- Tables (docs)
- Views (docs)
- Data Types (docs)
Data Sharing
- Sharing Configuration & Access Control options
- Secure Data Sharing
- Providers, Consumers & Reader Accounts
- Creating & Managing Shares