Snowflake SnowPro™ Advanced Architect Certification Companion : Hands-on Preparation and Practice / by Ruchi Soni.

Format:

Book

Author/Creator:

Soni, Ruchi, author.

Series:

Certification Study Companion Series, 2731-877X

Language:

English

Subjects (All):

Database management.

Big data.

Business--Data processing.

Business.

Database Management.

Big Data.

Business Analytics.

Local Subjects:

Database Management.

Big Data.

Business Analytics.

Physical Description:

1 online resource (XXVI, 222 p. 87 illus.)

Edition:

1st ed. 2023.

Place of Publication:

Berkeley, CA : Apress : Imprint: Apress, 2023.

Summary:

Master the intricacies of Snowflake and prepare for the SnowPro Advanced Architect Certification exam with this comprehensive study companion. This book provides robust and effective study tools to help you prepare for the exam and is also designed for those who are interested in learning the advanced features of Snowflake. The practical examples and in-depth background on theory in this book help you unleash the power of Snowflake in building a high-performance system. The best practices demonstrated in the book help you use Snowflake more powerfully and effectively as a data warehousing and analytics platform. Reading this book and reviewing the concepts will help you gain the knowledge you need to take the exam. The book guides you through a study of the different domains covered on the exam: Accounts and Security, Snowflake Architecture, Data Engineering, and Performance Optimization. You’ll also be well positioned to apply your newly acquired practical skills to real-world Snowflake solutions. You will have a deep understanding of Snowflake to help you take full advantage of Snowflake’s architecture to deliver value analytics insight to your business. What You Will Learn Gain the knowledge you need to prepare for the exam Review in-depth theory on Snowflake to help you build high-performance systems Broaden your skills as a data warehouse designer to cover the Snowflake ecosystem Optimize performance and costs associated with your use of the Snowflake data platform Share data securely both inside your organization and with external partners Apply your practical skills to real-world Snowflake solutions.

Contents:

1. Exam Overview

2. Snowflake Architecture and Overview

3. Kafka Connectors and Client Drivers

4. Loading Data in Snowflake

5. Data Unloading from Snowflake

6. Tables and Views

7. Clustering and Micro-partitions

8. Cloning

9. Secure Data Sharing

10. Semi-structured Data

11. Time Travel and Fail Safe

12. Continuous Data Pipeline

13. Data Replication and Failovers

14. Managing Account and Security

15. Query Profile and Tuning

16. Performance and Resource Optimization

17. Snowflake Best Practices.

Notes:

Includes bibliographical references and index.

ISBN:

9781484292624

1484292626

OCLC:

1376536566