The breakdown

Domain 1: Snowflake Data Cloud Features and Architecture

1.1. Outline key features of the Snowflake Data Cloud

- Elastic Storage
- Elastic Compute
- Snowflake's three distinct layers
- Data Cloud / Data Exchange / Partner Network

1.2. Outline key Snowflake tools and user interfaces

- Snowflake User Interfaces (UI)
- Snowsight
- Snowflake Connectors & Drivers
- SQL Scripting
- Snowpark

1.3 Outline Snowflake's catalog and objects

- Databases
- Schemas
- Tables types
- View Types
- User-Defined Functions (UDFs) and User Defined Table Functions (UDTFs)
- Stored Procedures
- Streams
- Tasks
- Pipes
- Shares
- Sequences

1.4 Outline Snowflake Storage Concepts

- Micro-partitions
- Types of column metadata clustering
- Data Storage Monitoring
- Search Optimization Service

Domain 2. Account Access and Security

2.1 Outline security principles

- Network security and policies
- Multi-Factor Authentication (MFA)
- Federated authentication
- Single Sign-On (SSO)

2.2 Define the entries and roles that are used in Snowflake

- Outline how privileges can be granted and revoked
- Explain role hierarchy and privilege inheritance

2.3. Outline data governance capabilities in Snowflake

- Accounts
- Secure views
- Information schemas
- Access history and read support

Domain 3.0. Performance Concepts

3.1. Explain the use of Query Profile

- Explain plans
- Data spilling
- Use of the data cache
- Micro-partition pruning
- Query history

3.2. Explain virtual warehouse configurations

- Multi-clustering
- Warehouse sizing
- Warehouse settings and access

3.3. Outline virtual warehouse performance tools

- Monitoring warehouse loads
- Query performance
- Scaling up compared to scaling out
- Scaling policies
- Resource monitors

3.4. Optimize query performance

- Describe the use of materialized views
- Use of specific SELECT commands

Domain 4.0. Data Loading and Unloading

4.1. Define concepts and best practices that should be considered when loading data

- Stages and stage types
- File size
- File formats
- Folder Structure
- Ad hoc/bulk loading using the Snowflake UI

4.2. Outline different commands used to load data and when they should be used

- CREATE PIPE
- COPY INTO
- GET
- INSERT / INSERT OVERWRITE
- PUT
- STREAM
- TASK
- VALIDATE

4.3. Define concepts and best practices that should be consideres when unloading data

- File formats
- Empty strings and NULL values
- Unloading to a single file
- Unloading relational tables

4.4. Outline the different commands used to unload data and when they should be used

- LIST
- COPY INTO
- CREATE FILE FORMAT
- CREATE FILE FORMAT ... CLONE
- ALTER FILE FORMAT
- DROP FILE FORMAT
- DESCRIBE FILE FORMAT
- SHOW FILE FORMAT

Domain 5.0: Data Transformation

5.1. Explain how to work with standard data

- Estimating functions
- Sampling
- Supported functions types

5.2. Explain how to work with semi-structured data

- Supported file formats, data types and sizes
- VARIANT column

5.3. Explain how to work with unstructured data

- Define and use directory tables
- SQL File Functions

Domain 6.0: Data Protection and Data Sharing

6.1. Outline Continuous Data Protection

- Time Travel
- Fail-Safe
- Data Encryption
- Cloning
- Replication

6.2. Outline Snowflake data sharing capabilities

- Account types
- Snowflake Marketplace
- Data Exchange
- Access control options
- Secure Data Sharing (for example. Direct Share, Listing)

Community Access

The place where you can bring all your doubts and answers.
The place where you can share with other members.

Exam Preparation

Contains a set of external assets which you can assess your skills, domain by domain.

30€

• Buy Now