Salesforce Certified Data Architect — Question 43

Universal Containers has a rollup summary field on account to calculate the number of contacts associated with an account. During the account load, Salesforce is throwing an "UNABLE_TO_LOCK_ROW" error.
Which solution should a data architect recommend to resolve the error?

Answer options

• A. Perform a batch job in parallel mode and reduce the batch size.
• B. Defer rollup summary field calculation during data migration.
• C. Perform a batch job in serial mode and reduce the batch size.
• D. Leverage Data Loader’s platform API to load data.

Correct answer: C

Explanation

The correct answer is C because running a batch job in serial mode reduces the chance of record locking conflicts during data processing. Options A and D do not address the locking issue effectively, while B would postpone the calculation but may not solve the underlying problem during the load.