Too many key points, too little time — Lead2Passed knows the trouble. The Microsoft Querying Data with Transact-SQL study engine helps you get the 070-761 exam certificate easier and sooner: 205 practice questions for the 070-761 exam.
Microsoft 070-761 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Querying Data with Transact-SQL |
| Exam Number: | 70-761 |
| Related Certifications: | 70-762 MCSA: SQL 2016 Database Development MCSA: SQL 2016 BI Development |
| Available Languages: | Russian, English, Brazilian Portuguese, French, Simplified Chinese, German, Traditional Chinese, Japanese |
| Real Exam Qty: | 40–60 |
| Exam Format: | Multiple response, Drag and drop, Hot area, Short answer, Code completion, Build list, Active screen, Multiple choice |
| Passing Score: | 700 / 1000 |
| Exam Duration: | 90–180 |
| Certificate Validity Period: | MCSA certification valid for 2 years; exam retired since January 2021 |
| Exam Price: | $165 USD |
| Recommended Training: | Exam Ref 70-761 Querying Data with Transact-SQL Course 20761: Querying Data with Transact-SQL |
| Exam Registration: | Microsoft Exam Page Pearson VUE (archived) |
| Sample Questions: | DOWNLOAD DEMO |
| 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 |
|---|---|---|
| Topic 1: Manage data with Transact-SQL | 40–45% | - Create Transact-SQL SELECT queries
|
| Topic 2: Program databases by using Transact-SQL | 20–25% | - Implement functions and error handling
|
| Topic 3: Query data with advanced Transact-SQL components | 30–35% | - Use set operators and grouping
|
070-761 Exam FAQ — Easier and Sooner
Yes — download the free Microsoft Querying Data with Transact-SQL demo and judge the quality yourself before paying; the whole content goes further than the demo, but the demo shows the style. Purchases include 365 days of free updates delivered by email; renew afterward at 50% off.
No formal prerequisites; recommended 1–2 years experience writing Transact-SQL queries; required with 70-762 for MCSA: SQL 2016 Eligibility rules change over time, so verify the current requirements on the official page (official 070-761 exam page) before registering.
The Microsoft Querying Data with Transact-SQL is Microsoft's certification exam for MCSA: SQL 2016 Database Development / MCSA: SQL 2016 Business Intelligence Development, at the Associate level. Related credentials include 70-762, MCSA: SQL 2016 Database Development, MCSA: SQL 2016 BI Development. Prepare efficiently: short review sessions anywhere, mock exams when you have a desk.
The Microsoft Querying Data with Transact-SQL blueprint spans 3 domains — including Manage data with Transact-SQL (40–45%), Program databases by using Transact-SQL (20–25%), Query data with advanced Transact-SQL components (30–35%). Tag key points per domain in the PDF version; the complete outline above lists every subtopic.
90–180 for 40–60 questions. Build pacing with the Lead2Passed software engine: repeated timed mock exams make the real clock feel easy.
Yes:
After any course, consolidate the knowledge with the 205 practice questions for the Microsoft Querying Data with Transact-SQL — every answer expert-verified.
Our system emails the Microsoft Querying Data with Transact-SQL material automatically right after purchase — about a minute; click the link, sign in, and use the engine immediately, with 24/7 help if nothing arrives within 2 hours. If you unfortunately fail the corresponding 070-761 exam within 60 days of purchase, you're welcome to a full refund: upload your failed result — a scanned enrollment slip plus the official Score Report PDF within 2 days of the exam — and we handle it within 7 days. Excluded: exams within 3 days of purchase, candidate names that don't match the payer, and free or expired products. We also recommend an alternative: exchange for two equal-value products free.
Through the vendor's official registration channels:
The Microsoft Querying Data with Transact-SQL is delivered Retired; previously delivered via Pearson VUE test centers or online proctored — pick the arrangement that suits you when booking.
$165 USD per attempt, 700 / 1000 to pass. Each retake costs the full fee, so prepare thoroughly the first time — the 205 practice questions for the 070-761 exam at Lead2Passed closely simulate the real test.
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 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: B 🗳️
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 are creating indexes in a data warehouse.
You have a dimension table named Table1 that has 10,000 rows. The rows are used to generate several reports.
The reports join a column that is the primary key.
The execution plan contains bookmark lookups for Table1.
You discover that the reports run slower than expected.
You need to reduce the amount of time it takes to run the reports.
Solution: You create a nonclustered index on the primary key column that includes the bookmark lookup columns.
Does this meet the goal?
- A. Yes
- B. No
Correct Answer: B 🗳️
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 are building a stored procedure that will be used by hundreds of users concurrently.
You need to store rows that will be processed later by the stored procedure. The object that stores the rows must meet the following requirements:
* Be indexable
* Contain up-to-date statistics
* Be able to scale between 10 and 100,000 rows
The solution must prevent users from accessing one another's data.
Solution: You create a global temporary table in the stored procedure.
Does this meet the goal?
- A. Yes
- B. No
Correct Answer: A 🗳️
You have a database for a banking system. The database has two tables named tblDepositAcct and tblLoanAcct that store deposit and loan accounts, respectively. Both tables contain the following columns:
You need to determine the total number of customers who have only deposit accounts.
Which Transact-SQL statement should you run?
- A. Option D
- B. Option F
- C. Option B
- D. Option G
- E. Option C
- F. Option H
- G. Option E
- H. Option A
Correct Answer: B 🗳️
Explanation: Only visible for Lead2Passed members. You can sign-up / login (it's free).
Viewing page 1 out of 41 pages.
Viewing questions 1-5 out of 205 questions.
1066 Customer Reviews
