Snowflake SnowPro Core Certification Study Guide

Snowflake SnowPro Core Certification Study Guide

by Hamid Mahmood Qureshi
Released December 2022
Publisher(s): Wiley
ISBN: 9781119824442

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Prepare smarter, faster, and better with the premier study guide for Snowflake SnowPro Core certification

Snowflake, a cloud-based data warehousing platform, has steadily gained popularity since its 2014 launch. Snowflake offers several certification exams, of which the SnowPro Core certification is the foundational exam. The SnowPro Core Certification validates an individual's grasp of Snowflake as a cloud data warehouse, its architectural fundamentals, and the ability to design, implement, and maintain secure, scalable Snowflake systems.

The Snowflake SnowPro Core Certification Study Guide delivers comprehensive coverage of every relevant exam topic on the Snowflake SnowPro Core Certification test. Prepare efficiently and effectively for the exam with online practice tests and flashcards, a digital glossary, and concise and easy-to-follow instruction from the subject-matter experts at Sybex. You'll gain the necessary knowledge to help you succeed in the exam and will be able to apply the acquired practical skills to real-world Snowflake solutions.

This Study Guide includes:

  • Comprehensive understanding of Snowflake's unique shared data, multi-cluster architecture
  • Guidance on loading structured and semi-structured data into Snowflake
  • Utilizing data sharing, cloning, and time travel features
  • Managing performance through clustering keys, scaling compute up, down & across
  • Steps to account management and security configuration including RBAC & MFA
  • All the info you need to obtain a highly valued credential for a rapidly growing new database software solution
  • Access to the Sybex online learning center, with chapter review questions, full-length practice exams, hundreds of electronic flashcards, and a glossary of key terms

Perfect for anyone considering a new career in cloud-based data warehouse solutions and related fields, Snowflake SnowPro Core Certification Study Guide is also a must-read for veteran database professionals seeking an understanding of one of the newest and fastest-growing niches in data.

Table of contents

  1. Cover
  2. Title Page
  3. Copyright
  4. Dedication
  5. Acknowledgments
  6. About the Author
  7. About the Technical Editor
  8. Table of Exercises
  9. Introduction
    1. What Is Snowflake?
    2. Who Should Buy This Book
    3. How This Book Is Organized
    4. Bonus Digital Contents
    5. Conventions Used in This Book
    6. SnowPro Study Guide Exam Objectives
    7. Domain 1.0: Account and Security
    8. Domain 2.0: Virtual Warehouses
    9. Domain 3.0: Data Movement
    10. Domain 4.0: Performance Management
    11. Domain 5.0: Snowflake Overview & Architecture
    12. Domain 6.0: Storage and Protection
    13. How to Contact the Publisher
    14. Assessment Test
    15. Answers to Assessment Test
  10. Chapter 1: Introduction and Overview
    1. Introducing Snowflake
    2. Snowflake Certifications
    3. Signing Up for a Snowflake Trial
    4. Summary
    5. Exam Essentials
    6. Review Questions
  11. Chapter 2: Snowflake Architecture
    1. Traditional Database Architectures
    2. Snowflake’s Hybrid Architecture
    3. Summary
    4. Exam Essentials
    5. Review Questions
  12. Chapter 3: Interfaces and Connectivity
    1. Snowflake Web UI
    2. Snowflake Partners
    3. Snowflake Connectors and Drivers
    4. New Snowflake Web Interface
    5. Summary
    6. Exam Essentials
    7. Review Questions
  13. Chapter 4: Loading Data
    1. Data Loading in Snowflake
    2. What Is a Stage?
    3. Data Loading via Internal Stages
    4. Data Ingestion Using the Named External Stage
    5. Loading Data via the Snowflake Web UI
    6. Basic Data Transformations While Ingesting
    7. External Tables
    8. Semi-Structured Data
    9. Unloading Data from Snowflake
    10. Load Near-Real-Time Streaming Data
    11. Optimizing Data Loading and Unloading
    12. Summary
    13. Exam Essentials
    14. Review Questions
  14. Chapter 5: Data Pipelines
    1. Introducing Tasks
    2. Introducing Streams
    3. Summary
    4. Exam Essentials
    5. Review Questions
  15. Chapter 6: Continuous Data Protection
    1. Components of Continuous Data Protection
    2. Time Travel and Fail-safe
    3. Undrop Using Time Travel
    4. Time Travel and Fail-safe Storage Costs
    5. Summary
    6. Exam Essentials
    7. Review Questions
  16. Chapter 7: Cloning and Data Sharing
    1. Zero-Copy Cloning
    2. Secure Data Sharing in Snowflake
    3. Summary
    4. Exam Essentials
    5. Review Questions
  17. Chapter 8: Performance
    1. Snowflake Performance Considerations
    2. Virtual Warehouse Configuration
    3. Caching in Snowflake
    4. Micro-partition Pruning
    5. Micro-partitions and Data Clustering
    6. Materialized Views
    7. Summary
    8. Exam Essentials
    9. Review Questions
  18. Chapter 9: Security
    1. Data Encryption at Rest
    2. Authentication
    3. Authorization
    4. Network
    5. Compliance with Standards
    6. Summary
    7. Exam Essentials
    8. Review Questions
  19. Chapter 10: Account and Resource Management
    1. Resource Monitors
    2. System Usage and Billing
    3. Snowflake Releases
    4. Summary
    5. Exam Essentials
    6. Review Questions
  20. Appendix: Answers to the Review Questions
    1. Chapter 1: Introduction and Overview
    2. Chapter 2: Snowflake Architecture
    3. Chapter 3: Interfaces and Connectivity
    4. Chapter 4: Loading Data
    5. Chapter 5: Data Pipelines
    6. Chapter 6: Continuous Data Protection
    7. Chapter 7: Cloning and Data Sharing
    8. Chapter 8: Performance
    9. Chapter 9: Security
    10. Chapter 10: Account and Resource Management
  21. Index
  22. End User License Agreement

Product information

  • Title: Snowflake SnowPro Core Certification Study Guide
  • Author(s): Hamid Mahmood Qureshi
  • Release date: December 2022
  • Publisher(s): Wiley
  • ISBN: 9781119824442