You can see it againUnder pressure people bring back shapes and positions long after the wording has gone.
Picture superiority · Shepard 1967, Standing 1973
SNOWFLAKESnowflake SnowPro Advanced:Data Analyst
The SnowPro Advanced: Data Analyst certification validates your ability to apply comprehensive data analysis principles using Snowflake and its components. Designed for data analysts with hands-on production experience, it covers advanced SQL, data transformations, and predictive analysis. Earning it demonstrates you can turn raw data into business-ready insights on the Snowflake AI Data Cloud.
DeliveryPearson VUE
Free questions388
Content last reviewed 1 January 2025 · Up to date
The certification
What Snowflake SnowPro Advanced: Data Analyst proves, and what it asks of you
What this certification covers, who it is written for, and what the exam itself looks like on the day.
4domains
12objectives
134concepts
$375 USDexam fee
What it is
What this certification is
What it validates, who it is written for, and the experience it assumes.
About this certification
The SnowPro Advanced: Data Analyst certification is a role-based credential that validates advanced knowledge and skills for applying comprehensive data analysis principles using Snowflake and its components. It goes beyond core fundamentals to test your ability to prepare and load data, perform simple and complex transformations, and build and troubleshoot advanced SQL queries.
This certification also covers using Snowflake built-in functions and creating User-Defined Functions (UDFs), performing descriptive, diagnostic, and predictive data analyses, and preparing and presenting data to meet business requirements. Earning this credential signals to employers that you can drive data-driven decision-making and deliver actionable insights on the Snowflake platform.
Who it’s for
This certification is for data analysts who work hands-on with Snowflake in a production environment and are responsible for analyzing data to support business decisions. It is ideal for professionals who need to demonstrate advanced skills in SQL, data transformation, and predictive analysis using Snowflake's features. Candidates typically have one or more years of practical experience as a data analyst using Snowflake, with fluency in advanced SQL and possibly knowledge of an additional programming language.
Recommended experience
One or more years of hands-on practical experience with Snowflake as a Data Analyst in a production environment, plus fluency with advanced SQL and knowledge of an additional computer language. Preparing and loading data into Snowflake; Performing data transformations for analysis; Building and troubleshooting advanced SQL queries; Using Snowflake built-in functions and creating UDFs; Performing descriptive, diagnostic, and predictive data analyses
The syllabus
What you’ll learn
Every domain and objective Snowflake measures, with the weight they carry on the exam.
The official Snowflake exam outline · checked 1 January 2025 · See the source
Data Analysis
- Perform data analysis with SQL
- Apply analytic and window functions
- Derive insights from datasets
Data Presentation and Visualization
- Present and visualize data
- Build dashboards and reports with Snowsight
- Communicate analytical results
Data Transformation and Data Modeling
- Transform data for analysis
- Design and use data models
- Work with views and semi-structured data
Data Ingestion and Data Preparation
- Ingest data for analysis
- Prepare and clean datasets
- Configure stages and file formats
On the day
The exam itself
Everything Snowflake publishes about sitting it, and nothing we inferred.
Prerequisites
SnowPro Core certification is recommended but not required.
CertificationSnowflake SnowPro Advanced: Data Analyst
DeliveryPearson VUE
LanguagesEnglish
Pricing$375 USD
After you pass
Where this credential goes next
The path Snowflake lays out, how the credential is kept, and where to book.
Step-by-step path to Snowflake SnowPro Advanced: Data Analyst
PrerequisiteSnowPro Core certification is recommended but not required.
Credential earnedSnowflake SnowPro Advanced: Data Analyst Certification Renewal and maintenance
SnowPro certifications must be renewed periodically to stay current. Specific renewal requirements are not detailed on the exam page. Stay current with the latest technologies and maintain your certification.
Learn more about renewal requirements Lifecycle status
This certification is currently active and available. Snowflake maintains this certification to validate current skills and industry relevance.
Exam status: ActiveMaintained by Snowflake
Exam registration
Register for the exam through Pearson VUE, Snowflake’s authorized testing partner.
Schedule your examVisit the official Snowflake certification page for exam policies and requirements.
View the official pageYour coach
And when you are serious, your coach Pip takes over
Your coach in the app reads what you have answered with the book closed and tells you one thing to do tonight. It will not count an answer you gave with the page open, and it will tell you when you are not ready.
See how the coach worksBefore you book
Questions people ask
How does the SnowPro Advanced: Data Analyst exam relate to the SnowPro Core certification?
The SnowPro Core certification is recommended as a foundation for the Advanced Data Analyst exam, but it is not a mandatory prerequisite. The Advanced exam builds on core knowledge to validate deeper analytical skills.
Is there a hands-on or lab component in the exam?
The official exam page does not specify a hands-on or lab component. The exam focuses on validating knowledge and skills through its question format.
What is the retake policy if I fail the exam?
Snowflake's FAQ indicates there is a limit on how many times you can fail an exam, but the specific retake policy is not detailed on the exam page. Contact Snowflake for the current retake policy.
Can I reschedule my exam appointment?
Yes, you can reschedule your exam if you cannot make your scheduled appointment. Specific rescheduling terms are not detailed on the exam page.
What job roles does the SnowPro Advanced: Data Analyst certification map to?
This certification is designed for data analysts who work with Snowflake in production environments, focusing on advanced data analysis, SQL, and data transformation skills.
Are there regional discounts for the exam fee?
Yes, exams delivered in India receive a 20% regional discount on the exam fee.
Information freshness · Content last reviewed on 2025-01-01 Up to date
Practice free questions 388 questions, free, no account needed.
The curriculum
The whole exam, mapped and written
Every domain, every objective, and every concept Snowflake measures — each one written out.
4domains
12objectives
134concepts
82free pages
The domains, and what sits inside them
Every objective below is a page you can open and practise now, without an account.
The official Snowflake exam outline · checked 1 January 2025 · See the source
1Data Analysis63 questions
2Data Presentation and Visualization65 questions
3Data Transformation and Data Modeling167 questions
4Data Ingestion and Data Preparation93 questions
Not a table of contents
Every line on this map already opens
In front of every objective the practice pages are already there, free and without an account. This is one objective, opened.
Perform data analysis with SQL1 pagesOpen →
Free in front of it
3 questions on this objective, five to a page. Every range above is a real page, open now, with no account.
Reading the map is not the same as knowing the ground
The curriculum tells you what is on the exam. Proving you know it is a different job — and it is the one the closed-book run does.
Free questions
388 questions. No account, no card.
The whole bank is open. 5 questions to a page, every answer explained, and a discussion thread on each one.
388questions
82pages
12objectives
Freealways
Browse by domain
Every objective, and every page range, is a link — so you can pick up exactly where you left off.
1Data Analysis63 questions
2Data Presentation and Visualization65 questions
3Data Transformation and Data Modeling167 questions
4Data Ingestion and Data Preparation93 questions
What a practice page gives you
1Five to a page
Short enough to finish, long enough to matter.
2Every answer explained
Not only which one is right — why the others are wrong.
3A discussion on each
Ask, answer, and vote. Every question has its own thread.
A question, and the idea behind it
Every question comes from a concept
These are not trivia. Each one is written against a concept in the book, so when you get one wrong there is somewhere to go and find out why.
The visual book
See it once. Carry it into the exam.
The pages shown here come from our AI-900 book — an example of how each concept is written in plain language and, where the idea needs one, drawn as a full page you can take in at a glance.
134concepts
388free questions
Why a picture, and not another paragraph
Three reasons, and each one is a real finding rather than a slogan.
You can see it againThe whole idea at onceWhere it starts, what happens in the middle, what comes out, and the mistake to avoid.
Multimedia principle · MayerThe look-alikes sit togetherThe pairs the exam tests are drawn side by side, so the difference is seen, not told.
Dual coding · PaivioWhat one page is made of
You are never asked to read a poster here — only to see how one is built. After that, every other page is legible at a glance.
1A numbered strip on top
The idea as a sequence, followed with a finger before a word is read.
2Panels for the parts
What it is, how the machine learns it, when it is the right tool.
3The trap, framed
The distinction the exam tests, given its own box instead of buried in prose.
4One line at the bottom
The sentence to carry into the exam room.
Open book, on purpose
Answer it with the picture beside you
This is the part that teaches. The illustration and the written explanation stay where they are while you work, so a scenario stops being a memory test and becomes something you can simply look at.
It teaches · it does not count
A smartphone uses AI to unlock when the owner looks at the camera. Which AI capability is being used?
AImage classification
BFacial recognition
COptical character recognition
DObject detection
Look at the five steps. Detect finds a face, align straightens it, encode turns it into numbers, search compares it with a stored face, and decide answers one question: is this the same person? Classification would only say “a face”. Detection would only draw a box. Neither decides whose.
Then the page shuts, and it starts counting
The same questions come back with the book closed — that run is the one that counts. After it, your coach picks one thing for tonight, sized to the time you have, and brings pages back before you lose them.
Testing effect · Roediger & Karpicke 2006 · spacing effect · Cepeda et al. 2006
Official resources
Straight from Snowflake
Where the exam is defined, scheduled and scored.
1official link
134concepts mapped
The source
Snowflake’s own pages
We link to them rather than repeat them, so nothing here goes stale behind them.
Checked against the source
Every objective on the official Snowflake outline already has questions here
We build from the official skills outline, not from a summary of it — 12 objectives, 134 concepts written under them, and free questions against every one. When Snowflake changes the outline, this page changes with it.
12objectives on the outline→134concepts written→388free questions
An official page tells you what will be asked. It cannot tell you what you will get right.
That is the only question worth answering the night before, and no link answers it. You answer it by taking the questions with the book closed, and seeing what comes back.