Home > Store

Exam Ref 70-764 Administering a SQL Database Infrastructure

Exam Ref 70-764 Administering a SQL Database Infrastructure

eBook (Watermarked)

  • Your Price: $25.59
  • List Price: $31.99
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader 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.


  • Copyright 2018
  • Dimensions: 7-3/8" x 9"
  • Edition: 1st
  • eBook (Watermarked)
  • ISBN-10: 1-5093-0389-8
  • ISBN-13: 978-1-5093-0389-2

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



Click the buttons below to download this book's support files (.pdf).

Chapter 1
Chapter 2
Chapter 3
Chapter 4
All URLs

Sample Content

Sample Pages

Download the sample pages (includes Chapter 4 and the Index)

Table of 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



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

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership