Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam Certified Data Architect All Questions

View all questions & answers for the Certified Data Architect exam

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 Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
lizbette
6 months, 4 weeks 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 ago
C. confirmation here in Bulk API section https://help.salesforce.com/s/articleView?id=000387767&type=1
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...