For my career, I needed this certification. so, I purchased the 070-761 training prep. Believe it or not, I found the latest exam questions along with answers. I answered well on my exam and passed highly. Thanks!
Exams4sures 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.
The gap between deciding to certify and starting to study should be measured in minutes. Exams4sures emails your 070-761 package within one minute of payment — 205 practice questions for the Microsoft Querying Data with Transact-SQL, ready before your motivation cools.
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Querying Data with Transact-SQL |
| Exam Number: | 70-761 |
| Exam Format: | Hot area, Drag and drop, Active screen, Code completion, Multiple choice, Short answer, Build list, Multiple response |
| Exam Duration: | 90–180 |
| Available Languages: | Simplified Chinese, Brazilian Portuguese, English, Traditional Chinese, Japanese, French, Russian, German |
| Passing Score: | 700 / 1000 |
| Real Exam Qty: | 40–60 |
| Related Certifications: | MCSA: SQL 2016 BI Development MCSA: SQL 2016 Database Development 70-762 |
| Certificate Validity Period: | MCSA certification valid for 2 years; exam retired since January 2021 |
| Exam Price: | $165 USD |
| Recommended Training: | Course 20761: Querying Data with Transact-SQL Exam Ref 70-761 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 |
| Section | Weight | Objectives |
|---|---|---|
| Manage data with Transact-SQL | 40–45% | - Modify data
|
| Query data with advanced Transact-SQL components | 30–35% | - Use set operators and grouping
|
| Program databases by using Transact-SQL | 20–25% | - Implement programming objects
|
Microsoft recommends these training resources for the Microsoft Querying Data with Transact-SQL:
Courses give you the map; practice teaches you to drive. Finish any of the options above, then sharpen your readiness with 205 practice questions from Exams4sures before you schedule the real thing.
On delivery: the download is available the moment your payment clears, and a copy reaches your email within one minute. If 2 hours pass and nothing arrives, check spam and contact our support team. Install the software on as many computers as you need — there is no device limit.
On outcomes: if you take the 070-761 exam within 60 days of purchase and do not pass, the Exams4sures money back guarantee applies. File your claim within 2 days of the exam with a scanned enrollment slip and the official score report (PDF); claims are processed within 7 days. The candidate name must match the payer name, and the policy excludes exams taken within 3 days of purchase, purchases never used in an actual exam attempt, free materials, and expired orders. Alternatively, you can exchange the product for two free exam packages of equal value and keep the update service on your original purchase.
The 070-761 exam gives you 90–180 to work through 40–60 questions. That pace punishes perfectionism — the candidates who struggle are usually the ones who burned ten minutes on one stubborn item. Train the skill directly: take timed, full-length mocks in the Exams4sures desktop or online test engine, practice skipping and returning, and walk in with a pacing strategy you have already tested.
No formal prerequisites; recommended 1–2 years experience writing Transact-SQL queries; required with 70-762 for MCSA: SQL 2016
Vendor requirements do change, so before you commit to an exam date, confirm the latest eligibility rules on the official Microsoft exam page.
The Microsoft Querying Data with Transact-SQL syllabus is split into 3 domains, anchored by 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 breakdown sits in the syllabus section above — treat it as the checklist that decides where your study hours go.
The passing mark for the 070-761 exam is 700 / 1000, and the official registration fee is $165 USD. Remember that the fee covers a single attempt — fail, and the retake costs the same again with no loyalty discount. Protect the budget by self-testing first: drill 205 practice questions at Exams4sures under timed conditions until your scores clear the bar with margin, then register.
The 070-761 exam, officially the Querying Data with Transact-SQL, is Microsoft's benchmark for proving you can work with its technologies in professional settings; passing it awards the MCSA: SQL 2016 Database Development / MCSA: SQL 2016 Business Intelligence Development certification, which sits at the Associate level. Because the credential is issued by the vendor itself, it carries weight with employers that self-assessed skills simply cannot match. It also opens the road toward 70-762, MCSA: SQL 2016 Database Development, MCSA: SQL 2016 BI Development.
Yes — Exams4sures publishes a free PDF demo of the 070-761 materials so you can check the question quality and verified answers before paying anything. Once you purchase, 365 days of free updates come standard, and if your product expires you can renew the update service at a 50% discount from your member zone.
Registration for the Microsoft Querying Data with Transact-SQL runs through the official channels below:
Worth knowing before you book: the 070-761 exam is delivered Retired; previously delivered via Pearson VUE test centers or online proctored.
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.
You are developing a database to track customer orders. The database contains the following tables:
Sales.Customers, Sales.Orders, and Sales.OrderLines.
The following table describes the columns in Sales.Customers.
The following table describes the columns in Sales.Orders.
The following table describes the columns in Sales.OrderLines.
You need to create a database object that calculates the total price of an order including the sales tax. The database object must meet the following requirements:
- Reduce the compilation cost of Transact-SQL code by caching the plans and reusing them for repeated execution.
- Return a value.
- Be callable from a SELECT statement.
How should you complete the Transact-SQL statements? To answer, select the appropriate Transact-SQL segments in the answer area.
Correct Answer:

Explanation
Box 1: FUNCTION
To be able to return a value we should use a scalar function.
CREATE FUNCTION creates a user-defined function in SQL Server and Azure SQL Database. The return value can either be a scalar (single) value or a table.
Box 2: RETURNS decimal(18,2)
Use the same data format as used in the UnitPrice column.
Box 3: BEGIN
Transact-SQL Scalar Function Syntax include the BEGIN ..END construct.
CREATE [ OR ALTER ] FUNCTION [ schema_name. ] function_name
( [ { @parameter_name [ AS ][ type_schema_name. ] parameter_data_type
[ = default ] [ READONLY ] }
[ ,...n ]
]
)
RETURNS return_data_type
[ WITH <function_option> [ ,...n ] ]
[ AS ]
BEGIN
function_body
RETURN scalar_expression
END
[ ; ]
Box 4: @OrderPrice * @CalculatedTaxRate
Calculate the price including tax.
Box 5: END
Transact-SQL Scalar Function Syntax include the BEGIN ..END construct.
References: https://msdn.microsoft.com/en-us/library/ms186755.aspx
You need to develop a Transact-SQL statement that meets the following requirements:
- The statement must return a custom error when there are problems updating a table.
- The error number must be value 50555.
- The error severity level must be 14.
- A Microsoft SQL Server alert must be triggered when the error condition occurs.
Which Transact-SQL segment should you use for each requirement? To answer, select the appropriate Transact-SQL segments in the answer area.
Correct Answer:

Explanation
Box 1: TRY...CATCH
The TRY...CATCH Transact-SQL construct implements error handling for Transact-SQL that is similar to the exception handling in the Microsoft Visual C# and Microsoft Visual C++ languages. A group of Transact-SQL statements can be enclosed in a TRY block. If an error occurs in the TRY block, control is passed to another group of statements that is enclosed in a CATCH block.
Box 2: RAISERROR(50555, 14, 1 'The update failed.") WITH LOG
We must use RAISERROR to be able to specify the required severity level of 14, and we should also use the LOG option, which Logs the error in the error log and the application log for the instance of the Microsoft SQL Server Database Engine, as this enable a MS MS SQL SERVER alert to be triggered.
Note: RAISERROR generates an error message and initiates error processing for the session. RAISERROR can either reference a user-defined message stored in the sys.messages catalog view or build a message dynamically. The message is returned as a server error message to the calling application or to an associated CATCH block of a TRY...CATCH construct.
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 table variable in the stored procedure.
Does this meet the goal?
Correct Answer: B 🗳️
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 table named AuditTrail that tracks modifications to data in other tables. The AuditTrail table is updated by many processes. Data input into AuditTrail may contain improperly formatted date time values.
You implement a process that retrieves data from the various columns in AuditTrail, but sometimes the process throws an error when it is unable to convert the data into valid date time values.
You need to convert the data into a valid date time value using the en-US format culture code. If the conversion fails, a null value must be returned in the column output. The conversion process must not throw an error.
What should you implement?
Correct Answer: C 🗳️
Explanation: Only visible for Exams4sures 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 several connected tables. The tables contain sales data for customers in the United States only.
You have the following partial query for the database. (Line numbers are included for reference only.)
You need to complete the query to generate the output shown in the following table.
Which statement clause should you add at line 3?
Correct Answer: E 🗳️
Explanation: Only visible for Exams4sures members. You can sign-up / login (it's free).
Viewing page 1 out of 41 pages.
Viewing questions 1-5 out of 205 questions.
For my career, I needed this certification. so, I purchased the 070-761 training prep. Believe it or not, I found the latest exam questions along with answers. I answered well on my exam and passed highly. Thanks!
Iit is the latest 070-761 exam questions. Can not imagine it is so useful for passing exam at the first attempt. I just studied for two days and passed with ease. Thank you, all the team!
I got one version of 070-761 exam questions and later on an updated version. I studied both of them and passed with a high score. Nice to share with you! Thanks!
I just wrote and passed the 070-761 exams. The 070-761 practice dumps did help. I feel so grateful to Exams4sures!
Perfect study guide for my 070-761 exam. The 070-761 study dump is very helpful. I took and passed the 070-761 exam this morning. Cool!
Exams4sures's superb study material made it possible! Exams4sures 070-761 study Guide was available in PDF format and I downloaded it on my tab and continued reading Passed exam 070-761!
I attended the 070-761 exam today, in the real exam, I encountered most questions in the 070-761 training materials, and I had confidence that I can pass the exam this time.
Most of the questions are in the 070-761 dumps, but some answers are in correct.
I just passed the 070-761 exam. 070-761 dump had already covered all of the changes. Wonderful!
I have passed my 070-761 exam with preparing for it for about a week, carefully studied the 070-761 exam dumps and the questions are almost all from the 070-761 exam dump.
Today, I get my desired job. I think it is the 070-761 certification that makes an important effect on the job interview. Thank you to provide the best valid 070-761 exam dump.
I came here to thank you and also wanted to know, do you guys offer the Bundle Sales? I need to purchase more Microsoft exams.
We respect customer privacy. We use McAfee's security service to provide you with utmost security for your personal information & peace of mind.
Free update is available within 365 days after your purchase. After 365 days, you will get 50% discounts for updating.
Full refund if you fail the corresponding exam in 60 days after purchasing. And Free get any another product.
After Payment, our system will send you the products you purchase in mailbox in a minute after payment. If not received within 2 hours, please contact us.
If you choose us Exams4sures you can feel at ease to purchase best exam guide torrent and we will be your best select. Every year thousands candidates choose our test prep materials and clear their exams at the first attempt.
Our Working Time: ( GMT 0:00-15:00 )
From Monday to Saturday
If you have any question please leave me your email address, we will reply and send email to you in 12 hours.