Certification vendors refresh their exams without much warning, and outdated material quietly hurts your score. LatestCram reviews and updates the 070-761 practice questions on a continuous basis, and every Microsoft Querying Data with Transact-SQL purchase in 2026 includes 365 days of free updates.
Microsoft 070-761 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Querying Data with Transact-SQL |
| Exam Number: | 70-761 |
| Available Languages: | Japanese, German, Spanish, Korean, Portuguese (Brazil), English, Chinese (Simplified), French, Russian |
| Real Exam Qty: | 40-60 (approximate) |
| Exam Duration: | 120 minutes |
| Exam Price: | USD 165 (varies by country/region) |
| Certificate Validity Period: | Retired (no longer available; certification has been discontinued) |
| Passing Score: | 700 (on a 1000 scale) |
| Exam Format: | Multiple choice, Case studies, Multiple response, Drag and drop |
| Related Certifications: | MCSA: SQL 2016 Database Development 70-762 Developing SQL Databases |
| Recommended Training: | SQL Server T-SQL Documentation Microsoft Learn T-SQL Learning Paths |
| Exam Registration: | Microsoft Learn Certification Page Pearson VUE Microsoft Exams |
| Sample Questions: |  |
| Exam Way: | Computer-based exam delivered via online proctoring or authorized test centers (Pearson VUE, historically). |
| Pre Condition: | No formal prerequisites; recommended knowledge of relational databases and basic Transact-SQL. |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/exams/70-761/ |
Microsoft 070-761 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Data aggregation and grouping | - Aggregation functions
|
| Topic 2: Advanced querying features | - Windowing functions
|
| Topic 3: Query multiple tables | - Set operators
|
| Topic 4: Programming with Transact-SQL | - Error handling and transactions
|
| Topic 5: Modify data | - Data manipulation language (DML)
|
| Topic 6: Work with SELECT queries | - Advanced SELECT operations
|
Microsoft 070-761 Exam: Your Questions, Answered
The Microsoft Querying Data with Transact-SQL exam is the official Microsoft assessment behind the MCSA: SQL 2016 Database Development credential, which sits at the Associate level. Passing it confirms that your skills meet the vendor's current requirements rather than a textbook outline. It also connects with related certifications such as MCSA: SQL 2016 Database Development, 70-762 Developing SQL Databases, so it can anchor a broader certification path.
According to the official exam information, the Microsoft Querying Data with Transact-SQL exam includes 40-60 (approximate) questions and gives you 120 minutes to complete them. Treat that as a pacing exercise, not just a knowledge check: bank the questions you know first, flag the ones that stall you, and circle back instead of burning minutes on a single item. Before test day, run at least one full timed session in the LatestCram desktop or online test engine, so the clock never feels unfamiliar when it counts.
To pass the Microsoft Querying Data with Transact-SQL exam you need 700 (on a 1000 scale), and the official registration fee is USD 165 (varies by country/region). Keep one thing in mind: a failed attempt is not discounted, so retaking the exam means paying USD 165 (varies by country/region) again in full. A practical safeguard is to sit a complete LatestCram practice test a week or two before your exam date; if your timed scores are not sitting comfortably above the passing mark, consider pushing your booking back and drilling the weak domains first.
The official prerequisites for the Microsoft Querying Data with Transact-SQL exam are as follows: No formal prerequisites; recommended knowledge of relational databases and basic Transact-SQL.. Requirements can change over time, so confirm the details on the official Microsoft exam page at https://learn.microsoft.com/en-us/credentials/certifications/exams/70-761/ before you book your seat.
You can register through the official channels listed below:
Exam delivery: Computer-based exam delivered via online proctoring or authorized test centers (Pearson VUE, historically)..
Microsoft points candidates toward the following official training options:
Official training builds the theory; the 205 practice questions from LatestCram show you how that theory appears in exam-style items, which is where most study plans actually pay off.
Yes. A free PDF demo of the Microsoft Querying Data with Transact-SQL practice questions is available on the LatestCram samples page, so you can check the question style and difficulty before spending anything. Every purchase also includes 365 days of free updates, and if your product expires after that period, you can extend the update service from your member zone at 50% off.
If you take the 070-761 exam within 60 days of your purchase and do not pass, LatestCram offers a 100% money-back guarantee: send a scanned copy of your exam enrollment slip together with the official Score Report PDF within two days of your exam date, and the refund is processed within seven days. The candidate name must match the payer name, and the guarantee does not apply to exams taken within three days of purchase, to material that was downloaded without the exam actually being taken, or to free materials and expired orders. Prefer to keep studying instead? You can exchange your purchase for two additional exam products of equal value, free of charge, while keeping the update service on your original product. Delivery itself is instant: the download link is emailed within one minute of payment, and if nothing arrives within two hours, our support team will sort it out. There is no limit on how many computers you install the material on.
The Microsoft Querying Data with Transact-SQL syllabus is organized into 6 domains. The leading areas include Modify data, Advanced querying features, and Work with SELECT queries. For the complete, topic-by-topic breakdown, scroll up to the Exam Topics section above.
Microsoft Querying Data with Transact-SQL Sample Questions:
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 data below:
Customer_CRMSystem
Customer_HRSystem
Records that contain null values for CustomerCode can be uniquely identified by CustomerName.
You need to display customers that have a proper CustomerCode and do not appear in the Customer_HRSystem table.
Which Transact-SQL statement should you run?
- A. Option C
- B. Option D
- C. Option G
- D. Option H
- E. Option A
- F. Option E
- G. Option F
- H. Option B
Correct Answer: A 🗳️
Explanation: Only visible for LatestCram 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 create a table named Products by running the following Transact-SQL statement:
You have the following stored procedure:
You need to modify the stored procedure to meet the following new requirements:
- Insert product records as a single unit of work.
- Return error number 51000 when a product fails to insert into the database.
- If a product record insert operation fails, the product information must not be permanently written to the database.
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 LatestCram members. You can sign-up / login (it's free).
You need to create an indexed view that requires logic statements to manipulate the data that the view displays.
Which two database objects should you use? Each correct answer presents a complete solution.
- A. a user-defined table-valued function
- B. a stored procedure
- C. a user-defined scalar function
- D. a CRL function
Correct Answer: A,B 🗳️
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 Managers report.
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.
Correct Answer:
Explanation
From scenario: Sales Manager report: This report lists each sales manager and the total sales amount for all employees that report to the sales manager.
Box 1:..WHERE Title='Sales representative'
The valid values for the Title column are Sales Representative manager, and CEO.
First we define the CTE expression.
Note: A common table expression (CTE) can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query. Unlike a derived table, a CTE can be self-referencing and can be referenced multiple times in the same query.
Box 2:
Use the CTE expression one time.
Box 3: UNION
Box 4:
Use the CTE expression a second time.
References:
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
Your company is developing a new social application that connects customers to each other based on the distance between their delivery locations.
You need to write a query that returns the nearest customer.
Solution: You run the following Transact-SQL statement:
The variable @custID is set to a valid customer.
Does the solution meet the goal?
- A. Yes
- B. No
Correct Answer: A 🗳️
Explanation: Only visible for LatestCram members. You can sign-up / login (it's free).
Viewing page 1 out of 41 pages.
Viewing questions 1-5 out of 205 questions.
1061 Customer Reviews
