PrepAway - Latest Free Exam Questions & Answers

You need to schedule the SSIS package to run on a regular basis

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?

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply