Which step should the data architect take to correct the data model without affecting the app?

Refer to the exhibit.

A data architect is reviewing an app that is under development. The app as NOT been published. All data has been validated in all charts and KPIs. The data architect notices that the data model has two fact tables with common field names that cause a synthetic join.

Which step should the data architect take to correct the data model without affecting the app?
A . Concatenate LOAD the data from the Sales and Budget tables to combine into a single table.
B . Create a composite key in the Sales and Budget tables that consists of the Year, EmployeeID, and ProductID
C . Perform a composite key in the Sales and Budget tables instead of loading Year, EmployeeID, and ProductID
D . Perform a mapping load for the Employees table and use ApplyMap in the Sales and Budget tables.

View Answer

Answer: A