70-465 Exam Dumps | You are designing a Windows Azure SQL Database for an order fulfillment system. You create a table named

<< Prev Question Next Question >>

Question 34/66

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 FulfilledDate, ShippedDate, and ReceivedDate.
Update the value of each column from null to the appropriate date as the order status changes.

B. Implement change data capture on the Sales.Orders table.

C. 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.

D. To the Sales.Orders table, add three columns named Status, PreviousStatus and ChangeDate. Update rows as the order status changes.

Question 34/66

LEAVE A REPLY

Download PDF File