PL-300 Model the data Practice Question
A company has a Power BI semantic model that uses Import mode. The model contains a table with 10 million rows. The data source is a SQL Server view that takes 5 minutes to execute. The scheduled refresh is set to every hour. What is the likely impact on refresh performance?
⚠ Common exam trap
Many exam-takers assume the gateway has a default 5-minute timeout, leading them to choose Option A, but the actual default timeout is 10 minutes, and the question does not specify any custom timeout settings.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Refresh will take at least 5 minutes plus data loading time.
The refresh process must first execute the SQL Server view to retrieve data, which takes at least 5 minutes, and then load that data into the Import mode model. The total refresh time is the sum of the query execution time and the data loading time, so it will be at least 5 minutes plus additional time for loading 10 million rows.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Refresh will fail due to timeout on the gateway.
Why it's wrong here
A gateway timeout occurs only when the gateway's configured wait time for a data source response is exceeded during a refresh operation. This scenario does not mention a gateway or its timeout settings, and the 5-minute view execution is not inherently a timeout trigger, as the refresh is still in progress. Therefore, assuming failure is unfounded; the refresh may simply take longer than the view execution time.
- ✗
The model will automatically use incremental refresh to split the load.
Why it's wrong here
Incremental refresh requires explicit configuration through RangeStart/RangeEnd parameters and a defined incremental refresh policy in Power BI Desktop; it does not automatically engage based on source query duration. Moreover, incremental refresh is designed for partitioning data by date ranges, not for splitting the load of a slow view, and it depends on query folding back to the source. Without prior setup, the refresh will attempt to load the entire dataset in a single pass.
- ✗
Refresh will complete in parallel with the view execution.
Why it's wrong here
A refresh operation is strictly sequential at the data retrieval stage: the query that defines the view must return its result set before the Power BI engine can begin loading rows into the semantic model. Parallelism in a refresh pipeline can occur between different tables or partitions, but within a single table's refresh, the view execution and data load are dependent steps. Since the view is the data source for this model, the load cannot start until the view finishes, making the total time at least the sum of both stages.
- ✓
Refresh will take at least 5 minutes plus data loading time.
Why this is correct
The view execution is a fixed prerequisite for the refresh: the Power BI engine must run the source query and wait for the full 5-minute execution to complete before it receives any data to load. Only after the view returns can the data loading phase, including any transformations, indexing, and storage into the in-memory columnstore, take place. Therefore, the absolute minimum refresh duration is 5 minutes, with the actual time being that 5 minutes plus the entire downstream loading and processing time.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PL-300 question from scratch — 217 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
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.