Exam DP-201 topic 2 question 14 discussion

Actual exam question from Microsoft's DP-201

Question #: 14
Topic #: 2

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 create an Azure Stream Analytics job that uses an input from Event Hubs to count the posts that have the specified keywords, 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

Suggested Answer: A 🗳️
Reference:
https://docs.microsoft.com/en-us/power-bi/service-real-time-streaming https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-twitter-sentiment-analysis-trends

by Nik71 at March 24, 2021, 10:43 a.m.

Comments

Submit Cancel

vivekazure

3 years, 4 months ago

Unless Power BI connects to SQL DB thru Import mode and schedule a automatic refresh, Data can never be available in near real-time.

upvoted 1 times

...

Saravjeet

4 years ago

What I think is the proposed solution is correct, as we can generate the report directly through power BI by connecting it to ASA but not through direct query mode, I am not able to find the source as ASA while referring to DirectQuery. Refer the link: https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources So we have to use sql db if we use directquery mode. Thanks.

upvoted 1 times

...

cadio30

4 years ago

The propose solution is feasible as the data can be stored in Azure SQL DB then use of direct mode from Power BI retrieves the latest data while 'import' connectivity mode requires schedule to refresh the dataset. And as mentioned in the requirement, it states 'near real time' unless it is explicitly label as 'real time' then Azure Stream Analytics is the most suited solution.

upvoted 1 times

...

Nik71

4 years, 2 months ago

You can add Power BI as an output within Azure Stream Analytics (ASA), and then visualize those data streams in the Power BI service in real time https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming#pushing-data-to-datasets

upvoted 3 times

...

Nik71

4 years, 2 months ago

Answer should be No why we output data from Stream to SQL db we can direct output to power BI

upvoted 3 times

chirag1234

4 years, 2 months ago

but they have not mentioned real-time, it is near real-time so it should be year

upvoted 3 times

...