Exam PL-300 All QuestionsBrowse all questions from this exam
Go to Exam
Question 1

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:

    Correct 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

Discussion
_Jay_

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)

Deeku

makes sense

GuerreiroJunior

Make sense, thank you so much Jay

RAMzZV

Agreed with this approach.

JudT

Correct, cheers Jay!

Tomasz_Black

Hi All, I have passed an exam with score nearly 900 points. Most of the questions were from this site. Exam 01.12.2023 Good luck all !!!

tranalyst

Xin via!

0e18c76

Passed my exam on 21.05.2024 with a score of 958 points. I'd like to thank all the contributors for the valuable tips and information on each subject. It allowed me to practice and level up my skills in Power BI. For those planning to get the certification, I strongly advice you to get the subscription to get access to all 258 questions, as most of the questions were from this site. But be aware that some of the answers given on this site are not correct. Therefore, it really helps if you follow the discussions on each question and then practice on Power BI Desktop and Power Bi service to confirm the answers (Learn by doing is the best strategy). Check also the Microsoft documentation suggested by the contributors of this site. Good luck! By the way this question came on the exam today. The answer given is correct.

Viole9

Hey guys, I passed with 875 points. I used this website and Microsoft's learning path and practice assessments; I bought the contributor access for this PL-300 exam. I thought I'd share my experience and clear up some points. First of all, not all questions you get are here. I got around 70% questions from here. So, take your chances by keeping that in mind. (April 9, 2024) Second, must read the comments because many answers are wrong. All the best and I hope it helps.

Tareqk

This is was on the exam today. 2024-04-19

Raj1690

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?

LOCOBI

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.

05d50c0

Today, I had an exam that I passed, and most of the questions were from this site. I subscribed just yesterday, and thank God I found such a helpful website. I recommend paying attention to the discussions, as they help more in clarifying the underlying concepts related to specific scenarios in the questions.

Nishi_06

Dual Mode

king1994

I have all PL 300 exam questions, please contact me if you want

Databoydata

PleSe share it with me king

haerinfan

hi please share it with me king

Anu_27

Hi, Can you share it with me? Thanks

Dk4484

hi please share it with me king

shosha7

Hello, did anyone take the exam on Pearson Vue? I really wish someone would fill me on the steps, please.

Chellz

On today's exam 06/08/2024

ARuku_5

guys I need help anyone pls tell me is this website useful for pl-300 exam???

0e18c76

I promiss you that this site is very usefull. Around 80% to 90% of the questions come in the exam. I bought the whole package with 258 questions and did all questions at least 2 times. The questions where I had more dificulties I practiced and repeated a couples of times. Be aware that some of the responses from the site are not correct. Therefore, consult the discussions and confirm with the related microsoft documentation, and try to reproduce the situation on Power Bi Desktop and Power BI Service. With this site and by practicing I passed 5 days ago with a score of 958 over 1000. If you study and practice the exam is gonna be too easy. Good luck

Inesd

This brings clear answer : https://prologika.com/understanding-power-bi-dual-storage/

phoenixxWR

How to best prepare for test. Any tips ?

docoumn

The answer is correct

GowthamMupparapu

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.