Exam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance
1. Installing and Configuring SQL Server 2008
• Install SQL Server 2008 and related services
• Configure SQL Server instances
• Configure SQL Server services
• Configure additional SQL Server components
• Implement database mail
• Configure full-text indexing
2. Maintaining SQL Server Instances
• Manage SQL Server Agent jobs
• Manage SQL Server Agent alerts
• Manage SQL Server Agent operators
• Implement the declarative management framework (DMF)
• Back up a SQL Server environment
3. Managing SQL Server Security
• Manage logins and server roles
• Manage users and database roles
• Manage SQL Server instance permissions
• Manage database permissions
• Manage schema permissions and object permissions
• Audit SQL Server instances
• Manage transparent data encryption
• Configure surface area
4. Maintaining a SQL Server Database
• Back up databases
• Restore databases
• Manage and configure databases
• Manage database snapshots
• Maintain database integrity
• Maintain a database by using maintenance plans
5. Performing Data Management Tasks
• Import and export data
• Manage data partitions
• Implement data compression
• Maintain indexes
• Manage collations
6. Monitoring and Troubleshooting SQL Server
• Identify SQL Server service problems
• Identify concurrency problems
• Identify SQL Agent job execution problems
• Locate error information
7. Optimizing SQL Server Performance
• Implement Resource Governor
• Use the Database Engine Tuning Advisor
• Collect trace data by using SQL Server Profiler
• Collect performance data by using Dynamic Management Views (DMVs)
• Collect performance data by using System Monitor
• Use Performance Studio
8. Implementing High Availability
• Implement database mirroring
• Implement a SQL Server clustered instance
• Implement log shipping
• Implement replication
Exam 70-450: PRO: Designing, Optimizing, and Maintaining a
Database Administrative Solution using Microsoft SQL Server
2008
1. Designing a SQL Server Instance and a Database Solution
• Design for CPU, memory, and storage capacity requirements
• Design SQL Server instances
• Design physical database and object placement
• Design a migration, consolidation, and upgrade strategy
2. Designing a Database Server Security Solution
• Design instance authentication
• Design instance-level security configurations
• Design database, schema, and object security parameters
• Design a security policy and an audit plan
• Design an encryption strategy
3. Designing a Database Solution for High Availability
• Design a failover clustering solution
• Design database mirroring
• Design a high-availability solution that is based on replication
• Design a high-availability solution that is based on log shipping
• Select high-availability technologies based on business requirements
4. Designing a Backup and Recovery Solution
• Design a backup strategy
• Design a recovery strategy
• Design a recovery test plan
5. Designing a Monitoring Strategy
• Design a monitoring solution at the operating-system level
• Design a monitoring solution at the instance level
• Design a solution to monitor performance and concurrency
6. Designing a Strategy to Maintain and Manage Databases
• Design a maintenance strategy for database servers
• Design a solution to govern resources
• Design policies by using Policy-Based Management
• Design a data compression strategy
• Design a management automation strategy
7. Designing a Strategy for Data Distribution
• Administer SQL Server Integration Services (SSIS) packages
• Design a strategy to use linked servers
• Design a replication strategy for data distribution
Exam 70-453: Upgrade: Transition Your MCITP SQL Server 2005
DBA to MCITP SQL Server 2008
1. Installing and Configuring SQL Server 2008
• Install SQL Server 2008 and related services
• Configure SQL Server instances
• Configure SQL Server services
2. Maintaining SQL Server Instances
• Manage SQL Server Agent jobs
• Implement the declarative management framework (DMF)
• Backup a SQL Server environment
3. Managing SQL Server Security
• Manage users and database roles
• Manage SQL Server instance permissions
• Manage schema permissions and object permissions
• Audit SQL Server instances
4. Maintaining a SQL Server Database
• Back up databases
• Restore databases
• Manage and configure databases
5. Performing Data Management Tasks
• Manage data partitions
• Maintain indexes
6. Monitoring and Troubleshooting SQL Server
• Identify SQL Server service problems
• Identify concurrency problems
7. Optimizing SQL Server Performance
• Collect trace data by using SQL Server Profiler
• Collect performance data by using Dynamic Management Views (DMVs)
• Use Performance Studio
8. Implementing High Availability
• Implement database mirroring
• Implement a SQL Server clustered instance
9. Designing a SQL Server Instance and a Database Solution
• Design for CPU, memory, and storage capacity requirements
• Design physical database and object placement
10. Designing a Database Server Security Solution
• Design database, schema, and object security parameters
• Design a security policy and audit plan
11. Designing a Database Solution for High Availability
• Select high-availability technologies based on business requirements
• Design a failover clustering solution
• Design database mirroring
12. Designing a Backup and Recovery Solution
• Design a backup strategy
• Design a recovery strategy
• Design a recovery test plan
13. Designing a Monitoring Strategy
• Design a monitoring solution at the instance level
• Design a solution to monitor performance and concurrency
14. Designing a Strategy to Maintain and Manage Databases
• Design a maintenance strategy for database servers
• Design a management automation strategy
15. Designing a Strategy for Data Distribution
• Administer SQL Server Integration Services (SSIS) packages
• Design a replication strategy for data distribution