READ Free Dumps For Microsoft- 70-461
| Question ID 15064 | You have a database named Sales that contains the tables shown in the exhibit. (Click the
Exhibit button).
You need to create a query for a report. The query must meet the following requirements:
✑ NOT use object delimiters.
✑ Use the first initial of the table as an alias.
✑ Return the most recent order date for each customer.
✑ Retrieve the last name of the person who placed the order.
The solution must support the ANSI SQL-99 standard.
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 C.LastName, MAX(O.OrderDate) AS MostRecentOrderDate FROM Customers AS C INNER JOIN Orders AS O ON C.CustomerID=O.CustomerID GROUP BY C.Lastname ORDER BY MAX (O.OrderDate) DESC
| Question ID 15065 | You use Microsoft SQL Server 2012 to develop a database application.
You need to create an object that meets the following requirements:
✑ Takes an input parameter
✑ Returns a table of values
✑ Can be referenced within a view
Which object should you use?
|
| Option A | inline table-valued function
|
| Option B | user-defined data type
|
| Option C | stored procedure
|
| Option D | scalar-valued function
|
| Correct Answer | A |
Explanation