nerdexam
Microsoft

70-451 · Question #3

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?

The correct answer is B. Create a credential and a proxy. See the full explanation below for the reasoning.

Question

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?

Options

  • ACreate a credential and a login.
  • BCreate a credential and a proxy.
  • CCreate a login and map a user to the login.
  • DCreate a login and map the user to a login.

How the community answered

(63 responses)
  • A
    13% (8)
  • B
    73% (46)
  • C
    5% (3)
  • D
    10% (6)

Community Discussion

No community discussion yet for this question.

Full 70-451 Practice