A Microsoft exam that changed last month makes last month's questions dangerous. GuideTorrent tracks the Microsoft Querying Data with Transact-SQL continuously and keeps your 070-761 material updated free for 365 days — all through 2026.
Microsoft 070-761 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Data aggregation and grouping | - GROUP BY and HAVING
|
| Advanced querying features | - Windowing functions
|
| Work with SELECT queries | - Query fundamentals
|
| Query multiple tables | - Set operators
|
| Programming with Transact-SQL | - Control of flow
|
| Modify data | - Data manipulation language (DML)
|
070-761 Exam FAQ — Everything Before You Buy
The Microsoft Querying Data with Transact-SQL is one of Microsoft's influential certification exams — pass it and you earn the MCSA: SQL 2016 Database Development certification (Associate level). Among IT workers it's a popular way to prove professional knowledge in the field. It also connects with related credentials such as MCSA: SQL 2016 Database Development, 70-762 Developing SQL Databases.
Yes — download the free 070-761 demo and judge the question quality with your own eyes before paying. Every purchase then includes 365 days of free updates, and an expired update period can be extended at 50% off.
No formal prerequisites; recommended knowledge of relational databases and basic Transact-SQL. Because these requirements change over time, double-check the current criteria on the official exam page (official 070-761 exam information) before you book.
The vendor recommends:
Training is a solid foundation — but practice is the proof. Follow up any course with the 070-761 practice questions from GuideTorrent to see whether you're truly exam-ready.
Register through the vendor's official channels:
The exam is offered Computer-based exam delivered via online proctoring or authorized test centers (Pearson VUE, historically). — pick what suits you when you book.
40-60 (approximate) questions inside 120 minutes. The hidden skill here is pacing: know your per-question budget, skip and return rather than stall, and rehearse with the GuideTorrent online test engine — you can set the timer yourself to mimic real exam pressure, on any device, whenever spare time appears.
Delivery is instant — after successful payment, our system automatically emails the product to your mailbox within a minute, with download access right away and no installation limits; contact our 24/7 customer assistance if 2 hours pass with nothing. If you fail: take the corresponding 070-761 exam within 60 days of purchase and submit a scanned enrollment slip plus the official Score Report PDF within 2 days of the exam — the full refund is processed within 7 days. Exclusions: exams taken within 3 days of purchase, name mismatches between candidate and payer, and free or expired products. Or exchange for two equal-value exam products free, keeping your updates.
The official Microsoft Querying Data with Transact-SQL blueprint contains 6 domains, including Query multiple tables, Modify data, Data aggregation and grouping. The weightings tell you where the exam's points live — allocate your spare time to match. The complete outline above has every domain and subtopic.
You'll need 700 (on a 1000 scale) to pass, and the official fee is USD 165 (varies by country/region) per attempt — every retake bills the full amount again. Practicing with the 205 questions from GuideTorrent until your scores are consistently comfortable is how you pay that fee once.
Microsoft Querying Data with Transact-SQL Sample Questions:
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:
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.
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.
Use the Check Syntax button to verify your work. Any syntax or spelling errors will be reported by line and character position.
Correct 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
You are creating a database solution to track sales achievements of your training courses. You run the following statements:
You plan to add courses to a table named HighlightedCourses. You must add courses that have been delivered to more than 100 participants only.
If the total number of participants for a course is lower than 100, the course must not be added to the HighlightedCourses table. In addition, an error message must be displayed and remaining Transact-SQL code must not run.
How should you complete the Transact-SQL statement? To answer, select the appropriate Transact-SQL segments in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation
Box 1: THROW
TRHOW raises an exception and transfers execution to a CATCH block of a TRY...CATCH construct.
If a TRY...CATCH construct is not available, the statement batch is terminated. The line number and procedure where the exception is raised are set.
Box 2: IF (@TotalParticipants < 100)
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section. You will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a table named Products that stores information about products your company sells. The table has a column named ListPrice that stores retail pricing information for products.
Some products are used only internally by the company. Records for these products are maintained in the Products table for inventory purposes. The price for each of these products is $0.00. Customers are not permitted to order these products.
You need to increase the list price for products that cost less than $100 by 10 percent. You must only increase pricing for products that customers are permitted to order.
Solution: You run the following Transact-SQL statement:
Does the solution meet the goal?
- A. Yes
- B. No
Correct Answer: B 🗳️
Explanation: Only visible for GuideTorrent members. You can sign-up / login (it's free).
You have a database that contains the following tables.
You need to create a query that lists the lowest-performing salespersons based on the current year-to-date sales period. The query must meet the following requirements:
- Return a column named Fullname that includes the salesperson FirstName, a space, and then LastName.
- Include the current year-to-date sales for each salesperson.
- Display only data for the three salespersons with the lowest year-to-year sales values.
- Exclude salespersons that have no value for TerritoryID.
Construct the query using the following guidelines:
- Use the first letter of a table name as the table alias.
- Use two-part column names.
- Do not surround object names with square brackets.
- Do not use implicit joins.
- Use only single quotes for literal text.
- Use aliases only if required.
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.
Use the Check Syntax button to verify your work. Any syntax or spelling errors will be reported by line and character position.
Correct Answer:
Please see explanation
Explanation
SELECT TOP (3) LastName, S.SalesYTD
FROM Person as P INNER JOIN SalesPerson AS S
ON P.PersonID = S.SalesPersonID
WHERE S.TerritoryID IS NOT NULL
ORDER BY S.SalesYTD DESC
On ordering: ASC | DESC
Specifies that the values in the specified column should be sorted in ascending or descending order. ASC sorts from the lowest value to highest value. DESC sorts from highest value to lowest value. ASC is the default sort order. Null values are treated as the lowest possible values.
References:
https://msdn.microsoft.com/en-us/library/ms189463.aspx
You have a database that stored information about servers and application errors. The database contains the following tables.
Servers
Errors
You need to return all error log messages and the server where the error occurs most often.
Which Transact-SQL statement should you run?
- A. Option D
- B. Option A
- C. Option C
- D. Option B
Correct Answer: C 🗳️
Viewing page 1 out of 41 pages.
Viewing questions 1-5 out of 205 questions.
