Prepare for Microsoft Exam 70-764 and help demonstrate your real-world mastery of skills for database administration. This exam is intended for database administrators charged with installation, maintenance, and configuration tasks. Their responsibilities also include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.

Focus on the expertise measured by these objectives:

• Configure data access and auditing

• Manage backup and restore of databases

• Manage and monitor SQL Server instances

• Manage high availability and disaster recovery

This Microsoft Exam Ref:

• Organizes its coverage by exam objectives

• Features strategic, what-if scenarios to challenge you

• Assumes you have working knowledge of database installation, configuration, and maintenance tasks. You should also have experience with setting up database systems, ensuring those systems operate efficiently, regularly storing and backing up data, and securing data from unauthorized access.

About the Exam

Contents

Chapter 1 Configure data access and auditing 

Skill 1.1: Configure encryption

Skill 1.2 Configure data access and permissions

Skill 1.3: Configure auditing

Chapter 2 Manage backup and restore of databases

Skill 2.1: Develop a backup strategy

Skill 2.2 Restore databases

Skill 2.3 Manage database integrity

Chapter 3 Manage and monitor SQL Server instances

Skill 3.1: Monitor database activity

Skill 3.2 Monitor queries

Skill 3.3 Manage indexes

Skill 3.4 Manage statistics

Chapter 4 Manage high availability and disaster recovery

Skill 4.1: Design a high availability solution

Skill 4.2: Design a disaster recovery solution

Skill 4.3: Implement log shipping

Skill 4.4: Implement Availability Groups

Skill 4.5: Implement failover clustering