Microsoft MCP 070-761

Certification exams change, and Getcertkey keeps pace: the 070-761 practice question set is reviewed continuously and updated free of charge for 365 days. Your Microsoft Querying Data with Transact-SQL preparation stays aligned with the current exam throughout 2026 and beyond.

Microsoft 070-761 Exam Overview:

Certification Vendor:	Microsoft
Exam Name:	Querying Data with Transact-SQL
Exam Number:	70-761
Available Languages:	Chinese (Simplified), Portuguese (Brazil), Spanish, Japanese, Korean, German, French, Russian, English
Passing Score:	700 (on a 1000 scale)
Certificate Validity Period:	Retired (no longer available; certification has been discontinued)
Exam Format:	Multiple choice, Case studies, Multiple response, Drag and drop
Exam Price:	USD 165 (varies by country/region)
Exam Duration:	120 minutes
Real Exam Qty:	40-60 (approximate)
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:

070-761 Exam FAQs for 2026 Candidates

Which certification does the 070-761 exam lead to?

The 070-761 exam is the official Microsoft exam behind the MCSA: SQL 2016 Database Development certification, validating the skills measured by the Microsoft Querying Data with Transact-SQL credential. It sits at the Associate level of the Microsoft certification program. It also connects to MCSA: SQL 2016 Database Development, 70-762 Developing SQL Databases, so the knowledge you build here carries over to those tracks as well.

How many questions are on the 070-761 exam, and how much time do I get?

The 070-761 exam contains 40-60 (approximate) questions to be completed within 120 minutes. Before exam day, divide the available time by the question count to work out a comfortable per-question pace, and mark any item that eats into it so you can return later instead of getting stuck. Timed sessions in the Getcertkey test engines make that pacing automatic — run at least two full-length mock exams under the clock so time pressure never becomes the reason you drop points.

What score do I need to pass the 070-761 exam, and what does it cost?

The passing score for the 070-761 exam is 700 (on a 1000 scale), and the official registration fee is USD 165 (varies by country/region). Retakes are not discounted — every new attempt means paying the full fee again — so it pays to measure yourself before you book. Work through the 205 practice questions on Getcertkey, sit a timed practice test, and schedule your exam only when your scores are consistently comfortable. That simple habit is the cheapest exam strategy there is.

Are there any prerequisites for the 070-761 exam?

No formal prerequisites; recommended knowledge of relational databases and basic Transact-SQL. Requirements can change when Microsoft revises its certification program, so confirm the current eligibility rules on the official exam page before you register.

How do I register for the 070-761 exam?

You can book the Microsoft Querying Data with Transact-SQL exam through the official registration channels below:

• Microsoft Learn Certification Page
• Pearson VUE Microsoft Exams

As for delivery, the exam is offered in the following format: Computer-based exam delivered via online proctoring or authorized test centers (Pearson VUE, historically).. Choose the option that suits you best when you book your seat.

What official training is recommended for the 070-761 exam?

Microsoft recommends the following training resources for the Microsoft Querying Data with Transact-SQL exam:

• Microsoft Learn T-SQL Learning Paths
• SQL Server T-SQL Documentation

Official courses build the foundation; the 205 practice questions from Getcertkey then show you how that knowledge is examined, so the two work best together.

Can I try the 070-761 practice questions before I buy?

Yes. Getcertkey provides a free 070-761 PDF demo so you can review the question style and answer quality before purchasing. Every purchase also includes 365 days of free updates — if Microsoft revises the exam during that period, the updated material reaches you at no cost. Once the free-update year ends, you can extend your update service at a 50% discount.

What if I fail the 070-761 exam, and how is my order delivered?

Every Microsoft Querying Data with Transact-SQL purchase on Getcertkey is covered by a 100% money-back guarantee with clear conditions: if you take the corresponding exam within 60 days of your purchase and do not pass, you can claim a full refund by submitting a scanned copy of your exam enrollment slip and your official score report as a PDF within two days of the exam date; claims are processed within seven days of submission. The guarantee does not apply to exams taken within three days of purchase, to material that was downloaded but never used in an exam attempt, or to free products and expired orders, and the candidate name must match the payer name. If you would rather not take a refund, you can instead exchange your purchase for two free exam preparation products of equal value and keep the update service on your original product.

Delivery is instant: your download is sent to your email within one minute of payment, with no limit on how many computers you may install the material on. If nothing arrives within two hours, check your spam folder and contact customer service for help.

What topics are covered in the 070-761 exam?

The Microsoft Querying Data with Transact-SQL exam blueprint is organized into 6 domains. The first three are:

• Data aggregation and grouping
• Modify data
• Query multiple tables

For the complete domain-by-domain breakdown, scroll up to the full exam topics outline above and use it to plan how you distribute your study time.

Microsoft Querying Data with Transact-SQL Sample Questions:

Question #1
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.

You need to design an indexed view to return customer information.
What are the requirements for creating an indexed view? Use the drop-down menus to select the answer choice that completes each statement.

Question #2
You have a database named MyDb. You run the following Transact-SQL statements:

A value of 1 in the IsActive column indicates that a user is active.
You need to create a count for active users in each role. If a role has no active users. you must display a zero as the active users count.
Which Transact-SQL statement should you run?

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

Question #3
You run the following Transact-SQL statements:

You need to create a query that returns the total number of attendees for each combination of CourseID, CourseDate, and the following locations: Lisbon, London, and Seattle. The result set should resemble the following:

Which Transact-SQL code segment should you run?

A. SELECT *
FROM CourseParticipants
PIVOT(SUM(NumParticipants) FOR LocationDescription
IN (Lisbon, London, Seattle))
B. SELECT *
FROM CourseParticipants
PIVOT(SUM(NumParticipants) FOR LocationDescription
IN (Lisbon, London, Seattle)) as PVTTable
C. SELECT *
FROM CourseParticipants
UNPIVOT(SUM(NumParticipants) FOR LocationDescription
IN (Lisbon, London, Seattle) AS PVTTable
D. SELECT *
FROM CourseParticipants
UNPIVOT(SUM(NumParticipants) FOR LocationDescription
IN (Lisbon, London, Seattle)

Question #4
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 create a table by running the following Transact-SQL statement:

You are developing a report that aggregates customer data only for the year 2014. The report requires that the data be denormalized.
You need to return the data for the report.
Which Transact-SQL statement should you run?

A. Option G
B. Option C
C. Option F
D. Option B
E. Option E
F. Option A
G. Option H
H. Option D

Question #5
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 G
B. Option C
C. Option F
D. Option B
E. Option E
F. Option A
G. Option H
H. Option D

Solutions: