Training Kit (Exam 70-462): Administering Microsoft SQL Server 2012 Databases

Errata for Training Kit (Exam 70-462): Administering Microsoft SQL Server 2012 Databases

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.

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

Version Location Description Submitted By Date Submitted
ePub Page Practice Exam: question about restoring a database
United States

The correct answer says that you must restore the full backup from Sunday, then the differential backup from Monday, then the differential backup from Tuesday, then the logs. I think the correct answer should be that you restore the full backup, then the differential backup from Tuesday (no need to restore more than one diff backup), then the logs.

James Hatcher  Dec 28, 2013 
Printed Page 95
After step 8

Also you need to add another inbound rule in addition to the rule specified in steps 7 and 8. SQL Server named instances (not the default instance) all like to use dynamic ports. SQL Server Browser will take care of the dynamic port mapping so you need to created a GPO for UDP 1434 (SQL Server Browser). Basically following steps 7 and 8 but use a port rule rather than an program rule. Otherwise I was not able to connect to the ALTERNATE instances on either SQL-B or SQL-CORE. After I added the additional inbound rule to the SQL-POLICY GPO (I called the rule SQL-Server-Browser) I was able to connect to both SQL-B\ALTERNATE and SQL-CORE\ALTERNATE without any problems. I was using Windows 8.1 Professional Microsoft Hyper-V for my virtual machine setup.

David Hicks  Mar 10, 2014 
PDF Page 157

The link in the More Info - Supported Edition and Version Upgrades doesn't work. I was able to find this information at:

Andy Binning  Oct 21, 2013 
Printed Page 220
Exercises 1.2 and 2.4

In chapter 5, Lesson 2, Exercise 1, Part 2 you are instructed to create the user "sql_user_c" Then in Exercise 2, Part 4 you are told to "add the sql-c user to the TableAdmin flexible database role". When you do this you receive an error because the user "sql-c" doesn't exist. I believe this question intends to refer to the user created in Exercise 1, Part 2. To remain consistent with the other examples the user created in Exercise 1, Part 2 should have been called "sql-c".

Anonymous  Nov 28, 2013 
Printed Page 268
towards the bottom

syspolicy_policy_group_subscriptions should be syspolicy_policy_category_subscriptions. See

Anonymous  Oct 21, 2013 
Printed Page 343
Exercise 4.3

The third bullet point in exercise 4.3 says to set the Cluster Network Configuration IP address to With this value the SQL Server Installation Center gives an error and won't let you proceed. The correct address needs to be on the same subnet as the Cluster IP Address and therefor should be

Anonymous  Dec 04, 2013 
PDF Page 429
last paragraph

"There are several specific dynamic management views (DMVs) that can be used to retrieve information about indexes. One such DMV is sys.dm_db_index_physical_stats." sys.dm_db_index_physical_stats is a DMF, not a DMV.

Anonymous  Mar 13, 2014 
PDF Page 435
The first step of adding a maintenance plan

"In SSMS, expand the Instance node and then expand the Maintenance node." Actually, you need to expand the Management node.

Anonymous  Mar 13, 2014 
Printed Page 462
Lesson 1, Question 5, Answer B

Executing the UPDATE STATISTICS command on the table specifying the WITH SAMPLE 20 PERCENT option will not fix the out-of-data statistics. This command will fix the out-of-date (not out-of-data / typo) statistics. If anything, this should say that it wouldn't do it to the level of accuracy of a full scan. However, in the context, you could not mark this as an incorrect solution.

Steve Hood  Feb 11, 2014 
PDF Page 463
answer 4

In order to meet the requirement "You need to remove the blocking" , you must issue the KILL 57 command. In order to meet the requirement "must be able to give an estimate of the time remaining until the blocking is resolved", you must issue the KILL 57 WITH STATUSONLY if the index rebuild operation is still running when you execute the KILL 57 WITH STATUSONLY you will get a message Msg 6120, Level 16, State 1, Line 1 Status report cannot be obtained. Rollback operation for Process ID 54 is not in progress.

Sal Young  Nov 19, 2013