Which statement best defines a semantic model in a data warehouse context?

• A. A semantic model is a physical data model that describes the structure of the data stored in the data warehouse.
• B. A semantic model is a business-oriented data model that provides a consistent and reusable representation of data across the organization.
• C. A semantic model is a data governance artifact that defines data lineage and policies.
• D. A semantic model is a machine learning model that is used to make predictions based on data in the data warehouse.

Answer: (D)

A semantic model in a data warehouse context is a business-oriented data model that provides a consistent and reusable representation of data across the organization. It translates technical data into business concepts—like customers, orders, and revenue—and defines the metrics, hierarchies, and relationships in meaningful, business-friendly terms. This abstraction lets analysts and BI tools work with a common vocabulary, enabling reliable reporting and self-service analytics even if the underlying storage or physical schemas change. It focuses on meaning and usability rather than how data is physically stored, which helps maintain consistent interpretation and governance across departments.

The other options describe different things: a physical data model focuses on how data is stored and organized on disk, not on business meaning; a data governance artifact about data lineage and policies is about governance details rather than the business-facing semantic layer; and a machine learning model is about making predictions, not about presenting data in a consistent business context.