Exam PL-400 topic 6 question 37 discussion

Actual exam question from Microsoft's PL-400

Question #: 37
Topic #: 6

You manage a Microsoft Power Automate cloud flow. The cloud flow queries Microsoft Dataverse data by using the List rows action.

You need to configure the cloud flow to process 10,000 records in a single run.

What should you do? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A. Set the row count parameter to 10,000.
B. Return the first 5,000 records and use the @odata.nextLink in the response to return the remaining records.
C. Create the query by using FetchXML and set the top parameter to 10,000.
D. Turn on pagination and set the threshold to 10,000.

Show Suggested Answer

Suggested Answer: BD 🗳️

by hai297 at April 3, 2024, 4:09 a.m.

Comments

Submit Cancel

pey

Highly Voted 9 months ago

Selected Answer: BD

B & D provide a way to handle large datasets efficiently by processing records in batches, ultimately achieving the goal of processing 10,000 records in a single run.

upvoted 5 times

...

hulendar

Most Recent 3 months, 2 weeks ago

Selected Answer: CD

It is "a single run", only C & D

upvoted 1 times

b40490f

1 month, 2 weeks ago

"Single run" not "Single action"

upvoted 1 times

...

Juan0414

4 months, 4 weeks ago

Selected Answer: BD

Correct! B and D

upvoted 1 times

...

1285cc6

5 months, 3 weeks ago

Selected Answer: B

Max limit for top is 5000, taking from MS docs: https://learn.microsoft.com/en-us/power-apps/developer/data-platform/fetchxml/reference/fetch top No Positive integer value to specify the number of records to return. This value can't exceed 5,000. Don't use top together with the page, count, or returntotalrecordcount attributes. Using OData.nextLink will work for sure. It's all you need.

upvoted 1 times

...

hai297

10 months ago

Selected Answer: C

Should be C https://learn.microsoft.com/en-us/power-automate/dataverse/list-rows?tabs=classic-designer#fetch-xml-query

upvoted 1 times

hai297

9 months, 4 weeks ago

correction: C and D

upvoted 1 times

...

pey

9 months ago

Option C suggests creating the query using FetchXML and setting the top parameter to 10,000. While this approach is valid for limiting the number of records returned by the query, it does not directly address the requirement of processing 10,000 records in a single run. The top parameter in FetchXML limits the number of records returned in the initial query response but doesn't inherently ensure that all 10,000 records are processed within one run of the flow. Additionally, setting the top parameter to 10,000 may not be supported if the service's maximum query result size is lower.

upvoted 1 times

...