Skip to main content

Posts

Showing posts from October, 2008

Beta Exam 71-433: TS: Microsoft SQL Server 2008, Database Development

Did this exam on Friday afternoon (10/10/08).

I wrote down the significant tested 'areas' and counted the number of times they came up. The exam format was 75 X multi choice questions, no practical component. It went a bit like this:
XML ~12 questionsCLR ~2 questionsService Broker ~3 questionsRecursion ~3 questionsTriggers (DML/DDL) ~5 questionsFull Text Index ~3 questionsDatabase Mail ~2 questionsMonitoring and Troubleshooting (DMV, process monitoring, etc) ~7 questionsSpatial Datatypes (Geography/Geometry) 1 questionWindows Powershell 1 question (cmdlet)
Database/Server Collation ~2 questionsChange Tracking ~7 questions
etc ...Actually I think that this preparation guide provides quite an accurate summary of what to expect: http://www.microsoft.com/learning/en/us/exams/70-433.mspx

Areas of emphasis seemed to be general query implementation, XML based data management, triggers and change tracking. Some questions were clearly not directly targeting knowledge of these emphasised fea…