Free Databricks Certified Data Analyst Associate Practice Questions

Sample Practice Questions

Try these 10 sample questions from the Databricks Certified Data Analyst Associate practice bank. Each includes the answer and explanation. Continue with the interactive practice above to review the full question set.

1. 1What is the central purpose of the data lakehouse architecture on Databricks?

   1. A. Maintain a separate authoritative dataset for each analytics team.
   2. B. Use a common data source across analytics disciplines.
   3. C. Keep BI in a warehouse and machine learning in a separate data lake.
   4. D. Consolidate structured BI data while excluding non-tabular workloads.

   Answer: B

   Explanation: The documentation says teams can use the lakehouse "as their single source of truth". This supports a shared foundation for engineers, scientists, analysts, and production systems.

   Reference: What is Databricks? — Common use cases > Build an enterprise data lakehouse

2. 2What does a certified status on a Unity Catalog data asset communicate?

   1. A. The asset's quality is guaranteed for every possible use.
   2. B. The asset can be queried without data-access permissions.
   3. C. The asset meets the organization's internal trust standards.
   4. D. The asset's quality is revalidated automatically on every query.

   Answer: C

   Explanation: Certified means the asset "has met internal standards for accuracy, completeness, and trust." This is an organizational endorsement, rather than an access grant or a guarantee of suitability and automatic revalidation for every use.

   Reference: Flag data as certified or deprecated — Certification status system tag > certified

3. 3Which Databricks ingestion feature provides the cloudFiles Structured Streaming source to process newly arriving files in an S3 directory?

   1. A. COPY INTO
   2. B. Delta Sharing
   3. C. Lakehouse Federation
   4. D. Auto Loader

   Answer: D

   Explanation: Auto Loader "provides a Structured Streaming source called cloudFiles." It incrementally processes files arriving in cloud object storage, including Amazon S3.

   Reference: What is Auto Loader? — How does Auto Loader work?

4. 4Which notebook coding-assistant command proposes a correction for a SQL error in a diff view?

   1. A. /prettify
   2. B. /doc
   3. C. /fix
   4. D. /findTables

   Answer: C

   Explanation: The command table describes /fix as "Proposes a fix to any code errors in a diff view". The other commands format, document, or discover rather than propose the error correction.

   Reference: Get coding help from Genie Code — Use slash commands for prompts > /fix

5. 5Which execution mechanism is central to Photon query acceleration?

   1. A. Interpreting SQL expressions one row at a time in the JVM.
   2. B. Processing data in columnar batches with a native engine.
   3. C. Processing individual rows in a native row-at-a-time engine.
   4. D. Running Python row functions instead of native SQL operators.

   Answer: B

   Explanation: Photon operates by "processing data in columnar batches rather than row by row." Its native execution engine accelerates supported SQL operations while Catalyst continues to plan queries.

   Reference: What is Photon? — How Photon works

6. 6Where does an AI/BI dashboard editor arrange visualizations, explanatory text, and images into a multi-page report?

   1. A. The Data tab's SQL editor.
   2. B. The Canvas tab.
   3. C. The dashboard's Share dialog.
   4. D. The dashboard's schedule dialog.

   Answer: B

   Explanation: The dashboard guide says, "The Canvas tab can be organized into multi-page reports." It supports visualization, filter, text, and image widgets; the Data tab defines datasets.

   Reference: Author dashboards — Create a new dashboard > Canvas

7. 7What is the central purpose of a Genie space, now called a Genie Agent, for business users?

   1. A. Schedule SQL and notebook tasks as dependency-based workflows.
   2. B. Develop machine learning models through a coding interface.
   3. C. Query organizational data through natural-language conversation.
   4. D. Edit SQL code with inline programming assistance.

   Answer: C

   Explanation: The guide describes Genie as "a conversational interface for querying your data using natural language." Business users can explore governed data without manually authoring every SQL statement.

   Reference: Use a Genie Agent to explore business data — Overview

8. 8A sales star schema must support analyzing transaction amounts and quantities by customer, product, and date. Which table design places the measures and context appropriately?

   1. A. Store transaction amounts and quantities as attributes of customer dimension rows.
   2. B. Store measures in a central fact table linked to descriptive dimensions.
   3. C. Keep dimensions separate but omit their keys from the transaction fact table.
   4. D. Store one overall sales total without customer, product, or date keys.

   Answer: B

   Explanation: The star-schema description places "a central fact table for measures such as sales amounts" alongside dimension tables that hold time, product, and customer context. This separates measured events from descriptive analysis axes.

   Reference: What is Star Schema? — Summary; Fact tables and dimension tables

9. 9Which catalog privilege supports discovering data objects and viewing basic metadata without granting access to underlying data or privilege administration?

   1. A. SELECT
   2. B. BROWSE
   3. C. MANAGE
   4. D. ALL PRIVILEGES

   Answer: B

   Explanation: BROWSE allows users to "discover and view metadata about objects without granting access to the underlying data." SELECT grants data-query access, while MANAGE and ALL PRIVILEGES exceed this limited discovery purpose.

   Reference: Unity Catalog privileges reference — Detailed Unity Catalog privileges reference > BROWSE

10. 10Which platform component schedules notebooks and SQL queries as automated workflows?

    1. A. Delta Lake
    2. B. Unity Catalog
    3. C. Databricks Marketplace
    4. D. Lakeflow Jobs

    Answer: D

    Explanation: The platform documentation states, "Jobs schedule Databricks notebooks, SQL queries, and other arbitrary code." Lakeflow Jobs supplies the scheduling and orchestration role.

    Reference: What is Databricks? — DevOps, CI/CD, and task orchestration