Microsoft
70-463 · Question #247
70-463 Question #247: Real Exam Question with Answer & Explanation
The correct answer is C: a data viewer. A data viewer attaches to data flow paths between components and displays the actual rows passing through at runtime, making it the precise tool for locating the source of incorrect data.
Question
You are developing a SQL Server Integration Services (SSIS) package that loads data from a source transactional tables in a data warehouse. You discover that one of the data flows loads incorrect data to one of the destination tables. You need to identify the cause of the incorrect data flow. Which tool should you use?
Options
- ASSIS logging.
- Ba breakpoint
- Ca data viewer
- Dthe locals window.
Explanation
A data viewer attaches to data flow paths between components and displays the actual rows passing through at runtime, making it the precise tool for locating the source of incorrect data.
Common mistakes.
- A. SSIS logging captures package events, warnings, row counts, and execution metadata but does not record or display the actual data values flowing through the data flow pipeline components.
- B. A breakpoint pauses package or task execution at a defined event boundary for interactive debugging but does not expose the stream of row data flowing between individual data flow transformations.
- D. The locals window displays variable values and system property values during a breakpoint-suspended debug session but does not show the actual rows of data flowing through the data flow pipeline.
Concept tested. Using SSIS data viewer to inspect pipeline data flow
Reference. https://learn.microsoft.com/en-us/sql/integration-services/troubleshooting/debugging-data-flow
Community Discussion
No community discussion yet for this question.