SnowPro Core Certification Study Guides

Snowflake Features & Architecture

Overview And Key ConceptsCloud Services LayerCompute LayerStorage LayerSnowflake EditionsSnowflake Objects HierarchyTable Types And ViewsMicro Partitions And ClusteringSnowflake Cortex AiIceberg TablesSnowpark And StreamlitSnowflake Tools EcosystemSessions And Parameters

Account Management & Governance

Account StructureUser And Role ManagementRbac And DacNetwork Policies And SecurityAuthentication MethodsData Masking And Row AccessObject Tagging And ClassificationResource MonitorsTrust Center And ComplianceData LineageSecondary Roles

Data Loading, Unloading & Connectivity

Stages Internal ExternalFile FormatsCopy Into CommandSnowpipeSnowpipe StreamingData UnloadingConnectors And DriversBest Practices

Performance Optimization, Querying & Transformation

Virtual Warehouses Deep DiveWarehouse Sizing ScalingMulti Cluster WarehousesQuery Processing And CachingQuery Profiling And OptimizationClustering KeysMaterialized ViewsDdl And DmlSemi Structured DataUnstructured DataTasks And StreamsStored Procedures And UdfsTransactions And Error Handling

Data Collaboration & Secure Sharing

Secure Data SharingData MarketplaceData Clean RoomsCross Region Cross CloudReader Accounts

Supplementary Concepts & Tools

Time Travel And Fail SafeZero Copy CloningData ReplicationSnowflake NotebooksGit IntegrationCost Management