nerdexam
Microsoft

70-448 · Question #217

You maintain the SQL Server 2008 Integration Services (SSIS) instance for a healthcare device manufacturing company. You develop a package named Memberinformation.dtsx with Windows authentication…

The correct answer is C. dtexec /f "Z:\Memberinxormation.dtsx" /conf "Z:\Memberiniormationconfig.cfg". See the full explanation below for the reasoning.

Question

You maintain the SQL Server 2008 Integration Services (SSIS) instance for a healthcare device manufacturing company. You develop a package named Memberinformation.dtsx with Windows authentication. You deploy it to SQL Server. You need to validate Memberinformation.dtsx packages without package execution. Which command syntax should you use?

Options

  • Adtexec /sq Memberinformation /verifyv {a400e860-38d5-11c5-11ce-ae62-08002b2b79ef}
  • Bdtexec /sq Memberinformation /ser productionServer /va
  • Cdtexec /f "Z:\Memberinxormation.dtsx" /conf "Z:\Memberiniormationconfig.cfg"
  • Ddtexec /f "2:\Member^nformation.dtsx" /l "DTS.LogProviderTextFile;2:\loginformation.txt"

How the community answered

(32 responses)
  • A
    3% (1)
  • B
    16% (5)
  • C
    75% (24)
  • D
    6% (2)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice