READ Free Dumps For Microsoft- 70-461
| Question ID 15110 | 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?
|
| Option A | SELECT COUNT(*) FROM SalesOrders WHERE OrderTime = CONVERT(DATE, GETDATE())
|
| Option B | SELECT COUNT(*) FROM SalesOrders WHERE OrderTime = GETDATE()
|
| Option C | SELECT COUNT(*) FROM SalesOrders WHERE CONVERT(VARCHAR, OrderTime, 112) = CONVERT(VARCHAR, GETDATE(), 112))
|
| Option D | SELECT COUNT(*) FROM SalesOrders WHERE OrderTime >= CONVERT(DATE, GETDATE()) AND OrderTime < DATEADD(DAY, 1, CONVERT(DATE, GETDATE()))
|
| Correct Answer | D |
Explanation
| Question ID 15111 | You have a database that contains the tables as shown in the exhibit. (Click the Exhibit
button.)
You have the following query:
You need to recreate the query to meet the following requirements:
✑ Reference columns by using one-part names only.
✑ Sort aggregates by SalesTerritoryID, and then by ProductID.
✑ Order the results in descending order from SalesTerritoryID to ProductID.
✑ The solution must use the existing SELECT clause and FROM clause.
Which code segment should you use?
To answer, type the correct code in the answer area.
|
| Option A | Answer : Please review the explanation part for this answer
|
| Correct Answer | A |
Explanation Explanation: SELECT SalesTerritoryID, ProductID, AVG(UnitPrice), MAX(OrderQty), MAX(DiscountAmount) FROM Sales.Details GROUP BY SalesTerritoryID , ProductID ORDER BY SalesTerritoryID DESC, ProductID DESC