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

Article translations Article translations
Article ID: 945452
Expand all | Collapse all

On This Page

Summary

This article contains comments, corrections, and information about known errors relating to the Microsoft Press book MCTS Self-Paced Training Kit (Exam 70-445): Microsoft SQL Server 2005 Business Intelligence-Implementation and Maintenance, 978-0-7356-2341-5.

The following topics are covered:

  • CDROM: Readiness Review answer incorrect
  • Page 81: Additional information is needed in Step 3
  • Page 97: "Lookup" should be "Aggregate"
  • Page 164: Fact should be Many-to-Many
  • Page 193: 2004 should be 2003
  • Page 294: "DSCategory" and "DSMonth" should be switched

More information

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."

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."

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."

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."

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."

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.

Properties

Article ID: 945452 - Last Review: June 21, 2014 - Revision: 2.0
Keywords: 
KB945452

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com