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
- 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)

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 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