Microsoft 70-461 Sample Question

Question No:3You work as a database developer at ABC.com. ABC.com has a SQL Server 2012 databasenamed SalesDB that has a table named WeeklySales. The WeeklySales table records the sales amount for each of ABC.com's 20 sales representitives.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...

Read More

Microsoft 70-461 Sample Question

Question No:2 CORRECT TEXT You are employed as a SQL Server 2012 database developer at ABC.com. ABC.com has adatabase named HRDB with tables named Staff and SalaryHistory. The Staff and SalaryHistorytables were created using the following Transact-SQL code:CREATE TABLE HRDB.Staff(StaffID int NOT NULL PRIMARY KEY,FirstName nvarchar(50) NOT NULL,LastName nvarchar(50) NOT NULL,JobTitle nvarchar(50) NOT NULL,StaffAddress nvarchar (200) NULL,StaffCity nvarchar(50) NOT NULL,StaffState nvarchar(50) NOT NULL,StaffPhone varchar (10) NOT NULL,Salary smallmoney...

Read More