Announcing an all-new Microsoft Certified IT Professional (MCITP) Training Kit designed to help maximize your performance on Exam 70-444, an exam for the new MCITP: Database Administrator certification. This kit packs the tools and features exam candidates want mostincluding in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and a robust testing suite. It also provides real-world scenarios, case study examples, and troubleshooting labs for skills and expertise that you can apply to the job.
Focusing on SQL Server 2005, this official study guide covers topics such as optimizing the performance of database servers, implementing a data recovery plan, designing a strategy for monitoring and maintaining a database, designing a database management strategy, and designing a strategy to manage and maintain database security.
Ace your exam preparation and ramp up quickly on SQL Server 2005 database administration by working at your own pace through the lessons, hands-on exercises, and practice tests. The CD features 425 practice questions and a flexible test engine with pre-assessment and post-assessment capabilities. Choose timed or untimed testing mode, generate random tests, or focus on discrete objectives or chapters, and get detailed explanations for right and wrong answersincluding pointers back to the book for further study. You also get a 180-day evaluation version of SQL Server 2005 Enterprise Edition and a 15 percent exam discount vouchermaking this kit an exceptional value and a great career investment.
Customer Reviews & Comments
I have done all 3 exams. I did this one last, and barely cracked the book. I passed (1000) easily. This exam is a joke. If you can pass the 70-431, you'll have what you need. I actually got the feeling that Microsoft was giving us a 'slider' as a congrats to passing the other 2 exams.
The exam has answers where it is obvious what the answer is, and not because you know Sql. It actually has simplistic Reading Comprehension type questions. Example:
"database 'A' and database 'B' ... 'A' is bad and needs to be fixed ... what to do?"
1. delete 'A' - omg! why would you delete a database???
2. delete 'B' - why is 'B' even mentioned???
3. restore 'A' - obviously.
4. restore 'B' - again, why 'B' ???
My 7 year old could pass these types of questions.
Read the book, but do not sweat the exam. I never even opened the CD jacket.
I would point out that the sections on Query Optimization are very weak. If you really want a good book on understanding how to analyze a query, get Grant Fritchey's "Execution Plans" book.