Understand How Industry-Standard Models Align with the Medallion Architecture. DATA-ANALYST-ASSOCIATE Practice Questions (Page 3)

Questions 11–15

1. 11application · medium

   A data analyst is working on a project to build a sales fact table. They have access to the bronze, silver, and gold layers. The silver layer contains a conformed `dim_customer` table and a `dim_product` table. The gold layer contains a pre-aggregated `sales_summary` table. Which source should the analyst use to build the sales fact table at the most granular level?

   • AThe bronze layer, because it has the most detailed raw data
   • BAny layer, because the fact table can be built from any source
   • CThe gold layer, because it contains the sales summary
   • DThe silver layer, because it contains conformed dimensions and integrated data
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A data team is implementing the Medallion Architecture in Databricks SQL. They want to follow a consistent naming convention that clearly indicates the layer and the content of each table. Which naming convention is most aligned with the Medallion Architecture best practices?

   • Araw_customer, clean_customer, agg_customer
   • Btbl_customer_1, tbl_customer_2, tbl_customer_3
   • Cbronze_customer_raw, silver_customer_clean, gold_customer_agg
   • Dcustomer_raw, customer_clean, customer_agg
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A healthcare organization is implementing a data platform using the Medallion Architecture. They are following a Kimball-style dimensional model. The data engineering team has loaded raw patient records into the bronze layer. They now need to create a conformed patient dimension that will be used across multiple fact tables. In which layer should this conformed dimension be created?

   • AGold layer, because it is the final layer and all final tables go there
   • BBronze layer, because it is the first place the data is stored
   • CA separate dimension layer, because dimensions do not fit into the Medallion Architecture
   • DSilver layer, because it is where data is cleaned, conformed, and integrated
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   In the Medallion Architecture, which layer typically stores raw, unprocessed data as it is ingested from source systems?

   • ABronze layer
   • BPresentation layer
   • CGold layer
   • DSilver layer
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A marketing analytics team needs to create a dashboard that shows monthly revenue by product category and region. They have already built conformed fact and dimension tables in the silver layer. According to the Medallion Architecture, where should they create the pre-aggregated tables that will directly feed this dashboard?

   • ABronze layer, to keep the dashboard queries close to the raw data
   • BGold layer, because it is designed for business-level aggregates and curated datasets
   • CA separate external database, because Databricks SQL cannot store aggregates
   • DSilver layer, alongside the fact and dimension tables
   Reveal Solution Discussion Select an answer first