![]() |
![]() |
Twoje konto | Zarejestruj | Schowek | Kontakt | Pomoc |
![]() Exam Ref 70-764 Administering a SQL Database Infrastructure
Exam Ref 70-764Administering a SQL Database InfrastructurePrepare 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 Contents Chapter 1 Configure data access and auditing Skill 1.1: Configure encryption Skill 1.2 Configure data access and permissions Skill 1.3: Configure auditing Chapter 2 Manage backup and restore of databases Skill 2.1: Develop a backup strategy Skill 2.2 Restore databases Skill 2.3 Manage database integrity Chapter 3 Manage and monitor SQL Server instances Skill 3.1: Monitor database activity Skill 3.2 Monitor queries Skill 3.3 Manage indexes Skill 3.4 Manage statistics Skill 3.5 Monitor SQL Server instancesChapter 4 Manage high availability and disaster recovery Skill 4.1: Design a high availability solution Skill 4.2: Design a disaster recovery solution Skill 4.3: Implement log shipping Skill 4.4: Implement Availability Groups Skill 4.5: Implement failover clustering |
|