READ Free Dumps For Microsoft- 70-461
| Question ID 15072 | 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 returns a list of products from Sales.ProductCatalog. The
solution must meet the following requirements:
✑ Return rows ordered by descending values in the UnitPrice column.
✑ Use the Rank function to calculate the results based on the UnitPrice column.
✑ Return the ranking of rows in a column that uses the alias PriceRank.
✑ Use two-part names to reference tables.
✑ Display the columns in the order that they are defined in the table. The PriceRank
column must appear last.
Part of the correct T-SQL statement has been provided in the answer area. Provide the
complete code.
|
| Option A | Answer : Please check the explanation part for the solution answer as.
|
| Correct Answer | A |
Explanation Explanation: SELECT CatID, CatName, ProductID, ProdName, UnitPrice, RANK (ORDER BY UnitPrice DESC) OVER () AS PriceRank FROM Sales.ProductCatalog ORDER BY PriceRank
| Question ID 15073 | You are developing a database application by using Microsoft SQL Server 2012.
An application that uses a database begins to run slowly.
Your investigation shows the root cause is a query against a read-only table that has a
clustered index.
The query returns the following six columns:
✑ One column in its WHERE clause contained in a non-clustered index
✑ Four additional columns
✑ One COUNT (*) column based on a grouping of the four additional columns
You need to optimize the statement.
What should you do?
|
| Option A | Add a HASH hint to the query.
|
| Option B | Add a LOOP hint to the query.
|
| Option C | Add a FORCESEEK hint to the query.
|
| Option D | Add an INCLUDE clause to the index.
|
| Option E | Add a FORCESCAN hint to the Attach query.
|
| Option F | Add a columnstore index to cover the query.
|
| Correct Answer | F |
Explanation