Microsoft Power BI Data Analyst — Question 114

You have a Power BI semantic model that contains four queries named Query 1, Query2. Query3, and Query4.

Query1 loads customer data into the model and is referenced by the other three queries.

You discover that data refresh for the model is slow.

You need to improve the data refresh time. The solution must minimize costs.

What should you do?

Answer options

• A. Run the Table.buffer function in Query1.
• B. Duplicate Query1 to all the other queries.
• C. Reconfigure Query1 as a dataflow entity.
• D. From the Power BI Admin portal, increase the Capacity settings.

Correct answer: C

Explanation

Reconfiguring Query1 as a dataflow entity allows for better resource management and efficiency during refresh operations, which directly addresses the slow refresh issue. The other options either do not effectively improve refresh times or could lead to unnecessary costs and complexity, such as duplicating queries which can increase refresh time rather than decrease it.