|
Page |
Correction |
|
Page
74 |
70-431 question 1. Answer D has been joined with question 2. Answer
D should read as:
D. Define the new column as NOT NULL with a default value of not Identified.
|
|
Page
78 |
Answer 3. Incorrect answer given. The correct answer is A.
The four-part name is server.database.schema.object. We are accessing MCITP1
(the external server). |
|
Page
172 |
First para should read as:
... The query hint is in bold and directs the Query Optimizer to use a clustered
index scan. INDEX(0) forces a clustered index scan and INDEX(1) forces a clustered
index scan or seek.
|
|
179 |
70-431 question 4. Correct answer is D, not B. As the explanation
states, the problem is with the use of the alias. |
|
229 |
70-443 question 2. The correct answer is A, not B. As the
explanation states, you need a DML trigger to identify when data is modifid.
|
|
272 |
70-431 question 3. The correct answer is B, not A. Since we're
running the query on MCITP2, we need to configure MCITP1 as a linked server on MCITP2.
|
|
Page
445 |
Subscription paragraph. Replace last sentence with: Push subscriptions are initiated
by the Publisher. |
|
519 |
70-444 Question 2. Answer D has been joined with question 3. Answer
D should read as:
D. Back up the transaction log.
|
|
520 |
Question 3 answer. Correct answer should be B, D, E
not B, D, F. |
|
Page
684 |
Insert after 3rd para in What You Can Expect section.
There are two things you can do to help you prepare for these simulations –
do the exercises in the book, and watch the videos on the CD. These show you how
to do certain tasks and allow you to put that knowledge into action. |
|
Page 684 |
70-431 is no longer part of the MCITP: BI certification. Change fourth and fifth
paras (including bullets) to read as:
The 70-431 exam is designed for professionals who are either working as, or
pursuing careers as, database administrators or database developers. This is the
first test in both the MCITP: Database Administrator and the MCITP Database Developer
certifications on SQL Server 2005. Because of this, the 70-431 exam crosses the
two different fields. You will see topics from both of these MCITP certifications,
though not to the depth of the full MCITP certification. |