Exam Ref 70-764 Administering a SQL Database Infrastructure

by Victor Isakov

Overview

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

Product Details

ISBN-13:	9781509303830
Publisher:	Pearson Education
Publication date:	09/18/2017
Series:	Exam Ref
Pages:	416
Product dimensions:	7.40(w) x 8.90(h) x 1.00(d)

About the Author

Victor Isakov is a Microsoft Certified Master, Microsoft Certified Architect, and Microsoft Certified Trainer. He’s worked with SQL Server since 1994 and is a Microsoft SQL Server MVP. Victor is the author of MCITP Developer: Microsoft SQL Server 2005 Database Solutions Design (Exam 70-441) Study Guide (Sybex, 2006) and co-author of MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide (Sybex, 2007). He also co-authored the Microsoft SQL Server 2005 Administrator’s Companion (Microsoft Press, 2006) and helped to create the High Availability course for Microsoft’s official curriculum. Currently Victor is based in Sydney, Australia, and provides consulting and training services to organizations worldwide.

Table of Contents

• 1. Configure Data Access and Auditing
• 2. Manage Backup and Restore of Databases
• 3. Manage and Monitor SQL Server Instances
• 4. Manage High Availability and Disaster Recovery