Snowflake · SF-DA · Advanced

SnowPro Advanced: Data Analyst (DAA-C01) — Practice Questions and Mock Exam

Name: Pass-IT
Author: Pass-IT

The SnowPro Advanced: Data Analyst Certification (DAA-C01) validates the ability to perform end-to-end data analysis on Snowflake, including data ingestion and preparation, transformation and modeling, advanced analytical techniques, and data presentation and visualization.

Practice for free Try a practice question first

Try a practice question first Practice for free

Start practicing SF-DA free Buy SF-DA access for $29.99

65Questions per Pass-IT mock exam

115minPass-IT mock exam time limit

Official SF-DA exam: 750 out of 1000 points to pass.

Checked against Snowflake · August 2026 · Current exam version

Try Pass-IT

See what learning with Pass-IT is like.

Answer a SF-DA sample question and read the explanation with its source. Right here, with no sign-up.

Data Transformation and Data Modeling1 / 5

An analyst uses CONNECT BY to query an employee hierarchy table. Which pseudo-column indicates the depth of each node relative to the root in the traversal?

AlexFull explanation from Alex

LEVEL is the correct pseudo-column for depth in CONNECT BY hierarchical queries. It returns 1 for root nodes and increments by 1 for each deeper level. Example: SELECT employee_id, LEVEL FROM employees START WITH manager_id IS NULL CONNECT BY PRIOR employee_id = manager_id. Distractors: DEPTH(), SYS_TREE_DEPTH, and CONNECT_BY_DEPTH are fabricated—none exist in Snowflake. Other valid CONNECT BY pseudo-columns include CONNECT_BY_ROOT (root row value) and SYS_CONNECT_BY_PATH (full path string), but only LEVEL indicates depth. Ref: docs.snowflake.com/en/sql-reference/constructs/connect-by

Sourcedocs.snowflake.com

Data Analysis4 / 5

A Snowflake Scripting procedure runs four independent INSERT INTO ... SELECT statements, one per region. The job now takes 40 minutes because each statement waits for the previous one to finish. The analyst wants the four inserts to run concurrently and the procedure to return after all four have completed. What should the analyst change in the procedure?

AlexFull explanation from Alex

In Snowflake Scripting, statements in a block run one after another by default: each child job waits for the running one to finish. Putting the ASYNC keyword in front of a query starts it as an asynchronous child job, so the block continues and several child jobs can run at the same time. To control completion you use AWAIT: AWAIT ALL waits for every running child job, and AWAIT on a RESULTSET waits for that one job. CANCEL stops a child job tied to a RESULTSET. Exam tip: concurrency inside one procedure is ASYNC, and 'return after everything finishes' is AWAIT ALL.

Sourcedocs.snowflake.com

Data Ingestion and Data Preparation5 / 5

Finance reconciles each quarter against the exchange-rate table it receives through a Marketplace listing. Auditors later ask to see exactly the rates that were used at quarter end, after the provider has updated the table several times. What should the analyst do at each quarter end?

AlexFull explanation from Alex

Shared data is live: when the provider updates a table, consumers see the new rows. That is convenient for current analysis but means the consumer has no history of earlier states. Snowflake lists cloning and Time Travel among the actions not supported for imported databases, and the database is read-only, so the consumer is not the one who raises retention settings either. If the business needs a snapshot, the consumer materializes it, for example with CREATE TABLE ... AS SELECT into its own database at the moment it matters, and the copy then has its own Time Travel. Exam tip: shared data has no consumer-side history; snapshot it into your own table when history matters.

Sourcedocs.snowflake.com

Create a free account

How to prepare for SF-DA with Pass-IT.

Currently 403 practice questions for SF-DA, with new ones added regularly. Focus on what you still need to learn.

Get past difficult questions.

Understand why an answer is correct. Alex explains the concepts and answers your follow-up questions so you can apply what you learn to the next task.

Meet Alex →

Conversation preview · SF-DA

Hierarchy depth

You
Which value tells me how deep a row is in a CONNECT BY hierarchy?
Alex · AI tutor
The LEVEL pseudo-column.
Read the Snowflake documentation ↗
You
Does it describe a stored employee attribute?
Alex · AI tutor
No. It represents the row’s depth relative to the root during the traversal.
Read the Snowflake documentation ↗

Make your study time count.

Practice at your level.
For new practice sessions, Pass-IT adjusts the difficulty based on your previous answers.

Learn from mistakes.
Incorrect answers automatically become flashcards. When you review them, you rate how confidently you remember; Pass-IT schedules the next review.

See how focused practice works →

Animated feature preview

Turn your mistakes into knowledge you can rely on.

How Pass-IT works

Your review

Answered a question incorrectly?

Pass-IT saves it for your review.

SF-DA · Question excerpt

Hierarchy depth

View the full question

An analyst uses CONNECT BY to query an employee hierarchy table. Which pseudo-column indicates the depth of each node relative to the root in the traversal?

Understand the correct answer.

LEVEL

LEVEL reports a node’s depth in a CONNECT BY hierarchy traversal.

Read the Snowflake documentation ↗

How confidently do you remember?

During review, you assess how well you still know the answer.

Correct after hesitating

Pass-IT schedules your next review.

The date depends on your self-assessment and previous reviews.

Simplified demonstration. No learning progress is saved.

Practice for the moment that counts.

Take a full mock exam with a time limit and find out whether you can finish in time.

Your SF-DA mock exam

Questions: 65
Minutes: 115

Illustration of an exam session

Start
Answer questions
Finish

Length and time limit of the Pass-IT mock exam.

Go into your exam with more confidence.

Your Readiness Score helps you assess whether you are ready for the exam. Results by exam domain show you where you should keep practicing.

Your money back if you fail despite 80% Readiness.
If your Readiness Score is at least 80% when you take the exam and you still fail, we refund the Pass-IT purchase price for this certification.

For active, paid access. Submit proof of failing within 14 days.

Further guarantee conditions

You need at least 80% Readiness and active, paid access to the certification when you take the exam. Take the exam within your access period and submit official proof of failing within 14 days after the exam.

For purchases through Apple or Google, refunds are handled by the respective store. See the full terms for further details.

Read the guarantee terms →

The Readiness Score describes your practice progress, not a probability of passing.

Guarantee requirement

80%

At least 80% Readiness
when you take the exam

Money back if you fail

Question counts and mock exam settings from the current Pass-IT catalog.

Exam domains

What you practice for SF-DA.

Exam topics, relevant practice and sources you can check.

Find and prepare useful dataSee the guide for weighting72 QuestionsPass-IT questions

Build a reliable starting dataset for the business question.

Retrieve structured, semi-structured, unstructured or synthetic data and inspect metadata, granularity and required fields with SQL, joins, set operations and context commands.
Enrich datasets through Marketplace or secure sharing, and define keys, constraints and parent-child joins to preserve integrity.
Clean, conform and enrich data in scheduled pipelines; use logs, monitoring, audits and lineage to respond to failures.
Load files through Snowsight or stages, prepare external tables, apply INSERT, UPDATE and DELETE, and resolve import errors.
Choose scalar, aggregate, window, table, system, geospatial, AI, ML or user-defined functions for the analysis task.

Official Snowflake objectives

Transform and model dataSee the guide for weighting101 QuestionsPass-IT questions

Turn source data into consistent datasets that support analysis.

Parse CSV, JSON, Parquet and XML into usable data, using native types and functions to traverse, flatten or nest semi-structured values.
Resolve duplicates, nulls, ambiguity and type errors; validate quality with data metric functions and use Time Travel or clones where needed.
Aggregate and validate data with window functions, ranking, casting, joins, subqueries and CTEs; work with hierarchies, sampling, approximation and estimation.
Choose dimensional, Data Vault or flattened models for the reporting and consumption requirements.
Read execution plans and improve queries with pruning, clustering, caches, search optimization and query acceleration.

Official Snowflake objectives

Analyze patterns and make forecastsSee the guide for weighting127 QuestionsPass-IT questions

Use SQL and statistical reasoning to explain what the data shows.

Extend SQL with UDFs, UDTFs, stored procedures, including asynchronous execution, and regular, secure or materialized views.
Summarize and explore datasets with reusable dashboard filters, Notebooks and worksheets.
Investigate historical anomalies and patterns by collecting related data and examining demographics, relationships, statistics and trends.
Use statistics and built-in functions to forecast and make data-based predictions.

Official Snowflake objectives

Present and maintain analysisSee the guide for weighting103 QuestionsPass-IT questions

Make analytical results understandable and keep reports useful over time.

Select data, SQL context, chart types and filters for Snowsight or connected BI tools, accounting for row access and masking policies.
Automate repeatable reporting tasks, prepare data for consumption, share dashboards and configure subscriptions and updates.
Show business patterns, trends and correlations clearly; refine filters and presentation and troubleshoot dashboard or report issues.

Official Snowflake objectives

Question formats you can practice

Multiple Choice: Select one answer.
Multiple Response: Select multiple applicable answers.

These are Pass-IT practice formats. Check the Snowflake certification page for the official exam information.

How we review questions

Source check: The answer, answer options and explanation are checked against official documentation. We call this canonical validation.

Adversarial review: An additional AI reviewer specifically looks for factual errors, ambiguous answers and weaknesses in the explanation.

Learning objectives: We count specific exam topics with clearly linked exercises. Subheadings are not counted separately.

The figures refer to available questions in each SF-DA exam domain. The additional review count includes matching review logs for the current question version, even if errors were found. It is not an error-free rate.

The date shows the latest matching evidence or log entry in each domain. An import or transfer of an existing review result can update this entry. This does not mean the entire question pool has been reviewed again.

Review methods and criteria in detail

Frequently asked questions

Your preparation

How much study time should I plan for SF-DA?

For planning, Pass-IT estimates roughly 50–120 hours. Relevant experience may put you toward the lower end; starting from scratch may put you toward the higher end. Your needs may fall outside this range. This is not a time requirement from Snowflake or a promise that you will be exam-ready within that time.

What do you need before the Advanced Data Analyst exam?

SnowPro Core certification is required, and Snowflake expects a year or more of Snowflake analytics work including hands-on use of the Data Cloud. The catalog budget is around 80 hours. The one-year expectation is lower than the two years the other advanced exams assume.

Using Pass-IT

What language are Pass-IT questions in?

Questions in the app are currently in English. Translations of the sample questions on this page apply only to this preview. Check with Snowflake for the languages available for the official exam.

How long does my SF-DA access last?

Access covers this certification for 12 months. You pay once, with no automatic renewal.

When does the money-back guarantee apply?

The guarantee refunds the Pass-IT purchase price for this certification. You need eligible paid access and a Readiness Score of at least 80% from your practice results when you take the exam. This score can only reach 80% after at least 50 answered questions and is not a validated probability of passing. Take the exam during your access period and submit official proof of failing within 14 days. Guarantee terms

About the SF-DA exam

Where can I take the SF-DA exam?

Online proctored or onsite testing centers.

How long is the SnowPro Advanced: Data Analyst (DAA-C01) exam?

The SnowPro Advanced: Data Analyst (DAA-C01) exam has 65 questions and a 115-minute time limit.

Advanced Data Analyst or Advanced Data Engineer?

The analyst exam is weighted towards analysis and presentation, which together are 60% of it. The engineer exam puts 28% on data movement and 25% on transformation, which is the pipeline side. If your output is an answer, take the analyst exam; if it is a table other people use, take the engineer one.

How long is the Advanced Data Analyst certification valid?

Your certification expires two years after it is awarded. To renew through continuing education, complete one eligible Snowflake instructor-led training course or earn an equivalent or higher-level SnowPro certification before your certification expires. You can also retake the full exam in the six months before its expiry date.

Your preparation for SF-DA

$29.99one-time

12 months of access for SF-DA · No automatic renewal

Buy SF-DA access

Questions in the app are currently in English.

Try 20 questions for freeFree account required. No credit card.

Already have an account? Log in

Prefer a subscription? View subscriptions →

Money back if you fail with at least 80% Readiness, for eligible purchases under the guarantee terms.

Guarantee terms

Full guarantee terms →