nerdexam
Microsoft

PL-300 · Question #403

You have a Power BI semantic model that connects to a streaming data source. The data source is updated frequently. You need to create a Power BI report that meets the following requirements…

The correct answer is A. DirectQuery mode. For a Power BI semantic model connected to a frequently updated streaming source, DirectQuery mode is best for real-time analytics, minimizing source impact, and displaying the most recent data without explicit refreshes.

Submitted by rohit_dlh· Apr 18, 2026

Question

You have a Power BI semantic model that connects to a streaming data source. The data source is updated frequently. You need to create a Power BI report that meets the following requirements:

  • Supports real-time analytics
  • Minimizes performance impact on the data source
  • Displays the most recent data without performing a data refresh

Which connectivity mode should you use for the dataset?

Options

  • ADirectQuery mode
  • Bimport mode
  • CLiveConnect mode
  • Dpush mode

How the community answered

(48 responses)
  • A
    81% (39)
  • B
    10% (5)
  • C
    2% (1)
  • D
    6% (3)

Why each option

For a Power BI semantic model connected to a frequently updated streaming source, DirectQuery mode is best for real-time analytics, minimizing source impact, and displaying the most recent data without explicit refreshes.

ADirectQuery modeCorrect

DirectQuery mode directly queries the underlying data source with every user interaction, ensuring that reports always display the most current data without needing a data refresh in Power BI. This mode minimizes performance impact on the data source as Power BI does not store a copy of the data, only metadata.

Bimport mode

Import mode loads all data into the Power BI model, requiring scheduled refreshes to get updated data, which doesn't meet the real-time or 'without data refresh' requirements.

CLiveConnect mode

LiveConnect mode connects to existing Power BI datasets or Analysis Services models, not directly to a streaming source for query-based real-time analysis as described.

Dpush mode

Push mode programmatically pushes data into Power BI, typically for real-time dashboards, but for a semantic model connecting to a source for query-based real-time analytics, DirectQuery is the standard approach.

Concept tested: Power BI connectivity modes (DirectQuery)

Source: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about

Community Discussion

No community discussion yet for this question.

Full PL-300 Practice