Microsoft Power BI Data Analyst Practice Question

DirectQuery leaves the data in the source system and executes queries at report time, so the dataset stored in the Power BI service remains small. Because the data is queried live, changes made in Azure Synapse are visible almost immediately without scheduling large periodic refreshes. Import mode would copy the multi-terabyte table into the Power BI dataset, creating a very large model and requiring scheduled refreshes that cannot occur every few minutes. A live connection to a Power BI semantic model or a push dataset would still need the data pre-loaded into that dataset; they do not directly query Synapse and thus would not avoid the storage or refresh constraints in this scenario.