Exams Organizations How it works Pricing Help & FAQ

Sign in Start free

DATABRICKS

Databricks Certified Data Analyst Associate

DATA-ANALYST-ASSOCIATE

The Databricks Certified Data Analyst Associate certification validates your ability to use the Databricks Data Intelligence Platform to perform introductory data analysis tasks. It is designed for data analysts who query, visualize, and manage data using Databricks SQL, Unity Catalog, and AI/BI Genie. Earning it demonstrates that you can turn raw data into trusted insights and share them through dashboards and visualizations.

Practice Free Questions

9Domains

39Objectives

180Practice pages

817Free questions

DATA-ANALYST-ASSOCIATE free practice questions

Choose any objective and open any question page — no sign-in required.

Use Unity Catalog to discover, query, and manage certified datasets.

24 questions · 5 pages

Questions 1–5 6–10 11–15 16–20 21–24

Use the Catalog Explorer to tag a data asset and view its lineage.

12 questions · 3 pages

Questions 1–5 6–10 11–12

Perform data cleaning on Unity Catalog Tables in SQL, including removing invalid data or handling missing values.

7 questions · 2 pages

Questions 1–5 6–7

Use the Databricks Workspace UI to upload a data file to the platform.

8 questions · 2 pages

Questions 1–5 6–8

Utilize Databricks Assistant within a Notebook or SQL Editor to facilitate query writing and debugging.

15 questions · 3 pages

Questions 1–5 6–10 11–15

Explain the role a SQL Warehouse plays in query execution.

23 questions · 5 pages

Questions 1–5 6–10 11–15 16–20 21–23

Querying cross-system analytics by joining data from a Delta table and a federated data source.

22 questions · 5 pages

Questions 1–5 6–10 11–15 16–20 21–22

Create a materialized view, including knowing when to use Streaming Tables and Materialized Views, and differentiate between dynamic and materialized views.

23 questions · 5 pages

Questions 1–5 6–10 11–15 16–20 21–23

Perform aggregate operations such as count, approximate count distinct, mean, and summary statistics.

16 questions · 4 pages

Questions 1–5 6–10 11–15 16–16

Write queries to combine tables using various join operations (inner, left, right, and so on) with single or multiple keys, as well as set operations like union and union all, including the differences between the joins (inner, left, right, and so on).

28 questions · 6 pages

Questions 1–5 6–10 11–15 16–20 21–25 26–28

Perform sorting and filtering operations on a table.

10 questions · 2 pages

Questions 1–5 6–10

Create managed tables and external tables, including creating tables by joining data from multiple sources (e.g., CSV, Parquet, Delta tables) to create unified datasets, including Unity Catalog.

18 questions · 4 pages

Questions 1–5 6–10 11–15 16–18

Use Delta Lake's time travel to access and query historical data versions.

22 questions · 5 pages

Questions 1–5 6–10 11–15 16–20 21–22

Understand the Features, Benefits, and Supported Workloads of Photon.

21 questions · 5 pages

Questions 1–5 6–10 11–15 16–20 21–21

Identify poorly performing queries in the Databricks Intelligence platform, such as Query Insights, Query Profiler log, etc.

27 questions · 6 pages

Questions 1–5 6–10 11–15 16–20 21–25 26–27

Utilize Delta Lake to audit and view history, validate results, and compare historical results or trends.

21 questions · 5 pages

Questions 1–5 6–10 11–15 16–20 21–21

Utilize query history and caching to reduce development time and query latency

28 questions · 6 pages

Questions 1–5 6–10 11–15 16–20 21–25 26–28

Apply Liquid Clustering to improve query speed when filtering large tables on specific columns.

24 questions · 5 pages

Questions 1–5 6–10 11–15 16–20 21–24

Fix a query to achieve the desired results.

16 questions · 4 pages

Questions 1–5 6–10 11–15 16–16

Build dashboards using AI/BI Dashboards, including multi-tabs/page layouts, multiple data sources/datasets, and widgets (visualizations, text, images).

35 questions · 7 pages

Questions 1–5 6–10 11–15 16–20 21–25 26–30 31–35

Create visualizations in notebooks and the SQL editor.

15 questions · 3 pages

Questions 1–5 6–10 11–15

Work with parameters in SQL queries and dashboards, including defining, configuring, and testing parameters.

18 questions · 4 pages

Questions 1–5 6–10 11–15 16–18

Schedule an automatic dashboard refresh.

14 questions · 3 pages

Questions 1–5 6–10 11–14

Configure an alert with a desired threshold and destination.

15 questions · 3 pages

Questions 1–5 6–10 11–15

Identify the effective visualization type to communicate insights clearly.

29 questions · 6 pages

Questions 1–5 6–10 11–15 16–20 21–25 26–29

Describe the purpose, key features, and components of AI/BI Genie spaces.

22 questions · 5 pages

Questions 1–5 6–10 11–15 16–20 21–22

Create Genie spaces by defining reasonable sample questions and domain-specific instructions, choosing SQL warehouses, curating Unity Catalog datasets (tables, views...), and vetting queries as Trusted Assets.

16 questions · 4 pages

Questions 1–5 6–10 11–15 16–16

Assign permissions via the UI and distribute Genie spaces using embedded links and external app integrations.

22 questions · 5 pages

Questions 1–5 6–10 11–15 16–20 21–22

Optimize AI/BI Genie spaces by tracking user questions, response accuracy, and feedback; updating instructions and trusted assets based on stakeholder input; validating accuracy with benchmarks; refreshing Unity Catalog metadata.

29 questions · 6 pages

Questions 1–5 6–10 11–15 16–20 21–25 26–29

Apply industry-standard data modeling techniques, such as star, snowflake, and data vault schemas, to analytical workloads.

21 questions · 5 pages

Questions 1–5 6–10 11–15 16–20 21–21

Understand how industry-standard models align with the Medallion Architecture.

22 questions · 5 pages

Questions 1–5 6–10 11–15 16–20 21–22

Understand how the 3-level namespace(Catalog / Schema / Tables or Volumes) works in the Unity Catalog.

28 questions · 6 pages

Questions 1–5 6–10 11–15 16–20 21–25 26–28

Apply best practices for storage and management to ensure data security, including table ownership and PII protection.

23 questions · 5 pages

Questions 1–5 6–10 11–15 16–20 21–23

Want a smarter study session?Try adaptive questions aimed at your weak spots, the illustrated book, and readiness you can trust.

Continue Free Practice

Percentages reflect share of the current practice bank, not official exam weightings. Every page above is a live, crawlable practice page (39 objectives · 180 pages).