Which method should the data architect use?

Refer to the exhibit.

The data model shown has a synthetic key for information that contains actual sales and budget sales for a multi-national company. As a business requirement, users must be able to drill down by department and country. Data must not be lost. Due to data quality issues, some departments are NOT included in the Sales and Budget tables. The data architect needs a method to eliminate synthetic keys that generates the fastest performing data model.

Which method should the data architect use?
A . A link table to associate the two tables.
B . A forced concatenation statement.
C . Field aliases or comment out redundant fields.
D . A Left Join statement in the script.

View Answer

Answer: B