Question 1

How many DAA-C01 practice questions are there?

Accepted Answer

150 questions across 1 version, each with the correct answer and an explanation.

Question 2

Are there free DAA-C01 sample questions?

Accepted Answer

Yes. 12 sample questions are free; 6 are open to everyone and the rest unlock with a free account.

Question 3

What does full access include?

Accepted Answer

Every DAA-C01 question in study, timed and flashcard modes, explanations for each answer, and progress that saves so you can resume.

Question 4

What topics does DAA-C01 cover?

Accepted Answer

Data Ingestion and Data Preparation (17%), Data Transformation and Data Modeling (23%), Data Analysis (32%), Data Presentation and Data Visualization (28%).

Question 5

What is the SnowPro Advanced: Data Analyst (DAA-C01) certification?

Accepted Answer

DAA-C01 is Snowflake's advanced-level certification that validates the ability to apply comprehensive data analysis principles using Snowflake, including preparing and loading data, building and troubleshooting advanced SQL, using built-in functions and UDFs, and performing descriptive, diagnostic, and predictive analyses to meet business requirements.

Question 6

Do I need any prerequisites to take the DAA-C01 exam?

Accepted Answer

Yes. You must hold an active SnowPro Core Certification (COF-C02) in good standing before taking the SnowPro Advanced: Data Analyst exam. Snowflake also recommends at least one year of hands-on Snowflake data analytics experience and fluency with advanced SQL.

Question 7

How much does the DAA-C01 exam cost?

Accepted Answer

The SnowPro Advanced Certification series, including DAA-C01, costs $375 USD per exam attempt, and each registration requires the full $375 amount.

Question 8

What domains are covered on the DAA-C01 exam and how are they weighted?

Accepted Answer

There are four domains: Data Ingestion and Data Preparation (17%), Data Transformation and Data Modeling (23%), Data Analysis (32%), and Data Presentation and Data Visualization (28%).

Question 9

How many questions are on the DAA-C01 exam and what is the passing score?

Accepted Answer

The exam has 65 scenario-based multiple select/multiple choice questions with a 115-minute time limit, and a passing score of 750 on a scaled range of 0-1000. (Format specifics are published on Snowflake's certification 'Exam Details' tab.)

Question 10

How long is the SnowPro Advanced: Data Analyst certification valid, and how do I recertify?

Accepted Answer

All Snowflake certifications expire two years after the issue date. You can recertify through the Snowflake Continuing Education (CE) program by completing eligible Instructor-Led Training courses or by earning an equivalent or higher-level SnowPro Certification.

Question 11

What tools and features does DAA-C01 focus on?

Accepted Answer

The exam focuses heavily on Snowsight (dashboards, charts, custom filters), advanced SQL (window functions, QUALIFY, CTEs, FLATTEN), UDFs/UDTFs and stored procedures, views, Snowflake Marketplace and Secure Data Sharing, query performance tuning (clustering, pruning, caching, search optimization, query acceleration), and built-in ML/statistical functions for forecasting and anomaly detection.

Question 12

What is the passing score for DAA-C01?

Accepted Answer

You need 750 (scaled 0-1000) to pass DAA-C01.

Question 13

How long is the DAA-C01 certification valid?

Accepted Answer

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

DAA-C01SnowPro Advanced: Data Analyst practice test

Full access

Practice DAA-C01 in the simulator.

DAA-C01, by the numbers.

Everything about DAA-C01.

Exam information

What DAA-C01 covers

How do I earn this certification?

How to study for this exam?

What's changed on this exam?

Who should take this exam?

Three ways to practise

Study mode

Timed mode

Flashcards

DAA-C01 questions, answered

DAA-C01SnowPro Advanced: Data Analyst practice test

Full access

Practice DAA-C01 in the simulator.

DAA-C01, by the numbers.

Everything about DAA-C01.

Exam information

01Exam format115 min · 654

02Registration$375 · Pearson VUE, online proctoring4

03Validity2 years2

04In our question bankv1 (150)

What DAA-C01 covers

01Data Ingestion and Data Preparation17%7 topics

1.1Use a collection system to retrieve dataRetrieve structured, semi-structured, unstructured, and synthetically generated data from a source2 obj.

1.2Perform data discovery to identify what is needed from the available datasetsAssess data elements and granularity4 obj.

1.3Enrich data by identifying and accessing relevant data from the Snowflake MarketplaceEnrich datasets using Secure Data Sharing and the Snowflake Marketplace2 obj.

1.4Use best practice considerations relating to data integrity structuresApply data integrity structures (keys, constraints, parent/child joins)2 obj.

1.5Implement data processing solutionsAutomate data pipelines and respond to processing failures with logging, monitoring, auditing, and lineage2 obj.

1.6Given a scenario, prepare data and load into SnowflakeLoad different data types from stages, perform DML, and resolve import errors2 obj.

1.7Given a scenario, use Snowflake functionsApply the full range of Snowflake function categories including AI and ML functions2 obj.

Hands-on skills & common mistakesLoading via Snowsight and COPY INTO · Confusing UNION vs UNION ALL

02Data Transformation and Data Modeling23%5 topics

03Data Analysis32%4 topics

04Data Presentation and Data Visualization28%3 topics