SNOWFLAKE SNOWPRO CORE CERTIFICATION STUDY GUIDE. (2022)

• Record Type: Book
• 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 -- 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
• 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.