PL-300 Prepare the data Practice Question
Which THREE factors should you consider when choosing between Import and DirectQuery storage modes? (Choose three.)
⚠ Common exam trap
It's easy for candidates to confuse licensing constraints (Pro vs Premium) with storage mode capabilities, when in fact both modes are available regardless of license, though Premium offers higher Import size limits and additional features like automatic page refresh for DirectQuery.
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
✓
Report interactivity and performance needs.
Option B is correct because Import mode loads data into the in-memory VertiPaq engine and typically delivers the fastest query performance and richest interactivity, while DirectQuery pushes queries to the source and can introduce latency, so the report's interactivity and performance needs directly drive the choice. Option D is correct because Import is bounded by dataset size limits (for example, 1 GB per dataset on Shared/Pro capacity, up to 400 GB on Premium/Fabric capacities) and memory, whereas DirectQuery has no such dataset size limit since data stays at the source, making data volume a key factor. Option E is correct because Import requires scheduled refreshes (up to 8 per day on Pro, 48 on Premium) and only shows data as of the last refresh, while DirectQuery reflects source changes in near real time, so refresh frequency and latency requirements are decisive. Option A is not a storage-mode factor because the Pro vs Premium license affects capacity features and refresh limits rather than the fundamental Import vs DirectQuery decision. Option C is irrelevant because color scheme and branding are purely visual design choices unrelated to how data is stored or queried.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
User license type (Pro vs Premium).
Why it's wrong here
User license type (Pro vs Premium) is irrelevant to storage mode selection. While Premium capacity affects how reports are shared, dataset size limits, and features like paginated reports, the choice between Import and DirectQuery is driven by data volume, refresh latency, and query performance. Licensing does not change the underlying mechanics of how data is stored or queried within a dataset.
- ✓
Report interactivity and performance needs.
Why this is correct
Report interactivity and performance needs are critical because Import mode pre-loads data into memory via VertiPaq, enabling sub-second slicer and cross-filter responses. DirectQuery issues live queries to the source system, so performance depends on the source database's load, indexing, and connectivity speed, which can cause visible delays. For highly interactive dashboards, import or a composite model with aggregated import tables is usually superior.
- ✗
Report color scheme and branding.
Why it's wrong here
Report color scheme and branding are purely aesthetic design decisions that do not impact data storage engine selection. Whether a report uses a corporate palette or custom visuals, the underlying storage mode remains unchanged. These choices neither limit nor require any particular data connection method.
- ✓
Data volume and size limits.
Why this is correct
Data volume and size limits matter because Import mode loads a compressed copy into Power BI, and that copy counts against dataset size caps (e.g., 1 GB in shared capacity, larger in Premium) and memory on the capacity. DirectQuery avoids storing a copy, allowing you to work with massive tables that would exceed import limits. However, DirectQuery pushes the performance burden back onto the source system.
- ✓
Data refresh frequency and latency requirements.
Why this is correct
Data refresh frequency and latency requirements distinguish the modes: Import requires a scheduled or triggered refresh, meaning the report shows data as of the last refresh, while DirectQuery always queries the live source so no refresh is needed. If business users expect real-time insights—e.g., fraud detection or inventory monitoring—DirectQuery (or a hybrid with incremental refresh) is necessary. Conversely, for historical analysis where hourly or daily updates suffice, import is simpler and faster.
Go deeper
Related to this question
About these practice questions
This PL-300 question is part of Courseiva's 524-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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.