The SnowPro Advanced Data Analyst (DAA-C01) is the Advanced-level certification that validates your data analytics skills on Snowflake. It tests practical analytics chops including SQL window functions, data modeling, Snowsight visualization, and performance tuning. Note, however, that the exam retires on December 1, 2026, and every scheduled exam must be completed by that date. This article covers what Snowflake says about the retirement, the exam scope, and how to prepare for each domain.
The Data Analyst exam is part of the SnowPro Advanced track and evaluates your ability to perform analytics and reporting on Snowflake. It requires SnowPro Core certification as a prerequisite and demands more specialized SQL and analytics skills.
| Item | Details |
|---|---|
| Exam Code | DAA-C01 |
| Number of Questions | 65 (may include unscored items) |
| Duration | 115 minutes |
| Passing Score | 750 / 1000 |
| Exam Fee | $375 USD |
| Prerequisite | SnowPro Core certification (in-date) |
| Question Format | Multiple choice (single and multi-select) and interactive |
| Delivery | Pearson VUE test center or online proctoring (OnVUE) |
| Retirement | Retires on December 1, 2026 (every scheduled exam must be completed by that date) |
Snowflake has announced that the SnowPro Advanced: Data Analyst exam (DAA-C01) retires on December 1, 2026. If your appointment is later than that, you must reschedule it to a date on or before December 1, 2026. No successor exam has been named; the official retirement FAQ recommends the SnowPro Core Certification to candidates going forward, and the Snowflake Data Analyst Training course remains available. A certification you have already earned stays valid for 2 years from the date you earned it.
Below are the four exam domains from the official Study Guide. Data Analysis carries the largest weight at 32% of the exam.
| Domain | Weight | Key Topics |
|---|---|---|
| 1.0 Data Ingestion and Data Preparation | 17% | Retrieving and loading data (COPY INTO, stages), data discovery, enriching data from the Marketplace, functions (window functions, UDFs, etc.) |
| 2.0 Data Transformation and Data Modeling | 23% | Data cleansing, semi-structured data, window functions and CTEs, data modeling, query performance optimization |
| 3.0 Data Analysis | 32% | UDFs, stored procedures, and views; descriptive and diagnostic analysis; forecasting |
| 4.0 Data Presentation and Data Visualization | 28% | Snowsight dashboards and charts, filters, effects of row access policies and Dynamic Data Masking, connecting BI tools |
SQL window functions are the single most important topic on the Data Analyst exam. Snowflake supports the standard SQL:2003 window functions broadly, and the exam tests them through applied, real-world scenarios.
The differences between these three ranking functions show up over and over. You need to know exactly how numbers are assigned when ties occur: ROW_NUMBER always returns unique sequential numbers, RANK gives ties the same number and then skips, and DENSE_RANK gives ties the same number without skipping.
-- Compare the three ranking functions for sales
SELECT
salesperson,
revenue,
ROW_NUMBER() OVER (ORDER BY revenue DESC) AS row_num,
RANK() OVER (ORDER BY revenue DESC) AS rank_val,
DENSE_RANK() OVER (ORDER BY revenue DESC) AS dense_rank_val
FROM sales_summary;LEAD (next row) and LAG (previous row) are workhorses for month-over-month comparisons and daily delta calculations. The exam tests that the second argument controls the offset and the third argument sets a default value.
-- Compute month-over-month revenue change
SELECT
month_date,
monthly_revenue,
LAG(monthly_revenue, 1, 0) OVER (ORDER BY month_date) AS prev_month,
monthly_revenue - LAG(monthly_revenue, 1, 0) OVER (ORDER BY month_date) AS mom_change
FROM monthly_sales;Window FRAME clauses are an advanced topic, but you cannot skip them for the Data Analyst exam. They are required to implement running sums and moving averages. The key distinction to memorize: ROWS BETWEEN specifies a physical number of rows, while RANGE BETWEEN specifies a logical range of values.
-- 3-month moving average
SELECT
month_date,
monthly_revenue,
AVG(monthly_revenue) OVER (
ORDER BY month_date
ROWS BETWEEN 2 PRECEDING AND CURRENT ROW
) AS moving_avg_3m
FROM monthly_sales;QUALIFY is a clause that Snowflake adopted early. It lets you filter on the results of window functions just like WHERE does for base columns. Because you don't need a wrapping subquery or CTE, your SQL stays clean. The exam tests the QUALIFY execution order: WHERE → GROUP BY → HAVING → QUALIFY.
-- Top 3 per department, filtered directly with QUALIFY
SELECT
department,
salesperson,
revenue,
RANK() OVER (PARTITION BY department ORDER BY revenue DESC) AS dept_rank
FROM sales_detail
QUALIFY dept_rank <= 3;The Data Analyst exam tests your design decisions for analytics-oriented data models. Because Snowflake uses columnar storage, the level of normalization you choose directly impacts query performance.
Snowsight is Snowflake's native visualization tool, letting you build dashboards directly from SQL worksheets. The exam targets the following points.
The Data Analyst exam also covers query acceleration techniques. Reading a Query Profile is mandatory knowledge.
Snowflake caches identical query results for 24 hours. Because cached results return without spinning up a warehouse, this is highly effective for accelerating reporting queries. However, the cache is invalidated when the underlying data changes. You can disable caching with the session parameter USE_CACHED_RESULT = FALSE.
Analysts often handle data that includes personal information, so understanding governance features is essential.
Because the Data Analyst exam translates directly to SQL skill, you must do hands-on query practice in addition to reading. The exam retires on December 1, 2026, and the official retirement FAQ advises scheduling early, because a fail close to that date may leave no time for a retake. Plan backward from your exam date.
SnowPro Advanced: Data Analyst
Question 1
In Snowflake, which SQL most appropriately returns only the top sales record per department?
Correct answer: A
QUALIFY is the Snowflake-supported clause for directly filtering on window function results. B is wrong because window functions cannot be used in WHERE. C is invalid because RANK() cannot be used in HAVING. D returns only one row across the entire result.
Until when can I take the SnowPro Advanced: Data Analyst exam?
Snowflake has announced that the Data Analyst exam (DAA-C01) retires on December 1, 2026. Every scheduled exam must be completed by that date, and if your appointment is later, you must reschedule it to a date on or before December 1, 2026. No successor exam has been named; the official retirement FAQ recommends the SnowPro Core Certification to candidates instead (the Snowflake Data Analyst Training course remains available). A certification you have already earned stays valid for 2 years from the date you earned it.
Are there any prerequisites for the SnowPro Advanced Data Analyst exam?
An active SnowPro Core certification is required to take this exam. Without one you are not eligible, and you cannot register through the Snowflake Certification Portal. Officially, the exam is aimed at candidates with 1 or more years of hands-on experience using Snowflake as a data analyst in a production environment.
How deeply does the exam cover window functions?
Beyond the differences between ROW_NUMBER, RANK, and DENSE_RANK, the exam covers LEAD/LAG for row comparison, NTILE for quantile splits, and the behavioral differences of FRAME clauses (ROWS BETWEEN / RANGE BETWEEN). Implementing a running sum with a FRAME clause is an especially frequent pattern.
What is the difference between the Data Analyst and Data Engineer exams?
The Data Analyst exam centers on SQL-based analysis, visualization, and reporting, testing window functions and Snowsight Dashboard usage. The Data Engineer exam focuses on data integration and transformation: Snowpipe, Streams, Tasks, and ELT pipelines. The SQL skills you need to study point in noticeably different directions.
Practice with certification-focused question sets
Try free questionsNicheeLab Editorial Team
NicheeLab editorial team focused on data engineering and cloud certification learning. Content is structured around practical study needs and official exam domains.
Snowflake Certifications: All 11 Exams Explained (2026)
Every SnowPro certification on Snowflake's official list — C...
Snowflake Exam Difficulty Ranking: All 11 Certs Compared (2026)
All 11 SnowPro exams compared by difficulty in a ranking and...
Snowflake Study Guide: Fastest Pass Route by Exam (2026)
How to pass SnowPro certifications efficiently — official ma...
SnowPro Core (COF-C03): Complete Exam Guide (2026)
Pass the SnowPro Core exam — five domains, scope, sample que...
SnowPro Associate Platform (SOL-C01): Current Status & What to Take Next (2026)
As of October 2026, SnowPro Associate: Platform (SOL-C01) is...