READ Free Dumps For Microsoft- 70-461
| Question ID 15140 | You have a view that was created by using the following code:
You need to create an inline table-valued function named Sales.fn_OrdersByTerritory that
returns sales information from a specified SalesTerritoryID. Sales.fn_OrdersByTerritory
must meet the following requirements:
✑ Use one-part names to reference columns.
✑ Return all the columns in the OrdersByTerritory View. The function should return
the same columns as they exist in the OrdersByTerritory view and in the same
order.
✑ Declare the input variable as @T.
✑ Use SalesTerritoryID as an integer.
Part of the correct T-SQL statement has been provided in the answer area. Provide the
complete code.
|
| Option A | Answer : Please refer to explanation part for the solution below.
|
| Correct Answer | A |
Explanation Explanation: CREATE FUNCTION Sales.fn_OrdersByTerritory (@T integer) RETURNS TABLE AS RETURN (SELECT OrderID, OrderDate, SalesTerritoryID, TotalDue FROM Sales.OrdersByTerritory WHERE SalesTerritoryID = @T)
| Question ID 15141 | You use Microsoft SQL Server 2012 database to develop a shopping cart application.
You need to rotate the unique values of the ProductName field of a table-valued expression
into multiple columns in the output.
Which Transact-SQL operator should you use?
|
| Option A | CROSS JOIN
|
| Option B | CROSS APPLY
|
| Option C | PIVOT
|
| Option D | UNPIVOT
|
| Correct Answer | C |
Explanation Explanation: http://technet.microsoft.com/en-us/library/ms177634.aspx