- Published 9/26/2017
- 1st Edition
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
Exam 70-764 focuses on skills and knowledge required for database administration.
About Microsoft Certification
Passing both Exam 70-764 and Exam 70-765 (Provisioning SQL Databases) earns you credit toward an MCSA: SQL 2016 Database Administration certification. See full details at: microsoft.com/learning
Sample Pages
Download the sample pages (includes Chapter 4 and the Index)
Table of Contents
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
Skill 3.5 Monitor SQL Server instances
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
Errata
We've made every effort to ensure the accuracy of this book and its companion content. Any errors that have been confirmed since this book was published can be downloaded below.
Download the errata
If you find an error, you can report it to us through our Submit errata page.