Three versions, one decision: the Microsoft Querying Data with Transact-SQL package from ActualPDF comes as a budget-friendly printable PDF, a Windows software engine that flags your mistakes for re-practice, and an online version for any operating system. All carry the same 205 070-761 questions.

Microsoft 070-761 Exam Overview:

Certification Vendor:	Microsoft
Exam Name:	Querying Data with Transact-SQL
Exam Number:	70-761
Real Exam Qty:	40-60
Available Languages:	German, Portuguese (Brazil), Chinese (Simplified), Chinese (Traditional), Russian, French, English, Japanese
Related Certifications:	MCSA: SQL 2016 Database Development
Passing Score:	700/1000
Certificate Validity Period:	No fixed expiration for earned legacy certification; exam retired on January 31, 2021
Exam Format:	Multiple choice, Short answer, Hot area, Multiple response, Build list, Active screen, Review screen, Drag and drop
Exam Duration:	120 minutes
Exam Price:	$165 USD
Sample Questions:
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.

Microsoft 070-761 Exam Syllabus Topics:

Section

Weight

Objectives

Topic 1: Manage data with Transact-SQL

40-45%

- Create Transact-SQL SELECT queries

1. Identify proper SELECT query structure
2. Write queries to satisfy business requirements
3. Identify queries that return expected results based on table structure or data
4. Construct results from multiple queries using set operators
5. Distinguish between UNION and UNION ALL behavior

- Modify data

1. Write UPDATE statements
2. Use the OUTPUT statement
3. Write INSERT statements
4. Write DELETE statements

- Implement functions and aggregate data

1. Use scalar functions
2. Use aggregate functions
3. Use ranking functions
4. Use GROUP BY and HAVING

- Query multiple tables by using joins

1. Write queries using self joins
2. Handle NULL values in join columns
3. Write queries using outer joins
4. Write queries using cross joins
5. Write queries using inner joins

Topic 2: Query data with advanced Transact-SQL components

30-35%

- Query data by using table expressions

1. Use inline table-valued functions
2. Use derived tables
3. Use views
4. Use common table expressions

- Query temporal and non-relational data

1. Query temporal tables
2. Query XML data
3. Query JSON data
4. Output results as XML or JSON

- Group and pivot data by using queries

1. Use PIVOT and UNPIVOT
2. Use ROLLUP and CUBE
3. Use grouping sets

- Query data by using subqueries and APPLY

1. Use APPLY
2. Use EXISTS and NOT EXISTS
3. Use correlated and non-correlated subqueries

Topic 3: Program databases by using Transact-SQL

25-30%

- Implement data types and NULLs

1. Handle NULL values
2. Use implicit and explicit conversions
3. Choose appropriate data types

- Create database programmability objects by using Transact-SQL

1. Create user-defined functions
2. Create views
3. Create stored procedures

- Implement error handling and transactions

1. Implement transactions
2. Use TRY...CATCH
3. Use THROW and RAISERROR
4. Manage transaction isolation

Microsoft 070-761 Exam: FAQ for Serious Candidates

What is the 070-761 exam all about?

Microsoft Querying Data with Transact-SQL is an official Microsoft exam, listed under exam code 070-761. A passing result earns you the MCP certification at the Associate level. It also ties into MCSA: SQL 2016 Database Development, extending its value across your certification roadmap. Employers read this credential as verified competence, which is why it keeps appearing in job requirements.

How many questions are in the 070-761 exam, and how long do I have?

Expect 40-60 questions inside 120 minutes on the Microsoft Querying Data with Transact-SQL exam. That pace punishes hesitation, so rehearse it: the ActualPDF software engine simulates the real exam scene, reminds you of the questions you got wrong, and pushes you to re-practice them until the clock stops being your enemy.

What is the 070-761 passing score, and how expensive is the exam?

Passing Microsoft Querying Data with Transact-SQL requires 700/1000, and the official registration fee is $165 USD. Retakes charge the full $165 USD again, which is why experienced candidates treat preparation as the cheaper exam fee. Verify your readiness with repeated ActualPDF practice scores above the requirement before you commit to a date.

What do I need before sitting the 070-761 exam?

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.

Requirements evolve, so confirm the current conditions before registering.

Can I preview the 070-761 questions before purchasing?

Yes. ActualPDF provides a free download demo of the Microsoft Querying Data with Transact-SQL material, so you can check the content before choosing a version. After purchase, a one-year warranty covers you: the latest version is sent to you as it releases, free for 365 days, and after expiry you can extend the update service at a 50% discount.

What if I fail the 070-761 exam, and how fast is delivery?

Your purchase is covered by a 100% money-back guarantee with clear conditions. Take the Microsoft Querying Data with Transact-SQL exam within 60 days of purchase; if you fail, provide your unqualified result by submitting a scanned enrollment slip and the official Score Report PDF within 2 days of the exam, and the full refund is processed within 7 days. The exam must match your product, candidate and payer names must match, and attempts within 3 days of purchase, unused downloads, free materials, and expired orders are not covered. Alternatively, exchange for two other exam products of equal value, free, or wait for updates while keeping your original product's update service.

Delivery is instant: files unlock for download at payment and are emailed within one minute. If nothing arrives within 2 hours, check spam and contact customer service, which works 7/24 and normally replies within two hours. Installation is unlimited across your computers.

What topics are covered in the 070-761 exam?

The Microsoft Querying Data with Transact-SQL syllabus spans 3 domains, led by Manage data with Transact-SQL (40-45%), Query data with advanced Transact-SQL components (30-35%), and Program databases by using Transact-SQL (25-30%). The complete topic list is published above; candidates who study the map first rarely get lost later.

Microsoft Querying Data with Transact-SQL Sample Questions:

Question 1

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 need to create a query that generates sample data for a sales table in the database. The query must include every product in the inventory for each customer.
Which statement clause should you use?

A. CROSS JOIN
B. GROUP BY
C. PIVOT
D. LEFT JOIN
E. MERGE
F. GROUP BY ROLLUP
G. GROUP BY CUBE
H. UNPIVOT

Question 2

You are a database administrator for an online retail store. You create a table to track orders by running the following Transact-SQL statement:

You need to create a report that includes the following information:
* Total sales for each year
* Total sales for each category
* Total sales for each category per year
How should you complete the Transact-SQL statement? To answer, drag the appropriate Transact-SQL segment to the correct locations. Each Transact-SQL segment may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Question 3

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 display customers who appear in both tables and have a proper CustomerCode.
Which Transact-SQL statement should you run?

A. Option C
B. Option E
C. Option B
D. Option A
E. Option D

Question 4

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?