MCQOPTIONS
Saved Bookmarks
| 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. | |