Sybex's study guide for snowflake snowpro core certification : COF-C02 exam / Hamid Mahmood Qureshi.

Format:

Book

Author/Creator:

Qureshi, Hamid Mahmood, author.

Series:

ITpro collection

Language:

English

Subjects (All):

Cloud computing--Examinations--Study guides.

Cloud computing.

Computer architecture--Examinations--Study guides.

Computer architecture.

Physical Description:

1 online resource (314 pages)

Place of Publication:

Hoboken, New Jersey : John Wiley & Sons, Inc., [2023]

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.

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 &amp

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

Chapter 3: Interfaces and Connectivity

Snowflake Web UI

Snowflake Partners

Snowflake Connectors and Drivers

New Snowflake Web Interface

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

Chapter 5: Data Pipelines

Introducing Tasks

Introducing Streams

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

Chapter 7: Cloning and Data Sharing

Zero-Copy Cloning

Secure Data Sharing in Snowflake

Chapter 8: Performance

Snowflake Performance Considerations

Virtual Warehouse Configuration

Caching in Snowflake

Micro-partition Pruning

Micro-partitions and Data Clustering

Materialized Views

Chapter 9: Security

Data Encryption at Rest

Authentication

Authorization

Network

Compliance with Standards

Chapter 10: Account and Resource Management

Resource Monitors

System Usage and Billing

Snowflake Releases

Appendix: Answers to the Review Questions

Index

End User License Agreement.

Notes:

Description based on print version record.

Includes index.

Other Format:

Print version: Qureshi, Hamid Mahmood Snowflake SnowPro Core Certification Study Guide

ISBN:

9781119824466

111982446X

9781119824459

1119824451

OCLC:

1338196546