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 appropriate date as the
order status changes.