Question 1
A multinational financial services firm, FinGlobal, is experiencing significant performance degradation during their nightly batch data loads. The architecture team has identified that the 'Account' object has over 20 million records. The integration creates child 'Transaction__c' records linked to a generic 'System User' Account for all unassigned transactions. This 'System User' Account now has over 4 million related child records. Which architectural phenomenon is primarily causing the performance issues, and what is the optimal solution?
Answer and explanation
Correct answer: B
The scenario describes Account Data Skew, where a single parent record (Account) has more than 10,000 child records. This causes performance issues during sharing recalculations and record locking. The optimal solution is to distribute the child records across multiple parent accounts to mitigate the skew.