Question
You have the source data model shown in the following exhibit.
The primary keys of the tables are indicated by a key symbol beside the columns involved in each key.
You need to create a dimensional data model that will enable the analysis of order items by date, product, and customer.
What should you include in the solution? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
The Product table's primary key is composite (CompanyID and ProductID), so ProductID by itself is not unique and cannot serve as the one side of the relationship. A Power BI model relationship relates a single column to a single column, so you cannot base it on both columns directly; instead you create one key that combines CompanyID and ProductID (a surrogate key) in both the Product dimension and the OrderItem fact table and relate on it. The Company entity contains only CompanyID, which is already carried in the Product and Customer keys, and the analysis is required only by date, product, and customer, so Company adds no attributes worth denormalizing and can be omitted from the dimensional model.
