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.

Explanation:

This stores only the minimal information required.

Incorrect Answers:

B: We do not need to keep the complete history.