
Ultimate access to all questions.
You are working on a data transformation project using Azure Data Factory and need to perform a series of conditional transformations on a dataset. Which of the following Azure Data Factory transformations would you use to implement these conditional transformations, and how would you configure the transformation to handle different conditions?
A
Use the Copy Data activity and configure the 'Mapping' tab to define conditional mappings based on the data values.
B
Use the Data Flow activity and configure the 'Conditional Split' transformation to handle different conditions.
C
Use the Execute SSIS Package activity and import the SSIS package that contains the conditional logic.
D
Use the Lookup activity to retrieve the conditions and then use a custom activity to perform the conditional transformations.