nerdexam
Microsoft

70-448 · Question #328

You design a SQL Server 2008 Integration Services (SSIS) package that contains several data flows. You need to monitor the data that passes through each path in the data flow by using the Business…

The correct answer is A. Use the Data Viewer tool. See the full explanation below for the reasoning.

Question

You design a SQL Server 2008 Integration Services (SSIS) package that contains several data flows. You need to monitor the data that passes through each path in the data flow by using the Business Intelligence Development Studio. You also need to ensure that data flow logic is retained. What should you do?

Options

  • AUse the Data Viewer tool.
  • BUse the Data Profiling task.
  • CUse the Audit transformation.
  • DUse breakpoints in the Script component.

How the community answered

(35 responses)
  • A
    86% (30)
  • B
    9% (3)
  • C
    3% (1)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice