❄️ SnowPro Core Certification Exam Material

This repository contains structured study material for the Snowflake SnowPro Core Certification. It includes topic-wise guides to help you prepare effectively. Ideal for beginners and professionals aiming to validate their Snowflake expertise.

---

🎯 SnowPro Core Certification Overview

• ✅ Official Certification Link
• 📝 Exam Format:
  • 100 questions
  • Total marks: 1000
  • Passing score: 750
  • Duration: 115 minutes
• 📚 Question Style:
  • Mostly case study-based
  • Few direct questions
  • Focus on scenario-based problem solving

---

📊 Topic-wise Weightage

Domain	Weight
1.0 Snowflake Data Cloud Features & Architecture	24%
2.0 Account Access and Security	18%
3.0 Performance Concepts	16%
4.0 Data Loading and Unloading	12%
5.0 Data Transformations	18%
6.0 Data Protection and Data Sharing	12%

Snow Pro Core Study Guide

Register for Certification

---

📚 Repository Contents

This repository contains detailed descriptions on each topic in a well-structured format:

• 🔹 Introduction
• 🔹 Snowflake Architecture
  • Snowflake Introduction
  • Multi-cluster Shared Disk
  • Architecture Layers
  • Snowflake Editions
  • Snowflake Pricing
  • Resource Monitor
  • Warehouse and Multiclustering
  • Snowflake Objects
  • SnowSQL
• 🔹 Load and Unload Data
  • Stages
  • COPY INTO
  • FILE FORMAT
  • Storage Integration
  • Snowpipe
  • COPY Options
  • Validation Mode
  • VALIDATE
  • Unloading
• 🔹 Transformation and Functions
  • Introduction to Transformations
  • Introduction to Functions
  • Estimation Functions
  • User Defined Functions
  • External Functions
  • Stored Procedures
  • Secure UDFs and Stored Procedures
  • Sequences
  • Semi-Structured Data
  • Querying Semi-Structured Data
  • Unstructured Data
  • Directory Tables
  • Data Sampling
  • Tasks
  • Streams
• 🔹 Tools, Drivers, and Connectors
  • Connectors and Drivers
  • Snowflake Scripting
  • Snowpark
• 🔹 Data Protection
  • Time Travel
  • Retention Period
  • Fail Safe
  • Table Types
• 🔹 Zero Copy Cloning
  • Introduction to Zero Copy Cloning
  • Data Sharing
  • Database Replication
• 🔹 Account and Security
  • Access Control
  • Privileges
  • Multi-Factor Authentication
  • Federated Authentication
  • Key Pair Authentication
  • Column-Level Security
  • Row-Level Security
  • Network Policies
  • Data Encryption
  • Account Usage & Information Schema
  • Release Process
• 🔹 Performance Concepts
  • Query Profiling and History
  • Caching
  • Micro-Partitions
  • Clustering Keys
  • System Functions for Clustering Keys
  • Search Optimization Services
  • Materialized Views
  • Warehouse Considerations

---

Feel free to contribute or raise issues to improve the content. Happy learning! 🎓