ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 232 - Certified Data Architect discussion

Report
Export

Universal Containers (UC) manages Vehicle and Service History in Salesforce. Vehicle (Vehicle__ c) and

Service History (Service-History__ c) are both custom objects related through a lookup relationship.

Every week a batch synchronization process updates the Vehicle and Service History records in Salesforce. UC has two hours of migration window every week and is facing locking issues as part of the data migration process.

What should a data architect recommend to avoid locking issues without affecting performance of data migration?

A.
Use Bulk API parallel mode for data migration
Answers
A.
Use Bulk API parallel mode for data migration
B.
Use Bulk API serial mode for data migration
Answers
B.
Use Bulk API serial mode for data migration
C.
Insert the order in another custom object and use Batch Apex to move the records to Service_ Order__ c object.
Answers
C.
Insert the order in another custom object and use Batch Apex to move the records to Service_ Order__ c object.
D.
Change the lookup configuration to 'Clear the value of this field' when lookup record is deleted.
Answers
D.
Change the lookup configuration to 'Clear the value of this field' when lookup record is deleted.
Suggested answer: B

Explanation:

According to the official Salesforce guide1, using Bulk API serial mode for data migration can help avoid locking issues by processing batches in a single thread. This mode ensures that batches are processed in the order they are received and that only one batch is processed at a time. This reduces the risk of lock contention and deadlocks, especially when updating parent and child records in a lookup relationship. Option B is the correct answer because it suggests using Bulk API serial mode for data migration. Option A is incorrect because using Bulk API parallel mode for data migration can cause locking issues by processing batches in multiple threads. This mode does not guarantee the order of batch processing and can result in concurrent updates to the same records, which can lead to lock contention and deadlocks. Option C is incorrect because inserting the order in another custom object and using Batch Apex to move the records to Service_Order__c object adds unnecessary complexity and overhead to the data migration process. Option D is incorrect because changing the lookup configuration to ''Clear the value of this field'' when lookup record is deleted does not address the locking issues caused by data migration, but rather by record deletion.

asked 23/09/2024
Paula Castanheira
36 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first