nerdexam
Microsoft

70-448 · Question #249

You maintain a SQL Server Integration Services (SSIS) instance that uses Windows Authentication. You need to determine if there is a package named DailyLoad in the MSDB database on the local…

The correct answer is A. dtutil /SQL DailyLoad /EXISTS. See the full explanation below for the reasoning.

Question

You maintain a SQL Server Integration Services (SSIS) instance that uses Windows Authentication. You need to determine if there is a package named DailyLoad in the MSDB database on the local instance of SQL Server. Which dtutil command syntax should you use?

Options

  • Adtutil /SQL DailyLoad /EXISTS
  • Bdtutil /SQL DailyLoad /USERNAME xyz /USERPASSWORD xxxxxx /EXISTS
  • Cdtutil /DTS DailyLoad.dtsx /MOVE SQL;destPackage
  • Ddtutil /File W:/DailyLoad.dtsx /EXISTS

How the community answered

(32 responses)
  • A
    78% (25)
  • B
    3% (1)
  • C
    6% (2)
  • D
    13% (4)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice