Retired

Snowflake · SF-AP · Beginner

SnowPro Associate: Platform (SOL-C01)

Name: Pass-IT
Author: Pass-IT

Validates knowledge of essential Snowflake skills including data management, AI/ML integration, and Snowflake Cortex LLM functions. Entry-level certification for the Snowflake platform.

This exam has been retired.

65Mock exam questions

85minTime limit

750/ 1000Passing score

Overview

About the exam

The SnowPro Associate: Platform Certification (SOL-C01) validates foundational knowledge of Snowflake's AI Data Cloud platform, including basic navigation of the Snowflake UI and Notebooks, creating databases and stages, loading structured and semi-structured data, understanding roles and access management, and using Snowflake Cortex LLM functions. It demonstrates entry-level competency with the platform's core features.

This is Snowflake's introductory certification designed for individuals with as little as three months of Snowflake experience, including business analysts, junior data professionals, and technical managers looking to formalize their understanding of the platform before pursuing the SnowPro Core credential.

Try the practice preview

Try five SF-AP questions

Try five practice questions from the app’s current SnowPro Associate: Platform (SOL-C01) question bank, with answers and explanations.

Interacting with Snowflake and the Architecture1 / 5

A Snowflake Enterprise Edition customer runs a Medium warehouse for 45 minutes continuously. How many credits are consumed?

AlexFull explanation from Alex

A Medium warehouse consumes 4 credits per hour (docs.snowflake.com/en/user-guide/warehouses-overview). Running for 45 minutes = 4 × (45/60) = 3 credits. Credit rates double with each size: X-Small=1, Small=2, Medium=4, Large=8, X-Large=16 credits/hour. Snowflake bills per second with a 60-second minimum each time a warehouse starts or resumes. Edition (Standard, Enterprise, etc.) does not change per-size credit rates. Distractor A (2 credits) confuses Medium with Small. Distractor C (4 credits) assumes a full hour. Distractor D (6 credits) may confuse with Large at 45 min.

Sourcedocs.snowflake.com

Data Loading and Virtual Warehouses2 / 5

Which SQL clause returns a random sample of approximately 10% of the rows from a table?

AlexFull explanation from Alex

TABLESAMPLE (synonym: SAMPLE) returns a random subset of rows. TABLESAMPLE(10) returns approximately 10% of rows using the default BERNOULLI/ROW method, sampling each row with probability p/100 (docs.snowflake.com/en/sql-reference/constructs/sample). The SYSTEM/BLOCK method samples entire micro-partitions—faster but less precise. Distractor B (LIMIT 10 PERCENT) is invalid syntax—LIMIT accepts only a fixed row count, not a percentage. Distractor C (SAMPLE ROWS (10)) returns exactly 10 rows, not 10%. Distractor D (RANDOM(10)) is not a valid sampling clause; RANDOM() generates random numbers, not row samples.

Sourcedocs.snowflake.com

Identity and Data Access Management3 / 5

Snowflake's access control framework primarily assigns privileges to roles and then assigns roles to users. What is this model called?

AlexFull explanation from Alex

Role-Based Access Control (RBAC) is Snowflake's primary model: privileges are granted to roles, roles are assigned to users (docs.snowflake.com/en/user-guide/security-access-control-overview). System-defined roles form a hierarchy: ACCOUNTADMIN > SYSADMIN/SECURITYADMIN > USERADMIN > PUBLIC. Custom roles extend this. Distractor A (MAC) enforces fixed security labels—not used by Snowflake. Distractor B (ABAC) uses attributes for access decisions—not natively supported. Distractor C (IBAC) is not a recognized Snowflake model. Snowflake also supports DAC through object ownership, but RBAC is the primary framework described here.

Sourcedocs.snowflake.com

Create a free account

Exam domains

What's on the exam

Exam blueprint: SF-AP

Interacting with Snowflake and the Architecture35%

Set up and navigate the Snowflake user interface and Snowflake Notebooks. Create databases and stages, and use compute resources.

Identity and Data Access Management15%

Understand Snowflake roles and data access management.

Data Loading and Virtual Warehouses40%

Load and leverage structured, semi-structured, and unstructured data. Understand and manage the Snowflake Account structure.

Data Protection and Data Sharing10%

Use cloning, Time Travel, and Fail-safe to manage data. Facilitate Secure Data Sharing.

Format

Exam format and question types

The exam consists of 40 questions — multiple-choice and multiple-select — to be completed in 85 minutes. Questions cover foundational concepts including Snowflake UI navigation, basic data operations, compute resource management, role-based access, account structure, and Cortex AI functions. A passing score is 750 out of 1000. With 1.5 minutes per question, pacing is comfortable but read each scenario carefully before answering.

Question types: SF-AP

Multiple Choice70%

Select the single answer that best meets the question’s requirements.

Multiple Response30%

Select multiple answers. Follow the question’s instructions on how many to choose.

Study notes

Common pitfalls

Topics to review: SF-AP

01Roles vs Privileges
Confusing Snowflake system roles (ACCOUNTADMIN, SYSADMIN, SECURITYADMIN) with custom roles and not understanding the role hierarchy leads to access management errors.
02Snowflake Editions
Not knowing the differences between Standard, Enterprise, and Business Critical editions — and which features are available at each tier — costs easy points.
03Stage vs Table
Mixing up staging areas (where files land before loading) with actual Snowflake tables and not understanding the COPY INTO workflow causes data loading confusion.
04Cortex Functions
Not knowing which Cortex LLM functions exist (COMPLETE, TRANSLATE, SUMMARIZE, SENTIMENT) or when to apply them leads to incorrect AI-related answers.

Practice with questions and explanations in Pass-IT →

Questions

Frequently asked questions

How long is the SnowPro Associate: Platform (SOL-C01) exam?

The SnowPro Associate: Platform (SOL-C01) exam has 65 questions and a 85-minute time limit.

What is the passing score for SnowPro Associate: Platform (SOL-C01)?

The passing score for the SnowPro Associate: Platform (SOL-C01) exam is 750 / 1000.

Which pitfalls should I review when preparing for SnowPro Associate: Platform (SOL-C01)?

Topics to review include Roles vs Privileges, Snowflake Editions, Stage vs Table, Cortex Functions. Work through examples to check that you understand the distinctions and can explain your answer.