You plan to create a Power BI semantic model named Model1 that will contain data from an Azure SQL database named DB1. Model1 must show updated data within two minutes of the data being updated in…

The correct answer is A. DirectQuery. DirectQuery does not import data into Power BI; instead, every report interaction sends a live query directly to the Azure SQL database, so the data displayed is always current - satisfying the two-minute freshness requirement. Import mode caches a snapshot of the data and the…

Submitted by kim_seoul· Apr 18, 2026

Question

You plan to create a Power BI semantic model named Model1 that will contain data from an Azure SQL database named DB1. Model1 must show updated data within two minutes of the data being updated in DB1. You need to select a connectivity mode for the connection to DB1. What should you choose?

Options

ADirectQuery
Blive connection
Cimport

How the community answered

(32 responses)

A
81% (26)
B
6% (2)
C
13% (4)

Explanation

DirectQuery does not import data into Power BI; instead, every report interaction sends a live query directly to the Azure SQL database, so the data displayed is always current - satisfying the two-minute freshness requirement. Import mode caches a snapshot of the data and the minimum scheduled refresh interval in shared capacity is 30 minutes (8 times per day), which cannot meet a two-minute SLA. Incremental refresh optimizes Import mode refreshes but does not overcome the minimum interval constraint. Live connection is specific to Analysis Services (SSAS) or Power BI datasets, not Azure SQL Database directly.

Community Discussion

No community discussion yet for this question.

Full PL-300 Practice