70-463 · Question #181
You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a source system into a data warehouse hosted on Windows Azure SQL Database. One of the columns in t
The correct answer is D. Script Component. Script Component Transformation: The transformation that uses script to extract, transform, or load data. - SQL Server Integration Services provides three different types of data flow components: sources, transformations, and destinations. Sources extract data from data stores su
Question
You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a source system into a data warehouse hosted on Windows Azure SQL Database. One of the columns in the data source is named ProductCode. Some of the data to be loaded will reference products that need special processing logic in the data flow. You need to enable separate processing streams for a subset of rows based on the source product code. Which data flow transformation should you use?
Options
- ASource Assistant
- BDestination Assistant
- CAudit
- DScript Component
How the community answered
(29 responses)- A10% (3)
- B3% (1)
- C7% (2)
- D79% (23)
Explanation
Script Component Transformation: The transformation that uses script to extract, transform, or load data. - SQL Server Integration Services provides three different types of data flow components: sources, transformations, and destinations. Sources extract data from data stores such as tables and views in relational databases, files, and Analysis Services databases. Transformations modify, summarize, and clean data. Destinations load data into data stores or create in-memory datasets. Not A, Not B: No Data Transforms called Source Assistant or Destination Assistant Not C: Not related to auditing
Topics
Community Discussion
No community discussion yet for this question.