READ Free Dumps For Microsoft- 70-461
| Question ID 15161 | You have a database named Sales that contains the tables as shown in the exhibit. (Click
the Exhibit button.)
You need to create a query that meets the following requirements:
✑ References columns by using one-part names only.
✑ Groups aggregates only by SalesTerritoryID, and then by ProductID.
✑ Orders the results in descending order by SalesTerritoryID and then by ProductID
in descending order for both.
Part of the correct T-SQL statement has been provided in the answer area. Provide the
complete code.
|
| 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
| Question ID 15162 | You need to create a query to execute a stored procedure for each row in a record set.
How should you complete the query? To answer, drag the appropriate values to the correct
locations. Each value may be use once, more than once or not at all.
|
| Option A | 
|
| Correct Answer | A |
Explanation