SNOWFLAKE SNOWPRO CORE CERTIFICATION STUDY GUIDE

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...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Qureshi, Hamid Mahmood
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [S.l.] : JOHN WILEY & SONS, 2022.
Colección:ITpro collection
Temas:
Cloud computing > Examinations > Study guides.
Computer architecture > Examinations > Study guides.
Computer architecture > Examinations.
Study guides.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Intro
  • Table of Contents
  • Title Page
  • Copyright
  • Dedication
  • Acknowledgments
  • About the Author
  • About the Technical Editor
  • Table of Exercises
  • Introduction
  • What Is Snowflake?
  • Who Should Buy This Book
  • How This Book Is Organized
  • Bonus Digital Contents
  • Conventions Used in This Book
  • SnowPro Study Guide Exam Objectives
  • Domain 1.0: Account and Security
  • Domain 2.0: Virtual Warehouses
  • Domain 3.0: Data Movement
  • Domain 4.0: Performance Management
  • Domain 5.0: Snowflake Overview & Architecture
  • Domain 6.0: Storage and Protection
  • How to Contact the Publisher
  • Assessment Test
  • Answers to Assessment Test
  • Chapter 1: Introduction and Overview
  • Introducing Snowflake
  • Snowflake Certifications
  • Signing Up for a Snowflake Trial
  • Summary
  • Exam Essentials
  • Review Questions
  • Chapter 2: Snowflake Architecture
  • Traditional Database Architectures
  • Snowflake's Hybrid Architecture
  • Summary
  • Exam Essentials
  • Review Questions
  • Chapter 3: Interfaces and Connectivity
  • Snowflake Web UI
  • Snowflake Partners
  • Snowflake Connectors and Drivers
  • New Snowflake Web Interface
  • Summary
  • Exam Essentials
  • Review Questions
  • Chapter 4: Loading Data
  • Data Loading in Snowflake
  • What Is a Stage?
  • Data Loading via Internal Stages
  • Data Ingestion Using the Named External Stage
  • Loading Data via the Snowflake Web UI
  • Basic Data Transformations While Ingesting
  • External Tables
  • Semi-Structured Data
  • Unloading Data from Snowflake
  • Load Near-Real-Time Streaming Data
  • Optimizing Data Loading and Unloading
  • Summary
  • Exam Essentials
  • Review Questions
  • Chapter 5: Data Pipelines
  • Introducing Tasks
  • Introducing Streams
  • Summary
  • Exam Essentials
  • Review Questions
  • Chapter 6: Continuous Data Protection
  • Components of Continuous Data Protection
  • Time Travel and Fail-safe
  • Undrop Using Time Travel
  • Time Travel and Fail-safe Storage Costs
  • Summary
  • Exam Essentials
  • Review Questions
  • Chapter 7: Cloning and Data Sharing
  • Zero-Copy Cloning
  • Secure Data Sharing in Snowflake
  • Summary
  • Exam Essentials
  • Review Questions
  • Chapter 8: Performance
  • Snowflake Performance Considerations
  • Virtual Warehouse Configuration
  • Caching in Snowflake
  • Micro-partition Pruning
  • Micro-partitions and Data Clustering
  • Materialized Views
  • Summary
  • Exam Essentials
  • Review Questions
  • Chapter 9: Security
  • Data Encryption at Rest
  • Authentication
  • Authorization
  • Network
  • Compliance with Standards
  • Summary
  • Exam Essentials
  • Review Questions
  • Chapter 10: Account and Resource Management
  • Resource Monitors
  • System Usage and Billing
  • Snowflake Releases
  • Summary
  • Exam Essentials
  • Review Questions
  • Appendix: Answers to the Review Questions
  • Chapter 1: Introduction and Overview
  • Chapter 2: Snowflake Architecture
  • Chapter 3: Interfaces and Connectivity
  • Chapter 4: Loading Data
  • Chapter 5: Data Pipelines

Ejemplares similares