nerdexam
Microsoft

DP-203 · Question #180

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…

The correct answer is B. No. R script cannot be run in Azure Synapse Analytics. sp_execute_external_script can only be applied to SQL Server 2016 (13.x) and later, Azure SQL Managed Instance. https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/r-developers-

Submitted by emma.c· Mar 30, 2026Develop data processing

Question

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 copies the data to a staging table in the data warehouse, and then uses a stored procedure to execute the R script. Does this meet the goal?

Options

  • AYes
  • BNo

How the community answered

(32 responses)
  • A
    16% (5)
  • B
    84% (27)

Explanation

R script cannot be run in Azure Synapse Analytics. sp_execute_external_script can only be applied to SQL Server 2016 (13.x) and later, Azure SQL Managed Instance. https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/r-developers-

Topics

#Azure Data Lake Storage#incremental load#staging zone#data transformation

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice