Lab Answer Key: Module 3: Working with Databases and Storage

Lab Answer Storage

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

Databases and

Lab: Managing Exercise

Task 1: Prepare

1.

Ensure running,

are both ADVENTUREWORKS\Student

with the 2.

In the D:

click Run as

administrator 3.

Click Yes

wait for the

script to

Task 2: Configure

1.

Start SQL

database engine by

using Windows 2.

In Object

right-click tempdb,

and click 3.

On the

4.

On the

5.

Enter the Configur

open the folder):

USE

1 of 9

26/09/2016 16:00

Lab Answer Key: Module 3: Working with Databases and Storage

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

GO ALTER MODIFY

5MB,

FILENAME ALTER MODIFY

1MB,

FILENAME GO

6.

In Object changes,

prompted to allow service,

click Yes 7.

View the

files have been

moved 8.

In SQL

and click

Properties 9.

On the

10. Save the 11.

click Cancel. \Labfiles\Lab03\Starter folder.

Keep SQL

Result: After

tempdb database.

Exercise

Task 1: Create

2 of 9

1.

In SQL

2.

Enter the

open the Create

26/09/2016 16:00

Lab Answer Key: Module 3: Working with Databases and Storage

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

HumanResources CREATE ON (NAME \HumanResources. LOG (NAME \HumanResources. GO

3.

On Object

confirm that

the HumanResources 4.

Save the

\Labfiles\Lab03\Starter

folder.

Task 2: Create

1.

In SQL

2.

Enter the Create

open the folder):

CREATE ON (NAME \InternetSales. FILEGROUP (NAME \InternetSales_data1.

10MB ),

(NAME \InternetSales_data2.

10MB )

LOG

3 of 9

26/09/2016 16:00

Lab Answer Key: Module 3: Working with Databases and Storage

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

(NAME \InternetSales. GO

3.

Under the

statements you

have just ALTER MODIFY GO

4.

On Object

confirm that

the InternetSales 5.

Save the

\Labfiles\Lab03\Starter folder.

Task 3: View

1.

In SQL

the

D:\Labfiles\Lab03\Starter 2.

Select the

This query

retrieves 3.

Note the

4.

Select the

filegroup and click

Execute 5.

Select the

6.

Select the

7.

Note the

Execute. data in the

table is

4 of 9

26/09/2016 16:00

Lab Answer Key: Module 3: Working with Databases and Storage

Result: After an InternetSales

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

database and

Exercise

Task 1: Attach

1.

Move AWDataWarehouse.

to the

L:\Logs\ 2.

Move the

M:\Data\

folder:

3.

o

AWDataWarehouse.

o

AWDataWarehouse_archive.

o

AWDataWarehouse_current.

In SQL

Databases and click

Attach 4.

In the Attach dialog box,

5.

In the Attach

Database Files click OK. databases file,

note that 6.

In Object

now listed.

Task 2: Configure

5 of 9

1.

In Object

2.

On the

Properties.

26/09/2016 16:00

Lab Answer Key: Module 3: Working with Databases and Storage

3.

Select the

4.

In Object

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

right-click

the dbo. 5.

On the

in the

Current 6.

Right-click

7.

On the

is stored in

the Archive 8.

In Object

Edit Top 200

Rows. 9.

Change

to update

the record. 10. In Object

click Edit

Top 200 11.

Change

to update

the record. 12. View the

cancel the

update

Result: After MIA-SQL.

6 of 9

database to

26/09/2016 16:00

Lab Answer Key: Module 3: Working with Databases and Storage

7 of 9

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

26/09/2016 16:00

Lab Answer Key: Module 3: Working with Databases and Storage

8 of 9

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

26/09/2016 16:00

Lab Answer Key: Module 3: Working with Databases and Storage

9 of 9

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

26/09/2016 16:00