Querying Data with Transact-SQL Exam Questions with VCE and PDF for Free Download (Question 41 – Question 45)

Valid 70-761 Dumps shared by PassLeader for Helping Passing 70-761 Exam! PassLeader now offer the newest 70-761 VCE dumps and 70-761 PDF dumps, the PassLeader 70-761 exam questions have been updated and ANSWERS have been corrected, get the newest PassLeader 70-761 dumps with VCE and PDF here: http://www.passleader.com/70-761.html (74 Q&As Dumps)

BTW, DOWNLOAD part of PassLeader 70-761 dumps from Cloud Storage: https://drive.google.com/open?id=0B-ob6L_QjGLpaEZzRVFnOE9OenM

QUESTION 41
You have a database that stored information about servers and application errors. The database contains the following tables.
Servers:
passleader-70-761-dumps-411
Errors:
passleader-70-761-dumps-412
You need to return all error log messages and the server where the error occurs most often. Which Transact-SQL statement should you run?

passleader-70-761-dumps-413

A.    Option A
B.    Option B
C.    Option C
D.    Option D

Answer: C

QUESTION 42
Drag and Drop Question
You have a database that stored information about servers and application errors. The database contains the following tables.
Servers:
passleader-70-761-dumps-421
Errors:
passleader-70-761-dumps-422
You are building a webpage that shows the three most common errors for each server. You need to return the data for the webpage. How should you complete the Transact-SQL statement? To answer, drag the appropriate Transact-SQL segments to the correct location. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.
passleader-70-761-dumps-423

Answer:
passleader-70-761-dumps-424

QUESTION 43
You have a table named Cities that has the following two columns: CityID and CityName. The CityID column uses the int data type, and CityName uses nvarchar(max). You have a table named RawSurvey. Each row includes an identifier for a question and the number of persons that responded to that question from each of four cities. The table contains the following representative data:
passleader-70-761-dumps-431
A reporting table named SurveyReport has the following columns: CityID, QuestionID, and RawCount, where RawCount is the value from the RawSurvey table. You need to write a Transact-SQL query to meet the following requirements:
– Retrieve data from the RawSurvey table in the format of the SurveyReport table.
– The CityID must contain the CityID of the city that was surveyed.
– The order of cities in all SELECT queries must match the order in the RawSurvey table.
– The order of cities in all IN statements must match the order in the RawSurvey table.
Construct the query using the following guidelines:
– Use one-part names to reference tables and columns, except where not possible.
– ALL SELECT statements must specify columns.
– Do not use column or table aliases, except those provided.
– Do not surround object names with square brackets.
passleader-70-761-dumps-432
Part of the correct Transact-SQL has been provided in the answer area below. Enter the code in the answer area that resolves the problem and meets the stated goals or requirements. You can add code within the code that has been provided as well as below it.
passleader-70-761-dumps-433
Use the Check Syntax button to verify your work. Any syntax or spelling errors will be reported by line and character position.

Answer: UNPIVOT
Explanation:
UNPIVOT must be used to rotate columns of the Rawsurvey table into column values.
References: https://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx

QUESTION 44
You have a database named MyDb. You run the following Transact-SQL statements:
passleader-70-761-dumps-441
A value of 1 in the Is Active column indicates that a user is active. You need to create a count for active users in each role. If a role has no active users. you must display a zero as the active users count. Which Transact-SQL statement should you run?

passleader-70-761-dumps-442

A.    Option A
B.    Option B
C.    Option C
D.    Option D

Answer: C

QUESTION 45
Drag and Drop Question
You create three tables by running the following Transact-SQL statements:
passleader-70-761-dumps-451
For reporting purposes, you need to find the active user count for each role, and the total active user count. The result must be ordered by active user count of each role. You must use common table expressions (CTEs). Which four Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.
passleader-70-761-dumps-452

Answer:
passleader-70-761-dumps-453


Get the newest PassLeader 70-761 VCE dumps here: http://www.passleader.com/70-761.html (74 Q&As Dumps)

And, DOWNLOAD the newest PassLeader 70-761 PDF dumps from Cloud Storage for free: https://drive.google.com/open?id=0B-ob6L_QjGLpaEZzRVFnOE9OenM