ExamDumpster

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
Try the free samples first
Microsoft logo
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.

Open the full exam guide

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 simulator

Timed mode

A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.

Open in the simulator

Flashcards

Question on the front, answer on the back. Good for the last week before the exam.

Open in the simulator

70-761 questions, answered