SNOWPRO-ADVANCED-DATA-ANALYST: SnowPro Advanced: Data Analyst
Browse certifications
Exam Resources
Official learning paths, exam details, skills measured, and community resources to supplement your study.
About the SnowPro Advanced: Data Analyst Exam
Master the Snowflake SnowPro Advanced: Data Analyst certification (DAA-C01) — data ingestion and preparation, transformation and modeling, advanced data analysis, and data presentation and visualization in Snowflake.
The complete practice exam for the Snowflake SnowPro Advanced: Data Analyst certification (DAA-C01). This advanced, role-based exam goes deeper than SnowPro Core — it tests how you ingest, transform, analyze, and present data on the Snowflake AI Data Cloud. Covers data ingestion and preparation (loading structured and semi-structured CSV/JSON/Parquet/Avro/ORC/XML data, COPY INTO and stages, ASOF and set-operation joins, Snowflake-maintained statistics, Marketplace and Secure Data Sharing enrichment, external tables, and pipeline automation with Snowpipe, streams, tasks, and dynamic tables), data transformation and data modeling (LATERAL FLATTEN and semi-structured parsing, Data Metric Functions, window and analytic functions with QUALIFY, CTEs and recursive queries, sampling and approximation, Time Travel and zero-copy cloning, views vs materialized views vs dynamic tables, and query optimization with clustering, caching, Search Optimization, and Query Acceleration), data analysis (UDFs and UDTFs, synchronous and asynchronous stored procedures, secure and materialized views, Snowsight dashboards and Notebooks, statistics and trends, and forecasting with built-in ML functions and Cortex Analyst), and data presentation and visualization (Snowsight charts and dashboards, custom filters, Streamlit in Snowflake, row access and masking effects on reports, BI tool connectivity, subscriptions and operationalized reporting) — every question a real-world analyst scenario with full explanations.
Who Should Take This Exam?
The SnowPro Advanced: Data Analyst certification is designed for data analysts, BI developers, and analytics engineers who explore, transform, and present data on the Snowflake AI Data Cloud. It validates advanced, hands-on skill across the analytics lifecycle: ingesting and shaping data, modeling and optimizing queries, running diagnostic and forecasting analyses, and building dashboards and reports. Candidates typically have 2+ years of hands-on Snowflake and SQL experience.
Prerequisites: SnowPro Core Certified
Typical study time: 6-10 weeks of focused study (plus hands-on Snowsight, SQL, and dashboard experience)
Exam Quick Facts
| Detail | Value |
|---|---|
| Exam Code | SnowPro Advanced: Data Analyst (DAA-C01) |
| Title | SnowPro Advanced: Data Analyst |
| Duration | 115 minutes |
| Questions | 65 |
| Pass Score | 750 / 1000 (scaled) |
| Cost | $375 USD |
| Provider | Snowflake (Pearson VUE / online proctored) |
| Validity | 2 years |
| Prerequisites | SnowPro Core Certified |
| Question Types | Multiple choice, Multiple select, Interactive |
| Official Page | View on Snowflake → |
Exam Domains & Weights
The SnowPro Advanced: Data Analyst exam covers 4 domains. Focus your study time based on the weights below — higher-weighted domains have more exam questions.
| Domain | Weight | Practice Qs |
|---|---|---|
| Data Analysis | 32% | 80 |
| Data Presentation and Data Visualization | 28% | 70 |
| Data Transformation and Data Modeling | 23% | 57 |
| Data Ingestion and Data Preparation | 17% | 43 |
| Total | 100% | 250 |
💡 Study tip: Data Analysis (32%) is the heaviest domain — know UDFs and UDTFs, synchronous and asynchronous stored procedures, secure and materialized views, Snowsight dashboards and Notebooks, statistics and trend analysis, and forecasting with built-in ML functions and Cortex Analyst. Data Presentation and Visualization (28%) is Snowsight charts and dashboards, custom filters, Streamlit, BI connectivity, and how row access and masking policies affect reports. Data Transformation and Data Modeling (23%) covers window functions and QUALIFY, FLATTEN, CTEs, sampling, dynamic tables, and query optimization. Data Ingestion and Data Preparation (17%) is COPY INTO and stages, joins and set operations, Marketplace enrichment, and pipeline automation.
Practice Exam — 250 Questions
Prepare for the SnowPro Advanced: Data Analyst with our 250-question practice exam covering all 4 exam domains. Every question is a real-world analyst scenario with detailed explanations and maps to official exam objectives.
What you get:
- ✅ Exam simulation mode with timer
- ✅ Spaced repetition for weak areas
- ✅ Detailed explanations for every question
- ✅ Progress tracking across domains
- ✅ 20 free questions — no account needed
Snowflake Certification Path
Start with the SnowPro Core Certification (the broad, foundational credential and a prerequisite for the Advanced track), then specialise with the SnowPro Advanced certifications — Data Analyst, Data Engineer, Data Scientist, Architect, and Administrator — which go deeper into role-specific design and operations.
Study Tips
- Lead with analysis — the heaviest domain rewards knowing UDF/UDTF, stored procedures, views, Snowsight dashboards and Notebooks, statistics, and forecasting cold
- Use our practice exam — try the 20 free questions first to gauge your readiness for the advanced level
- Get hands-on in a trial account — load data, build window-function and FLATTEN queries, create dashboards, and ship a Streamlit app in a real Snowflake account
- Think in trade-offs — the data-analyst exam is about choosing (view vs materialized view vs dynamic table; BERNOULLI vs SYSTEM sampling; which chart for the story); read every explanation for the why
- Check the official page — official exam details always have the latest objectives