Forum Discussion
Power BI PL 300 (Modelling & JSON) - Test 1, Question 1 & Test 3, Question 3/Question 54
Hi, everyone,
I would love to double check my answer. if I am wrong, please let me know and tell me why? Thank you!!
PL 300 Exam, Test 1, Question 1
My answer to this question is
Customer: Dual (as dual/hybrid can refresh in real time)
Date: Dual (as dual/hybrid can refresh in real time)
Sales: DirectQuery (as direct query can refresh NEAR real time)
Sales Aggregate: Import (as import model must refresh on the scheduled basis)
PL 300 Exam, Test 3, Question 3
My answer to this question is: B & E
My answer to this question is: D
10 Replies
- AnonymousNot applicable
Hi MapleCookie,
Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to Syk for prompt and helpful responses.
In my opinion Date table change from Dual to Import. Reason is The Date table is very static and does not need real time behavior. Using Import gives better performance and simpler queries. Dual is unnecessary here.
Thanks & Regards,
Prasanna Kumar
- Syk
Resident Rockstar
For your first question, the criteria is data loaded rarely (with the exception of Sales). It also wants the visuals on the report to be quick. This would mean every table that is not Sales should use Import. Sales I'd probably answer as Direct Query since its near real time.
Your other two questions seem correct.
- MapleCookie
Helper II
also I have enclosed further explanation for your consideration.
hope it helps. thanks.
- MapleCookie
Helper II
I am not 100% sure of my answer to Test 1, Question 1.
I have the articles from:
a/Manage storage mode in Power BI Desktop, Microsoft
b/Semantic model modes in the Power BI service, Microsoft
https://learn.microsoft.com/en-us/power-bi/connect-data/service-dataset-modes-understand
Based on the above 2 artciles, I got my answer to this question.
- Syk
Resident Rockstar
My answer to this question is
Customer: Dual (as dual/hybrid can refresh in real time)
Date: Dual (as dual/hybrid can refresh in real time)
These are incorrect. Import is what you want for these since you can update it daily on a schedule and it will improve preformance of visuals.
- MapleCookie
Helper II
Thanks for your reply. thank you!!
- MapleCookie
Helper II
Hiļ¼ have you every considered the followinhg article?
Initially my first attempt answer was as the same as yours.
but after read the following articles, I changed my mind.
I still believe that my orginal answer is correct.
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode
- MapleCookie
Helper II
so far, I am not 100% sure about my answer.
anyone disagree with my original answer within this post, welcome to let me know and please also kindly tell me why?
- AnonymousNot applicable
Hi MapleCookie,
Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar - MapleCookie
Helper II
Anonymous
Thanks for your reply.
I will take a look at your answer and related Microsoft technical artilce again.
if have any questions, I will reach out to you again.
Once again thanks for your help to my Power BI study.