|
Core
Exams
|
One
Exam Required
|
|
70–431 |
Implementing a MS
SQL Server 2005 Database
|
Maintaining a MS SQL
Server 2005 Database
|
Topics |
•
Installing
and Configuring SQL Server 2005
• Implementing High
Availability and Disaster Recovery
• Supporting Data
Consumers
• Maintaining
Databases
• Monitoring and
Troubleshooting SQL Server Performance
• Creating and
Implementing Database Objects |
|
|
|
|
Core
Exams
|
One
Exam Required
|
|
70–443 |
Designing a MS SQL
Server 2005 Infrastructure
|
Designing Security
for MS SQL Server 2005
|
Designing High
Availability Database Solutions Using MS SQL
Server 2005
|
Topics |
•
Designing a Database Server Infrastructure
• Designing Security for a
Database Server Solution
• Designing a Physical
Database
• Designing a Database
Solution for High Availability
• Designing a Data Recovery
Solution for a Database
• Designing a Strategy for
Data Archiving |
|
|
|
|
Core
Exams
|
One
Exam Required
|
|
70–444 |
Administering and
Automating MS SQL Server 2005 Databases and
Services 2005
|
Troubleshooting
and Optimizing Database Servers Using MS SQL
Server 2005
|
Topics |
•
Optimizing the Performance of Database Servers and
Databases
• Optimizing and Implementing
a Data Recovery Plan for a Database
• Designing a Strategy to
Monitor and Maintain a Database Solution
• Designing a Database Data
Management Strategy
• Designing a Strategy to
Manage and Maintain Database Security |