Exam Ref 70-764 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 moreManaging database backup/restore: developing backup strategies, performing backups/restores, and managing database integrityManaging and monitoring SQL Server instances: monitoring database activity and queries; managing indexes and statistics, and monitoring instancesManaging high availability and disaster recovery: implementing log shipping, AlwaysOn Availability Groups, and failover cluster instancesMicrosoft Exam Ref publications stand apart from third-party study guides because they:Provide guidance from Microsoft, the creator of Microsoft certification examsTarget IT professional-level exam candidates with content focused on their needs, not ”one-size-fits-all” contentStreamline study by organizing material according to the exam’s objective domain (OD), covering one functional group and its objectives in each chapterFeature Thought Experiments to guide candidates through a set of ”what if?” scenarios, and prepare them more effectively for Pro-level style exam questionsExplore big picture thinking around the planning and design aspects of the IT pro’s job roleFor more information on Exam 70-764 and the MCSA: SQL Server 2016 Database Administration certification, visit microsoft.com/learning