DP-600 Question #22: Real Exam Question with Answer & Explanation

Question

You have a Fabric tenant that contains 30 CSV files in OneLake. The files are updated daily. You create a Microsoft Power BI semantic model named Model1 that uses the CSV files as a data source. You configure incremental refresh for Model1 and publish the model to a Premium capacity in the Fabric tenant. When you initiate a refresh of Model1, the refresh fails after running out of resources. What is a possible cause of the failure?

Options

• AQuery folding is occurring.
• BOnly refresh complete days is selected.
• CXMLA Endpoint is set to Read Only.
• DQuery folding is NOT occurring.
• EThe delta type of the column used to partition the data has changed.

Explanation

Incremental refresh in Power BI depends on query folding to push date/time range filter predicates back to the data source, so only the relevant partition's data is retrieved. When query folding is NOT occurring (D), Power BI cannot delegate the filter to the source and must instead load the entire dataset into the Power Query engine in memory, then filter locally. With 30 large CSV files loaded entirely into memory on each refresh, available memory on the Premium capacity can be exhausted. Query folding occurring (A) would actually be desirable and prevent this problem. Options B, C, and E describe unrelated configuration issues.

No community discussion yet for this question.