This eBook includes the following formats, accessible from your Account page after purchase:
EPUB The open industry format known for its reflowable content and usability on supported mobile devices.
MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.
PDF The popular standard, used most often with the free Adobe® Reader® software.
This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
Also available in other formats.
Register your product to gain access to bonus material or receive a coupon.
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
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 statisticsSkill 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