Exam 70-461 topic 1 question 85 discussion

Actual exam question from Microsoft's 70-461

Question #: 85
Topic #: 1

Your database contains a table named SalesOrders. The table includes a DATETIME column named OrderTime that stores the date and time each order is placed. There is a non-clustered index on the OrderTime column.
The business team wants a report that displays the total number of orders placed on the current day.
You need to write a query that will return the correct results in the most efficient manner.
Which Transact-SQL query should you use?

A. SELECT COUNT(*) FROM SalesOrders WHERE OrderTime = CONVERT(DATE, GETDATE())
B. SELECT COUNT(*) FROM SalesOrders WHERE OrderTime = GETDATE()
C. SELECT COUNT(*) FROM SalesOrders WHERE CONVERT(VARCHAR, OrderTime, 112) = CONVERT(VARCHAR, GETDATE(), 112))
D. SELECT COUNT(*) FROM SalesOrders WHERE OrderTime >= CONVERT(DATE, GETDATE()) AND OrderTime < DATEADD(DAY, 1, CONVERT(DATE, GETDATE()))

Show Suggested Answer

Suggested Answer: D 🗳️

by Sugar at April 28, 2020, 2:37 p.m.

Comments

Submit Cancel

TomPill

4 years, 11 months ago

How can answer A also give the desired result when OrderTime contains the date and time an order was placed and the call to CONVERT(DATE, GETDATE()) effectively removes the time portion of the GETDATE() DATETIME value?

upvoted 1 times

...

Sugar

5 years, 1 month ago

Answer A will also give the desired result

upvoted 1 times

...