Exam Ref 70-764 Administering a SQL Database Infrastructure

Description

• 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

• Authoritative and complete MCSA Exam 70-764 preparation content, straight from Microsoft
• Covers configuring data access and auditing, managing database backup/restore; managing/monitoring SQL Server instances, and managing high availability and disaster recovery
• Organized by exam objectives for efficient study
• Strategic, what-if scenarios challenge you as an exam candidate, helping you master the big-picture thinking the exam demands
• Contains up-to-date exam preparation tips from a long-time Microsoft SQL MVP and Microsoft Certified Trainer (MCT)

Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-764 Administering a SQL Database Infrastructure certification exam, the first of two exams required for MCSA: SQL 2016 Database Administration certification.

 

Exam Ref 70-764 Administering a SQL Database Infrastructure offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern database professionals need to succeed with SQL database administration.

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.

Prepare for Microsoft MCSA Exam 70-764 — and demonstrate your skills in administering modern SQL database systems and infrastructure

• Authoritative and complete MCSA Exam 70-764 preparation content, straight from Microsoft
• Covers configuring data access and auditing, managing database backup/restore; managing/monitoring SQL Server instances, and managing high availability and disaster recovery
• Organized by exam objectives for efficient study
• Strategic, what-if scenarios challenge you as an exam candidate, helping you master the big-picture thinking the exam demands
• Contains up-to-date exam preparation tips from a long-time Microsoft SQL MVP and Microsoft Certified Trainer (MCT)

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

 

Additional information

Dimensions	1.00 × 7.40 × 8.90 in
Series	Exam Ref
Imprint	Microsoft Press
Format	gen
ISBN-13	09781509303830
ISBN-10	1509303839
Author	Victor Isakov
BISAC	COM055020
Subjects	certification, higher education, Employability, IT Professional, COM055020, H-36 MS PRESS PEARSN CERTFCTN