ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 1 question 1 discussion

Actual exam question from Microsoft's PL-300
Question #: 1
Topic #: 1
[All PL-300 Questions]

HOTSPOT -
You plan to create the Power BI model shown in the exhibit. (Click the Exhibit tab.)

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.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Dual -
Customer should use the dual storage mode.
Dual: Tables with this setting can act as either cached or not cached, depending on the context of the query that's submitted to the Power BI dataset. In some cases, you fulfill queries from cached data. In other cases, you fulfill queries by executing an on-demand query to the data source.
Note: You set the Storage mode property to one of these three values: Import, DirectQuery, and Dual.

Box 2: Dual -
You can set the dimension tables (Customer, Geography, and Date) to Dual to reduce the number of limited relationships in the dataset, and improve performance.

Box 3: DirectQuery -
Sales should use the DirectQuery storage mode.
DirectQuery: Tables with this setting aren't cached. Queries that you submit to the Power BI datasetג€"for example, DAX queriesג€"and that return data from
DirectQuery tables can be fulfilled only by executing on-demand queries to the data source. Queries that you submit to the data source use the query language for that data source, for example, SQL.

Box 4: Import -
Import: Imported tables with this setting are cached. Queries submitted to the Power BI dataset that return data from Import tables can be fulfilled only from cached data.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode
by gabrysr1997 at Sept. 4, 2022, 7:39 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
_Jay_
Highly Voted 5 months ago
Technically Yes, Correct Dual (Composite) Mode: The dual storage mode is between Import and DirectQuery. it is a hybrid approach, Like importing data, the dual storage mode caches the data in the table. However, it leaves it up to Power BI to determine the best way to query the table depending on the query context. 1) Sales Must be Refreshed in Near real time so "Direct Query" 2) Sales Aggregate is once per week so "Import" (performance also required) 3) Both Date and Customer has relationship with both Sales and SalesAggregate tables so "Dual" because to support performance for DirectQuery(Sales) and Import(SalesAggregate)
upvoted 211 times
mustafaalhnuty
1 year, 6 months ago
thanks for sharing your comment so I would ask if in case the Sales and the Sales Aggregate fact tables are both in near real-time will be a Direct Query not dual? thanks in advance
upvoted 1 times
mustafaalhnuty
1 year, 6 months ago
I mean for Both Date and Customer dimension tables
upvoted 2 times
...
...
Nawabi
2 years ago
Correct. IF someone still unable to understand I would highly recommend going through this link. Excellent explanation
upvoted 30 times
__Sai_Mounika__
1 year, 1 month ago
the link provided is on spot
upvoted 1 times
...
...
...
Raj1690
Highly Voted 11 months, 1 week ago
My interpretation of the answer: there are 2 fact tables connected to 2 dim tables. Sales fact table needs DirectQuery.. Sales Aggregate table needs to weekly refreshes hence Import mode. But both dimension tables have to serve these fact tables and hence they will be in DUAL MODE. Am I correct?
upvoted 5 times
...
examtopicsms99
Most Recent 4 months, 3 weeks ago
If the tables are from the same database in this model. Then there is only one frequency of refresh possible. It cannot be weekly , since it says "Customer must be refreshed daily." Also Import mode generally minimizes the load time of visuals compared to Dual mode. This is because Import mode caches all the data in-memory, allowing for very fast query performance and quick rendering of visuals Customer: Import - refresh daily requirement Date: Dual - just because Sales is direct query and might be more efficient to have as Dual. Sales: Direct Query - Real Time by requirements Sales Aggregate: Imported, is weekly, but there is no saving in refresh, since the refresh is daily because the Customers table.
upvoted 1 times
...
Gbucci72
6 months ago
I dont agree, sales are to be done near real time so direct query is right. Sales aggregates once a week, then dual is ok as we want performance too. Customer is dual too. while Date, updated once every 3 yrs can be import.
upvoted 4 times
...
rcaliandro
6 months, 2 weeks ago
In PBI there are 3 connection modes: 1 - Import Mode, all the data is loaded into the model once and you need to manually refresh data before get latest updates 2 - Direct query mode (or similar live for Azure Analysis Service or SSAS), in which PBI sends queries to the sources each time a visualization is refreshed or interacted with 3 - Dual, it is an hybrid mode Saying that, we need for sure a direct query for the sales (since it is near real time) then the sales aggregate should be put to Import since there is an once per week update. Finally, as Microsoft suggest, the dimension tables should be set to dual (date and customers in this case)
upvoted 3 times
...
Nishi_06
7 months, 2 weeks ago
Dual Mode
upvoted 1 times
...
docoumn
11 months, 2 weeks ago
The answer is correct
upvoted 1 times
...
GowthamMupparapu
11 months, 2 weeks ago
Why does Sales Aggregate use Import as per the solution? Where as Date uses Dual. In both the cases there is no real time refresh required, why are we going with Import mode for sales aggregate?? BTW, I understand logic behind selecting Dual for Date as it is dimension table and we intend to reduce number of limited relationships.
upvoted 1 times
...
LOCOBI
11 months, 2 weeks ago
Sales need to be real time so a DirectQueary storage mode. Sales aggregate as is a weekly load you can use Import Mode and save on performance. As you have one of each, the other table connected to this source should be Dual. If they where not connected they would be Import mode.
upvoted 2 times
...
Mal42
1 year, 3 months ago
Dual, dual, direct query, import
upvoted 2 times
...
TrustMyAnswers
1 year, 3 months ago
Give answer is correct. The tables that are connected to both Direct Query and Import should be set as Dual.
upvoted 2 times
...
allapu
1 year, 3 months ago
Customer(dual), date(dual), sales(direct query) , salesaggregate(import)
upvoted 1 times
...
Igetmyrole
1 year, 5 months ago
1. Customer table: Import mode should be used because it needs to be refreshed daily, and importing the data will provide better performance for visuals. 2. Date table: Import mode should be used because even though it is refreshed once every three years, importing it will not significantly affect performance, and it ensures that visual loads quickly. 3. For Sales table: Dual mode should be used for this table because it needs to be refreshed in near real-time. 4. SalesAggregate Tabe: Import mode should be used because it needs to be refreshed once per week, and importing the data will insure better visual performance.
upvoted 2 times
...
Igetmyrole
1 year, 5 months ago
3. Date table: Import mode should be used because even though it is refreshed once every three years, importing it will not significantly affect performance, and it ensures that visual loads quickly.
upvoted 1 times
...
Shalaleh
1 year, 9 months ago
Dual Dual DQ Import
upvoted 1 times
...
lizbette
1 year, 9 months ago
This link is helpful in describing when to use which import mode. The requirement of the data (real-time refresh vs. performance) and the relationships in the exhibit are what this question comes down to. https://learn.microsoft.com/en-us/training/modules/choose-power-bi-model-framework/1-introduction
upvoted 2 times
...
DUVANES
1 year, 11 months ago
Dual Dual DirectQuery Import
upvoted 3 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago