Study material for exam 70-764 Administering a SQL Database Infrastructure

By:   |   Updated: 2017-02-17   |   Comments (2)   |   Related: 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:



sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip



About the author
MSSQLTips author Daniel Calbimonte Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and 6-time Microsoft Certified IT Professional. Daniel started his career in 2001 and has worked with SQL Server 6.0 to 2022. Daniel is a DBA as well as specializes in Business Intelligence (SSIS, SSAS, SSRS) technologies.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips


Article Last Updated: 2017-02-17

Comments For This Article




Wednesday, January 2, 2019 - 8:55:40 AM - Sara Colarossi Back To Top (78600)

i am  studying this exam adn i have found query like this

You are the database administrator for a company that hosts Microsoft SQL Server. You manage both on-premises and Microsoft Azure SQL Database environments. One instance hosts a user database named HRDB. The database contains sensitive human resources data. You need to grant an auditor permission to view the SQL Server audit logs while following the principle of least privilege. Which permission should you grant?

A. DDLAdmin

B. db_datawriter

C. dbcreator

D. dbo

E. View Database State

F. View Server State

G. View Definition

H. sysadmin

the answer of many sites is F View Server State, but i don't understand. I know that to view an audit log i must have control Server. Am i wrong ?


Tuesday, July 31, 2018 - 8:36:55 PM - Oddvar Eikli Back To Top (76920)

Hi,

Victor Isakov's Exam Ref book for 70-764 is now available:

https://www.microsoft.com/en-us/p/exam-ref-70-764-administering-a-sql-database-infrastructure/fgqpf3gzmxqc

Cheers,

Oddvar















get free sql tips
agree to terms