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

Questions 16–20

1. 16application · medium

   A data team is implementing the Medallion Architecture in Databricks SQL. They want to ensure that the naming conventions for tables clearly indicate the layer and the content. They also want to make it easy for analysts to find the right tables for their reports. Which naming convention is most aligned with these goals?

   • AUse a two-part naming convention: schema.table, where the table name indicates the layer (e.g., `customer_raw_bronze`)
   • BUse a three-part naming convention: catalog.schema.table, where the schema name indicates the layer (e.g., `analytics.bronze.customer_raw`)
   • CUse a single-part naming convention: table, where the table name is descriptive (e.g., `customer_raw`)
   • DUse a naming convention that does not include the layer, to keep it simple
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   In the Medallion Architecture, the gold layer is most similar to which component in traditional data warehousing?

   • AOperational data store
   • BStaging area
   • CData mart
   • DSource system
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   In the Medallion Architecture, which layer is most aligned with the concept of conformed dimensions and fact tables in dimensional modeling?

   • ABronze layer
   • BRaw layer
   • CSilver layer
   • DGold layer
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   Which statement best describes the bronze layer's relationship to source systems in the Medallion Architecture?

   • AIt contains only aggregated data from source systems.
   • BIt mirrors the source system data with minimal or no transformation.
   • CIt stores data in a fully normalized schema derived from source systems.
   • DIt stores only data that has passed quality checks.
   Reveal Solution Discussion Select an answer first
6. 20expert · medium

   A data platform team is implementing the Medallion Architecture in Databricks SQL. They have a requirement to maintain a full audit trail of all changes to customer data for regulatory compliance. They are considering using a Data Vault 2.0 model. Which layer should they use to store the raw, unprocessed customer data that will serve as the audit trail?

   • ABronze layer, because it preserves the original data exactly as received
   • BGold layer, because it contains curated data for reporting
   • CA separate audit layer, because the Medallion Architecture does not support audit trails
   • DSilver layer, because it contains cleaned and conformed data
   Reveal Solution Discussion Select an answer first