ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-764 All Questions

View all questions & answers for the 70-764 exam
Go to Exam

Exam 70-764 topic 1 question 153 discussion

Actual exam question from Microsoft's 70-764
Question #: 153
Topic #: 1
[All 70-764 Questions]

You are designing a SQL Server database for an order fulfillment system. You create a table named Sales.Orders by using 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 you can retrieve the status of an order on a given date.
The solution must ensure that new statuses can be added in the future.
What should you do? More than one answer choice may achieve the goal. Select the BEST answer.

  • A. To the Sales.Orders table, add a column named Status that will store the order status. Update the Status column 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 Hide Answer
Suggested Answer: A 🗳️
by vabjosh at May 4, 2019, 12:41 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Varad
Highly Voted 5 years, 1 month ago
Answer A is correct. Question is "Ensure that you can retrieve the status of an order ON A GIVEN DATE". So Answer "A" is correct. You can find the status of an order on any given date.
upvoted 5 times
cmps
4 years, 10 months ago
Exactly "ON A GIVEN DATE", that means "A" is incorrect, because it doesn't store a history of statuses of orders (its updating those statuses), so "B" is correct.
upvoted 3 times
...
...
huzein
Most Recent 4 years, 1 month ago
I vote for B. For me it doesnt make sense to retreive the status by a given date. When i want the actual status of an order, i retreive it giving the orderId. The date plays for me only a role when i in fact want to retreive historical statuses. But the task is very unclear formulated. A disaster when in the exam will be such questions...
upvoted 1 times
...
tapsAch
4 years, 2 months ago
the correct answer is A as the question mentioned that it wants to see order status at GIVEN date. It does not matter about previous statuses
upvoted 1 times
...
Makar
4 years, 5 months ago
It is B, 100 percent
upvoted 1 times
...
TheSwedishGuy
4 years, 10 months ago
Yeah, B is correct, it will allow you to see the different statuses set on different dates.
upvoted 3 times
...
Spicy2312
5 years, 4 months ago
Yep, the answer is B, can you admins update this?
upvoted 1 times
...
cian
5 years, 6 months ago
I agree, A will not allow user to retrieve order by date. Answer is B
upvoted 1 times
...
vabjosh
5 years, 7 months ago
it must be B
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago