You have a SQL Server Integration Services (SSIS) package that contains an Execute
Process task. You need to schedule the SSIS package to run on a regular basis. What
should you do?
A.
Create a login and map the user to a login. Add the user to the db_securityadmin role.
Configure a SQL Server Agent job to run the package by using the login.
B.
Create a login and map a user to the login. Add the user to the db_owner role. Configure
a SQL Server Agent job to run the package by using the login.
C.
Create a credential and a login. Configure a SQL Server Agent job to run the package by
using the login.
D.
Create a credential and a proxy. Configure a SQL Server Agent job to run the package
by using the proxy.