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-Powered Insights
Personalized preparation guidance that adapts to your performance and identifies weak spots automatically.
Exam Information
Official specifications published by Snowflake
Exam Format
Registration
Validity
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
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.
- SNOWPRO-CORE SnowPro Core
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
DAA-C01 glossary
19 terms from the exam objectives and the vendor's official material, each defined in a sentence.
- APPROX_COUNT_DISTINCT
- A function that estimates the number of distinct values quickly, trading a little accuracy for speed.
- ASOF JOIN
- A join that pairs each row with the closest earlier row in time from another table, such as a trade and the latest quote.
- COPY INTO <table>
- The command that loads data from staged files into a table.
- Data Metric Functions
- Functions that measure data quality, such as counts of nulls or duplicates, and can run on a schedule.
- Data Vault
- A modeling method that stores business keys, relationships and descriptive details in separate hubs, links and satellites.
- Dynamic Data Masking
- A column policy that hides or masks values at query time, depending on the role of the user.
- FLATTEN
- A table function that turns nested values in semi-structured data, such as a JSON array, into separate rows.
- QUALIFY
- A clause that filters the results of window functions, the way HAVING filters the results of aggregates.
- Query Acceleration Service
- A virtual warehouse feature that hands parts of large scans to shared compute, to speed up outlier queries.
- Query Profile
- A Snowsight view of a query's execution plan that shows where time and resources were spent.
- Row Access Policies
- Policies that decide which rows a role can see when it queries a table or view.
- Search Optimization Service
- A feature that builds a search access path so that selective lookups on large tables run faster.
- Secure Data Sharing
- A Snowflake feature that gives another account read access to live data without copying it.
- Snowflake Marketplace
- A catalog of data sets and services from other providers that an account can add to its own data.
- Snowflake Notebooks
- Notebooks inside Snowsight that mix SQL and Python cells for exploratory analysis.
- Snowsight
- Snowflake's web interface, where analysts write queries in worksheets and build charts and dashboards.
- Stages
- Locations, inside or outside Snowflake, that hold data files before they are loaded into tables.
- Time Travel
- A feature that lets a query read or restore data as it was at an earlier point within a retention period.
- User-Defined Table Functions (UDTFs)
- Functions written by users that return a set of rows instead of a single value.