Administering a SQL Database Infrastructure

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. Coverage includes:

• Configuring data access and auditing, including encryption, data access, permissions, and more
• Managing database backup/restore: developing backup strategies, performing backups/restores, and managing database integrity
• Managing and monitoring SQL Server instances: monitoring database activity and queries; managing indexes and statistics, and monitoring instances
• Managing high availability and disaster recovery: implementing log shipping, AlwaysOn Availability Groups, and failover cluster instances

Microsoft Exam Ref publications stand apart from third-party study guides because they:

• Provide guidance from Microsoft, the creator of Microsoft certification exams
• Target IT professional-level exam candidates with content focused on their needs, not "one-size-fits-all" content
• Streamline study by organizing material according to the exam's objective domain (OD), covering one functional group and its objectives in each chapter
• Feature Thought Experiments to guide candidates through a set of "what if?" scenarios, and prepare them more effectively for Pro-level style exam questions
• Explore big picture thinking around the planning and design aspects of the IT pro's job role

For more information on Exam 70-764 and the MCSA: SQL Server 2016 Database Administration certification, visit microsoft.com/learning