DP-500 Question #105: Real Exam Question with Answer & Explanation

Question

You manage a Power BI dataset that queries a fact table named SalesDetails. SalesDetails contains three date columns named OrderDate, CreatedOnDate, and ModifiedDate. You need to implement an incremental refresh of SalesDetails. The solution must ensure that OrderDate starts on or after the beginning of the prior year. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. NOTE: More than one of order of answer choices is correct. You will receive credit for any of the correct orders you select.

Explanation

This question tests your ability to configure incremental refresh on a Power BI dataset, specifically filtering by a date column (OrderDate) and defining the refresh range parameters in Power Query.

Approach. The correct sequence to implement incremental refresh for SalesDetails with OrderDate starting on or after the beginning of the prior year is: (1) Define RangeStart and RangeEnd parameters in Power Query (type: Date/Time, required for Power BI to recognize incremental refresh). (2) Filter the OrderDate column in Power Query using RangeStart and RangeEnd (OrderDate >= RangeStart AND OrderDate < RangeEnd) - this is critical because Power BI only supports incremental refresh on the column used in the filter. (3) In the dataset's Incremental Refresh settings in Power BI Desktop, enable incremental refresh on the SalesDetails table and set the 'Archive data starting' period to cover at least 1 full prior year. (4) Publish the dataset to the Power BI Service, which triggers Power BI to partition the data and apply the incremental policy. The filter must be on OrderDate specifically (not CreatedOnDate or ModifiedDate) because the requirement explicitly states OrderDate must start on or after the beginning of the prior year.

Concept tested. Power BI Incremental Refresh configuration - defining RangeStart/RangeEnd Power Query parameters, applying date filters on the correct column, configuring the refresh policy window, and publishing to the service to activate partitioning.

Reference. Microsoft Learn: Configure incremental refresh and real-time data for datasets - https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure

No community discussion yet for this question.