exam questions

Exam DP-201 All Questions

View all questions & answers for the DP-201 exam

Exam DP-201 topic 2 question 13 discussion

Actual exam question from Microsoft's DP-201
Question #: 13
Topic #: 2
[All DP-201 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 streaming data that is received by Azure Event Hubs and stored in Azure Blob storage. The data contains social media posts that relate to a keyword of
Contoso.
You need to count how many times the Contoso keyword and a keyword of Litware appear in the same post every 30 seconds. The data must be available to
Microsoft Power BI in near real-time.
Solution: You use Azure Data Factory and an event trigger to detect when new blobs are created. You use mapping data flows in Azure Data Factory to aggregate and filter the data, and then send the data to an Azure SQL database. You consume the data in Power BI by using DirectQuery mode.
Does the solution 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
cadio30
Highly Voted 4 years ago
Answer is NO. The propose solution to utilize ADF doesn't have real-time capability. Instead use of Azure Stream Analytics as it can count the data with the use of window function and output the data directly to the PowerBI dataset.
upvoted 11 times
...
AlexD332
Highly Voted 4 years, 3 months ago
scenario: You need to count how many times .. appear in the same post every 30 seconds. Solution: You use Azure Data Factory and an event trigger Answer: No - you don't need an event trigger - you need a schedule trigger each 30 seconds
upvoted 8 times
...
sjain91
Most Recent 4 years, 1 month ago
Answer: No - you don't need an event trigger - you need a schedule trigger each 30 seconds
upvoted 4 times
...
maciejt
4 years, 2 months ago
Mapping data flow needs few minutes to start up spark cluster, it's good for batch ETL, but not suitable for real time stream processing.
upvoted 4 times
karma_wins
4 years, 1 month ago
reply from maciejt seems only logical to me for "No" to this question i.e. since mapping dataflow needs few mins to spark up the cluster.
upvoted 1 times
...
...
mohowzeh
4 years, 4 months ago
correction: in my previous post, forget the 30-word distance. But the "break a post into words" remains the reason why the proposed solution does not fully meet the requirements IMHO
upvoted 1 times
...
mohowzeh
4 years, 4 months ago
Answer is correct in my opinion. The proposed approach is missing a step where you break out the social media post into words and investigate the 30-word "distance".
upvoted 1 times
...
cm19
4 years, 5 months ago
ADF is not a suitable solution for realtime feeds.When Streaming analytics can do the job directly no need of triggers to identify new blobs.So the answer looks correct to me.
upvoted 5 times
...
HPotter
4 years, 5 months ago
Why ? There should be an explanation. Solution provided seems reasonable
upvoted 2 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 ...