Microsoft Power BI Data Analyst — Question 48

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?

Answer options

• A. DirectQuery
• B. live connection
• C. import

Correct answer: A

Explanation

The correct choice is DirectQuery because it allows Power BI to query the data source in real-time, ensuring that updates from DB1 are reflected within the required two-minute timeframe. A live connection is typically used for connecting to Analysis Services, and import mode does not provide real-time updates as it requires scheduled refreshes to update the data.