Exam DP-201 All Questions

View all questions & answers for the DP-201 exam

Exam DP-201 topic 2 question 18 discussion

Actual exam question from Microsoft's DP-201

Question #: 18
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 directly to Power BI.
Does the solution meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️
DirectQuery mode is required for automatic page refresh.
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 stormraider at March 14, 2021, 11:23 p.m.

Comments

Submit Cancel

stormraider

Highly Voted 4 years, 3 months ago

Should be yes, Stream analytics can directly send the output to Power BI https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-power-bi-dashboard

upvoted 32 times

niwe

4 years, 2 months ago

Link is for real-time, questions says "The data must be available to Microsoft Power BI in near real-time." So is, B-No

upvoted 2 times

...

alf99

4 years, 1 month ago

MS documentations confirms this point: The analysis of the streaming data is performed with Stream Analytics itself. A Stream Analytics job is created that contains the Event Hubs as input streams, with a query that performs stream processing of the two event hubs to correlate the records in the two data streams. An output is defined to Cosmos DB that stores the correlated results written as JSON documents to a Cosmos DB document database. Power BI then uses Cosmos DB as a source for a dashboard of the correlated records. You could also have Power BI point directly from Stream Analytics; however, this data would not be persisted in a data store.

upvoted 1 times

...

cadio30

4 years, 1 month ago

The link already stated that the setup is feasible in 'REAL TIME'

upvoted 2 times

...

dakku987

Most Recent 1 year, 6 months ago

Selected Answer: A

chat gpt says Based on the information provided, it seems like the solution has the potential to meet the goal, but there are some details that need clarification and adjustments. Therefore, I would say it's a "Yes, with caveats." Ensure that you address the specific details mentioned in the evaluation to make the solution more robust and aligned with the goal of counting keyword occurrences and sending the data to Power BI in near real-time.

upvoted 1 times

...

Ssv2030

3 years, 9 months ago

the question says "The data must be available to Microsoft Power BI in near real-time", but ASA +Power BI is real-time combination as per: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-power-bi-dashboard And, there is difference between real time and near real time. So, I feel the answer is 'NO' can someone pls confirm?

upvoted 1 times

...

BigMF

4 years ago

I think the key phrase is "...then send the data directly to Power BI". Power BI is NOT a data store and does not "accept" data, it goes and gets it. Therefore, I believe the answer to be NO.

upvoted 2 times

...

Mandar77

4 years ago

You have to use power Bi in direct query mode

upvoted 2 times

...

MMM777

4 years, 1 month ago

Should be YES. Another doc showing it is possible - BI can only query every 1 second - but that is near real time: https://docs.microsoft.com/en-us/azure/stream-analytics/power-bi-output

upvoted 2 times

...

Nik71

4 years, 3 months ago

https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming#pushing-data-to-datasets Answer is Yes

upvoted 2 times

...

I

4 years, 3 months ago

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.

upvoted 2 times

I

4 years, 3 months ago

Answer is No.

upvoted 1 times

obz

4 years, 3 months ago

You can aggregate and send directly to Power BI with Azure stream analytics if you want to achieve near-real time reporting. Using a intermediary SQL Database will be a waste of cost & management and won't allow you to achieve near real-time reporting. The Answer is YES.

upvoted 7 times

...