READ Free Dumps For Microsoft- 70-461
| Question ID 15124 | You are developing a database application by using Microsoft SQL Server 2012.
An application that uses a database begins to run slowly.
You discover that the root cause is a query against a frequently updated table that has a
clustered index. The query returns four columns: three columns in its WHERE clause
contained in a non-clustered index and one additional column.
You need to optimize the statement.
What should you do?
|
| Option A | Include a SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement before you run the query.
|
| Option B | Include a SET TRANSACTION ISOLATION LEVEL SNAPSHOT statement before you run the query.
|
| Option C | Add a FORCESEEK hint to the query.
|
| Option D | Include a SET STATISTICS SHOWPLAN_XML ON statement before you run the query.
|
| Option E | Include a SET TRANSACTION ISOLATION LEVEL REPEATABLE READ statement before you run the query.
|
| Option F | Include a SET STATISTICS PROFILE ON statement before you run the query.
|
| Correct Answer | C |
Explanation
| Question ID 15125 | You have a database 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.
✑ Return the most recent orders first.
✑ 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.
✑ Return the order date in a column named MostRecentOrderDate that appears as
the last column in the report.
The solution must support the ANSI SQL-99 standard.
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 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 MostRecentOrderDate DESC