Exam PL-300 topic 2 question 91 discussion

real-time analytics => DirectQuery

Why push mode is the best fit: Real-time analytics: Push mode is designed specifically for streaming scenarios where data is sent into Power BI as it arrives. No refresh needed: Visuals update automatically when new data is pushed — no scheduled or manual refresh required. Minimal impact on source: Since Power BI receives the data passively (it doesn’t query the source), it avoids putting load on the original system

Push datasets allow streaming updates without refresh and support real-time visuals.

Push mode: This mode allows data to be pushed directly into Power BI from a streaming data source. It is designed for real-time analytics and does not require a data refresh because the data is continuously updated as it is pushed into Power BI. This minimizes the performance impact on the data source since the data is sent directly to Power BI without querying the source repeatedly.

D. push mode https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data Push semantic models don't contain a formal definition of a data source, so they **don't require you to perform a data refresh in Power BI**. You refresh them by pushing your data into the semantic model through an external service or process, such as Azure Stream Analytics. This is a **common approach for real-time analytics** with Power BI.

The correct answer is D: Push Mode

Push mode. The Refresh is for the data set. Not the report

Pushmode handles frequent data updates without requiring a data refresh. Cannot be direct query, as stated on the requirement '• Displays the most recent data without performing a data refresh' direct query it requires querying the data source each time the report is viewed or interacted with. 100%

C. LiveConnect Mode DirectQuery and Import modes are to connect to the data source, not the dataset. Push mode is a semantic model, not a connectivity mode. LiveConnect is used to connect to a semantic model that already exists: Source: https://learn.microsoft.com/en-us/power-bi/connect-data/service-live-connect-dq-datasets Excerpt: "When you create your report in Power BI Desktop, you can connect it to a semantic model that already exists. A live connection allows you to rely on existing data, which can be updated without accessing the report."

Push mode displays without a data refresh

With LiveConnection we can connect a PBI report to a Semantic Model but question is about "connectivity mode should you use for the dataset" so the answer should be DirectQuery (note: Dataset is the former name of current Semantic models)

Correct answer is D

I think it's Push mode based on this article:

Should be C. The power bi semantic model that's connected to the live streaming data source already is created and exists. You want to build a report by connecting to that semantic model, therefore you should just connect to it as a live dataset.

Direct Query.

Live connection and DirectQuery comparison https://learn.microsoft.com/en-us/power-bi/connect-data/service-live-connect-dq-datasets Live connection is a method that lets you build a report in Power BI Desktop without having to build a semantic model for it. The semantic model can dynamically request data from a data source it's connected to using a method called DirectQuery. When using DirectQuery, your report uses Data Analysis Expression (DAX) queries to get data. After the semantic model receives the report's DAX query, it generates another set of queries that are run on your data source, to get the required data. From this I am concluding use DirectQuery.

As I guess answer is push mode