70-463 · Question #231
Which of the following statements about simple and complex data movements are true? (Choose all that apply.)
The correct answer is B. Complex data movements require data to be transformed before it can be stored at the D. In complex data movements, additional programmatic logic is required to merge source data. Complex data movements are distinguished by the need for data transformation and additional programmatic logic to merge or reconcile data from multiple sources before loading.
Question
Which of the following statements about simple and complex data movements are true? (Choose all that apply.)
Options
- ASimple data movements only have a single data source and a single data destination.
- BComplex data movements require data to be transformed before it can be stored at the
- CIn simple data movements, data transformations are limited to data type conversion.
- DIn complex data movements, additional programmatic logic is required to merge source data
How the community answered
(52 responses)- A4% (2)
- B88% (46)
- C8% (4)
Why each option
Complex data movements are distinguished by the need for data transformation and additional programmatic logic to merge or reconcile data from multiple sources before loading.
Simple data movements are not restricted to a single source and destination; a simple movement can involve multiple sources as long as no transformation logic is required.
Complex data movements require transformation steps - such as lookups, aggregations, or format conversions - before data can be stored at the destination, unlike simple movements that copy data as-is.
Simple data movements are not limited to data type conversion; they can involve any direct copy operation where the data structure maps without business logic transformation.
Complex data movements require additional programmatic logic to handle tasks like merging records from multiple sources, resolving conflicts, or applying business rules that cannot be expressed as direct mappings.
Concept tested: Distinguishing simple vs complex ETL data movements
Source: https://learn.microsoft.com/en-us/sql/integration-services/sql-server-integration-services
Topics
Community Discussion
No community discussion yet for this question.