DAA-C01 Verified 2026 Edition

SnowPro Advanced: Data Analyst Practice Test

SnowPro Advanced: Data Analyst (DAA-C01) certifies analysts who prepare, analyze and visualize data inside Snowflake. It requires an active SnowPro Core certification and hands-on analyst experience. Practice questions here cover data ingestion and preparation, transformation and modeling, analysis with SQL, and reporting and visualization.

150 Total Questions
1 Included Version Get all versions for the price of one
English Edition
$90k–$140k Typical Salary An estimate of yearly pay in the United States for data analysts, analytics engineers and BI developers who work on Snowflake.
All-In-One Bundle
$79.99
$75.99
  • Interactive Simulator & AI
  • Detailed Explanations
  • Study, Timed & Flashcard Mode
  • Lifetime Access & Updates

Instant lifetime access • Secure checkout

Why Study with PlanetCert?

The Latest Questions

Practice questions and exam topics aligned with the current exam objectives.

Detailed Explanations

Go beyond the answer. Master the material with comprehensive learning and professional explanations for every concept.

AI

AI-Powered Insights

Personalized preparation guidance that adapts to your performance and identifies weak spots automatically.

Exam Information

Official specifications published by Snowflake

Exam Format

115 min
65
750 (scaled 0-1000)
Advanced

Registration

$375 USD
Pearson VUE or online proctoring
English

Validity

2 years
Snowflake Continuing Education (CE) program via eligible Instructor-Led (ILT) Training courses; Earn an equivalent or higher-level SnowPro Certification

Skills this practice test covers

  • Load files from internal and external stages with COPY INTO and resolve import errors.
  • Clean data by handling nulls, duplicates and type conversions, and check quality with Data Metric Functions.
  • Query and aggregate data with window functions, QUALIFY, CTEs and sampling.
  • Tune slow queries with the Query Profile, clustering keys, caching and the Search Optimization Service.
  • Extend SQL with UDFs, UDTFs and stored procedures, and forecast with built-in functions.
  • Build, share and maintain Snowsight dashboards with custom filters and subscriptions.

Explore related topics

DAA-C01 exam content

4 domains · 21 topics · 150 questions

Data Ingestion and Data Preparation17%25 questions

This domain covers getting data into Snowflake and deciding what is needed. Candidates retrieve structured, semi-structured and unstructured data, enrich it from the Snowflake Marketplace, keep keys and joins sound, and automate the loads.

Skills tested

  • Load files with PUT and COPY INTO <table>, and review loads with COPY_HISTORY.
  • Read metadata and change session context with DESCRIBE, SHOW and USE.
  • Enrich data through Secure Data Sharing, the Snowflake Marketplace and private listings.
  • Define primary keys and constraints, and join parent and child tables correctly.
  • Schedule pipelines with tasks, and trace failures with logging, auditing and data lineage.

Questions by topic

  • Query tables to assess data and required transformations4
  • Load data and perform DML5
  • Retrieve data from a source4
  • Use Secure Data Sharing to enrich existing data sets4
  • Automate pipelines and respond to failures4
  • Keys, joins, and constraints3
  • Data formats1
Data Transformation and Data Modeling23%33 questions

Here raw data becomes a clean, consumable model. Candidates parse CSV, JSON, Parquet and XML, fix quality problems, pick a dimensional or Data Vault model, and make the queries that read it run fast.

Skills tested

  • Parse semi-structured data with PARSE_JSON and FLATTEN into a consumable format.
  • Handle nulls, duplicates and type conversions, and measure quality with Data Metric Functions.
  • Use Time Travel and clones to restore or compare data.
  • Decide when a data model fits better than a flattened data set.
  • Speed up queries with partition pruning, clustering keys, caching and the Query Acceleration Service.

Questions by topic

  • Performance tuning9
  • Query, aggregate, and enrich7
  • Cleaning techniques8
  • Data formats4
  • Modeling techniques5
Data Analysis32%48 questions

The largest domain is the analysis itself. Candidates extend SQL with UDFs, UDTFs and stored procedures, summarize data in Snowsight and Notebooks, find the causes of anomalies, and forecast with statistics and built-in functions.

Skills tested

  • Write UDFs, UDTFs and asynchronous stored procedures, and choose regular, secure or materialized views.
  • Summarize large data sets with Snowsight dashboards and a reusable filter.
  • Explore data ad hoc in Snowflake Notebooks and worksheets.
  • Find the reasons for anomalies or patterns in historical data.
  • Make predictions with REGR_SLOPE, REGR_INTERCEPT and ML functions.

Questions by topic

  • Extensibility objects15
  • Root-cause and pattern analysis8
  • Predictive analysis8
  • Summarize and explore data11
  • Function categories5
  • Query, aggregate, and enrich1
Data Presentation and Data Visualization28%44 questions

This domain turns results into reports a business can use. Candidates build Snowsight charts and dashboards, keep them current with tasks and subscriptions, and pick the chart that shows a trend or a correlation.

Skills tested

  • Set the database, schema, virtual warehouse and role before building a dashboard.
  • Compare bar charts, scatter plots, heat grids and scorecards for a business question.
  • Explain how row access policies and Dynamic Data Masking change what viewers see.
  • Share Snowsight dashboards and configure subscriptions and updates.
  • Troubleshoot common problems with dashboards and reports.

Questions by topic

  • Build dashboards and charts24
  • Operationalize and maintain dashboards14
  • Present data for business use6
Practise these questions in study mode

Requirements

  • Required: a SnowPro Core certification that is active and in good standing.
  • Recommended: a year or more of hands-on Snowflake data analytics work in production.
  • Recommended: fluency with advanced SQL. Knowledge of another programming language helps but is not required.

About the DAA-C01 exam

Snowflake's DAA-C01 exam tests whether an analyst can take data from raw files to a finished Snowsight dashboard. Its scenario-based questions cover loading and cleaning data, modeling it for business intelligence, analysis with advanced SQL and built-in functions, and reports that answer business questions. An active SnowPro Core certification is required before booking. A pass earns SnowPro Advanced: Data Analyst, valid for two years.

Data Analysis is the largest domain, followed by Data Presentation and Data Visualization, and the PlanetCert practice test gives these two the most questions. The explanations show why one feature fits a case better than a close alternative, such as QUALIFY against a subquery, or a materialized view against a regular one. Study Mode suits the performance questions, where the Query Profile and the caching layers reward slow reading. Brainy AI Assistant can rewrite a query with a window function or explain what APPROX_COUNT_DISTINCT gives up in exchange for speed.

How to earn the certification

Earns
SnowPro Advanced: Data AnalystAdvanced

SnowPro certifications expire two years after the issue date and can be renewed through Snowflake's Continuing Education program.

Before
  • SNOWPRO-CORE SnowPro Core

    Required. This certification must be active and in good standing before the Data Analyst exam can be taken.

How to prepare for DAA-C01

  1. Open a practice Snowflake account

    Work in a Snowflake trial or sandbox account. Stage CSV and JSON files, load them with COPY INTO, and break one load on purpose to practise reading the import errors.

  2. Answer one question five ways

    Take a single business question and answer it with a CTE, a window function with QUALIFY, a UDF, a view and a stored procedure. Compare how each version reads and performs.

  3. Read query profiles closely

    Run a slow query and study its Query Profile for pruning, spilling and cache use. Add a clustering key or search optimization, then compare the profile again.

  4. Build a dashboard end to end

    Data Analysis and the Data Presentation and Data Visualization domain carry most of the exam's weight. Build a Snowsight dashboard with custom filters, try several chart types, and share it with a subscription.

  5. Study first, then sit a timed run

    Start the DAA-C01 practice test in Study Mode to read each explanation, then switch to Timed Mode for a full run. Ask Brainy AI Assistant about any function behind a wrong answer, such as FLATTEN or REGR_SLOPE.

    Start a timed DAA-C01run

Snowflake's study guide points to its Advanced Analytics Instructor-Led Training and BI Analytics Bootcamp course, and to its virtual hands-on labs and Quickstart tutorials.

Who DAA-C01 is for

  • Data analysts who hold SnowPro Core and query Snowflake every day.
  • ELT developers who prepare and transform data for reporting.
  • Business intelligence professionals and analytics engineers who turn Snowflake data into dashboards.

Typical job titles: Data analyst · BI developer · Analytics engineer · ELT developer · Business intelligence analyst

Your Complete Exam Solution

Best-In-Class Practice Tests

Exam-style questions that match the format and difficulty of the real exam, updated regularly. Original material — not recycled dumps.

Topical Breakdown

Study by domain, pinpoint weak areas, and focus your time where it matters most. Every topic mapped to the official syllabus.

Flashcard Mode

Rapid-fire review to reinforce key concepts. Flip through questions and answers at your own pace before exam day.

See How You Compare Against Yourself

✕
✕
✕

Other Exam Prep

  • Outdated question dumpsRecycled, often inaccurate material
  • No explanationsMemorize answers without understanding
  • Static PDF filesNo interactive practice or feedback
  • Subscription feesRecurring charges, access expires
✓
✓
✓

PlanetCert

  • Verified, current questionsUpdated weekly to match live exam objectives
  • Expert-written rationalesUnderstand every concept, not just the answer
  • Session tracking & exam progressTrack every attempt, see your growth over time
  • Lifetime access, one pricePay once — updates included forever
CERTIFIEDDAA-C01

Study Naturally, Study Responsibly

Practice with exam-style questions and detailed explanations until you're ready.

Try Free Demo
Secure Checkout Lifetime Access