Exam Certified Data Architect topic 1 question 49 discussion

Actual exam question from Salesforce's Certified Data Architect

Question #: 49
Topic #: 1

[All Certified Data Architect Questions]

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?

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.

Show Suggested Answer

Suggested Answer: C 🗳️

by [deleted] at Jan. 18, 2024, 9:20 p.m.

Comments

Submit Cancel

lizbette

7 months ago

Selected Answer: C

Agreed C. Options to resolve record lock: Reduce the batch size Process the records in Serial mode instead of parallel, that way one batch is processed at a time. Sort main records based on their parent record, to avoid having different child records (with the same parent) in different batches when using parallel mode.

upvoted 1 times

...

[Removed]

10 months, 1 week ago

C. confirmation here in Bulk API section https://help.salesforce.com/s/articleView?id=000387767&type=1

upvoted 1 times

...