Home » Microsoft » 70-465 » What should you recommend?
You need to recommend a solution that resolves the missing data issue. The solution must minimize the amount of development effort.
What should you recommend?
A. Denormalize the Products table.
B. Denormalize the OrderDetails table.
C. Normalize the OrderDetails table.
D. Normalize the Products table.
Correct Answer: D
Explanation/Reference:
Explanation:
* Scenario
/ Missing Data Issues
Customers report that when they make a price change in the Products table, they cannot retrieve the price that the item was sold for in previous orders.
/ The current database schema contains a table named OrderDetails. The OrderDetails table contains information about the items sold for each purchase order. OrderDetails stores the product ID, quantities, and discounts applied to each product in a purchase order. The product price is stored in a table named Products.
Reference: http://technet.microsoft.com/en-us/library/aa933055(v=sql.80).aspx