Training Kit (Exam 70-462): Administering Microsoft® SQL ...

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

Databases

Orin Thomas, Peter Ward, and boB Taylor

ISBN: 978-0-7356-6607-8

First printing: July, 2012

To ensure the ongoing accuracy of this book and its companion content, we¡¯ve reviewed and

confirmed the errors listed below. If you find a new error, we hope you¡¯ll report it to us on our

website: contact-us/errata.

Page

Location

ii

"Objective

Reads:

Maps" section Manage and configure databases. 3 3

xxii

xxiii

3

18

19

Description

Should read:

Manage and configure databases. 3 2

Reads:

Log on to the third computer

"Prepare

Fourth

Member

Server"

Should read:

section, step 2 Log on to the fourth computer

Second line

Reads:

10.10.10.40

Should read:

10.10.10.60

Third sentence Reads:

Windows Vista SP2 x86 is a 32-bit operating system that supports only

the x86 versions of SQL Server 2012 Developer and SQL Server 2012

Express editions.

Thirteenth

bulleted item

Line 6

Should read:

Windows Vista SP2 x86 is a 32-bit operating system that supports only

the x86 versions of SQL Server 2012 Developer, SQL Server 2012

Standard, and SQL Server 2012 Express editions.

The following bulleted item should be deleted:

SQL Client Connectivity SDK

Reads:

contso

Date corrected

2/8/2013

10/19/2012

10/19/2012

2/25/2015

5/24/2013

10/19/2012

Should read:

contoso

Last updated 6/29/2015

Page 1 of 13

Page

Location

Description

23

"Lesson

Summary"

section

Reads:

SQL Server 2012 Enterprise, Business Intelligence, and Web editions

of SQL Server 2012 can be run only on Windows Server 2008 R2 SP1

and Windows Server 2008 SP2 operating systems using SQL Server

2012 Datacenter, Enterprise, Standard, and Web

24

34

38

43

47

47

"Lesson

Summary"

section

Should read:

SQL Server 2012 Enterprise, Business Intelligence, and Web editions

can be run on the Windows Server 2008 R2 SP1 and Windows Server

2008 SP2 operating system.

Reads:

EMT54

Should read:

EMT64

First paragraph Reads:

...to install the SQL Server Database Engine, Replication, and Full-Text

Search features...

Should read:

...to install the SQL Server Database Engine, Replication, Data Quality

Server and Full-Text Search features...

First sentence Reads:

You can use the ...

Should read:

You can use the Setup.exe...

Table 1-4, Item Reads:

Column, fifth SQP Server

row

Should read:

SQL Server

Step 9

Reads:

Database Engine Configuration page shown in Figure 1-29,

Steps 8 and 9

Should read:

Server Configuration page shown in Figure 1-29,

Reads:

8. On the Server Configuration page, accept the default Service

Accounts settings.

9. On the Server Configuration page shown in Figure 1-29, click Add

Current User and ensure that Windows Authentication Mode is

selected.

Date corrected

10/19/2012

10/19/2012

10/19/2012

10/19/2012

10/19/2012

2/8/2013

2/25/2015

Should read:

8. On the Server Configuration page shown in Figure 1-29, accept the

default Service Accounts settings.

9. On the Database Engine Configuration page, click Add Current User

and ensure that Windows Authentication Mode is selected.

Last updated 6/29/2015

Page 2 of 13

Page

Location

Description

49

Exercise 4

description

Reads:

In this exercise, you add features to the existing SQL Server 2012

instances on servers SQL-A and SQL-B.

52

56

64

Fifth bullet

item

First question

Above Figure

2.2

Should read:

In this exercise, you add features to the existing SQL Server 2012

instance on server SQL-B.

Reads:

You can add features to an existing installation by using Windows

Explorer, by using Setup.exe from the command line, or by invoking

SQL Server Setup through SQL Server Installation Center.

Should read:

You can add features to an existing installation by using Setup.exe

from the command line, or by invoking SQL Server Setup through SQL

Server Installation Center.

Reads:

What is the minimum recommended amount of RAM for SQL Server

2012 Enterprise?

Should read:

What is the minimum required amount of RAM for SQL Server 2012

Enterprise?

Reads:

When SQL Server 2012 is run on a 32-bit operating system, the lowest

minimum memory value you can allocate is 64 MB

Date corrected

5/24/2013

5/24/2013

2/25/2015

10/19/2012

Should read:

When SQL Server 2012 is run on a 32-bit operating system, the lowest

maximum memory value you can allocate is 64 MB

Reads:

If SQL Server 2012 is run on a 64-bit operating system, the lowest

minimum memory value you can allocate is 128 MB

65

79

End of page,

start of next

page

Question 2

Should read:

If SQL Server 2012 is run on a 64-bit operating system, the lowest

maximum memory value you can allocate is 128 MB

Reads:

EXEC sys.sp_configure 'max server memory', 4096;

Should read:

EXEC sys.sp_configure 'max server memory', 8096;

Reads:

...instance uses does not exceed 4,096 GB?

10/19/2012

2/8/2013

Should read:

...instance uses does not exceed 4,096 MB?

Last updated 6/29/2015

Page 3 of 13

Page

Location

Description

85

Last sentence

Reads:

.exe /sq

88

91

95

101

106

Should read:

.exe /qs

"Create a

Reads:

Resource Pool" ...click on the column labeled with an asterix (*)

section, step 2

Should read:

...click on the row labeled with an asterisk (*)

First paragraph Reads:

underneath

WSRM allows you, to...

Figure 2-16

Should read:

WSRM allows you to...

Exercise 1,

Reads:

step 7

Computer Configuration\Windows Settings\Security Settings node

Question 5

answer

Should Read:

Computer Configuration\Policies\Windows Settings\Security Settings

node

Reads:

5. Which stored procedure do you use to enable Database Mail on an

instance?

A. sp_monitor

B. sp_configure

C. sp_rename

D. sp_depends

Should read:

5. Which stored procedure do you use to enable Database Mail on an

instance?

A. sp_configure

B. sp_rename

C. sp_monitor

D. sp_depends

Bottom of the Reads:

page

/ASSVCACCOUNT=NetworkService

Date corrected

10/19/2012

10/19/2012

5/24/2013

10/19/2012

10/19/2012

2/8/2013

Should read:

/ASSVCACCOUNT=Contoso\kim_akers

Last updated 6/29/2015

Page 4 of 13

Page

Location

Description

120

Step 7, code

block

Reads:

USE master

GO

ALTER DATABASE Litware2012 ADD FILE (

NAME = FileStrmFile,

FILENAME = 'C:\FSTRM'

TO FILEGROUP FileStreamFileGroup )

123

130

132

143

143

Exercise 2

Third

paragraph

Second row

Second bullet

item

Fourth

bulleted item

on page

Should read:

USE master

GO

ALTER DATABASE Litware2012 ADD FILE (

NAME = FileStrmFile

FILENAME = 'C:\FSTRM')

TO FILEGROUP FileStreamFileGroup

Reads:

Open an elevated PowerShell prompt and run the following

command:

Should read:

On SQL-A open an elevated PowerShell prompt and run the following

command:

Reads:

SQL Server 2012 supports contained databases and Partially

Contained Databases (Partial-CDBs),...

Should read:

SQL Server 2012 supports Partially Contained Databases (PartialCDBs),...

Reads:

ALTER INDEX indexName ON tableName REBUILD PARTITION ALL

WITH (DATA_COMPRESSION=ROW)

Should read:

ALTER INDEX indexName ON tableName REBUILD PARTITION = ALL

WITH (DATA_COMPRESSION=ROW)

Reads:

DBCC PROCACHE

Should read:

DBCC PROCCACHE

Reads:

DBCC SHOWCONFIG

Date corrected

2/8/2013

10/19/2012

2/25/2015

2/25/2015

10/19/2012

10/19/2012

Should read:

DBCC SHOWCONTIG

Last updated 6/29/2015

Page 5 of 13

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download