PL-400: Which Method Ensures High Throughput and Transaction Rollback for Bulk Updates in Dataverse?

How to Use ExecuteTransactionRequest for Reliable Data Processing in Power Platform?

Question

You use the Organization service to process data in Microsoft Dataverse tables.

You have a regular process that updates thousands of rows on the Contact table from an external system.

You need to use a method that has the highest throughput and will roll back all updates if any error occurs.

Which method should you use?

Select only one answer.

A. UpdateMultiple
B. ExecuteAsyncRequest
C. ExecuteMultipleRequest
D. ExecuteTransactionRequest

Answer

D. ExecuteTransactionRequest

Explanation

This item tests the candidate’s knowledge of performing operations with the Organization service and optimizing for performance, concurrency, transactions, and bulk operations.

ExecuteTransactionRequest allows for the update of contact rows and works as a single transaction, rolling back updates if an error occurs. Although UpdateMultiple offers the best throughput and works as a single transaction, it does not support the Contact table. ExecuteMultipleRequest does not support transactions and will not roll back changes if an error occurs. ExecuteAsyncRequest does not support Update requests and is used for importing and exporting solutions.

Microsoft Power Platform Developer PL-400 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Microsoft Power Platform Developer PL-400 exam and earn Microsoft Power Platform Developer PL-400 certification.