SNOWFLAKE SNOWPRO CORE CERTIFICATION STUDY GUIDE. (2022)
- Record Type:
- Book
- Title:
- SNOWFLAKE SNOWPRO CORE CERTIFICATION STUDY GUIDE. (2022)
- Main Title:
- SNOWFLAKE SNOWPRO CORE CERTIFICATION STUDY GUIDE
- Further Information:
- Note: Hamid Mahmood Qureshi.
- Other Names:
- Qureshi, Hamid Mahmood
- Contents:
- 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 -- UnloadingIntro -- 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 … (more)
- Publisher Details:
- S.l. : JOHN WILEY & SONS
- Publication Date:
- 2022
- Extent:
- 1 online resource
- Subjects:
- 004.67/82
Cloud computing -- Examinations -- Study guides
Computer architecture -- Examinations -- Study guides
Computer architecture -- Examinations
Study guides - Languages:
- English
- ISBNs:
- 9781119824466
9781119824459
1119824451 - Related ISBNs:
- 111982446X
1119824443
9781119824442 - Notes:
- Note: Includes bibliographical references.
- Access Rights:
- Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.768301
- Ingest File:
- 19_009.xml