SnowPro Advanced: Data Analyst (DAA-C01)
Demonstrate advanced proficiency in data analysis, data preparation, complex analytical SQL, windowing functions, semi-structured data analysis, visualization, and semantic modeling in Snowflake.
Official Exam Specification & Quick Facts
Question Difficulty Breakdown
Exam Guidelines & Simulation Rules
Frequently Asked Questions (FAQ)
The DAA-C01 exam features 65 scenario, analytical SQL, and visualization questions over 115 minutes. Cost is $375 USD with a passing threshold of 750/1000 (75%). SnowPro Core is a prerequisite.
Domains include: (1) Data Ingestion and Preparation (~20-25%), (2) Advanced Analytical SQL Queries (~35-40%), (3) Visualizations and Dashboards (~20-25%), and (4) Governance and Performance (~15-20%).
Key windowing functions include `QUALIFY` (filters window function results without subqueries), `LEAD()`, `LAG()`, `ROW_NUMBER()`, `DENSE_RANK()`, and window frame clauses (`ROWS BETWEEN`).
The `QUALIFY` clause filters the results of window functions directly in the `SELECT` statement (similar to a `HAVING` clause for aggregates), eliminating verbose nested subqueries or CTEs.
Recursive Common Table Expressions (CTEs) allow analysts to query and traverse hierarchical structures such as organizational reporting trees, bill-of-materials, and graph networks.
Snowsight is Snowflake's modern web interface providing integrated interactive SQL worksheets, charts (line, bar, scatter, heatmaps), dashboard sharing, and automatic code completion.
The `FLATTEN` table function explodes semi-structured arrays or objects inside `VARIANT` columns into individual rows, converting nested arrays into tabular relational datasets.
Snowflake supports Bernoulli sampling (row-based) and System sampling (block-based) via the `SAMPLE` clause, enabling rapid statistical analysis over multi-terabyte datasets without scanning all rows.
Using `AT(TIMESTAMP => ...)` or `BEFORE(STATEMENT => ...)`, analysts can query and compare past states of tables to calculate historical churn, attribution, and data modifications.
Snowflake Horizon is Snowflake's built-in governance solution providing automated data lineage, sensitive data tagging, data quality metrics, and role-based access control.
The DAA-C01 credential is valid for two years from the pass date.
DAA-C01 certifies Senior Business Intelligence Analysts, Lead Analytics Engineers, and Quantitative Data Specialists earning average US salaries between $125,000 and $165,000.