exam questions

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Exam DP-600 topic 1 question 91 discussion

Actual exam question from Microsoft's DP-600
Question #: 91
Topic #: 1
[All DP-600 Questions]

You have a Microsoft Power BI report named Report1 that uses a Fabric semantic model.

Users discover that Report1 renders slowly.

You open Performance analyzer and identify that a visual named Orders By Date is the slowest to render. The duration breakdown for Orders By Date is shown in the following table.



What will provide the greatest reduction in the rendering duration of Report1?

  • A. Enable automatic page refresh.
  • B. Optimize the DAX query of Orders By Date by using DAX Studio.
  • C. Change the visual type of Orders By Date.
  • D. Reduce the number of visuals in Report1.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

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
neoverma
Highly Voted 1 year, 3 months ago
Selected Answer: D
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer#display-the-performance-analyzer-pane "Other - This is the time required by the visual for preparing queries, waiting for other visuals to complete, or performing other background processing."
upvoted 13 times
...
282b85d
Highly Voted 1 year, 2 months ago
Selected Answer: D
While optimizing the DAX query could slightly improve performance, the DAX query duration (27 ms) is already very low. The "Other" duration (1047 ms) is significantly higher than the DAX query (27 ms) and the visual display (39 ms) durations combined. This indicates that most of the time is spent on backend processes such as data preparation, transformations, or communication with the data source. By reducing the number of visuals in Report1, you can decrease the overall load on the report rendering process.
upvoted 5 times
...
nappi1
Most Recent 7 months ago
very unclever question. there isn't enough context, it can be any of these. ofc you point to Other as the cause, so what referenced by neoverma seems reasonable
upvoted 2 times
...
AndreeaVlad
1 year, 1 month ago
Chatbot said the answer is c
upvoted 1 times
...
David_Webb
1 year, 2 months ago
Selected Answer: D
Other is referring to the time needed to waiting for other visuals to complete.
upvoted 2 times
...
stilferx
1 year, 2 months ago
Selected Answer: D
IMHO, D) Reducing visuals because according to Microsoft, it is the queries under them. Link as from colleagues below.
upvoted 2 times
...
Nefirs
1 year, 3 months ago
Selected Answer: D
"Other is slow" -> "Other" implies e.g. waiting time for other visuals. D is the solutio.
upvoted 4 times
...
00e2928
1 year, 3 months ago
B is the right answer For D. While reducing the number of visuals in Report1 can potentially improve overall performance by reducing the workload on the rendering engine, it may not directly address the specific issue of slow DAX query performance in the "Orders By Date" visual. It's better to focus on optimizing the problematic visual first.
upvoted 2 times
Nefirs
1 year, 3 months ago
"Other" is slow, "DAX query" performance is ok. "Other" implies e.g. waiting time for other visuals. So can't be B. D is the solutio.
upvoted 2 times
...
...
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
Loading ...