Exam DP-203 topic 4 question 46 discussion

Actual exam question from Microsoft's DP-203

Question #: 46
Topic #: 4

HOTSPOT
-

You have an Azure data factory named DF1 that contains 10 pipelines.

The pipelines are executed hourly by using a schedule trigger. All activities are executed on an Azure integration runtime.

You need to ensure that you can identify trends in queue times across the pipeline executions and activities The solution must minimize administrative effort.

How should you configure the Diagnostic settings for DF1? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by vk8880 at May 12, 2023, 1:54 a.m.

Comments

Submit Cancel

vk8880

Highly Voted 2 years, 1 month ago

1. To identify trends in queue times, you should focus on the Pipeline activity run logs rather than the Pipeline run logs. Pipeline activity run logs allows you to track the queue times for individual activities within the pipeline. While Pipeline run logs logs may provide some information about queue times, they do not provide granular details for each activity within the pipeline.

upvoted 11 times

henryphchan

2 years ago

so the provided answer is correct.

upvoted 8 times

...

renan_ineu

Most Recent 9 months, 1 week ago

The answers are correct. This documentation outlines all the options and describes them clearly. The provided solutions minimize administrative effort, as the goal of these logs is to facilitate further analysis. Sending them to Log Analytics offers a ready-to-use tool for this purpose. In contrast, other solutions store the data as files, such as JSON or Blobs, requiring additional steps to analyze, such as using copy activity in Data Factory to prepare them for further analysis. https://learn.microsoft.com/en-us/azure/azure-monitor/essentials/activity-log?tabs=powershell#send-to-log-analytics-workspace

upvoted 1 times

...

MBRSDG

1 year, 2 months ago

collect pipeline activity runs --> the question asks such a granularity, so it must be included send to log analytics workspace --> this minimized administrative effort in storing logs

upvoted 3 times

MBRSDG

1 year, 2 months ago

there's another better reason for answer 1: we're interested in measuring how much time activities spend waiting in queue, metric that cannot be analyzed using simple pipelines runs. We must have details about each activity, hence the first, "collect pipeline activity runs", is correct.

upvoted 2 times

...

Momoanwar

1 year, 5 months ago

Wrong activity runs dont minimize efforts, chatgpt : To minimize administrative effort while still being able to identify trends in queue times across pipeline executions and activities, you should collect: - Pipeline runs log: This log provides a high-level overview of each pipeline execution, which is sufficient for identifying trends in queue times without the need for the more granular detail that would come from collecting activity runs logs. And send to: - Log Analytics workspace: This will allow for centralized logging and analytics, which is effective for trend analysis with minimal administrative effort. So the settings should be: Collect: Pipeline runs log Send to: Log Analytics workspace

upvoted 1 times