Exam 70-765 topic 3 question 122 discussion

Actual exam question from Microsoft's 70-765

Question #: 122
Topic #: 3

You are designing a Windows Azure SQL Database for an order fulfillment system. You create a table named Sales.Orders with the following script.

Each order is tracked by using one of the following statuses:
✑ Fulfilled
✑ Shipped
✑ Ordered

Received -

You need to design the database to ensure that that you can retrieve the following information:
✑ The current status of an order
✑ The previous status of an order.
✑ The date when the status changed.
✑ The solution must minimize storage.
More than one answer choice may achieve the goal. Select the BEST answer.

A. To the Sales.Orders table, add three columns named Status, PreviousStatus and ChangeDate. Update rows as the order status changes.
B. Create a new table named Sales.OrderStatus that contains three columns named OrderID, StatusDate, and Status. Insert new rows into the table as the order status changes.
C. Implement change data capture on the Sales.Orders table.
D. To the Sales.Orders table, add three columns named FulfilledDate, ShippedDate, and ReceivedDate. Update the value of each column from null to the

Show Suggested Answer

Suggested Answer: A 🗳️
Expalantion:
This stores only the minimal information required.
Incorrect Answers:
B: We do not need to keep the complete history.

by cmps at May 19, 2020, 9:43 a.m.

Comments

Submit Cancel

cmps

Highly Voted 5 years ago

Correct is B. We need to keep history, because we need to know when status has changed and also previous status of an order.

upvoted 5 times

cmps

5 years ago

I was wrong, option A is enough and doesnt take too much space. So it's A.

upvoted 6 times

...