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

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. It tests proficiency in turning raw data into actionable business insights using Snowflake's analytical capabilities and connected visualization tools.

This certification is for data analysts, business intelligence developers, and reporting specialists with one or more years of Snowflake analytics experience. It demonstrates the ability to design analytical workflows, build data models for reporting, and present findings from Snowflake data.

Data Analysis carries the most weight at 32%, testing SQL extensibility (UDFs, stored procedures, views), descriptive and diagnostic analysis, and forecasting. Data Presentation and Visualization follows close behind at 28%, covering Snowsight dashboard design, chart selection, and BI tool connectivity. Together these two domains make up 60% of the exam, more than data preparation and modeling combined.

Data Transformation and Modeling (23%) and Data Ingestion and Preparation (17%) round out the blueprint, covering data cleaning, star and Data Vault modeling, and loading structured, semi-structured, and unstructured data. The distribution favors analysts who can turn a query into a decision over analysts who only know how to load and clean data, so study time should lean toward SQL analytics and dashboard design.

The exam consists of 65 questions in 115 minutes, drawn from multiple-choice, multiple-select, and interactive formats. Most items give you a data set or business use case and ask you to choose the query, transformation, or visualization approach that meets it. At roughly 1.8 minutes per question, the pace is comfortable if your SQL is fluent going in.

Every domain of the SF-DA exam has enough questions in the pool to practice it in depth. A mock exam asks 65 questions in one sitting, on the same 115-minute clock as the real thing.

How long you'll need depends on how much hands-on experience you bring. The rest is set by the vendor: how the exam is delivered, how soon you can retake it, and how long the credential stays valid.

Delivered by online proctoring or at an onsite testing center, in English. The certification expires two years after your issue date; you recertify through the Snowflake Continuing Education program with an eligible instructor-led training course or an equivalent or higher-level SnowPro certification.

Analysts who stop at basic SELECT statements struggle once the exam turns to window functions (ROW_NUMBER, RANK, LAG, LEAD) and to QUALIFY, the Snowflake-specific clause that filters on window-function results the way HAVING filters on GROUP BY. The same practice gap shows up in PIVOT and UNPIVOT syntax and in questions about materialized views, which auto-refresh under Enterprise Edition and behave differently from a regular view. BI tool integration questions, covering how Tableau, Power BI, or Looker connect through OAuth, ODBC, or JDBC, reward candidates who have wired up a live connection rather than just read about one.