mssqltips logo

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:



Last Updated: 2017-02-17


get scripts

next tip button



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
Email me updates

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.





Wednesday, January 02, 2019 - 8:55:40 AM - Sara Colarossi Back To Top

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

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



download

























get free sql tips

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



Learn more about SQL Server tools