Snowflake SnowPro Core Certification Exam Syllabus

• Elastic Storage
• Interoperable compute
• Snowflake’s three distinct layers
• Overview of Snowflake editions

- Outline key Snowflake tools and user interfaces.

• Snowsight
• SnowSQL
• Snowflake connectors
• Snowflake drivers
• Snowpark
• SnowCD
• Streamlit in Snowflake
• Cortex (AI/ML services)
• Snowflake SQL API

- Outline Snowflake’s catalog and objects.

• Databases
• Stages
• Schema types
• Table types
• View types
• Data types
• User Defined Functions (UDFs)
• User Defined Table Functions (UDTFs)
• Stored Procedures
• Streams
• Tasks
• Pipes
• Shares
• Sequences

- Outline Snowflake storage concepts.

• Micro-partitions
• Data clustering
• Data Storage Monitoring

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

- Define the entities and roles that are used in Snowflake.

• Overview of access control
  - Access control frameworks
  - Access control privileges
• Outline how privileges can be granted and revoked
• Explain role hierarchy and privilege inheritance

- Outline data governance capabilities in Snowflake.

• Accounts
• Organizations
• Secure views
• Secure functions
• Information schemas
• Access history
  - Tracking read/write operations
• Overview of row/column-level security
• Object tags

• Describe the use of materialized views
• Use of specific SELECT commands
• Clustering
• Search optimization service
• Persisted query results
• Understanding the impact of different types of caching
  - Metadata cache
  - Result cache
  - Warehouse cache

- Describe cost optimization concepts and best practices in Snowflake.

• Understanding and exploring the costs of different Snowflake features and services
  - Cost insights feature in Snowsight
  - Use of different table types and sizes
  - Use of views
  - Use of search optimization paths
  - Storage costs
  - Compute costs
• Understand and explore cloud services costs in Snowflake
• Costs considerations when using serverless features
• Cost considerations when moving data among regions
  - Replication
  - Fail-over
• Monitor and control costs
  - Resource monitors
  - Snowflake Budgets service
• Attribute costs
  - Cost center tagging
  - Use of the ACCOUNT_USAGE schema

• Stages and stage types
• File size and formats
• Folder structures
• Ad hoc/bulk loading
• Snowpipe

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

• CREATE STAGE
• CREATE FILE FORMAT
• CREATE PIPE
• CREATE EXTERNAL TABLE
• COPY INTO
• INSERT/INSERT OVERWRITE
• PUT
• VALIDATE

- Define concepts and best practices that should be considered when unloading data.

• File size and formats
  - Overview of compression methods
• 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.

• GET
• LIST
• COPY INTO
• CREATE STAGE
• CREATE FILE FORMAT

• Estimation functions
• Sampling
  - SAMPLE command
  - /TABLESAMPLE command
  - Sampling methods
  1.Fraction-based
  2.Fixed-size
• Supported function types
  - System functions
  - Table functions
  - External functions
  - User-Defined Functions (UDFs)
• Stored procedures
• Streams
• Tasks

- Explain how to work with semi-structured data.

• Supported data formats, data types, and sizes
• VARIANT column
• Flattening the nested structure
  - FLATTEN command
  - LATERAL FLATTEN command
• Semi-structured data functions
  - ARRAY/OBJECT creation and manipulation
  - Extracting values
  - Type predicates

• Define and use directory tables
• SQL file functions
  - Types of URLs used to access data files
• Processing unstructured data
• User-Defined Functions (UDFs) for unstructured data analysis