Designing an Azure Data Solution (legacy) — Question 55

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 an Azure Databricks notebook, 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 it lacks a clear step for executing the R script, which is essential for transforming the data. Simply using an Azure Databricks notebook does not guarantee that the R script will be executed unless explicitly defined in the notebook. Therefore, the correct answer is B, as the process is incomplete.