The correct answer is to configure Incremental refresh with Detect data changes on the date column. This approach partitions the large fact table by date, loading only recent data into the model while keeping historical partitions available for on-demand queries. By enabling Detect data changes, Power BI efficiently identifies and refreshes only the partitions where the date column has been modified, drastically reducing data load and refresh time for a 100-million-row table. On the PL-300 exam, this scenario tests your understanding of optimizing large datasets without sacrificing query flexibility—a common trap is choosing a simple filter or full refresh, which would either lose historical data or overload the model. Remember the key principle: incremental refresh balances storage and performance by archiving history while refreshing only what changes. A useful memory tip is “Partition by date, detect the change, keep the range.”
PL-300 Prepare the data Practice Question
This PL-300 practice question tests your understanding of prepare the data. Read the scenario carefully and evaluate each option against the stated constraints before committing to an answer. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
You are building a Power BI report that uses a large fact table with 100 million rows. The data source is a SQL Server view that filters data by a date range. You want to minimize the data loaded into the model while maintaining the ability to query any date range later. What should you do?
Clue words in this question
Noticing these words before you look at the options changes how you read each choice.
Clue: "minimum / minimize"
Why it matters: Asks for the least resource use — fewest addresses, smallest subnet, lowest overhead. Eliminate over-provisioned options even if they would technically work.
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Configure Incremental refresh with Detect data changes on the date column.
Option B is correct because Incremental refresh allows you to partition the fact table by date, loading only recent data into the model while keeping the ability to query historical data on demand. By enabling 'Detect data changes', Power BI can efficiently identify and refresh only the partitions that have changed, minimizing data load and refresh time. This approach maintains query performance for any date range because historical partitions remain available in the model without being re-imported.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
✗
Switch to DirectQuery mode and rely on the source database for filtering.
Why it's wrong here
DirectQuery may be slow for large fact tables and complex aggregations.
✓
Configure Incremental refresh with Detect data changes on the date column.
Why this is correct
This loads only the changed/new partitions, reducing refresh load while keeping full history.
Clue confirmation
The clue word "minimum / minimize" in the question point toward this answer.
Related concept
Read the scenario before looking for a memorised answer.
✗
Use Import mode and apply a date filter in Power Query to limit rows.
Why it's wrong here
This limits initial load but cannot query other dates without re-import.
✗
Create a calculated table with only the required columns.
Why it's wrong here
This does not reduce rows loaded; it only removes columns.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates often choose Import mode with a static filter (Option C) thinking it reduces data load, but they overlook the requirement to query any date range later, which Incremental refresh uniquely satisfies by partitioning data dynamically.
Detailed technical explanation
How to think about this question
Incremental refresh works by creating date-range partitions in the Power BI service, using a RangeStart and RangeEnd parameter in Power Query. The 'Detect data changes' option uses a date/time column to track modifications, enabling Power BI to refresh only partitions where data has changed, rather than scanning the entire table. This is particularly effective for large fact tables (e.g., 100 million rows) where full refreshes would be time-consuming and resource-intensive, and it ensures that historical data remains queryable without re-importing it.
KKey Concepts to Remember
Read the scenario before looking for a memorised answer.
Find the constraint that changes the correct option.
Eliminate answers that are true in general but not in this case.
TExam Day Tips
→Watch for words such as best, first, most likely and least administrative effort.
→Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
How this comes up in practice
A cloud solutions architect for a retail company is evaluating services for a new workload. The correct answer here reflects best practice for the specific scenario described — not a general cloud recommendation. Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option. Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.
What to study next
Got this wrong? Here's your next step.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Prepare the data — This question tests Prepare the data — Read the scenario before looking for a memorised answer..
What is the correct answer to this question?
The correct answer is: Configure Incremental refresh with Detect data changes on the date column. — Option B is correct because Incremental refresh allows you to partition the fact table by date, loading only recent data into the model while keeping the ability to query historical data on demand. By enabling 'Detect data changes', Power BI can efficiently identify and refresh only the partitions that have changed, minimizing data load and refresh time. This approach maintains query performance for any date range because historical partitions remain available in the model without being re-imported.
What should I do if I get this PL-300 question wrong?
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Are there clue words in this question I should notice?
Yes — watch for: "minimum / minimize". Asks for the least resource use — fewest addresses, smallest subnet, lowest overhead. Eliminate over-provisioned options even if they would technically work.
What is the key concept behind this question?
Read the scenario before looking for a memorised answer.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
This PL-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-300 exam.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.