exam questions

Exam PL-600 All Questions

View all questions & answers for the PL-600 exam

Exam PL-600 topic 3 question 3 discussion

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

HOTSPOT -
You design a Power Platform solution for a customer. The solution uses Microsoft Dataverse as the data store. You are managing the go-live process for the solution.
The customer reports the following performance issues:
✑ Form load time is much slower than it was during testing.
✑ Overall system performance has been significantly slower that it was during testing.
You need to recommend how to troubleshoot system performance.
Which actions should you recommend? 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: Review the fields that are on the form
Keep the number of table columns (fields) to a minimum.
The more table columns (formerly referred to as fields) you have in a form, the more data that needs to be downloaded to view each record.
Box 2: Review one to many relationships to verify whether cascade settings are necessary.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/optimize-form-performance

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
Jpb99
Highly Voted 2 years, 4 months ago
Answer given is correct, if you reduce the access to the solution read transaction (e.g. Global > Business), then the system has to do more work (when querying the Principle Object Access) to figure out what the user is entitled to see.
upvoted 24 times
...
loftuscheek
Most Recent 3 months ago
Review workflows associated with the form events. Review one-to-many relationships to verify whether cascade settings are necessary. *restricting to business unit will make the query bigger then worst performance *Microsoft’s performance guidance explicitly identifies synchronous workflows as a primary cause of slow form loads.
upvoted 1 times
...
KaDevi
10 months, 1 week ago
What is the correct answer?
upvoted 2 times
Tootru2bReal
5 months, 2 weeks ago
This is an unusual set of answers for a question. Well, the 2nd one is definitely wrong. Setting the Cascading behavior on table relationships will not change the performance. That leaves you with Option 1 & 3 which is almost essentially the same thing. Wording is read permissions vs read access. I would go with option 1 for the permissions. #1 question is correct: Review the fields that are on the forms. Columns/fields can slow load times for forms, especially if there are too many and unnecessary ones included.
upvoted 1 times
WASSIM2020
4 months, 3 weeks ago
TootrubTeal: the 2nd question is correct, cascading behavior has an impact on performance, if Parental, each modification in the parent record affects the child records so more processing time
upvoted 2 times
...
...
...
giogo
1 year, 10 months ago
correct
upvoted 3 times
...
fhqhfhqh
2 years, 3 months ago
This question was on the exam.
upvoted 4 times
...
NoNameBrand
2 years, 5 months ago
"Synchronous transactions with a large number of records can cause performance issues for environments when long running transactions fail due to server timeouts. The records are locked preventing other jobs and user transactions that operate on the same records from executing. Also, long running transactions might result in a backlog of pending transactions and requests that decrease system performance and might cause work stoppage." https://docs.microsoft.com/en-us/power-platform/admin/async-cascading
upvoted 1 times
...
cakriwut
2 years, 6 months ago
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/common-performance-issue-resolutions
upvoted 2 times
...
N8n0z
2 years, 7 months ago
For the second one, I think that some stuff changed to business unit would reduce results size on things like views. But permissions cant be changed from org to BU for everything and anything without causing further issues. So maybe reviewing the cascade settings as more data on performance testing may cause more operations from cascading than in testing.
upvoted 1 times
ZVV
2 years, 6 months ago
Moreover, it's not clear what the difference between options 1&3 in the second question is.
upvoted 1 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 ...