TS: Microsoft SQL Server 2008, Implementation and Maintenance (70-432)

After passing the certification for 2005, I've been given the opportunity to write the 70-432 beta exam. It's the same basic exam as the 2005 version, except, naturally, for 2008. I would hazard a guess that it's going to cover much of the same material, and cover all the new stuff for 2008. Luckily from a management perspective there aren't too many life-altering differences. For the complete rundown of whats going to be covered on the actual RTM exam (couldn't think of a better way to differentiate between the two :)) you can find information here: http://www.microsoft.com/learning/en/us/exams/70-432.mspx.

However, seeing as most people are lazy (Myself included) I'll give a quick rundown of what to expect.

***NOTE*** This information may be outdated by the time the exam is released. It falls under the same category as beta API's.

Installing and Configuring SQL Server 2008 (10 %)
  • Installation: File Locations, default paths, service accounts
  • Configuration of Instances: mostly sp_configure
  • Configuration of services: Configuration Manager, SQL Browser
  • Configuration of Components: SSIS, SSAS, SSRS, Replication
  • Setting up and using SQL Mail
  • Enabling/Disabling and creating indexes
Maintaining SQL Server Instances (13 %)
  • Managing SQL Agent jobs
  • Managing SQL Agent alerts
  • Manage SQL Agent operators
  • Implementation of the Declarative Management Framework
  • Backup and restoration of SQL Server environment (OS and database levels)
Managing SQL Server Security (15 %)
  • Logins and Server Roles
  • Users and Database Roles
  • Instance permissions
  • Schema and object permissions
  • Auditing of SQL Server instances
  • Transparent data encryption
  • Surface area configurator
Maintaining a SQL Server database (16 %)
  • Backup databases
  • Restore databases
  • Manage/configure databases: files, filegroups, recovery models, etc
  • Database snapshots
  • Maintaining database integrity: DBCC, CHECKDB, suspect pages
  • Maintence plans
Performing data management tasks (14 %)
  • Importing/Exporting data: BCP, BULK INSERT, COPY ROWSET, etc
  • Managing data partitions
  • Data compression
  • Maintain Indexes
  • Manage collations
Monitoring and Troubleshooting SQL Server (13 %)
  • Identify SQL Server service problems
  • Identify concurrency problems: locking, blocking, etc
  • Identify SQL Agent job execution problems
  • Locate error information
Optimizing SQL Performance (10 %)
  • Implement resource governor
  • Database engine tuning advisor
  • Collect trace data by using SQL Server Profiler
  • Collect performance through Dynamic management views
  • Collect performace data through System Monitor
  • Use Performance Studio
Implementing High Availability (9 %)
  • Implement database mirroring
  • Implement clustered instances
  • Implement log shipping
  • Implement replication
I have set up my exam for June 30th. Time to study my butt off. From what everyone else has told me, who have taken beta exams in the past, they tend to be much harder than the final exams. The idea is that they chop off the easiest questions and the hardest questions from the beta exam and from that they do some mathematical reasoning to pick and choose from whats left over. In the end they have a fully working exam. Unfortunately, Microsoft forces us to sign Non-Disclosure Agreements when we take the exams so no details of what I actually found on the exam will be posted. Let's hope it's not that scary. ;)