Microsoft KB Archive/932713

= MCITP Self-Paced Training Kit (Exam 70-444): Optimizing and Maintaining a Database Administration Solution Using Microsoft SQL Server 2005 Comments and Corrections =

Article ID: 932713

Article Last Modified on 2/7/2007

-

APPLIES TO


 * MCITP Self-Paced Training Kit (Exam 70-444): Optimizing and Maintaining a Database Administration Solution Using Microsoft SQL Server 2005, ISBN 0-7356-2254-X

-



SUMMARY
This article contains comments, corrections, and information about known errors relating to the Microsoft Press book MCITP Self-Paced Training Kit (Exam 70-444): Optimizing and Maintaining a Database Administration Solution Using Microsoft SQL Server 2005, 0-7356-2254-X.

The following topics are covered:


 * Page xxvi: Incorrect Service Pack listed for Windows Server 2003 in software requirements
 * Page 107: The word &quot;maximum&quot; is used in place of &quot;minimum&quot;
 * Page 313: Operating system referenced in place of SQL Server 2005 instance
 * Page 340: Missing backslash in server path name
 * Page 394: Negative incorrectly included in review question
 * Page 445: bin data type referenced in place of bit
 * Page 516: UNIQUE constraint referenced in place of DISTINCT
 * Page 729: UNIQUE constraint referenced in place of DISTINCT



Page xxvi: Incorrect Service Pack listed for Windows Server 2003 in software requirements
On page xxvi, the first bullet under Software Requirements reads:

&quot;Microsoft Windows 2003 Server with Service Pack 2 (SP2) or later&quot;

It should read:

&quot;Microsoft Windows 2003 Server with Service Pack 1 (SP1) or later&quot;

Page 107: The word &quot;maximum&quot; is used in place of &quot;minimum&quot;
On page 107, the last bullet point on the page reads:

&quot;The maximum CPU time, in microseconds, that the plan has ever consumed during a single execution&quot;

It should read:

&quot;The minimum CPU time, in microseconds, that the plan has ever consumed during a single execution&quot;

Page 313: Operating system referenced in place of SQL Server 2005 instance
On page 313, the second bullet point reads:

&quot;Prior to beginning the test, ensure that the same hotfixes, service packs, and security updates that are installed on the production computer’s operating system are also installed on the test computer’s SQL Server 2005 instance.&quot;

It should read:

&quot;Prior to beginning the test, ensure that the same hotfixes, service packs, and security updates that are installed on the production computer’s SQL Server 2005 instance are also installed on the test computer’s SQL Server 2005 instance.&quot;

Page 340: Missing backslash in server path name
On page 340, Step 8 reads:

&quot;Set the Path field to localhost\reports.&quot;

It should read:

&quot;Set the Path field to \\localhost\reports.&quot;

Page 394: Negative incorrectly included in review question
On page 394, the last sentence of question 2 reads:

&quot;When Ian creates a package and configures the package protection level, which of the following settings should he not use to ensure that Orin doesn’t have to re-enter sensitive values when he opens the package?&quot;

It should read:

&quot;When Ian creates a package and configures the package protection level, which of the following settings should he use to ensure that Orin doesn’t have to re-enter sensitive values when he opens the package?&quot;

Page 445: bin data type referenced in place of bit
On page 445, the answer to Quick Check question 2 reads:

&quot;You would use the bin data type to accomplish this task.&quot;

It should read:

&quot;You would use the bit data type to accomplish this task.&quot;

Page 516: UNIQUE constraint referenced in place of DISTINCT
On page 516, answer A to question 1 reads:

&quot;A SELECT clause with a UNIQUE constraint&quot;

It should read:

&quot;A SELECT clause with a DISTINCT constraint&quot;

Page 729: UNIQUE constraint referenced in place of DISTINCT
On page 729, the first sentence of answer A to question 1 of Lesson 2 reads:

&quot;The UNIQUE constraint ensures that a SELECT statement does not return duplicate rows in a result set.&quot;

It should read:

&quot;The DISTINCT constraint ensures that a SELECT statement does not return duplicate rows in a result set.&quot;

Microsoft Press is committed to providing informative and accurate books. All comments and corrections listed above are ready for inclusion in future printings of this book. If you have a later printing of this book, it may already contain most or all of the above corrections.

Additional query words: 0-7356-2254-X 978-0-7356-2254-8

Keywords: KB932713

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.