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-
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)- A16% (5)
- B84% (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
Community Discussion
No community discussion yet for this question.