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 & 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 & auditing including encryption data access permissions & more Managing database backuprestore developing backup strategies performing backupsrestores & managing database integrity Managing & monitoring SQL Server instances monitoring database activity & queries; managing indexes & statistics & monitoring instances Managing high availability & disaster recovery implementing log shipping Always On Availability Groups & 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 & its objectives in each chapter Feature Thought Experiments to guide candidates through a set of what if? scenarios & prepare them more effectively for Pro-level style exam questions Explore big picture thinking around the planning & design aspects of the IT pro's job role For more information on Exam 70-764 & the MCSA SQL Server 2016 Database Administration certification visit microsoftcomlearning