lab answer and encrypting lab: auditinglymeaware.free.fr/lyme/sysinfo/sqlserver2014/xlab answer key_...

Lab

Lab:

Task 1:

1.

with

2. In the

3. Click

wait

Task 2:

Answer andEncrypting

Auditing

Exercise

Prepare

Ensure are both

running, ADVENTUREWORKS\Student

the

D: click Run as

administrator

Yes file, and then

for

Create

Lab Answer Key: Module 10: Auditing Data Access and Encrypting Data https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

1 of 9 26/09/2016 16:04

1. Start

2. In

3. Select

audit

4. In

5.

Task 3:

1. In

2. In

Task 4:

1. In

audit

database

role

2. In

3.

SQL database engine

instance

SQL \Labfiles

\Lab10\Solution

the This creates an

that

Object expandable,

refresh

Double-click click

Cancel

Create

SQL under the

comment creates an audit

specification attempts.

Object expand it. Then

double-click

Create

SQL under the

comment creates an

specification events in the

InternetSales

and

Object Security, and

expand

Double-click Cancel.

Lab Answer Key: Module 10: Auditing Data Access and Encrypting Data https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

2 of 9 26/09/2016 16:04

Task 5:

1. In the

2.

1.

Implement

Audit. for a

user-defined custom audit

event when updated.

Select the and click

Execute procedure to

the public

Task 6: View

Open a as

ADVENTUREWORKS\

ADVENTUREWORKS\ member of the

ADVENTUREWORKS\

runas sqlcmd

2. When prompted

3. In the SQLCMD

Customers.

SELECT

Customers.

GO

4. In the SQLCMD sales_admin

application

EXEC

UPDATE

Lab Answer Key: Module 10: Auditing Data Access and Encrypting Data https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

3 of 9 26/09/2016 16:04

5. Close

6. In the

Task 1:

1. In

2. Select

3. Select

'user1@contoso.

GO

the

D: been created.

7. In SQL under the

comment the audit

folder and and the service

account

8. Note that

ADVENTUREWORKS\ accesses SQL

Server individual login.

This identity context of an

application

9. Keep SQL

Result: After specification,and a database

Exercise Encryption

Create

SQL \Labfiles

\Lab10\Solution

the creates a

database

the Execute. This

Lab Answer Key: Module 10: Auditing Data Access and Encrypting Data https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

4 of 9 26/09/2016 16:04

4. Select

backs

5. Select

Task 2:

1. In the and click

2. Select

database.

3. is

1.

Task 3:

1. In

Tasks

2. In

3. In and

click

4. In the file in

the M:

on the

5. Open

creates

the Execute. This

up

the creates a

database

Enable

TDE. encryption

Execute

the Execute. This

retrieves master

Review HumanResources

Move

Object point to

, OK.

Object Then

connect

Object Databases

Attach

Attach HumanResources.mdf

\Data is displayed

because does not exist

MIA-SQL\SQL2

the

Lab Answer Key: Module 10: Auditing Data Access and Encrypting Data https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

5 of 9 26/09/2016 16:04

6. Select

This

7. Select

This

the click Execute.

creates MIA-SQL\SQL2.

the click Execute.

creates the backup

files you

8. Select the This attaches

the HumanResources

9. Select the queries the

Employees.

10. Review without saving

any files.

Result: After moved theencrypted HumanResource

Lab Answer Key: Module 10: Auditing Data Access and Encrypting Data https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

6 of 9 26/09/2016 16:04

Lab Answer Key: Module 10: Auditing Data Access and Encrypting Data https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

7 of 9 26/09/2016 16:04

Lab Answer Key: Module 10: Auditing Data Access and Encrypting Data https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

8 of 9 26/09/2016 16:04

Lab Answer Key: Module 10: Auditing Data Access and Encrypting Data https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

9 of 9 26/09/2016 16:04