ExamDumpster

70-764

Administering a SQL Database Infrastructure practice test

366 Microsoft DP-300, 70-764 and 70-765 practice questions with explanations, in study, timed and flashcard modes. 8 sample questions are free.

Full access

$99

  • All 366 questions across DP-300, 70-764 and 70-765, with explanations
  • Study, timed and flashcard modes
  • Progress saved, resume any time
Try the free samples first
Microsoft logo
Total questions
366
Free samples
8
Versions
3
Updated
Oct 2026

Exam simulator

Practice 70-764 in the simulator.

Study, timed and flashcard modes. Answers and explanations as you go, and your progress saves.

At a glance

70-764, by the numbers.

Official specifications published by Microsoft.

In the bank
DP-300 (269), 70-764 (49), 70-765 (48)
Open the full exam guide

Exam guide

Everything about 70-764.

70-764 ยท Microsoft

What is 70-764?

SQL Server database administrators took 70-764 to show they could secure, back up and run SQL Server. It was one half of MCSA: SQL 2016 Database Administration, and Microsoft retired it in January 2021. Microsoft's current exam for database administrators is DP-300, which focuses on Azure SQL. An Always On availability group keeps copies of a set of databases on several servers, so one can take over if another fails. For example, you may plan full, differential and log backups so you can restore a database to a point in time. Security and auditing, backup and restore, monitoring and high availability are the main areas of the practice test.

What you'll practise

  • Control access with logins, users, roles and permissions on database objects.
  • Protect data with Transparent Data Encryption, Always Encrypted and auditing.
  • Plan backups, restore databases to a point in time and check database integrity.
  • Monitor activity, queries, indexes and statistics on SQL Server instances.
  • Set up Always On availability groups, failover cluster instances and log shipping.
  • Automate maintenance with SQL Server Agent jobs and alerts.

Requirements

  • Recommended: hands-on experience administering SQL Server databases.

Who it's for

  • Database administrators who run on-premises SQL Server.
  • IT staff reviewing SQL Server administration before DP-300.

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-764 questions, answered