READ Free Dumps For Microsoft- 70-461
| Question ID 15169 | You develop a database application for a university. You need to create a view that will be
indexed that meets the following requirements:
✑ Displays the details of only students from Canada.
✑ Allows insertion of details of only students from Canada.
Which four Transact-SQL statements should you use? (To answer, move the appropriate
SQL statements from the list of statements to the answer area and arrange them in the
correct order.)
|
| Option A | 
|
| Correct Answer | A |
Explanation
| Question ID 15170 | You have a database 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:
✑ UnitPrice must be returned in descending order.
✑ The query must use two-part names to reference the table.
✑ The query must use the RANK function to calculate the results.
✑ The query must return the ranking of rows in a column named PriceRank.
✑ The list must display the columns in the order that they are defined in the table.
✑ PriceRank must appear last.
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 ProductCatalog.CatID, ProductCatalog.CatName, ProductCatalog.ProductID, ProductCatalog.ProdName, ProductCatalog.UnitPrice, RANK() OVER (ORDER BY ProductCatalog.UnitPrice DESC) AS PriceRank FROM Sales.ProductCatalog ORDER BY ProductCatalog.UnitPrice DESC