thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Snowflake · Data & Analytics · Professional

SnowPro Advanced: Data Analyst exam guide

Exam DAA-C01

SnowPro Advanced: Data Analyst validates advanced analytics on Snowflake: data ingestion and preparation, transformation and modeling, analysis with advanced SQL, and presenting results in dashboards. It suits analysts who work directly in Snowflake rather than only through a BI tool.

Questions65
Time limit115 minutes
Passing score750 (0-1000 scale)
Exam fee$375 USD
Valid for2 years
DeliveryPearson VUE: online proctored or test center

Format: Multiple choice, multiple select and interactive items. Fee note: $300 in India.

Who it's for

Analysts with at least a year of Snowflake analytics experience and fluency in advanced SQL.

What the exam covers

Data Ingestion and Data Preparation—
Data Transformation and Data Modeling—
Data Analysis—
Data Presentation and Data Visualization—

A dash means the vendor does not publish a weight for that domain.

Eligibility & prerequisites

Required: Active SnowPro Core certification and fluency in advanced SQL.

Recommended: 1+ year of Snowflake analytics experience; knowing an additional language such as Python is recommended but not required.

Keeping it active

Valid 2 years. Renew through Snowflake's Continuing Education program (eligible instructor-led training or a qualifying higher SnowPro certification) or by passing the shorter, lower-cost recertification exam within the window before expiry.

Skills & careers

Skills it validates

  • Advanced SQL (window functions, CTEs, semi-structured data)
  • Data cleansing and preparation
  • Dimensional modeling for analytics
  • Statistical and aggregate analysis in SQL
  • Snowsight dashboards and visualization
  • Working with JSON via VARIANT and FLATTEN

Job roles

Senior Data AnalystAnalytics EngineerBI DeveloperBusiness Intelligence AnalystData Scientist

Where it fits in your path

Planning a degree too? See how this cert earns college credit in the College Credit Navigator.

Build my study plan

  1. Week 1: Ingestion and preparation: loading, data quality checks, handling semi-structured data.
  2. Week 2: Transformation and modeling: views, materialized views, dimensional models, UDFs.
  3. Week 3: Analysis: window functions, QUALIFY, MATCH_RECOGNIZE, sampling, statistical functions.
  4. Week 4: Presentation: Snowsight dashboards, charts and sharing results; Streamlit basics.
  5. Week 5: Timed practice and review of SQL function gaps.

Make it yours: pick your exam date and weekly hours. We'll split your time by domain weight and give you a printable plan.

Exam-day tips

  • Know Snowflake-specific SQL (QUALIFY, FLATTEN, LATERAL, PIVOT) because generic SQL knowledge will not cover it.
  • Expect questions that ask for the most efficient query, not just a correct one.
  • Practise reading query output and choosing the SQL that produced it.
  • Confirm the current question count and fee on Snowflake's site before booking.

Key terms for this exam

All 58 terms Study with thinQcards™

Frequently asked questions

Do I need SnowPro Core first?

Yes. An active SnowPro Core and fluency in advanced SQL are required.

How much does it cost?

SnowPro Advanced exams are listed at $375; confirm the current fee on Snowflake's registration page.

Is Python required?

No. Snowflake recommends knowing another language but the exam centres on SQL.

How long is it valid?

Two years.

Data Analyst vs Data Engineer?

Data Analyst focuses on SQL analysis, modeling and presentation; Data Engineer focuses on pipelines, ingestion and performance.

Official page: learn.snowflake.com. Reviewed November 2026. Vendors change fees and objectives, so confirm with the vendor before you book. Spot something out of date? Tell us.