1. Home
  2. Snowflake
  3. SOL-C01 Exam Syllabus

Snowflake SOL-C01 Exam Syllabus

Start Free SOL-C01 Exam Practice After Reviewing the Topics

Before starting your SOL-C01 exam preparation, it is recommended to review the complete Snowflake SnowPro Associate: Platform Certification Exam syllabus and carefully go through the exam objectives listed below. Once you understand the exam structure and objectives, you should practice using our free SOL-C01 questions. We also provide premium SOL-C01 practice test, fully updated according to the latest exam objectives, to help you accurately assess your preparedness for the actual exam.

Snowflake SOL-C01 Exam Objectives

Section Weight Objectives
Interacting with Snowflake and the Architecture 35%
1.1 Outline key features and benefits of the Snowflake AI Data Cloud.
  • Elastic storage
  • Elastic compute
  • Snowflake layers
1.2 Outline the key Snowflake user interfaces.

Snowsight
Snowflake Notebooks
Worksheets
  • Python
  • SQL
1.3 Describe how to use the Snowsight user interface.

Data loading
Query history
Object browsers
  • Create objects (for example: databases, schemas, stages)
1.4 Work with Snowflake Notebooks.

Notebook sessions
Run code
  • SQL
  • Python
  • Cell execution status
Visualize data using Streamlit
Python variable substitution
 
1.5 Describe Snowflake objects and how they fit into the Snowflake hierarchy.
  • Databases
  • Schemas
  • Tables
  • Views
  • Data types
Identity and Data Access Management 15%
2.1 Define the roles that are used in Snowflake.

Role-Based Access Control (RBAC)
  • Explain role hierarchy
Role types
Privileges
Object access by role
 
2.2 Create a database, explore data, configure parameters, and transfer ownership.

Use database objects
  • Use the INFORMATION_SCHEMA
  • Use the PUBLIC SCHEMA
Understand context
Transfer ownership
Create and drop schemas
Run basic SQL commands
  • EXCLUDE
  • SELECT *
  • LIMIT
Data Loading and Virtual Warehouses 40%
3.1 Describe considerations when working with structured and semi-structured data.

Stages
Loading data
  • Structured data
  • Semi-structured data
Querying data
  • Structured data
  • Semi-structured data
Commands
  • COPY INTO
  • INSERT
  • LIST
3.2 Explain virtual warehouses
 
Standard warehouses compared to multi-clustered warehouses
Warehouse sizing
Warehouse scaling
  • Scaling in or out
  • Scaling up or down
3.3 Create tables in Snowflake and load
data into the tables.
 
Use Snowsight to identify particular tables
View the table definition
Preview the table data
Use INSERT statements to load data
Use Snowsight to load data
Use COPY INTO <table> statements
  • File format options
3.4 Explain how to work with unstructured data.

Directory tables
  • Enable
  • Use of SELECT statements
Use of Pre-signed URLs
  • Function argument
3.5 Explain how to use Snowflake Cortex LLM functions.
  • PARSE_DOCUMENT function
  • TRANSLATE function
  • CLASSIFY_TEXT function
  • COMPLETE function
Data Protection and Data Sharing 10%
4.1 Outline continuous data protection with Snowflake.
  • Time Travel
  • Cloning
4.2 Define Snowflake data sharing capabilities.

Snowflake Marketplace
  • Search listings
Data Exchange
  • Use a private data share
Official Information https://learn.snowflake.com/en/certifications/snowpro-platform/

Limited Time Offer

50%

Off

Get Premium SOL-C01 Questions as Interactive Practice Test or PDF