Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 47 of 134
Free Preview · 134 of 444 · questions 1–134 of 444 are free. Sign up free to sync your progress across devices.
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Direct query Live connection is when we work on an existing powerbi semantic model shared. Maybe also other cases ( Analysis service models )
* Answer: A. DirectQuery * Explanation: - DirectQuery keeps the data in the source (Azure SQL DB) and queries it in real time. - It supports near real-time updates because Power BI retrieves data directly from the database whenever the report is refreshed or interacted with. - This meets the requirement of showing updated data within two minutes of changes in DB1. * Why not the others: - Live connection: Used for Analysis Services models, not for Azure SQL DB. - Import: Loads data into Power BI’s in-memory model; updates require scheduled refresh, which cannot guarantee a 2-minute latency.
The correct answer is A. DirectQuery ✅ Reason: DirectQuery mode keeps data in the source system (DB1 in this case) and queries it in real time (or near real time) whenever a user interacts with a report. This means Model1 will reflect updates from DB1 within minutes — depending on refresh policy and query performance, even instantly. Why not the others? Live connection – Only applies to connecting to existing Analysis Services or Power BI datasets, not directly to Azure SQL Database. Import – Data is copied into Power BI’s in-memory model and only updates when you refresh it. Even with scheduled refresh, the minimum is usually every 30 minutes (in Premium workspaces) — not 2 minutes. DirectQuery is the only option here that meets the within two minutes requirement.