ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 132 - Certified Data Architect discussion

Report
Export

UC has a roll-up summary field on Account to calculate the count of contacts associated with an account. During the account load, SF is throwing an ''Unable to lock a row'' error.

Which solution should a data architect recommend, to resolve the error?

A.
Leverage data loader platform API to load data.
Answers
A.
Leverage data loader platform API to load data.
B.
Perform Batch job in parallel mode and reduce Batch size
Answers
B.
Perform Batch job in parallel mode and reduce Batch size
C.
Perform Batch job in serial mode and reduce batch size
Answers
C.
Perform Batch job in serial mode and reduce batch size
D.
Defer roll-up summary fields calculation during data migration.
Answers
D.
Defer roll-up summary fields calculation during data migration.
Suggested answer: C

Explanation:

The best solution to resolve the error of ''Unable to lock a row'' during the account load is to perform batch job in serial mode and reduce batch size. This is because roll-up summary fields are calculated synchronously when the parent record is updated, and asynchronously when the child record is updated. Therefore, updating many child records at once can cause locking issues on the parent record.To avoid this, it is recommended to use serial mode and smaller batch sizes when loading data using tools like Data Loader or Bulk API12. Leverage data loader platform API to load data is not a good option because it does not specify the mode or batch size. Perform batch job in parallel mode and reduce batch size is not a good option because parallel mode can still cause locking issues even with smaller batches.Defer roll-up summary fields calculation during data migration is not a good option because it is not possible to defer or disable roll-up summary fields calculation

asked 23/09/2024
Charalambos Stavrou
34 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first