Home / Data Analyst practice test / Data Modeling with Databricks SQL / Question

Databricks Data Analyst Associate · free practice question

A data engineering team is implementing Medallion Architecture on Databricks. A business analyst asks which layer of the architecture is most appropriate to…

Exam-style question on Data Modeling with Databricks SQL from the free Data Analyst practice test, with the answer and a full explanation below.

Updated November 10, 2026

Data Modeling with Databricks SQL

A data engineering team is implementing Medallion Architecture on Databricks. A business analyst asks which layer of the architecture is most appropriate to apply star or snowflake dimensional modeling for direct use by BI tools and reporting dashboards. Which layer should the analyst be directed to?

  1. AThe Bronze layer, which keeps raw source data without transformation and so preserves the original OLTP schema that star and snowflake models are meant to mirror for BI tools
  2. BThe Silver layer, which holds cleansed and deduplicated records and is the earliest point where attributes are stable enough to be arranged into fact and dimension tables for BI
  3. CThe Bronze and Silver layers together, which apply dimensional modeling conventions from ingestion onward to keep BI consumers from encountering raw or partly processed data
  4. DNo specific layer, as the Medallion Architecture is a compute orchestration pattern that schedules pipeline dependencies and leaves data modeling conventions to each BI tool
  5. EThe Gold layer, which holds curated, aggregated, business-ready data and is where star or snowflake schemas are built for consumption by BI tools and reporting dashboards
Answer & explanation

Correct answer: E

WHY E: In the Medallion Architecture, the Gold layer is where data is transformed into curated, aggregated, business-ready form. Dimensional modeling patterns are applied there: star schemas (fact plus denormalized dimension tables) or snowflake schemas (fact plus normalized dimension hierarchies) that support BI tools, dashboards, and reporting.

WHY NOT A: The Bronze layer stores raw, unprocessed data exactly as received from source systems, including schema imperfections, duplicates, and nulls. It does not apply dimensional modeling.

WHY NOT B: The Silver layer applies cleansing, deduplication, and schema enforcement, but it produces cleansed operational entities, not business-aggregated dimensional models optimized for BI.

WHY NOT C: The Medallion Architecture reserves each layer for a specific transformation purpose; Bronze and Silver are not designed for dimensional modeling, which belongs in Gold.

WHY NOT D: The Medallion Architecture does define progressive transformation conventions for each layer, including Gold as the home of consumption-ready dimensional models; it is not purely a scheduling or orchestration abstraction.

Take the full Data Analyst practice test free →

Would you pass today?

This question is one of 45 in the free, timed Databricks Data Analyst Associate practice test. Take it and get a section-by-section score.

Start the free test →