This package is targeted at the professional level SQL Server 2008 Database Administrator. It tests your ability to make appropriate design and technology choice considerations for your SQL Server 2008 installations. Candidates for this exam work in an environment in which Microsoft SQL Server 2008 is used for database solutions. Candidates should have at least three years of experience administering databases in an enterprise-level organization and designing, deploying, optimizing, maintaining, and supporting database service life cycle. Candidates should also have experience with the following: •Defining high-availability solutions •Data distribution •Automating administrative tasks (for example, checking db stats, backups) •Maintaining administrative tasks (for example, determining index rebuild time, file groups for backup) •Defining security solutions •Monitoring and troubleshooting the database server •Performance optimization (for example, physical tuning, including hardware, operating system, instance-level tuning), PerfMon •Designing and executing deployments •Deployments and migration •Defining the infrastructure (for example, storage, hardware, and number of servers or instances)
Designing, Optimizing, and Maintaining a Database Administrative Solution for Microsoft SQL Server 2008 | 42 |
Exam # | Duration | Language | Level | Type | Classroom | Code | Fees |
70-450 | 48 | English | Professional | Course | Classroom | Cs435 | 0 LE |
Microsoft Official Courseware (MOC)
This Package includes several labs to ensure you will gain the targeted skills and experience
Exam 70-450: PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008: counts as credit toward the following certification(s): Microsoft Certified IT Professional: Database Administrator 2008