DP-201 Exam QuestionsBrowse all questions from this exam
Go to Exam

DP-201 Exam - Question 63

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?

Show Answer
Correct Answer: B

The solution does not meet the goal. The problem requires counting the occurrences of specific keywords in real-time data and making this data available to Power BI in near real-time. While Azure Stream Analytics can process streaming data from Event Hubs and send it to an Azure SQL database, using DirectQuery in Power BI on an Azure SQL database does not provide the most efficient real-time data visualization. Instead, a more suitable approach would be to send the processed data directly from Azure Stream Analytics to Power BI, ensuring that the data is updated in near-real time.

Discussion

5 comments
Sign in to comment
Nik71
Mar 24, 2021

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

chirag1234
Apr 10, 2021

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

Nik71
Mar 24, 2021

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

cadio30
May 25, 2021

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.

Saravjeet
May 29, 2021

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.

vivekazure
Jan 12, 2022

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