book

SnowPro Core Certification Study Guide

by Jatin Verma

February 2025

Beginner to intermediate

314 pages

7h 40m

English

Packt Publishing

Read now

Unlock full access

ContributorsAbout the AuthorAbout the Reviewer
Who This Book Is ForWhat This Book CoversHow to Get the Most Out of This BookOnline Practice ResourcesDownload the Color ImagesConventions UsedGet in TouchShare Your ThoughtsDownload a Free PDF Copy of This Book
Making the Most of This Book – Your Certification and BeyondWhy Snowflake?Traditional Data Warehousing ChallengesCloud Computing Model versus Traditional Data WarehousesWhat Is Cloud Computing?SummaryExam Readiness Drill – Chapter Review QuestionsHOW TO GET STARTED
Snowflake Architecture and Key FeaturesSnowflake’s Data Warehouse ArchitectureSnowflake’s Data Warehouse Architecture ComponentsThe Flow of Data in Snowflake’s Warehouse ArchitectureSnowflake Data LakeOn-Demand Snowflake Data LakesPre-Purchased Capacity Snowflake Data LakesSnowflake EditionsStandard EditionEnterprise EditionBusiness Critical EditionVirtual Private SnowflakePricingChoosing the Right Snowflake EditionResource Monitoring in SnowflakeResource Monitor ActionsFeatures of Resource MonitoringCreating a Resource MonitorSnowflake CreditsCompute ResourcesStorageData TransferBilling for Snowflake CreditsSnowflake Schemas for Cost InformationWarehouses and Multi-ClusteringWhat Is a Warehouse?What Is a Multi-Cluster Warehouse?Snowflake Tools and User InterfacesSnowflake CLI (SnowSQL)Programmatic ConnectorsDriversWebUISnowCD (Snowflake Connectivity Diagnostic Tool)SnowparkExercise 2.2Snowflake’s Catalog and ObjectsTablesViewsExercise 2.3: Creating Different Table Types and Setting Retention Periods in SnowflakeSnowflake Storage ConceptsSummaryPractice ActivityScenario 1Scenario 2Scenario 3Scenario 4Scenario 5Exam Readiness Drill – Chapter Review QuestionsHOW TO GET STARTED
Authentication in SnowflakeFederated EnvironmentKey-Pair AuthenticationMFAWhy Is Authentication Necessary?Controlling Network/Site AccessNetwork RulesExercise 3.1: Using SQL to Create a Network PolicyExercise 3.2: Creating and Applying a Network Using the Snowflake ConsoleUnderstanding Access ControlSecurable ObjectEntities and Roles in SnowflakeExercise 3.3: Creating a Custom Role and Assigning PrivilegesBonus ExerciseAuthorization and Data Protection in SnowflakeColumn-Level SecurityExercise 3.4: Implementing a Masking Policy for Column-Level SecurityRAPsExercise 3.5: Implementing a RAPAccount Usage Schema, Information Schema, and the Release ProcessAccount UsageInformation SchemaRelease ProcessSummaryFurther ReadingPractice ActivitySolutionsExam Readiness Drill – Chapter Review QuestionsHOW TO GET STARTED
Virtual Warehouse Configurations in SnowflakeWarehouse SizeCluster TypeQuery Acceleration ServiceScaling PoliciesCreating a WarehouseSnowflake Virtual Warehouse ModesSnowflake Warehouse ConsiderationsCredits Charged for WarehousesMulti-Cluster WarehousesQuery Acceleration ServiceSummaryExam Readiness Drill – Chapter Review QuestionsHOW TO GET STARTED
Snowflake’s Query ProfileWhat Is Query Profile?Understanding the Query Profile InterfaceSpilling and How to Avoid ItAccessing Query ProfileCaching in SnowflakeQuery Result CacheData CacheMetadata CacheMicro-Partitions and Clustering in SnowflakeMicro-PartitioningClusteringReclusteringViews in SnowflakeWhat Are Views?Search Optimization ServiceWhat Is Snowflake’s SOS?Enabling Search OptimizationBeneficial QueriesAdditional Factors to Consider Before Using SOSCostingWorking with the SOSSummaryPractical ExerciseTaskSolutionExam Readiness Drill – Chapter Review QuestionsHOW TO GET STARTED

Stages in SnowflakeInternal StagesExternal StagesCOPY Command OptionsWorking with the COPY INTO CommandFile Formats in SnowflakeFile FormatsSpecifying File FormatsWorking with File FormatsStorage Integration in SnowflakeExampleStreaming Loads Using SnowpipeWhat Is Snowpipe?How Snowpipe WorksTriggering Data Ingestion in SnowpipeWorking with SnowpipeData Unloading CommandsBest Practices for Loading and Unloading DataBest Practices for Loading DataBest Practices for Unloading DataIntroducing SnowSQLWhat Is SnowSQL?SummaryPractical ExerciseTaskSolutionExam Readiness Drill – Chapter Review QuestionsHOW TO GET STARTED
Data Transformation FunctionsTransformationsFunctionsUser-Defined FunctionsExternal FunctionsWhat Are External Functions?SequencesCreating SequencesUsing SequencesStored ProceduresWhat Are Stored Procedures?Data SamplingWhat Is Data Sampling?Tasks and StreamsWhat Are Tasks?Working with TasksWhat Are Streams?Working with StreamsSummaryPractical ExerciseRequirementsSolutionExam Readiness Drill – Chapter Review QuestionsHOW TO GET STARTED
Working with Semi-Structured DataWhat Is Structured Data?What Is Semi-Structured Data?Experimenting with Semi-Structured DataWorking with Unstructured DataWhat Is Unstructured Data?Snowflake URLs for Accessing Files in Cloud StorageSnowflake File FunctionsExperimenting with Unstructured DataDirectory TablesWorking with Directory TablesExternal Tables in SnowflakeWorking with External TablesSummaryExam Readiness Drill – Chapter Review QuestionsHOW TO GET STARTED
Continuous Data ProtectionWhat Is CDP?Time TravelWhat Is Time Travel?Access Control Requirements for Time TravelQuerying Historical Data in Time TravelRestoring Objects Using Time TravelTime Travel Retention PeriodFail-SafeWhat Is Fail-Safe in Snowflake?Table Types and CDPData CloningZero-Copy Cloning in SnowflakeHow Zero-Copy Cloning WorksExample ScenarioSnowflake Cloning with Time TravelData ReplicationData Replication in SnowflakeHow Data Replication WorksReplication Across Accounts with Different Snowflake EditionsExample ScenarioSummaryPractical ExerciseTasks to be completedSolutionExam Readiness Drill – Chapter Review QuestionsHOW TO GET STARTED
Direct Data SharingData Sharing in SnowflakeHow Does Secure Data Sharing Work?Key Features of Snowflake Data SharingBenefits of Data SharingSharing Data with Snowflake Account ConsumersSharing Data with Non-Snowflake Account ConsumersSharing Data Using a Reader AccountCross-Cloud and Cross-Region Data Sharing in SnowflakeSharing Data from a Business Critical Account to Non-Business Critical AccountsData ExchangeWhat is Data Exchange in Snowflake?Key Features of ListingsBenefits of Using Data Exchange in SnowflakeSnowflake MarketplaceWhat is Snowflake Marketplace?Key Features of Snowflake MarketplaceSummaryPractical ExerciseRequirementsSolutionExam Readiness Drill – Chapter Review QuestionsHOW TO GET STARTED
Overview of the SnowPro Core Certification (COF-C02)Exam Content BreakdownExam FormatHow to Register for Your SnowPro ExamSetting Up an AccountScheduling an ExamExam PoliciesRescheduling and Cancellation PolicyRecertification PoliciesSummary
How to Access These MaterialsPurchased from Packt Store (packtpub.com)Packt+ SubscriptionPurchased from Amazon and Other SourcesTroubleshooting TipsShare FeedbackBack to the Book

Content preview from SnowPro Core Certification Study Guide

Part 6: Data Protection and Data Sharing

This part of the book helps you understand the concepts of data protection and data sharing in Snowflake. It covers Snowflake’s Continuous Data Protection (CDP) features, including Time Travel, Fail-safe, zero-copy cloning, and data replication. You will also explore Snowflake’s data-sharing capabilities, including direct data shares, private data exchanges, and the Snowflake Marketplace.

This part includes two chapters:

Chapter 9, Implementing Data Protection and Replication
Chapter 10, Sharing Data with Snowflake Objects

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Snowflake SnowPro Core Certification Study Guide

Hamid Mahmood Qureshi

CompTIA Network+ Certification (N10-009): The Total Course

Mike Meyers, Joe Ramm, Lyndon Williams

(ISC)2 CISSP Certified Information Systems Security Professional Official Study Guide 9th Edition

Mike Chapple, James Michael Stewart, Darril Gibson

ISC2 CISSP Certified Information Systems Security Professional Official Study Guide, 10th Edition

Mike Chapple, James Michael Stewart, Darril Gibson

Publisher Resources

ISBN: 9781835884669Supplemental Content