READ Free Dumps For Microsoft- 70-461
Question ID 15136 | You create a table that has the StudentCode, SubjectCode, and Marks columns to record |
Option A | SELECT StudentCode AS Code,Marks AS Value FROM ( SELECT StudentCode, Marks AS Marks, RANXO OVER (PARTITION BY StudentCode ORDER BY Marks DESC) AS Rank FROM StudentMarks) tmp WHERE Rank = 1 |
Option B | SELECT StudentCode AS Code,Marks AS Value FROM ( SELECT StudentCode, Marks AS Marks, RANK () OVER (PARTITION BY StudentCode ORDER BY Marks ASC) AS Rank FROM StudentMarks) tmp WHERE Rank = 1 |
Option C | SELECT StudentCode AS Code,Marks AS Value FROM ( SELECT StudentCode, Marks AS Marks, RANK() OVER (PARTITION BY SubjectCode ORDER BY Marks DESC) AS Rank FROM StudentMarks) tmp WHERE Rank = 1 |
Option D | SELECT StudentCode as Code, NTILE (2) OVER (ORDER BY AVG (Marks) DESC) AS Value FROM StudentMarks GROUP BY StudentCode |
Option E | SELECT StudentCode as Code, RANK() OVER (ORDER BY AVG (Marks) DESC) AS Value FROM StudentMarks GROUP BY StudentCode |
Option F | SELECT Id, Name, Marks, DENSE_RANK() OVER (ORDER BY Marks DESC) AS Rank FROM StudentMarks |
Correct Answer | D |
Question ID 15137 | You use Microsoft SQL Server 2012 to develop a database application. |
Option A | Reference a user-defined function within the computed column. |
Option B | Create a BEFORE trigger that maintains the state of the computed column. |
Option C | Add a default constraint to the computed column that implements hard-coded values. |
Option D | Add a default constraint to the computed column that implements hard-coded CASE statements. |
Correct Answer | A |