Administering Relational Databases on Microsoft Azure — Question 17

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure Data Lake Storage account that contains a staging zone.
You need to design a daily process to ingest incremental data from the staging zone, transform the data by executing an R script, and then insert the transformed data into a data warehouse in Azure Synapse Analytics.
Solution: You use an Azure Data Factory schedule trigger to execute a pipeline that executes mapping data flow, and then inserts the data into the data warehouse.
Does this meet the goal?

Answer options

Correct answer: B

Explanation

The proposed solution does not meet the goal because mapping data flows in Azure Data Factory do not support the execution of R scripts for data transformation. Instead, an alternative approach using Azure Databricks or Azure Functions to execute the R script would be necessary before loading the data into Azure Synapse Analytics. Therefore, option B is correct.