Snowflake · SF-DA · Advanced
SnowPro Advanced: Data Analyst (DAA-C01) — Practice Questions and Mock Exam
Practice real SF-DA questions, never dumps. Alex explains every answer, and your readiness score tells you when you're ready to pass.
Checked against Snowflake · April 2026Current exam version
Overview
About the exam
The SnowPro Advanced: Data Analyst Certification (DAA-C01) validates the ability to perform end-to-end data analysis on Snowflake, including data ingestion and preparation, transformation and modeling, advanced analytical techniques, and data presentation and visualization. It tests proficiency in turning raw data into actionable business insights using Snowflake's analytical capabilities and connected visualization tools.
This certification is ideal for data analysts, business intelligence developers, and reporting specialists with two or more years of Snowflake experience. It demonstrates the ability to design analytical workflows, build data models for reporting, and communicate findings effectively — skills essential for data-driven decision-making roles.
Exam Domains
What's on the exam
The exam consists of 65 questions — multiple-choice, multiple-select, and true/false — to be completed in 115 minutes. Questions cover four domains: Data Analysis (32%), Data Presentation & Visualization (29%), Data Transformation & Modeling (22%), and Data Ingestion & Preparation (17%). A passing score is 750 out of 1000. Analysis and visualization together comprise over 60% of the exam — prioritize SQL analytics and dashboard design in preparation.
Ingest, stage, and prepare data using COPY, Snowpipe, external tables, and data transformation techniques.
Transform data using SQL, CTEs, window functions, and design star/snowflake schemas and data vault models.
Perform advanced analytics using SQL, aggregate functions, time-series analysis, and Snowflake-specific analytical features.
Create dashboards, integrate with BI tools, and present analytical results using Snowsight and partner tools.
SourceSnowflake exam page
Format
What to expect
Watch out
Where candidates struggle
Analysts who only write basic SELECT queries often struggle with window functions, QUALIFY clauses, PIVOT/UNPIVOT operations, and questions about connecting Snowflake to BI tools like Tableau or Power BI.
- 01Window Functions — Not mastering ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, and NTILE window functions — including PARTITION BY and ORDER BY clauses — leads to analysis question failures.
- 02QUALIFY Clause — Not knowing that QUALIFY filters window function results (like HAVING for GROUP BY) and is unique to Snowflake SQL causes mistakes on advanced query questions.
- 03Materialized Views — Confusing regular views with materialized views and not understanding when Snowflake auto-refreshes materialized views or their Enterprise Edition requirement leads to modeling errors.
- 04BI Tool Integration — Not understanding how Snowflake connects to Tableau, Power BI, and Looker — including partner connect, OAuth, and ODBC/JDBC drivers — causes visualization ecosystem question mistakes.
- 05PIVOT and UNPIVOT — Struggling with PIVOT (rows to columns) and UNPIVOT (columns to rows) syntax and not understanding dynamic pivot patterns leads to transformation question errors.
Details
Exam logistics
Delivered online via the Snowflake Certification Portal. Available in English and Japanese. The certification is valid for 2 years. Renewal requires recertification or continuing education credits. Exam fee is $375 USD. Prerequisite: active SnowPro Core certification.
SourceSnowflake exam page
Before you book the exam
Would you pass SF-DA today?
Take the free readiness check. Answer real SF-DA questions and get your readiness score across every domain.
Take the free readiness check20 questions · freeReach 80% readiness by exam day. Pass, or your money back.