World Famous Comics: MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam (Exam Cram 2)
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam (Exam Cram 2)
By: Thomas Moore Publisher: Que Average Rating: Binding: Paperback Label: Que Number of Items: 1 Number of Pages: 456 Publication Date: August 10, 2006
Product Description: 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
Study Guide Only!!!! 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 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. 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... 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!
Good Starting Point This book was a good starting point, but I wouldn't suggest taking the exam after only studying it. I don't know what exam the author took, but there was a lot of stuff on mine that wasn't even alluded to in this book.
I've been a SQL Server programmer/admin for 10 years, so I went into this thinking my knowledge would just need a little brushing up. Breezed through the book and the sample tests and thought "This is going to be easy!" Wrong!
Given the MS 70-413 test is like all the other MS cert tests in that it is as much about getting past the trick questions as knowing anything practical, this book's example questions are waaaay too easy. The subject matter is extremely light weight, too.
Didn't try Transcender, but had coupons for MeasureUp and SelfTest preps. If I had it to do over, I'd devote most of my time to the SelfTest product. Its level of trick questions and general difficulty made it the best for this test. Unfortunately, I discovered this later than I should have.
Anything Goes Trivia
Megaton Man
Tony's Online Tips
Trevor
