Snowflake

SnowPro Advanced: Data Analyst Complete Guide

2026-03-26
Updated: 2026-10-15
NicheeLab Editorial Team
Table of contents
  1. Exam Overview and Specifications
  2. Exam Domains and Weighting
  3. Mastering SQL Window Functions
  4. QUALIFY: Snowflake's Powerful Native Clause
  5. Data Modeling Topics on the Exam
  6. Working with Snowsight Dashboards
  7. Performance Optimization
  8. Data Governance and Analytics Security
  9. Study Strategy for Passing
  10. Test Yourself
  11. Frequently Asked Questions

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.

Exam Overview and Specifications

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.

ItemDetails
Exam CodeDAA-C01
Number of Questions65 (may include unscored items)
Duration115 minutes
Passing Score750 / 1000
Exam Fee$375 USD
PrerequisiteSnowPro Core certification (in-date)
Question FormatMultiple choice (single and multi-select) and interactive
DeliveryPearson VUE test center or online proctoring (OnVUE)
RetirementRetires 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.

Exam Domains and Weighting

Below are the four exam domains from the official Study Guide. Data Analysis carries the largest weight at 32% of the exam.

DomainWeightKey Topics
1.0 Data Ingestion and Data Preparation17%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 Modeling23%Data cleansing, semi-structured data, window functions and CTEs, data modeling, query performance optimization
3.0 Data Analysis32%UDFs, stored procedures, and views; descriptive and diagnostic analysis; forecasting
4.0 Data Presentation and Data Visualization28%Snowsight dashboards and charts, filters, effects of row access policies and Dynamic Data Masking, connecting BI tools

Mastering SQL Window Functions

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.

Ranking Functions (ROW_NUMBER / RANK / DENSE_RANK)

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;

Time-Series Analysis with LEAD / LAG

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;

FRAME Clauses (ROWS BETWEEN / RANGE BETWEEN)

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: Snowflake's Powerful Native Clause

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;

Data Modeling Topics on the Exam

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.

  • Star schema: separates fact and dimension tables. JOINs stay one level deep, making it ideal for analytics queries.
  • Snowflake schema: further normalizes dimensions. Storage efficiency improves but JOIN count goes up.
  • OBT (One Big Table): a denormalized mega-table. Fast with no JOINs, but causes data duplication.
  • Secure View: a pattern for sharing analytics results while enforcing row-level control via Row Access Policy.

Working with Snowsight Dashboards

Snowsight is Snowflake's native visualization tool, letting you build dashboards directly from SQL worksheets. The exam targets the following points.

  • How to create dashboard tiles from a worksheet
  • Filter linkage: how changing one filter propagates to multiple tiles
  • Choosing chart types: when to use bar, line, scatter, and heatmap
  • Dashboard sharing and access control (how to grant USAGE privilege)
  • Snowsight's limits: where it fits next to external BI tools like Tableau and Power BI

Performance Optimization

The Data Analyst exam also covers query acceleration techniques. Reading a Query Profile is mandatory knowledge.

How to Read a Query Profile

  • Bytes Scanned: check whether full scans are happening; measure the effect of your Clustering Key
  • Spillage to Local/Remote Storage: disk spills caused by insufficient memory; a signal to rethink warehouse size
  • Pruning efficiency: the Partition Pruning ratio; tells you whether your Clustering Key design is right
  • JOIN Explosion: detects unintended many-to-many JOINs blowing up row counts

Using Result Cache

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.

Data Governance and Analytics Security

Analysts often handle data that includes personal information, so understanding governance features is essential.

  • Dynamic Data Masking: masks column values based on role; for example, displaying email addresses as "***@***" for any role other than ACCOUNTADMIN
  • Row Access Policy: restricts which rows a role or user can see; a classic example is showing regional sales data only to that region's owner
  • Object Tagging: tags tables and columns with labels like PII or Confidential, managed centrally from the Governance Dashboard
  • Access History: an audit log of who accessed what data and when; available on Enterprise Edition and above

Study Strategy for Passing

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.

  • Use the Snowflake free trial with the SAMPLE_DATA schema (TPCH_SF1) for intensive window function practice
  • Drill Snowflake-specific syntax like QUALIFY and PIVOT/UNPIVOT
  • Actually build a Snowsight Dashboard to experience filter linkage and chart design firsthand
  • Practice reading Query Profiles: intentionally write inefficient queries and train yourself to identify the bottleneck
  • Read through every reference doc listed in the official Study Guide (especially the window function reference)

Test Yourself

SnowPro Advanced: Data Analyst

Question 1

In Snowflake, which SQL most appropriately returns only the top sales record per department?

  1. SELECT department, salesperson, revenue FROM sales QUALIFY ROW_NUMBER() OVER (PARTITION BY department ORDER BY revenue DESC) = 1
  2. SELECT department, salesperson, revenue FROM sales WHERE ROW_NUMBER() OVER (PARTITION BY department ORDER BY revenue DESC) = 1
  3. SELECT department, salesperson, MAX(revenue) FROM sales GROUP BY department, salesperson HAVING RANK() = 1
  4. SELECT TOP 1 department, salesperson, revenue FROM sales ORDER BY revenue DESC

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.

Frequently Asked Questions

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.

Check what you learned with practice questions

Practice with certification-focused question sets

Try free questions
Author

NicheeLab Editorial Team

NicheeLab editorial team focused on data engineering and cloud certification learning. Content is structured around practical study needs and official exam domains.


Related articles
Snowflake

Snowflake Certifications: All 11 Exams Explained (2026)

Every SnowPro certification on Snowflake's official list — C...

Snowflake

Snowflake Exam Difficulty Ranking: All 11 Certs Compared (2026)

All 11 SnowPro exams compared by difficulty in a ranking and...

Snowflake

Snowflake Study Guide: Fastest Pass Route by Exam (2026)

How to pass SnowPro certifications efficiently — official ma...

Snowflake

SnowPro Core (COF-C03): Complete Exam Guide (2026)

Pass the SnowPro Core exam — five domains, scope, sample que...

Snowflake

SnowPro Associate Platform (SOL-C01): Current Status & What to Take Next (2026)

As of October 2026, SnowPro Associate: Platform (SOL-C01) is...

Browse all Snowflake articles (103)
© 2026 NicheeLab All rights reserved.