| Description |
1 online resource |
| Series |
ITpro collection |
| 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 |
| Summary |
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 |
| Bibliography |
Includes bibliographical references |
| Subject |
Cloud computing -- Examinations -- Study guides
|
|
Computer architecture -- Examinations -- Study guides
|
|
Computer architecture -- Examinations
|
| Genre/Form |
Study guides
|
| Form |
Electronic book
|
| ISBN |
9781119824466 |
|
111982446X |
|
9781119824459 |
|
1119824451 |
|
