READ Free Dumps For Microsoft- 70-461
| Question ID 15159 | You need to create a query that calculates the total sales of each OrderID from a table
named Sales.Details. The table contains two columns named OrderID and
ExtendedAmount.
The solution must meet the following requirements:
✑ Use one-part names to reference columns.
✑ Start the order of the results from OrderID.
✑ NOT depend on the default schema of a user.
✑ Use an alias of TotalSales for the calculated ExtendedAmount.
✑ Display only the OrderID column and the calculated TotalSales column.
Provide the correct code in the answer area.
|
| Option A | Answer : Please review the explanation part for this answer
|
| Correct Answer | A |
Explanation Explanation: SELECT OrderID, SUM(ExtendedAmount) AS TotalSales FROM Sales.Details GROUP BY OrderID ORDER BY OrderID
| Question ID 15160 | You have an XML schema collection named Sales.InvoiceSchema.
You need to declare a variable of the XML type named invoice. The solution must ensure
that the invoice is validated by using Sales.InvoiceSchema.
The solution must ensure that the invoice variable is validated by using
Sales.InvoiceSchema schema.
Provide the correct code in the answer area.
|
| Option A | Answer : DECLARE @invoice XML(Sales.InvoiceSchema)
|
| Correct Answer | A |
Explanation