DP-500 · Question #73
How should you configure the Power BI dataset refresh for the dbo.SalesTransactions table?
The correct answer is B. an incremental refresh of dbo.SalesTransactions where the SalesDate value is during the last three days. Configure an incremental refresh for the dbo.SalesTransactions table, using the SalesDate column to filter data for the last three days to optimize refresh performance.
Question
Options
- Aan incremental refresh of Product where the ModifiedDate value is during the last three days.
- Ban incremental refresh of dbo.SalesTransactions where the SalesDate value is during the last three days.
- Ca full refresh of all the tables
- Dan incremental refresh of dbo.SalesTransactions where the SalesDate value is during the last hour.
How the community answered
(40 responses)- A8% (3)
- B73% (29)
- C5% (2)
- D15% (6)
Why each option
Configure an incremental refresh for the `dbo.SalesTransactions` table, using the `SalesDate` column to filter data for the last three days to optimize refresh performance.
The question specifically asks about `dbo.SalesTransactions`, not `Product`, and `ModifiedDate` might not be the most relevant column for sales transactions.
An incremental refresh of the `dbo.SalesTransactions` table, filtered by the `SalesDate` column for data during the last three days, is an efficient way to refresh a large transactional table by only loading recent data, reducing refresh times.
A full refresh of all tables is inefficient for large transactional tables as it reloads all historical data every time, increasing refresh duration and resource usage.
An incremental refresh for only the last hour might be too granular, potentially missing transactions from the previous hours within the current day or leading to frequent, small refreshes.
Concept tested: Power BI incremental refresh configuration
Source: https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
Topics
Community Discussion
No community discussion yet for this question.