PrepAway - Latest Free Exam Questions & Answers

How can this be achieved?

You work as a database administrator for ABC.com. The ABC.com network contains a SQL
Server 2008 database server named ABC-DB03.
You are in the process of designing a SQL Server 2008 Integration Services (SSIS) package for
the ABC.com network. ABC.com has informed you that ABC-DB03 will be hosting the package.
You receive an instruction from the CIO to devise a plan of action in the event that ABC-DB03
becomes inactive.
How can this be achieved?

PrepAway - Latest Free Exam Questions & Answers

A.
The master database should be backed up.

B.
You should back up ABC-DB03.

C.
You should execute an incremental backup on a weekly basis.

D.
The SSIS package should be backed up.


Leave a Reply