MCTS Self-Paced Training Kit (Exam 70-445): Microsoft® SQL Server™ 2005 Business Intelligence—Implementation and Maintenance

Errata for MCTS Self-Paced Training Kit (Exam 70-445): Microsoft® SQL Server™ 2005 Business Intelligence—Implementation and Maintenance




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
Other Digital Version
CD-ROM

Readiness Review answer incorrect In the Readiness Review assessment, one of the questions reads: "Can a local administrator be denied "data access" to a SQL Server Analysis Services (SSAS) cube on the same server?" The correct answer should be: "Yes, local windows administrators can be denied access to an SSAS cube, but the only way to accomplish this is to exclude the administrator group from the server administrator role."

Microsoft Press  May 06, 2010 
Printed
Page 81

Additional information is needed in Step 3 On page 81, Step 3 is missing instructions to click "New" after selecting the "Create A Data Source Based On A New Or Existing Connection" radio button. Change: "3. In the Data Source Wizard, select the Create A Data Source Based On A New Or Existing Connection radio button in the Select How To Define The Connection page." To: "3. In the Data Source Wizard, on the Select How To Define The Connection page, verify that Create A Data Source Based On A New Or Existing Connection is selected and then click New."

Microsoft Press  Jul 13, 2010 
Printed
Page 97

"Lookup" should be "Aggregate" On page 97, Step 2 contains an incorrect transformation. Change: "2. Connect the output of the Lookup to the new OLE DB Destination by dragging the green path arrow from the Lookup transformation onto the OLE DB Destination adapter." To: "2. Connect the output of the Aggregate to the new OLE DB Destination by dragging the green path arrow from the Aggregate transformation onto the OLE DB Destination adapter."

Microsoft Press  May 06, 2010 
Printed
Page 164

Fact should be Many-to-Many On page 164, step 3 of Exercise 4 is incorrect. Change: "In the Select Relationship Type drop-down list, select Fact, and in the Intermediate Measure Group drop-down list, select Internet Sales Reason." To: "In the Select Relationship Type drop-down list, select Many-to-Many, and in the Intermediate Measure Group drop-down list, select Internet Sales Reason."

Microsoft Press  Jul 13, 2010 
Printed
Page 193

2004 should be 2003 On page 193, the sentence before the last code sample references calendar year 2004 rather than 2003. Change: "For example, the following MDX query returns the Internet Sales Amount measure on columns, broken down by product categories or rows, and filtered for calendar year 2004 only." To: "For example, the following MDX query returns the Internet Sales Amount measure on columns, broken down by product categories or rows, and filtered for calendar year 2003 only."

Microsoft Press  May 06, 2010 
Printed
Page 294

"DSCategory" and "DSMonth" should be switched On page 294, the first sentences of steps 11 and 15 contain the wrong dataset names for the query that follows. Change: "11. Type DSCategory as the name of the dataset." and "15. Type DSMonth as the name of the dataset." To: "11. Type DSMonth as the name of the dataset." and "15. Type DSCategory as the name of the dataset." 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