70-461 Question Answer

Question No : 1

Which of the following datatypes has a fixed precision and a scale of six digits?

A. Double
B. Money
C. Int
D. Numeric
E. SmallInt
F. VarInt
G. Float

Answer: B

Question : 2

You work as a database developer at ABC.com. ABC.com has a SQL Server 2012 database named SalesDB that has a table named Weekly Sales. The Weekly Sales table records the sales amount for each of ABC.com’s 20 sales representatives.You need to write a Transact-SQL query that ranks the sales representatives by the average sales amount for the past year. You want the sales representatives with the same average sales amount to have the same rank with the subsequent rank being skipped. Which ranking function should you use?

A. The RANK( ) OVER function.
B. The NTILE( ) OVER function
C. The DENSE_RANK( ) OVER function
D. The ROW_NUMBER( ) OVER function
E. The FORMAT function.

Answer: C