exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 5 question 9 discussion

Actual exam question from Microsoft's DP-300
Question #: 9
Topic #: 5
[All DP-300 Questions]

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?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
cusman
Highly Voted 2 years, 10 months ago
DP-203
upvoted 8 times
...
dakku987
Most Recent 1 year ago
Selected Answer: B
Transform Data using R Script: The solution suggests using a stored procedure to execute the R script. While stored procedures can be used for certain types of processing, executing an R script might be more efficiently done using tools that natively support R, such as Azure Machine Learning Services or Azure Databricks.
upvoted 2 times
...
U_C
1 year, 9 months ago
B. No. The solution described does not fully meet the stated goal. While it includes a pipeline to copy data to a staging table in the data warehouse, it does not account for the incremental nature of the data. Additionally, using a stored procedure to execute the R script may not be the most efficient approach for transforming the data.
upvoted 2 times
...
KIET2131
1 year, 11 months ago
Selected Answer: A
A. Yes. This solution meets the goal of ingesting incremental data from the staging zone, transforming the data using an R script, and inserting the transformed data into a data warehouse in Azure Synapse Analytics. By using Azure Data Factory to copy the data to a staging table in the data warehouse, and then using a stored procedure to execute the R script, you can ensure that the data is transformed correctly before it is inserted into the data warehouse. Additionally, using a stored procedure can help simplify the pipeline and reduce maintenance efforts, since the R script can be updated in a single location
upvoted 1 times
...
Ciupaz
2 years, 2 months ago
This question is not for DBA (DP-300 exam).
upvoted 3 times
...
Icyb3r
2 years, 5 months ago
Selected Answer: B
Insert to DWH comes after the Execution of R script, so the correct Answer should be (B. No)
upvoted 3 times
...
CaptainJameson
3 years ago
Selected Answer: A
Seems right https://docs.microsoft.com/en-us/sql/machine-learning/tutorials/quickstart-r-create-script?view=sql-server-ver15 By default, sp_execute_external_script accepts a single dataset as input, which typically you supply in the form of a valid SQL query. It then returns a single R data frame as output.
upvoted 1 times
...
o2091
3 years, 2 months ago
looks correct
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...