Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 12 Question 41 Discussion

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

Microsoft DP-300 Exam - Topic 12 Question 41 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 41
Topic #: 12
[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?

Show Suggested Answer Hide Answer
Suggested Answer: A

If you need to transform data in a way that is not supported by Data Factory, you can create a custom activity with your own data processing logic and use the activity in the pipeline. You can create a custom activity to run R scripts on your HDInsight cluster with R installed.


https://docs.microsoft.com/en-US/azure/data-factory/transform-data

by Ruthann at May 06, 2022, 05:01 AM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Dorothy
10 months ago
I agree, but what about error handling?
upvoted 0 times
...
Virgie
10 months ago
Wait, can R scripts run in stored procedures?
upvoted 0 times
...
Talia
11 months ago
Yes, that definitely meets the goal!
upvoted 0 times
...
Herminia
11 months ago
I think it might be overcomplicated.
upvoted 0 times
...
Kayleigh
11 months ago
Sounds like a solid plan!
upvoted 0 times
...
Denae
11 months ago
I’m leaning towards "No" because I don’t remember seeing stored procedures executing R scripts in our practice scenarios. It seems like there might be a gap in that part.
upvoted 0 times
...
Robt
11 months ago
I feel like this solution might work, but I wonder if there are better ways to run R scripts in Azure. Maybe using Azure Functions could be an option?
upvoted 0 times
...
Bev
11 months ago
I remember a similar question where we had to use Data Factory to move data, but I can't recall if executing R scripts directly from a stored procedure was the best approach.
upvoted 0 times
...
Tashia
11 months ago
I think using Azure Data Factory for scheduling makes sense, but I'm not sure if the stored procedure can handle the R script execution properly.
upvoted 0 times
...
My
11 months ago
This question seems pretty straightforward. I think I can apply some of the service-oriented design principles we've been learning about to come up with a good solution.
upvoted 0 times
...
Anglea
11 months ago
I've got a strategy for this. I'll start by checking the values of $a and $b, then I'll trace the ternary operator step-by-step to see what's happening with $c. That should help me figure out the output.
upvoted 0 times
...
Lashaunda
11 months ago
Okay, I think the key here is that extinction can help mitigate some of the potential downsides of reinforcement, like resistance to change and aggression. Combining the two approaches seems like a smart strategy.
upvoted 0 times
...
Eura
11 months ago
I think there was a practice question where the average was around 3 days, but I'm not confident if that was for all customers or just specific cases.
upvoted 0 times
...

Save Cancel