The errata list is a list of errors and their corrections that were found after the product was released.
The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.
| Version |
Location |
Description |
Submitted by |
Date submitted |
| Printed |
Page N/A
Practice test, Certification |
On the practice test, it says database crashes at 3:25 AM on Tuesday. It wants the steps to take to get the data restored. It does tran logs by the hour. So, I select restore last full backup (Friday), last differential (Tuesday at 1 AM) and 2 Am and 3 am tran logs. There is nothing in here for backing up and restoring the tail. When I took the test, it said incorrect. It said I had to restore the 4 Am tran log. In explaination, it says to restore the 4 Am tran log up until the moment prior to the crash.
If the database crashes at 3:25 AM, there will be no 4 AM tran log (as the database has crashed). this would make more sense if you did a backup of the tail, and restored that. I have a screen print, but cannot seem to attach it.
If I am incorrect, please let me know, but if it crashes at 3:25 AM, there cannot be a 4 AM tran log.
|
Shawn Scranton |
Oct 14, 2010 |
| Other Digital Version |
CD
Practice Exam |
After running through the practice exam in exam conditions, I got a popup stuck in an infinite loop alerting me of an error. This was very annoying as I hadn't got my test result but simply reviewing my answers prior to getting the result. The button at the bottom right (can't remember what it was labelled) was the reason. I had to kill the process and waste all that effort. This has happened TWICE!!!!!!!!!!!
Is there an update online that I can download?
|
Anonymous |
Jun 24, 2012 |
| Other Digital Version |
CD
Practice Test on CD |
I am using the practice test CD and I noticed an error. On the following
question:
The Surveys table in the Geology database has four indexes associated with it: Surveys.IndexA, Surveys.IndexB, Surveys.IndexC, and Surveys.IndexD.
You want to rebuild Surveys.IndexC while keeping the Surveys table
available to database users who might want to access it.
From the list on the right, select the lines of code to build a statement
to meet your needs. Place your selections in the list on the left in the
order in which the statement would be executed. Place your selections in
the list on the left by clicking the items in the list on the right and
clicking the arrow. You can also use the Up and Down buttons to rearrange items in the list on the left. You might not need to use all the items from the list on the right.
It lists the incorrect answer as correct. The explanation section DOES list
the correct answer, so it contradicts itself.
|
Anonymous |
Sep 06, 2012 |
| Printed |
Page 15
Lesson Summary |
The 2nd bullet point of the Lesson Summary implies that only Enterprise edition supports Service Broker, but the Microsoft MSDN website indicates that Service Broker is also supported by Standard and Workgroup editions.
|
Anonymous |
Dec 22, 2011 |
| Printed, PDF |
Page 15
Quick Check Answers |
It follows that if on pg 12 the values in Table 1-2 Hardware Support are incorrect and should be modified as specified in confirmed errata, Quick Check Answer 2 should be corrected to these new values as well.
|
roberto2525 |
May 16, 2012 |
| Printed |
Page 21
Quick Check Answers |
Quick Check Answer 1 says that only SQL Server 2008 Enterprise edition supports multiple instances, but I know 2005 Standard supports multiple instances and it is my understanding that 2008 Standard and Workgroup support multiple instances.
|
Anonymous |
Dec 22, 2011 |
| Printed, PDF |
Page 21
Quick Check |
Quick Check question 1 and its relevant Quick Check Answer 1 is incorrect and should be disregarded.
It follows that if on page 19 the NOTE regarding multiple instances only supported on Enterprise is incorrect and should be disregarded as specified in confirmed errata, then question 1 and its relevant answer 1 should also be disregarded in this Quick Check section as well.
|
Riccardo Capuano |
Feb 29, 2012 |
| Printed, PDF |
Page 27
Lesson Summary |
Lesson Summary point 4 is incorrect and should be disregarded.
It follows that if on page 19 the NOTE regarding multiple instances only supported in Enterprise is incorrect and should be disregarded as specified in confirmed errata, then in Lesson Summary, the 4th point that specifies only the Enterprise Edition has multi-instance support is incorrect and should also be disregarded as well.
|
Riccardo Capuano |
Feb 29, 2012 |
| Printed |
Page 50
Chapter #2, Lesson #2 |
In Chapter #2, Lesson #2 (page #50), the book has the following statement:
"In addition, when a database is placed in READ_ONLY mode, SQL Server
removes any transaction log file that is specified for the database."
I did not believe this to be accurate and therefore did a small test and
confirmed the same. If a database is marked READ_ONLY, the transaction log
file remains.
|
Anonymous |
Jul 28, 2011 |
| Printed, PDF |
Page 54
Para 2 (callout) |
The bullet point "Use DMVs to diagnose corruption issues" should be changed to "Use the DBCC CHECKDB command to diagnose corruption issues"
|
Scott Samuel |
Jan 05, 2012 |
|
67
1st paragragh and TABLE 3-5 |
"Binary data is stored in a set of four data types..." then Table 3-5 only lists three data types.
Also...
Microsoft Technet classifies the BIT data type as integer data (perhaps because it allows NULL values and not just 1 and 0?) and IMAGE data type as binary data (not shown in TABLE 3-5).
http://technet.microsoft.com/en-us/library/ms172424(v=sql.105).aspx
Granted, the book 70-433 Microsoft SQL Server 2008 - Database Development states that IMAGE data type is considered deprecated and could be left out of future versions of SQL Server.
|
Anonymous |
Apr 19, 2012 |
|
69
1st paragraph |
70-432 book: The 2nd sentence in the 1st paragraph reads "The only restriction on geographic data is that the data and any comparisons cannot span a single hemisphere."
According to another book (the book for exam 70-433), regarding geographic data, the data and any comparisons can span a single hemsphere, but not more than a single hemisphere.
Source: 70-433 Microsoft SQL Server 2008 - Database Development, page. 327, paragraph titled "Restrictions When Using the geography Data Type"
Can you please confirm which book is correct?
|
Anonymous |
Apr 19, 2012 |
| PDF |
Page 77
top of page |
You use constraints to enforce business rules as well as consistency in data. In this lesson, you learn about constraints and how to implement each type of constraints within your database.
Should be:
You use constraints to enforce business rules as well as consistency in data. In this lesson, you learn about constraints and how to implement each type of constraint within your database.
|
Anonymous |
Jan 19, 2012 |
| Printed |
Page 77
last paragraph |
A FOREIGN KEY constraint does not have to be linked only to a PRIMARY KEY constraint in another table; it can also be defined to reference the columns of a UNIQUE constraint in another table.
I'd rewrite the first sentence of that paragraph as:
To create a foreign key relationship between two tables, the parent table must have a candidate key (defined with either a PRIMARY KEY or UNIQUE constraint), which is referenced by the child table.
|
Anonymous |
May 09, 2012 |
| Printed |
Page 79
Quick Check answer 2. |
A FOREIGN KEY constraint does not have to be linked only to a PRIMARY KEY constraint in another table; it can also be defined to reference the columns of a UNIQUE constraint in another table.
I'd rewrite that answer as:
The parent table must have a candidate key, with either a PRIMARY KEY or UNIQUE constraint, that is used to define the relationship between parent and child tables. In addition, if this candidate key is defined on multiple columns, all those columns must exist in the child table.
|
Anonymous |
May 09, 2012 |
| PDF |
Page 90
Last paragraph |
The text states that finding a row in the table with little over 4 million rows requires a scan of only two pages. This is correct according to the numbers used, as two page scans would allow up to 1024^2 rows before an additional page scan is required.
However, it then states that the table could grow to more than 8 billion rows before three pages would need to be read. This is incorrect. A three page scan is required from (1024^2)+1 to 1023^3, that is, in the range of just over 4 million to over 8 billion. A 4 page scan would be required from 8181353376 INT rows and greater.
|
David Clark |
May 08, 2012 |
| Printed |
Page 114
Full Text Indexes |
On page 114, part Full Text Indexes
"You can create full text indexes on columns that are CHAR/VARCHAR, XML, and VARBINARY data types."
should be
"You can create full text indexes on columns that are char, varchar, nchar, nvarchar, text, ntext, image, xml, varbinary, and varbinary(max) data types."
source: http://msdn.microsoft.com/en-us/library/ms187317.aspx
|
Anonymous |
Jul 27, 2011 |
| PDF |
Page 203
3rd paragraph |
Quote: " As soon as SQL Server reaches the first LSN that has not yet been committed (that is, the oldest open transaction), the transaction log backup completes."
Is wrong, SQL Server writes all entries inside the log to the log backup, open transactions don't stop this.
Easy to verify: Set up a test database, do a full backup, start a transaction and insert an entry into a test table without committing. start a new session and do an insert with committing. do a transaction log backup and restore the backups to a new database. Would open transactions block the transaction backup the last entry shouldn't appear once restored, but... it is there.
|
Stefan Rosendorf |
Jul 11, 2012 |
| PDF |
Page 203
3rd paragraph |
quote: " The portion of the transaction log that has been backed up is then removed, allowing the space to be reused. "
This is wrong. The backed up log entries inside the log could still be required for other tasks, such as database mirroring or replication, and those requirements would prevent the truncation of the log.
|
Stefan Rosendorf |
Jul 11, 2012 |
| Printed |
Page 203 and 212
3rd line on Transaction Log Backups and 7th line on Transcation Log Internals |
When a DB is created the LSN is said to start at 1 on page 203 and at 0 on page 212
|
Jos? Teixeira |
Feb 18, 2013 |
| PDF |
Page 213
3rd line from the top |
If the LSN of the dirty page is greater than the page on disk or the data file containing the page, the page in the buffer pool is overwritten by the page on disk.
Must be:
If the LSN of the data page on disk is greater than the LSN of the dirty page or the data file containing the page, the page in the buffer pool is overwritten by the page on disk.
Also about this mistakes look there:
http://www.sqlservercentral.com/Forums/Topic1120099-1550-1.aspx
|
Yuriy |
Jan 31, 2012 |
| Printed |
Page 222
7th bullet on Lesson Summary |
CONTINUE_PAST_ERRORS should be CONTINUE_AFTER_ERROR
|
Jose Teixeira |
Feb 19, 2013 |
| Printed |
Page 291
chap 11, lesson 5, question 1. |
Hi,
on the question :
The Human Resources (HR) director at Contoso needs to ensure that only authorized users are accessing employee pay records. What do you need to implement to satisfy
these auditing needs?
The answer at page 578 seems to be A : database audit specification.
Bot you said in the question : ensure that only authorized users are accessing .
==> When you audit, you only log that employee are accessing. You dont prevent accessing. I thing, There is no good answers in your choise.
Can you explain your answer more ?
I think your question is not good.
Thanks for your answers.
PS: I usually speek french, so it 's probably my understanding that is not good...
|
Fran?ois Bourdages |
Dec 07, 2011 |
| Printed |
Page 411
Chart at top of page |
http://technet.microsoft.com/en-us/library/cc731844%28WS.10%29.aspx
Mistake in book, and I previously made the same mistake. A failover cluster can not be built with Windows Server 2008 Standard Edition. The minimum edition needed would be Enterprise. (MS SQL 2008 Standard Edition allows a two node cluster, which is what caused by confusion.)
|
Rich Weissler |
Aug 04, 2011 |
| Printed |
Page 563
Chapter 1: Case Scenario Answer 4 |
Answer 4 says Windows 2003 Enterprise SP2 and later or Windows Server 2008 Enterprise and later are required to support SQL Server 2008 Enterprise. Page 4 says that *all* editions or SQL Server are supported by Windows Server 2003 *Standard* SP2 or higher and Windows Server 2008 *Standard* or higher.
|
Anonymous |
Dec 22, 2011 |
| PDF |
Page 563
Ch.1 Case Scenario Answer, answer # 4 |
States:
"You need to install either Windows 2003 Server Enterprise SP2 and later or Windows Server
2008 Enterprise and later to support SQL Sever 2008 Enterprise."
According to p.4 of the book, bullets 1 and 2, all editions of SQL 2008 can run on Windows Server 2003 Standard SP2 (or higher) and on Windows Server 2008 Standard (or higher). Windows Server 2003 Enterprise SP2 / Windows Server 2008 Enterprise is not required. This is also confirmed on Microsoft's site at the following address:
http://msdn.microsoft.com/en-us/library/ms143506.aspx#EEx64
|
Phil Massimi |
Mar 08, 2012 |
| Printed |
Page 584
Ch 13, Lesson 4, Question 1 |
Correct answer states: "The Performance Data Warehouse in SQL 2008 allows you to configure data collection quickly against SQL 6.5 through 9.0 [...]"
I can't find a way to do this. After further research, I've found:
http://blogs.technet.com/b/rob/archive/2008/06/20/sql-server-2008-performance-studio.aspx
"Performance Studio will only collect data against SQL Server 2008 databases, so unfortunately you can't use it to monitor older versions of SQL Server."
(Ch 13, Lesson 4 starts with "The Performance Data Warehouse, also referred to as Performance Studio[...])
and
http://www.sqlservercentral.com/articles/Product+Reviews/66278/
"Since there are many dependencies on new SQL Server 2008 features, and because you need to configure data collection on each instance, there is simply no way to collect and upload data on other instances because the nodes in Management Studio?s Object Explorer (and the underlying procedures they ultimately call) simply don?t exist."
Am I misinterpreting? Is there a way to configure data collection against SQL 6.5 through 9.0?
|
Rich Weissler |
Aug 19, 2011 |