Microsoft Power BI Data Analyst Practice Question

DirectQuery leaves the data in the Azure SQL Database and stores only metadata in the Power BI semantic model, so no copy of the detailed rows is persisted in the service. Because queries are sent to the source each time a visual renders, the report can surface changes almost immediately-well inside the one-minute requirement-without waiting for scheduled or incremental refresh cycles. Import modes (with or without incremental refresh) would cache the data inside Power BI and rely on refresh jobs that cannot guarantee sub-minute latency. A live connection to Analysis Services is irrelevant here because the model resides directly in Azure SQL, and building an intermediate Analysis Services layer would still require data movement or a separate modeling environment. Therefore, DirectQuery best satisfies both the real-time visibility and the data-duplication constraint.