The MCTS 70-431 Exam Cram is a must-have resource in your MCTS 70-431 exam preparation. The Exam Cram focuses on exactly what you need to know to get certified. This includes features like:

• Complete coverage of all 70-431 exam objectives

• Exam alerts, practice questions, notes, tips, sidebars, cautions, test-taking strategies, and time-saving tips

• Access to MeasureUp practice questions and innovative testing software

• The popular Cram Sheet tear card, giving you the key facts you should review before you enter the testing center

• Insight from author Thomas Moore, a Microsoft Certified Trainer (MCT) and SQL Server expert who has helped hundreds of students earn their SQL Server certifications

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 16 Ratings

A good exam cram, but you need other resources. - 2010-02-14
Reviewer Rating:
I first purchased the Microsoft Press book and thought it had too much information in some areas and little or no information in others.
The Exam Cram seems to fill the holes and summarizes other topics that MSPress covered in too much detail.
Even with all the info covered in both books I dont feel like it's enough, so I also research on the web and have access to a SQL server. A third book probably couldnt hurt.
I gave it 4 stars because I consider a 5 star book to be the only book I would need to study for an exam.

Study Guide Only!!!! - 2008-02-22
Reviewer Rating:
After reading this book, I felt it was lacking in details and possibly had more than a few errors. Although it is a study guide, with some good challenging practice questions, I can not help but emphasize for a few dollars more you could get a better study guide that would be far more useful and prepare you better.

Average Study Guide - 2007-10-17
Reviewer Rating:
I would recommend using this book in conjunction with Microsoft 70-431 preparation guide and Measure UP's or Self Test Software's preperation and practice tests. Its hard to pass SQL 2005 depending only on this book (unless you have some experience working with SQL 2005). Good for quick final review before exam too.

Aimed to be a 5 stars. Got 4. - 2007-09-25
Reviewer Rating:
I've been using ExamCram since Windows NT 4. :) Not all of them are impressive. This one is the same.

This is a good last book for quickly reviewing the key concepts to pass the exam. If the topics, such as Service Broker, XML, etc, are new to you and you have read the topic else where, you will appreciate how much the author has condense everything to the basic. It reminds me of the "cheat sheet" at work someone showed me.

Don't get me wrong this is NOT the only book to use to prepare the exam. When I say quickly reviewing, it took me under 30 minutes to finish chapter one because it is easy for me. But, it was snail pace for me on couple new features from sql 2005. To average readers, I think 1 solid day will be the bare minimum to review using this book. I wish author can share more mnemonic to help sponge up all these new stuffs. :)

ON the plus side, ch7, subtitle: "Activity Monitor For Here and Now". really speak out what Activity Monitor does!

On the neg side, I don't like the style of writing. To me, tech book written in present tense with action words is preferred. Also, it was "wordy". May be it is just me.

now for the technical correctness, the following are things that aren't entirely correct.
ch4, question 2, nodes() and value() can both be the answer.
ch5, Creating a Queue, ALTER QUEUE example used CREATE.
ch6, While describing FORMAT option and how it works, it ends with "The default behavior is NOFORMAT, and the media header is not written." So, a FORMAT option has default behavior of NOFORMAT? This is not clear.
ch 10, q 2, IN is a possible answer when used with NESTED query.
q3, the choice (a) should have said CLR User-Defined Type, which is different than the plain-o UDT.
ch 10, q20, can two jobs with different schedules need be scheduled with one schedule?
Mirror is on the exam and detailed steps was asked.
The prospects.xls mentioned in the book is missing. where to download it? where is the errata?

The exam has simulation which requires much hands on experience. One will easily fail if this is the only study material.

Overall is a good book, it is destined to be a 5 stars. It is hammered down by a few , yet, important errors. 4 stars.

Concise exam preparation...only... - 2007-06-26
Reviewer Rating:
As mentioned in previous reviews, this book is purely an exam preparation guide. If you are planning on sitting the 70-431 exam, this book is a worthwhile resource. It ignores irrelevant (non-exam) material and contains a few sample test questions extremely similar to ones found in the actual exam (which is what you're after).

If you are planning on becoming a proficient SQL Server DBA, you will need to look elsewhere. However, for what it is intended to achieve, I give it 4 stars!

Browse Similar Topics

Top Level Categories:
Certification

Sub-Categories:
Certification > Microsoft
Microsoft > MCT