Exam 70-463 topic 3 question 36 discussion

Actual exam question from Microsoft's 70-463

Question #: 36
Topic #: 3

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?

A. Source Assistant
B. Destination Assistant
C. Audit
D. Script Component

Show Suggested Answer

Suggested Answer: D 🗳️
Script Component Transformation:
The transformation that uses script to extract, transform, or load data.
Note:
* 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.

by [deleted] at April 4, 2025, 11:58 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!