Certified Data Analyst AssociateDemo

By Databricks · Question Mode

QuestionQ37

Data Modeling with Databricks SQL

How are analytical models mapped to the Gold layer within the Delta Lake medallion architecture on Databricks?

  • A The Gold layer is primarily used for storing backup copies of all data for disaster recovery purposes.
  • B The Gold layer stores raw, unprocessed data for initial ingestion and schema evolution.
  • C The Gold layer is used for data cleaning, deduplication, and joining across domains to establish data integrity.
  • D The Gold layer contains de-normalized data models optimized for analytics, reporting, and machine learning.
Explanation

The Gold layer contains refined, business-ready dimensional or denormalized models and aggregates optimized for analytics, reporting, dashboards, and machine-learning use cases. Data ingestion belongs in Bronze, while cleaning, validation, deduplication, and integration commonly occur in Silver.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!