Note: This question is part of a series of

questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only t

o that question.

You are implementing the data load process for a data warehouse.

The data warehouse uses daily partitions to store data added or modified during the last 60 days. Older data is stored in monthly partitions.

You need to ensure that the E

TL process can modify the partition scheme during the data load process.

Which component should you use to load the data to the data warehouse?

A. the Slowly Changing Dimension transformation

B. the Conditional Split transformation

C. the Merge

transformation

D. the Data Conversion transformation

E. an Execute SQL task

F. the Aggregate transformation

G. the Lookup transformation

Incorrect Answers:

A: The Slowly Changing Dimension transformation coordinates the updating and inserting o

f records in data warehouse dimension tables.

References: https://social.technet.microsoft.com/wiki/contents/articles/50781.dynamic-management-of-ssas-partitions-with-ssis.aspx