Microsoft KB Archive/930741

= MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft SQL Server 2005 Comments and Corrections =

Article ID: 930741

Article Last Modified on 6/20/2007

-

APPLIES TO


 * MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft SQL Server 2005, ISBN 0-7356-2173-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-443): Designing a Database Server Infrastructure Using Microsoft SQL Server 2005, 0-7356-2173-X.

The following topics are covered:


 * Page 32: Incorrect RAID number used in Figure 1-7
 * Page 34: Incorrect RAID operation type
 * Page 38: Incorrect space requirement given for Analysis Services and data files
 * Pages 47-48: Buffer cache calculations incorrect
 * Page 139: Incorrect item circled in Figure 4-6
 * Pages 160-161: The formatting of questions 3 and 4 is incorrect
 * Page 187: Incorrect code in answer A
 * Page 377: Incorrect punctuation and server name
 * Page 433: Incorrect wording of answer D of question 3
 * Page 451: Explanation of the size declaration of character data types is incorrect
 * Page 464: NOTE needs to be added under the RULES subheading
 * Page 613: Missing letter from the explanation of answer C to question 1 of Lesson 4
 * Page 615: Incorrect SQL Server edition referenced in the explanation of answer B to question 3
 * Page 617: 5 GB should be 4 GB and 5 GB should be 6 GB
 * Page 647: Incorrect word usage in Answer B of Question 4



Page 32: Incorrect RAID number used in Figure 1-7
Page 32, Figure 1-7, the description for D: RAID reads:

&quot; D: RAID 1, 01, or 10 Log Files&quot;

It should read:

&quot;D: RAID 1 or 10 Log Files&quot;

Page 34: Incorrect RAID operation type
On page 34, the second sentence from the top reads:

&quot;RAID 1 and RAID 10, for example, each generate one additional read operation for each write operation.&quot;

It should read:

&quot;RAID 1 and RAID 10, for example, each generate one additional write operation for each write operation.&quot;

Page 38: Incorrect space requirement given for Analysis Services and data files
On page 38, the second row of table 1-7 reads:

&quot;Analysis Services and data files 35 KB&quot;

It should read:

&quot;Analysis Services and data files 35 MB&quot;

Pages 47-48: Buffer cache calculations incorrect
On pages 47 and 48, the last sentence of page 47 and the first sentence of page 48 reads:

&quot;In this example, Query A requires approximately 120 MB in the buffer cache, Query B requires 60 MB, and Query C requires 50 MB. Thus, the total requirements of all three queries are equal to 230 MB.&quot;

It should read:

&quot;In this example, Query A requires approximately 12 MB in the buffer cache, Query B requires 6 MB, and Query C requires 5 MB. Thus, the total requirements of all three queries are equal to 23 MB.&quot;

Page 139: Incorrect item circled in Figure 4-6
On page 139, in Figure 4-6 the link &quot;Web Browser Certificate&quot; is incorrectly circled. The correct phrase that should be circled is &quot;Or, submit an advanced certificate request.&quot;

Pages 160-161: The formatting of questions 3 and 4 is incorrect
On pages 160-161, Starting with question 3, the formatting and numbering is wrong: Items A, B, and C under question 3 should be bullets, not possible answers. The text of question 4 belongs to question 3, so that questions 5 and 6 need to be renumbered 4 and 5, respectively. Currently questions 3 and 4 read:

&quot;3. The Human Resources department in your company is deploying a new SQL Server 2005 database server. The HRDB server requires the following features:

A. Capability to host three databases and respond to queries

B. Capability to back up the database with the features of VSS enabled

C. Capability to automate administrative tasks

4. You want to reduce the attack surface of HRDB. Which of the following services should be disabled?

A. SQL Server

B. SQL Server Agent

C. SQL Server Browser

D. SQL Writer&quot;

Question 4 should be combined with question 3 and it should read:

&quot;3. The Human Resources department in your company is deploying a new SQL Server 2005 database server. The HRDB server requires the following features:

• Capability to host three databases and respond to queries

• Capability to back up the database with the features of VSS enabled

• Capability to automate administrative tasks

You want to reduce the attack surface of HRDB. Which of the following services should be disabled?

A. SQL Server

B. SQL Server Agent

C. SQL Server Browser

D. SQL Writer&quot;

Page 187: Incorrect code in answer A
On page 187, the 6th line of answer A reads:

PORTS = (SSL),

It should read:

PORTS = (CLEAR),

Page 377: Incorrect punctuation and server name
On page 377, the first sentence in the 5th paragraph reads:

&quot;Data within the existing Products, Customer, Orders, Flights, Cruises, Excursions, and Car Rental databases can be exposed to the Internet through applications running on WEB&quot;

It should read:

&quot;Data within the existing Products, Customer, Orders, Flights, Cruises, Excursions, and Car Rental databases can be exposed to the Internet through applications running on WEB 1.&quot;

Page 433: Incorrect wording of answer D of question 3
On page 433, Answer D of Question 3 reads:

&quot;RAID 1 + 0 (mirror of stripes)&quot;

It should read:

&quot;RAID 1 + 0 (stripe of mirrors)&quot;

Page 451: Explanation of the size declaration of character data types is incorrect
On page 451, the second and third sentence of the third paragraph in the Unicode box reads:

&quot;When defining a character data type, you specify the maximum number of bytes the column is allowed to store. For example, a char(10) can store a maximum of 10 characters because each character requires one byte of storage, whereas an nchar(10) can store a maximum of five characters because each Unicode character requires two bytes of storage.&quot;

It should read:

&quot;When defining a character data type, you specify the maximum number of characters the column is allowed to store.&quot;

Page 464: NOTE needs to be added under the RULES subheading
On page 464, under the RULES subheading a NOTE needs to be added with the following text:

&quot;NOTE: CREATE RULE will be removed in a future version of Microsoft SQL Server. Avoid using CREATE RULE in new development work, and plan to modify applications that currently use it. We recommend that you use check constraints instead. Check constraints are created by using the CHECK keyword of CREATE TABLE or ALTER TABLE.&quot;

Page 613: Missing letter from the explanation of answer C to question 1 of Lesson 4
On page 613, the last sentence of answer C to question 1 of Lesson 4 reads:

&quot;If it were a large-scale environment, thousands of users might be simultaneously connected, resulting in memory requirements of several G.&quot;

It should read:

&quot;If it were a large-scale environment, thousands of users might be simultaneously connected, resulting in memory requirements of several GB.&quot;

Page 615: Incorrect SQL Server edition referenced in the explanation of answer B to question 3
On page 615, the explanation for answer B of question 3 reads:

&quot;The replacement server is required to support failover clustering and it must be able to use more than 4 GB of RAM. SQL Server 2005 Standard Edition (32-bit) supports 2-node failover clustering and can use more than 4 GB of RAM.&quot;

It should read:

&quot;The replacement server is required to support failover clustering and it must be able to use more than 4 GB of RAM. SQL Server 2005 Standard Edition (64-bit) supports 2-node failover clustering and can use more than 4 GB of RAM.&quot;

Page 617: 5 GB should be 4 GB and 5 GB should be 6 GB
On page 617, the space requirements listed in Lesson 2, Question 2, Answer B is incorrect.

Change:

&quot;The databases currently stored on other servers require approximately 5 GB (2 + .5 + 1.5) of space. Therefore, if you use DBSRV2 as the consolidation server, it would leave 5 GB of free space.&quot;

To:

&quot;The databases currently stored on other servers require approximately 4 GB (2 + .5 + 1.5) of space. Therefore, if you use DBSRV2 as the consolidation server, it would leave 6 GB of free space.&quot;

Page 647: Incorrect word usage in Answer B of Question 4
On page 647, the first sentence of Answer B of Question 4 reads:

&quot;A database DDL trigger fires on when the specified action is issued within the database.&quot;

It should read:

&quot;A database DDL trigger fires when the specified action is issued within the database.&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-2173-X 978-0-7356-2173-2

Keywords: KB930741

-

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

© Microsoft Corporation. All rights reserved.