1.

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?

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.
Answer» B. You should back up ABC-DB03.


Discussion

No Comment Found