You work as a database administrator for ABC.com. Your duties include managing a FTP server
named ABC-SR01.
ABC-SR01 is configured to host the SQL Server 2008 Integration Services (SSIS) package.
Information is retrieved from ABC-SR01 through FTP tasks and is managed using Execute SQL
tasks.
How can you ensure that the packages will restart as soon as the files are downloaded?
A.
A checkpoint should be configured.
B.
The XML settings should be configured.
C.
A restore procedure should be configured prior to ABC-SR01 restarting.
D.
The SSIS service should be added to a resource group.