The 070-761 exam gets harder as its value rises — that is exactly why passing it earns attention from serious employers. Test4Cram prepares you properly: 205 practice questions refined over years by a dedicated team of experts, with 365 days of free updates.
Microsoft 070-761 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Querying Data with Transact-SQL |
| Exam Number: | 70-761 |
| Exam Duration: | 90–180 |
| Real Exam Qty: | 40–60 |
| Exam Format: | Code completion, Build list, Multiple choice, Hot area, Active screen, Multiple response, Drag and drop, Short answer |
| Certificate Validity Period: | MCSA certification valid for 2 years; exam retired since January 2021 |
| Related Certifications: | 70-762 MCSA: SQL 2016 BI Development MCSA: SQL 2016 Database Development |
| Available Languages: | Traditional Chinese, Russian, Japanese, Brazilian Portuguese, French, German, Simplified Chinese, English |
| Exam Price: | $165 USD |
| Passing Score: | 700 / 1000 |
| Recommended Training: | Course 20761: Querying Data with Transact-SQL Exam Ref 70-761 Querying Data with Transact-SQL |
| Exam Registration: | Pearson VUE (archived) Microsoft Exam Page |
| Sample Questions: |  |
| Exam Way: | Retired; previously delivered via Pearson VUE test centers or online proctored |
| Pre Condition: | No formal prerequisites; recommended 1–2 years experience writing Transact-SQL queries; required with 70-762 for MCSA: SQL 2016 |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/certifications/exams/70-761 |
Microsoft 070-761 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Program databases by using Transact-SQL | 20–25% | - Implement functions and error handling
|
| Manage data with Transact-SQL | 40–45% | - Query multiple tables by using joins
|
| Query data with advanced Transact-SQL components | 30–35% | - Use subqueries and table expressions
|
070-761 Exam: Frequently Asked Questions
Retired; previously delivered via Pearson VUE test centers or online proctored Book the Microsoft Querying Data with Transact-SQL exam through these official channels:
Once booked, your Test4Cram practice questions arrive by email within 1 minute, so preparation starts the same day.
The passing score for the Microsoft Querying Data with Transact-SQL exam is 700 / 1000, and registration costs $165 USD. A retake means the same fee again — a sound reason to test your readiness with the Test4Cram engines before committing to a date.
Test4Cram refunds you in full if you take the Microsoft Querying Data with Transact-SQL exam within 60 days of purchase and do not pass. The policy does not apply if the exam is taken within 3 days of purchase, if the exam was never actually taken, or to free materials or expired orders, and the candidate name must match the payer name. Submit a scan of your enrollment slip and the official Score Report PDF within 2 days of the exam; claims are processed within 7 days. As an alternative, exchange for two free exam products of equal value while keeping your original update service. Delivery is by email within 1 minute — contact support if nothing arrives within 2 hours.
Microsoft recommends these training resources for the Microsoft Querying Data with Transact-SQL exam:
After the training, the 205 practice questions from Test4Cram let you make full use of sporadic time — short sessions that steadily convert study into readiness.
The Microsoft Querying Data with Transact-SQL exam presents 40–60 with 90–180 available. That pace is demanding — rehearse it in the timed mode of the Test4Cram Desktop Test Engine until it feels familiar.
The official Microsoft Querying Data with Transact-SQL outline comprises 3 domains. The three largest are Query data with advanced Transact-SQL components (30–35%), Manage data with Transact-SQL (40–45%), and Program databases by using Transact-SQL (20–25%). The full list appears in the topics section above, and the 205 practice questions at Test4Cram cover all of them.
The 070-761 exam is a Microsoft certification exam built around the Microsoft Querying Data with Transact-SQL syllabus shown above. It feeds into these credential paths: 70-762, MCSA: SQL 2016 Database Development, MCSA: SQL 2016 BI Development. Precisely because the exam is demanding, passing it earns real attention from employers in 2026. Test4Cram prepares you with 205 practice questions in PDF, Desktop Test Engine, and Online Test Engine formats.
No formal prerequisites; recommended 1–2 years experience writing Transact-SQL queries; required with 70-762 for MCSA: SQL 2016 Requirements can change, so verify the latest on the official Microsoft exam page before scheduling.
The complete preparation toolkit: 205 practice questions for the Microsoft Querying Data with Transact-SQL exam in three formats — a printable, expert-prepared PDF with instant download; a Desktop Test Engine for Windows that simulates the real exam with two practice modes and works offline; and an Online Test Engine for any browser on Windows, Mac, Android, and iOS with test history and performance review. Included as well: a free demo, 365 days of free updates, a 50% renewal discount afterward, and unlimited computer installations — all from a platform refined through years of expert effort.
Microsoft Querying Data with Transact-SQL Sample Questions:
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 that was created by running the following Transact-SQL statement:
The Products table includes the data shown in the following table:
TotalUnitPrice is calculated by using the following formula:
TotalUnitPrice = UnitPrice * (UnitsInStock + UnitsOnOrder)
You need to ensure that the value returned for TotalUnitPrice for ProductB is equal to 600.00.
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 Test4Cram members. You can sign-up / login (it's free).
You need to create a table named Sales that meets the following requirements:
Which Transact-SQL statement should you run?
- A. Option A
- B. Option D
- C. Option B
- D. Option C
Correct Answer: B 🗳️
Explanation: Only visible for Test4Cram members. You can sign-up / login (it's free).
You develop and deploy a project management application. The application uses a Microsoft SQL Server database to store data. You are developing a software bug tracking add-on for the application.
The add-on must meet the following requirements:
* Allow case sensitive searches for product.
* Filter search results based on exact text in the description.
* Support multibyte Unicode characters.
You run the following Transact-SQL statement:
Users report that searches for the product Salt also return results for the product salt.
You need to ensure that the query returns the correct results.
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
References:
https://stackoverflow.com/questions/1831105/how-to-do-a-case-sensitive-search-in-where-clause-im-using-sql-s
A company produces and ships concrete blocks. You store information about factory and shipping centers in tables that were created by running the following Transact-SQL statements:
You must create a report that shows the regions that have a factory but do not have a shipping center.
You need to create the query for the report.
Which two Transact-SQL statements can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Option A
- B. Option D
- C. Option B
- D. Option C
Correct Answer: A,D 🗳️
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:
Please see explanation for answer.
Explanation
1 SELECT Rawcount
2 from (select cityid,questioned,rawcount) AS t1
3 unpivot
4 (rawcount for questioned in (QuestionID)) AS t2
5 JOIN t2
6. ON t1.CityName = t2.cityName
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
Viewing page 1 out of 41 pages.
Viewing questions 1-5 out of 205 questions.
