PDF Version DemoGood after-sales service is patience, courtesy, and respect — around the clock. The PassExamDumps team handles every question about the Microsoft Querying Data with Transact-SQL materials 24/7, and treats reputation as something earned one customer at a time. In 2026, that standard comes with every 070-761 exam purchase.
Microsoft 070-761 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Program databases by using Transact-SQL | 25-30% | - Create database programmability objects by using Transact-SQL
|
| Topic 2: Manage data with Transact-SQL | 40-45% | - Query multiple tables by using joins
|
| Topic 3: Query data with advanced Transact-SQL components | 30-35% | - Query data by using subqueries and APPLY
|
070-761 Exam Facts and Product Details
Patient, courteous, and available around the clock. Our team handles Microsoft Querying Data with Transact-SQL questions 24/7 with genuine respect for your time — whether you need help downloading, installing, or understanding an update. We treat our reputation as something earned one customer at a time, which is why so many candidates who finish the 070-761 exam with us come back when their next certification appears on the horizon.
No formal prerequisite exam. Intended for SQL Server database administrators, system engineers, and developers with two or more years of experience writing Transact-SQL queries. Exam 70-762 was also required to earn MCSA: SQL 2016 Database Development.
A dedicated team of experts compiles the Microsoft Querying Data with Transact-SQL question bank and maintains it continuously: new questions are added as the exam evolves in the market, and the content is recomposed against the latest syllabus and trends. Difficult topics are distilled into clear, study-friendly form, and every answer is expert-verified. The 070-761 exam bank you buy is a living product, not a frozen file.
The 070-761 exam is the official assessment behind the Microsoft Querying Data with Transact-SQL certification from Microsoft. Credentials like this carry weight because they demonstrate something specific: the ability to solve problems under pressure, verified by an independent exam. In a competitive field, that visible proof of skill is what helps a candidate stand out — and thorough preparation is what earns it.
Passing the 070-761 exam requires 700/1000, and registration costs $165 USD. Success takes perspiration — and a smart way to spend it, which is exactly what objective-aligned practice with verified answers provides.
The official outline divides the 070-761 exam into weighted domains, including:
- Program databases by using Transact-SQL (25-30%)
- Query data with advanced Transact-SQL components (30-35%)
- Manage data with Transact-SQL (40-45%)
The Microsoft Querying Data with Transact-SQL bank at PassExamDumps is recomposed against this syllabus whenever it shifts, so the material tracks the exam's own direction.
The 070-761 exam contains 40-60 questions with 120 minutes minutes to complete them. Solving problems under time pressure is a skill of its own — and timed practice is how you build it.
Microsoft Querying Data with Transact-SQL Sample Questions:
You create a table named Sales.Categories by running the following Transact-SQL statement:
You add the following data to the table.
You need to create a query that uses a common table expression (CTE) to show the parent category of each category. The query must meet the following requirements:
* Return all columns from the Categories table in the order shown.
* Exclude all categories that do not have a parent category.
Construct the query using the following guidelines:
* Name the expression ParentCategories.
* Use PC as the alias for the expression.
* Use C as the alias for the Categories table.
* Use the AS keyword for all table aliases.
* Use individual column names for each column that the query returns.
* Do not use a prefix for any column name.
* 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. You may check syntax as many times as needed.
Correct Answer:
Please see explanation
Explanation
1 WITH ParentCategories pc (CategoryID, Name, PatentCategoryID) AS (SELECT c.categoryID,c.name,c.parentcategoryid
2 FROM sales.categories c
3 WHERE parentcategoryid is not null
4 )
5 SELECT * FROM parentcategories
Note: On Line 1 replace c with WITH ParentCategories pc (CategoryID, Name, PatentCategoryID) AS Note: The basic syntax structure for a CTE is:
WITH expression_name [ ( column_name [,...n] ) ]
AS
( CTE_query_definition )
References: https://technet.microsoft.com/en-us/library/ms190766(v=sql.105).aspx
You need to create a table named Sales that meets the following requirements:
Which Transact-SQL statement should you run?
- A. Option D
- B. Option C
- C. Option A
- D. Option B
Correct Answer: D 🗳️
Explanation: Only visible for PassExamDumps members. You can sign-up / login (it's free).
A company's sales team is divided in two different regions, North and South. You create tables named SalesNorth and SalesSouth. The SalesNorth table stores sales data from the North region. The SalesSouth table stores sales data from the South region. Both tables use the following structure:
You need to create a consolidated result set that includes all records from both tables.
Which Transact-SQL statement should you run?
- A. SELECT SalesNorth.salesID, SalesNorth.customer,
SalesNorth.amount, SalesSouth.salesID, SalesSouth.customer,
SalesSouth.amount
FROM SalesNorth
LEFT JOIN SalesSouth
ON SalesNorth.salesID=SalesSouth.salesID - B. SELECT SalesNorth.salesID, SalesNorth.customer,
SalesNorth.amount, SalesSouth.SalesID, SalesSouth.customer,
SalesSouth.amount
FROM SalesNorth
JOIN SalesSouth ON SalesNorth.salesID = SalesSouth.salesID - C. SELECT salesID, customer, amount
FROM SalesNorth
UNION ALL
SELECT salesID, customer, amount
FROM SalesSouth - D. SELECT salesID, customer, amount
FROM SalesNorth
UNION
SELECT salesID, customer, amount
FROM SalesSouth
Correct Answer: C 🗳️
Explanation: Only visible for PassExamDumps members. You can sign-up / login (it's free).
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You have a database that contains the tables shown in the exhibit. (Click the Exhibit button.)
You review the Employee table and make the following observations:
- Every record has a value in the ManagerID except for the Chief Executive Officer (CEO).
- The FirstName and MiddleName columns contain null values for some records.
- The valid values for the Title column are Sales Representative manager, and CEO.
You review the SalesSummary table and make the following observations:
- The ProductCode column contains two parts: The first five digits represent a product code, and the last seven digits represent the unit price. The unit price uses the following pattern: ####.##.
- You observe that for many records, the unit price portion of the ProductCode column contains values.
- The RegionCode column contains NULL for some records.
- Sales data is only recorded for sales representatives.
You are developing a series of reports and procedures to support the business. Details for each report or procedure follow.
Sales Summary report: This report aggregates data by year and quarter. The report must resemble the following table.
Sales Manager report: This report lists each sales manager and the total sales amount for all employees that report to the sales manager.
Sales by Region report: This report lists the total sales amount by employee and by region. The report must include the following columns: EmployeeCode, MiddleName, LastName, RegionCode, and SalesAmount. If MiddleName is NULL, FirstName must be displayed. If both FirstName and MiddleName have null values, the world Unknown must be displayed/ If RegionCode is NULL, the word Unknown must be displayed.
Report1: This report joins data from SalesSummary with the Employee table and other tables. You plan to create an object to support Report1. The object has the following requirements:
- be joinable with the SELECT statement that supplies data for the report
- can be used multiple times with the SELECT statement for the report
- be usable only with the SELECT statement for the report
- not be saved as a permanent object
Report2: This report joins data from SalesSummary with the Employee table and other tables.
You plan to create an object to support Report1. The object has the following requirements:
Sales Hierarchy report. This report aggregates rows, creates subtotal rows, and super-aggregates rows over the SalesAmount column in a single result-set. The report uses SaleYear, SaleQuarter, and SaleMonth as a hierarchy. The result set must not contain a grand total or cross-tabulation aggregate rows.
Current Price Stored Procedure: This stored procedure must return the unit price for a product when a product code is supplied. The unit price must include a dollar sign at the beginning. In addition, the unit price must contain a comma every three digits to the left of the decimal point, and must display two digits to the left of the decimal point. The stored procedure must not throw errors, even if the product code contains invalid data.
End of Repeated Scenario
You need to create the query for the Sales by Region report.
Which function should you apply to each column? To answer, select the appropriate options in the answer area.
Correct Answer:
Explanation
Box 1: COALESCE
COALESCE evaluates the arguments in order and returns the current value of the first expression that initially does not evaluate to NULL.
If MiddleName is NULL, FirstName must be displayed. If both FirstName and MiddleName have null values, the world Unknown must be displayed.
The following example shows how COALESCE selects the data from the first column that has a nonnull value.
SELECT Name, Class, Color, ProductNumber,
COALESCE(Class, Color, ProductNumber) AS FirstNotNull
FROM Production.Product;
Not NULLIF: NULLIF returns the first expression if the two expressions are not equal. If the expressions are equal, NULLIF returns a null value of the type of the first expression.
Box 2: COALESCE
If RegionCode is NULL, the word Unknown must be displayed.
References: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/coalesce-transact-sql
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 database that tracks orders and deliveries for customers in North America. The database contains the following tables:
Sales.Customers
Application.Cities
Sales.CustomerCategories
The company's development team is designing a customer directory application. The application must list customers by the area code of their phone number. The area code is defined as the first three characters of the phone number.
The main page of the application will be based on an indexed view that contains the area and phone number for all customers.
You need to return the area code from the PhoneNumber field.
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 PassExamDumps members. You can sign-up / login (it's free).
Viewing page 1 out of 41 pages.
Viewing questions 1-5 out of 205 questions.
Ella 
Lillian 
Basil 
Odelia 
Todd 
Maurice 
Jacqueline 
Marshall 
Montague 
Alvin 
Barry 
Louis 
Dinah 
Rudolf 
Sibyl 
Isidore 
Lambert 
Tess 
