HOTSPOT You plan to create the Power BI model shown in the exhibit. (Click the Exhibit tab.) *(refer to diagram in explanation below)* The data has the following refresh requirements:
• Customer must be refreshed daily.
• Date must be refreshed once every three years.
• Sales must be refreshed in near real time.
• SalesAggregate must be refreshed once per week. You need to select the storage modes for the tables. The solution must meet the following requirements:
• Minimize the load times of visuals.
• Ensure that the data is loaded to the model based on the refresh requirements. Which storage mode should you select for each table? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Interactive Drag & Drop Matching
Drag each configuration to its target, or tap an option then tap a target slot.
Available Configurations4 remaining
DirectQuery It requires near real-time updates.
Dual mode It changes very rarely but is referenced in almost every model relationship.
Dual mode It refreshes daily and is a dimension table used with both cached and live data.
Import It refreshes just once per week.
Targets & Placement
1Customer
Drop configuration here
2Date
Drop configuration here
3Sales
Drop configuration here
4SalesAggregate
Drop configuration here
Explanation
Hotspot Solution:
Recommended Community Solution:
Customer – Dual mode It refreshes daily and is a dimension table used with both cached and live data. Dual lets Power BI decide whether to use the cached Import copy or query the source directly. This avoids performance penalties when joined with DirectQuery fact tables. 2. Date – Dual mode It changes very rarely but is referenced in almost every model relationship. Dual allows Power BI to reuse the cached data when possible and still work smoothly with DirectQuery tables. This prevents slowdowns in visuals that combine Date with DirectQuery facts. 3. Sales – DirectQuery It requires near real-time updates. Only DirectQuery can fetch the most current data from the source at query time. 4. SalesAggregate – Import It refreshes just once per week. Import mode gives in-memory storage which makes visuals much faster for aggregated data.
Community Discussion
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
6
So, I'm just here to encourage 2026 users that the questions are still the same and valid for practice. I wrote mine today; It was a breeze. 85% of the questions were in this material. Best of luck
2
Customer: Dual – Daily refresh and often joins with Sales; Dual optimizes mixed queries. Date: Import – Static table, refreshed every 3 years; Import is fastest for visuals. Sales: DirectQuery – Near real-time requirement; must query source directly. SalesAggregate: Import – Weekly refresh; Import ensures fast aggregated visuals.
1
Customer: Dual Date: Dual Sales: Direct Query Sales Aggregate: Import
