PrepAway - Latest Free Exam Questions & Answers

What should you do?

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 credential and a login. Configure a SQL Server Agent job to run the package by using the login.

B.
Create a credential and a proxy. Configure a SQL Server Agent job to run the package by using the proxy.

C.
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.

D.
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.

11 Comments on “What should you do?


Leave a Reply