Microsoft Power BI Data Analyst Practice Question

DirectQuery leaves the data in Azure SQL Database and sends a SQL query each time a report visual is rendered. Although Power BI may keep short-lived caches of recent query results, no full or permanent copy of the tables is imported into the semantic model, so the policy against storing persistent data is respected. DirectQuery still creates a semantic model in Power BI Desktop, enabling you to define relationships and DAX measures. Import mode would copy the data into the .pbix file and the service, violating the policy. A live connection is only available for Analysis Services or another published Power BI semantic model, and connecting to an existing dataset would prevent you from defining new relationships in the file.