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

Questions 6–10

1. 6application · medium

   A financial services company is implementing a new data platform using the Medallion Architecture. The data engineering team ingests raw transaction logs from multiple source systems into the bronze layer. A data analyst needs to build a customer dimension table that conforms to a Kimball-style dimensional model. Which layer should the analyst use as the primary source for building this dimension table?

   • AGold layer, because it contains business-level aggregates
   • BAny layer, because the Medallion Architecture does not prescribe a source for dimensional modeling
   • CSilver layer, because it contains cleaned, conformed, and integrated data
   • DBronze layer, because it contains the most granular raw data
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   What is a key consideration when designing transformation logic between the silver and gold layers in Databricks SQL?

   • AGold tables should be overwritten completely on every refresh to ensure accuracy.
   • BGold layer transformations should be simple and focused on business logic, not complex data cleaning.
   • CAll transformations must be written as stored procedures in Databricks SQL.
   • DTransformations should be applied directly to raw bronze tables to avoid duplication.
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A logistics company is building a data lakehouse with the Medallion Architecture. They ingest IoT sensor data from their fleet vehicles. The data arrives in JSON format and may contain duplicate readings and malformed records. According to the Medallion Architecture, what is the primary purpose of the bronze layer for this data?

   • ATo store the data in a query-optimized format like Parquet
   • BTo store the raw JSON data exactly as it was received, without any transformations
   • CTo create aggregated summaries of the sensor data for reporting
   • DTo clean the data and remove duplicates before storing it
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   Which industry-standard data modeling methodology emphasizes a normalized enterprise data warehouse as the foundation for downstream marts?

   • AInmon
   • BData Vault
   • CStar schema
   • DKimball
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   When implementing the Medallion Architecture in Databricks SQL, which naming convention is commonly used to distinguish layers?

   • AUsing table names that include the layer as a suffix, like 'sales_bronze'
   • BUsing separate databases or schemas named bronze, silver, and gold
   • CUsing prefixes like 'raw_', 'clean_', and 'aggregate_'
   • DUsing file extensions like .raw, .clean, and .agg
   Reveal Solution Discussion Select an answer first