MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft® SQL Server™ 2005

Errata for MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft® SQL Server™ 2005




The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update



Version Location Description Submitted By Date Submitted Date Corrected
Printed
Page 32

Incorrect RAID number used in Figure 1-7 Page 32, Figure 1-7, the description for D: RAID reads: " D: RAID 1, 01, or 10 Log Files" It should read: "D: RAID 1 or 10 Log Files"

Microsoft Press  May 06, 2010 
Printed
Page 34

Incorrect RAID operation type On page 34, the second sentence from the top reads: "RAID 1 and RAID 10, for example, each generate one additional read operation for each write operation." It should read: "RAID 1 and RAID 10, for example, each generate one additional write operation for each write operation."

Microsoft Press  Jul 13, 2010 
Printed
Page 38

Incorrect space requirement given for Analysis Services and data files On page 38, the second row of table 1-7 reads: "Analysis Services and data files 35 KB" It should read: "Analysis Services and data files 35 MB"

Microsoft Press  May 06, 2010 
Printed
Page 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: "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." It should read: "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."

Microsoft Press  Jul 13, 2010 
Printed
Page 139

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

Microsoft Press  May 06, 2010 
Printed
Page 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: "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" Question 4 should be combined with question 3 and it should read: "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"

Microsoft Press  Jul 13, 2010 
Printed
Page 187

Incorrect code in answer A On page 187, the 6th line of answer A reads: PORTS = (SSL),It should read: PORTS = (CLEAR),

Microsoft Press  May 06, 2010 
Printed
Page 226

SCHEMAS should be SCHEMA On page 226, the code sample in step 3 of Exercise 2 is incorrect. Change: "GRANT EXECUTE ON SCHEMAS::dbo TO sqltest" To: "GRANT EXECUTE ON SCHEMA::dbo TO sqltest"

Microsoft Press  Jul 13, 2010 
Printed
Page 377

Incorrect punctuation and server name On page 377, the first sentence in the 5th paragraph reads: "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" It should read: "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."

Microsoft Press  May 06, 2010 
Printed
Page 433

Incorrect wording of answer D of question 3 On page 433, Answer D of Question 3 reads: "RAID 1 + 0 (mirror of stripes)" It should read: "RAID 1 + 0 (stripe of mirrors)"

Microsoft Press  Jul 13, 2010 
Printed
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: "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." It should read: "When defining a character data type, you specify the maximum number of characters the column is allowed to store."

Microsoft Press  May 06, 2010 
Printed
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: "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."

Microsoft Press  Jul 13, 2010 
Printed
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: "If it were a large-scale environment, thousands of users might be simultaneously connected, resulting in memory requirements of several G." It should read: "If it were a large-scale environment, thousands of users might be simultaneously connected, resulting in memory requirements of several GB."

Microsoft Press  May 06, 2010 
Printed
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: "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." It should read: "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."

Microsoft Press  Jul 13, 2010 
Printed
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: "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." To: "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."

Microsoft Press  May 06, 2010 
Printed
Page 647

Incorrect word usage in Answer B of Question 4 On page 647, the first sentence of Answer B of Question 4 reads: "A database DDL trigger fires on when the specified action is issued within the database." It should read: "A database DDL trigger fires when the specified action is issued within the database." 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.

Microsoft Press  Jul 13, 2010