|
Page |
Correction |
|
Page 47 |
In the first paragraph below Figure 2-1, the third sentence should read as: "If
your row size in a table is 6K, you would be able to store only one row
per page (with 2K wasted space) and only eight rows per extent."
It should not read as "... only one row per table..." |
|
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
135 |
The script returns all the rows. To demonstrate the functionality of the LIKE clause,
use the following script instead:
SELECT * FROM Production.Product
WHERE ProductNumber LIKE '[A-C]%' |
|
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. |
|
216 |
In the paragraph between the two tables, the third sentence should read as:
"Table 5-6 lists some possible database-scoped trigger events that
can be monitored. The table caption is correct. |
|
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 modified.
|
|
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. |