Snowflake SnowPro Core

Snowflake Data Cloud Features and Architecture - 25%

- Outline key features of the Snowflake Data Cloud.
Elastic Storage
Elastic Compute
Snowflake’s three distinct layers
Data Cloud/ Data Exchange/ Partner Network
Cloud partner categories
- Outline key Snowflake tools and user interfaces.
Snowflake User Interfaces (UI)
Snowsight
Snowflake connectors
Snowflake drivers
SQL scripting
Snowpark
- Outline Snowflake’s catalog and objects.
Databases
Schemas
Tables Types
View Types
Data types
User-Defined Functions (UDFs) and User Defined Table Functions (UDTFs)
Stored Procedures
Streams
Tasks
Pipes
Shares
Sequences
- Outline Snowflake storage concepts.
Micro-partitions
Types of column metadata clustering
Data Storage Monitoring
Search Optimization Service

Account Access and Security - 20%

- Outline security principles.
Network security and policies
Multi-Factor Authentication (MFA)
Federated authentication
Single Sign-On (SSO)
- Define the entities and roles that are used in Snowflake.
Outline how privileges can be granted and revoked
Explain role hierarchy and privilege inheritance
- Outline data governance capabilities in Snowflake.
Accounts
Organizations
Databases
Secure views
Information schemas
Access history and read support

Performance Concepts - 15%

- Explain the use of the Query Profile.
Explain plans
Data spilling
Use of the data cache
Micro-partition pruning
Query history
- Explain virtual warehouse configurations.
Multi-clustering
Warehouse sizing
Warehouse settings and access
- Outline virtual warehouse performance tools.
Monitoring warehouse loads
Query performance
Scaling up compared to scaling out
Resource monitors
- Optimize query performance.
Describe the use of materialized views
Use of specific SELECT commands

Data Loading and Unloading - 10%

- Define concepts and best practices that should be considered when loading data.
Stages and stage types
File size
File formats
Folder structures
Ad hoc/bulk loading using the Snowflake UI
- 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
- Define concepts and best practices that should be considered when unloading data.
File formats
Empty strings and NULL values
Unloading to a single file
Unloading relational tables
- 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

Data Transformations - 20%

- Explain how to work with standard data.
Estimating functions
Sampling
Supported function types
User-Defined Functions (UDFs) and stored procedures
- Explain how to work with semi-structured data.
Supported file formats, data types, and sizes
VARIANT column
Flattening the nested structure
- Explain how to work with unstructured data.
Define and use directory tables
SQL file functions
Outline the purpose of User-Defined Functions (UDFs) for data analysis

Data Protection and Data Sharing - 10%

- Outline Continuous Data Protection with Snowflake.
Time Travel
Fail-safe
Data Encryption
Cloning
Replication
- Outline Snowflake data sharing capabilities.
Account types
Snowflake Marketplace and Data Exchange
Private data exchange
Access control options
Shares