Learn more about SQL Server tools

 

Tutorials          DBA          Dev          BI          Career          Categories          Videos          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Events

DBA    Dev    BI    Categories

 

Exam material for the Microsoft 70-764, Administering a SQL Database Infrastructure


By:   |   Read Comments   |   Related Tips: More > Professional Development Certifications

Problem

I am going to take the Microsoft exam 70-764, Administering a SQL Database Infrastructure. I would like to know what materials I can use to study and help pass this exam.

Solution

In this article, we will talk about materials that can be used to help study for this exam.

What is the 70-764 certification exam?

This is oriented for DBAs and covers security, backups, monitoring and high availability solutions.

Is it an exam for database developers?

This exam is for DBAs, but database developers can find some of the topics useful.

Is it an exam oriented to SQL Server 2016?

Yes, this is an exam is oriented to SQL Server 2016 and Azure SQL.

Which SQL Server 2012/2014 exam is similar to this one?

The 70-462 is similar to this new exam, but some topics were changed. This exam contains more Azure SQL related topics and a lot of topics were removed in this exam like installation, maintenance, replication and import/export data.

Is this exam difficult?

We believe that these new exams are less extensive than the older ones and it should take less time to study.

Are there some virtual labs?

Yes, there are some virtual labs. They are very useful to save time and contain some practice labs:

Some of the labs like the AlwaysOn labs are in SQL 2014, but they are still recommended for this exam.

Which books would you recommend for this exam?

There is no Training Kit book yet, but older books for old exams may help for this one. Here are some:

  1. Training Kit (Exam 70-462) Administering Microsoft SQL Server 2012 Databases (MCSA) (Microsoft Press Training Kit)
  2. Professional Microsoft SQL Server 2014 Administration
  3. Microsoft Azure SQL Database Step by Step (Step by Step Developer)
  4. Pro SQL Server on Microsoft Azure (specially chapter 8-10)

Which courses would you recommend for this exam?

The official Microsoft course is the 20764B, Administering a SQL Database Infrastructure.

There will be a specific MVA course in the future, but not for now. Other courses provided by are:

What links do you recommend reading for this exam?

Here are some useful links:

Configure data access and auditing

Manage backup and restore of databases

Manage and monitor SQL Server instances

Next Steps

Here are more links that will be useful:



Last Update:






About the author
MSSQLTips author Daniel Calbimonte Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and Microsoft Certified IT Professional.

View all my tips
Related Resources


 









Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


Get free SQL tips:

*Enter Code refresh code     



Learn more about SQL Server tools