Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
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 2 question 88 discussion

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

You have a Power BI semantic model that contains four queries named Query 1, Query2. Query3, and Query4.

Query1 loads customer data into the model and is referenced by the other three queries.

You discover that data refresh for the model is slow.

You need to improve the data refresh time. The solution must minimize costs.

What should you do?

  • A. Run the Table.buffer function in Query1.
  • B. Duplicate Query1 to all the other queries.
  • C. Reconfigure Query1 as a dataflow entity.
  • D. From the Power BI Admin portal, increase the Capacity settings.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by Endeetheanalyst at Sept. 5, 2024, 1:15 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
b92fc92
Highly Voted 2 months, 1 week ago
Selected Answer: C
https://learn.microsoft.com/en-us/power-bi/guidance/power-query-referenced-queries "In the example, if Query1 is redesigned as a dataflow entity, Query2, Query3, and Query4 can use it as a data source. With this design, the entity sourced by Query1 will be evaluated only once."
upvoted 5 times
1CY1
2 months, 1 week ago
Per the above reference... We recommend you create a dataflow instead. Using a dataflow can improve data refresh time and reduce impact on your data sources.
upvoted 2 times
...
...
jaume
Most Recent 3 days, 23 hours ago
Selected Answer: C
I vote for option C. We should copy the code in Query 1 t ouse it to create dataflow with it... Table.buffer could improve performace by preventing multiple scans of the SOURCE table during transformations; since queries 2, 3 and 4 are referenced to Query 1, they are not scanning the source table but the referenced query which is retrieving the data from the source
upvoted 1 times
...
Davery
2 months ago
Selected Answer: C
Its C: your comment is too short
upvoted 1 times
...
9d92039
2 months, 1 week ago
Selected Answer: A
https://learn.microsoft.com/en-us/power-bi/guidance/power-query-referenced-queries
upvoted 1 times
b92fc92
2 months, 1 week ago
you selected A, but your link says that the correct answer is C, about Table.Buffer it says "This result could in fact compound the negative performance, because the table will be buffered by each referencing query." While about evaluating Query1 as dataflow entity it says "In the example, if Query1 is redesigned as a dataflow entity, Query2, Query3, and Query4 can use it as a data source. With this design, the entity sourced by Query1 will be evaluated only once." So the correct answer is C
upvoted 1 times
...
...
Ash_34
2 months, 2 weeks ago
Selected Answer: A
Table.Buffer will keep the data in memory as buffer. So there wont be any changes in data. this is similar to referencing the data.
upvoted 1 times
...
Endeetheanalyst
2 months, 2 weeks ago
Run the Table.Buffer function in Query1
upvoted 1 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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