Exam 70-764 topic 1 question 287 discussion

Actual exam question from Microsoft's 70-764

Question #: 287
Topic #: 1

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: B 🗳️

by voodoo_sh at April 7, 2020, 10:44 a.m.

Comments

Submit Cancel

Neru

4 years, 11 months ago

I agree with voodoo_sh , by creating the new table you storing history that is not actually required, as only the current and previous status is needed. I think the answer should be A in this case keeping in line with "minimizing storage"

upvoted 1 times

chad_pace

4 years, 9 months ago

The Correct Answer is B. Create a new table with 3 columns. A is not correct, you would be adding 3 more columns to an existing table for a total of 6 columns. In order to capture the history of the OrderStatus changes, you would have to generate a new row each time the order was updated therefore duplicating OrderID, OrderDate, and CustomerID for no reason.

upvoted 2 times

KC

4 years, 9 months ago

A specifically says that there would be UPDATEs on the data, so there wouldn't be new row inserts. B would insert new rows, then save them. I think the answer is A for minimizing space.

upvoted 1 times

chad_pace

4 years, 9 months ago

But it also says you need to know the current status and previous status and when the status was changed. If you update an existing row you overwrite the history of the status changes.

upvoted 1 times

huzein

4 years, 6 months ago

No. When you have currently status s1, previous status null and changeDate null then with the change of the status you perform an update, so that you will have currently status s2, previous status s1 and changeDate d1. So you got all what you need. Answer A is correct.

upvoted 1 times

...

voodoo_sh

5 years, 2 months ago

"The solution must minimize storage." - this requirement made me think that correct answer is A

upvoted 2 times

...