70-761
Querying Data with Transact-SQL practice test
52 Microsoft 70-761 practice questions with explanations, in study, timed and flashcard modes. 12 sample questions are free.
Full access
$99
- All 52 questions, with explanations
- Study, timed and flashcard modes
- Progress saved, resume any time
- 2 packages, bundle from $148.99
- Questions
- 52
- Free samples
- 12
- Versions
- 1
- Updated
- Sep 2021
Exam simulator
Practice 70-761 in the simulator.
Study, timed and flashcard modes. Answers and explanations as you go, and your progress saves.
At a glance
70-761, by the numbers.
Official specifications published by Microsoft.

Exam guide
Everything about 70-761.
70-761 ยท Microsoft
What is 70-761?
70-761 tested whether you could write Transact-SQL queries to read and change data in SQL Server. It counted toward MCSA: SQL 2016 Database Development, and Microsoft retired it in January 2021. Database developers, analysts and report writers took it. Transact-SQL (T-SQL) is Microsoft's version of SQL, with extra features such as variables and error handling. A question might ask you to join three tables and group the results to total sales by region. This practice test covers querying and changing data, subqueries and window functions, and T-SQL programming.
What you'll practise
- Write SELECT queries that filter, sort and join data from several tables.
- Insert, update and delete data, and use built-in functions and aggregates.
- Write subqueries, common table expressions and APPLY queries.
- Group and pivot data, and use window functions for running totals.
- Query JSON and XML data and temporal tables.
- Create stored procedures and functions, and handle errors and transactions.
Requirements
- Recommended: hands-on experience writing queries against SQL Server databases.
Who it's for
- Database developers and analysts who write T-SQL every day.
- Report writers and data staff who query SQL Server.
Three ways to practise
Study mode
Work through the bank at your own pace with the answer and explanation one tap away. Flag questions, add notes, bookmark the hard ones.
Open in the simulatorTimed mode
A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.
Open in the simulatorFlashcards
Question on the front, answer on the back. Good for the last week before the exam.
Open in the simulator