Last Updated: Nov 16, 2026
No. of Questions: 205 Questions & Answers with Testing Engine
Download Limit: Unlimited
Our SurePassExams 070-761 Exam Preparation materials are famous for its high pass-rate. Actual studying content will help you pass exam for sure. Also different study methods will give you different choices and different preparing experience. 070-761 exam torrent files can help you prepare easily and get doubt result with half effort. Our Soft test engine and Online test engine will provide you simulation function so that you can have a good mood after studying deeply.
SurePassExams has an unprecedented 99.6% first time pass rate among our customers.
We're so confident of our products that we provide no hassle product exchange.
Waiting for a bus, waiting for friends — spare minutes add up to a certification. The Microsoft Querying Data with Transact-SQL online engine from SurePassExams turns them into progress on 205 practice questions for the 070-761 exam.
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Querying Data with Transact-SQL |
| Exam Number: | 70-761 |
| Exam Format: | Multiple choice, Build list, Review screen, Drag and drop, Multiple response, Active screen, Hot area, Short answer |
| Exam Price: | $165 USD |
| Available Languages: | Chinese (Simplified), Chinese (Traditional), English, German, Russian, Japanese, French, Portuguese (Brazil) |
| Real Exam Qty: | 40-60 |
| Certificate Validity Period: | No fixed expiration for earned legacy certification; exam retired on January 31, 2021 |
| Exam Duration: | 120 minutes |
| Passing Score: | 700/1000 |
| Related Certifications: | MCSA: SQL 2016 Database Development |
| Sample Questions: | DOWNLOAD DEMO |
| Exam Way: | Pearson VUE testing center or online proctored delivery when available; the exam is retired and no longer available for registration. |
| Pre Condition: | 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. |
| Section | Weight | Objectives |
|---|---|---|
| Query data with advanced Transact-SQL components | 30-35% | - Query data by using subqueries and APPLY
|
| Program databases by using Transact-SQL | 25-30% | - Implement data types and NULLs
|
| Manage data with Transact-SQL | 40-45% | - Query multiple tables by using joins
|
Delivery is instant: payment triggers an automatic email within a minute — unlimited installations, and 24/7 customer assisting for any downloading or purchasing issue if nothing arrives within 2 hours. If you fail the corresponding 070-761 exam within 60 days of purchase, choose your remedy: a full refund (scanned enrollment slip plus the official Score Report PDF within 2 days of the exam; processed within 7 days), waiting for the next updated version free, or a free change to two other equal-value dumps. Excluded: exams within 3 days of purchase, candidate names that don't match the payer, and free or expired products.
120 minutes for 40-60 questions. Fit the atmosphere in advance: timed sessions in the SurePassExams online engine make the formal pace feel practiced, not pressured.
The Microsoft Querying Data with Transact-SQL blueprint spans 3 domains — including Manage data with Transact-SQL (40-45%), Query data with advanced Transact-SQL components (30-35%), Program databases by using Transact-SQL (25-30%). Let the weightings direct your spare-time review; the full outline above lists every subtopic.
Yes — download the free Microsoft Querying Data with Transact-SQL demo and evaluate the material before paying. Purchases include 365 days of free updates, each new version emailed immediately upon release; renew afterward at 50% off.
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. Eligibility rules change periodically, so confirm the current requirements on the official page before registering.
The Microsoft Querying Data with Transact-SQL is Microsoft's certification exam for MCP, at the Associate level. It validates job-ready skills, and passing it marks you as a verified professional. Related credentials include MCSA: SQL 2016 Database Development.
$165 USD per attempt, 700/1000 to pass. A retake costs the full fee again — effective preparation with the 205 practice questions for the 070-761 exam is the economical path.
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
You have a database that contains the following tables:
Customer
CustomerAudit
Where the value of the CustomerID column equals 3, you need to update the value of the CreditLimit column to 1000 for the customer. You must ensure that the change to the record in the Customer table is recorded on the CustomerAudit table.
Which Transact-SQL statement should you run?
Correct Answer: B 🗳️
Explanation: Only visible for SurePassExams members. You can sign-up / login (it's free).
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have a database that contains tables named Customer_CRMSystem and Customer_HRSystem. Both tables use the following structure:
The tables include the following records:
Customer_CRMSystem
Customer_HRSystem
Records that contain null values for CustomerCode can be uniquely identified by CustomerName.
You need to create a list of all unique customers that appear in either table.
Which Transact-SQL statement should you run?

Correct Answer: B 🗳️
Explanation: Only visible for SurePassExams members. You can sign-up / login (it's free).
You need to create a database object that meets the following requirements:
* accepts a product identifies as input
* calculates the total quantity of a specific product, including quantity on hand and quantity on order
* caches and reuses execution plan
* returns a value
* can be called from within a SELECT statement
* can be used in a JOIN clause
What should you create?
Correct Answer: D 🗳️
Explanation: Only visible for SurePassExams members. You can sign-up / login (it's free).
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?
Correct Answer: A 🗳️
Explanation: Only visible for SurePassExams members. You can sign-up / login (it's free).
Viewing page 1 out of 41 pages.
Viewing questions 1-5 out of 205 questions.
Tim
Zebulon
Bridget
Eileen
Hedy
Laura
SurePassExams is the world's largest certification preparation company with 99.6% Pass Rate History from 58886+ Satisfied Customers in 148 Countries.
Over 58886+ Satisfied Customers
