Given a Customer Scenario, Recommend an Optimal Data Migration Plan Taking into Account Parallelism, Managing Locks, and Handling Sharing Rules. DATA-ARCHITECT Practice Questions (Page 1)

Questions 1–5

1. 1expert · hard

   A customer is migrating 5 million records across 3 objects with complex sharing rules. They have a 6-hour window. They need to ensure that sharing rules are correctly applied after migration. They also want to minimize lock contention. Which plan is most optimal?

   • ALoad objects sequentially, but use parallel batches within each object, and create sharing rules before the load.
   • BLoad all objects in parallel but disable sharing rules until after the migration.
   • CLoad all objects in parallel but use a batch size of 10,000 to reduce API calls.
   • DLoad all objects in parallel with maximum concurrency, then create sharing rules after the load.
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A company is migrating Accounts and Opportunities from a legacy CRM. After migration, they want to ensure that only the Sales team (a public group) can see Opportunities related to Accounts owned by the Sales Manager. They plan to use sharing rules. What should they do during the migration to ensure this access is correctly applied?

   • ASet the Organization-Wide Default (OWD) for Opportunity to Public Read/Write to grant access to all users.
   • BLoad all data first, then create the sharing rules and public group.
   • CCreate the sharing rules before the migration and ensure the public group and roles are set up correctly.
   • DUse manual sharing on each Opportunity to grant access to the Sales team.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   What is the primary purpose of sharing rules in Salesforce?

   • ATo prevent users from editing records they own.
   • BTo extend record access to users who would not normally have it based on their role or profile.
   • CTo automatically delete records that are no longer needed.
   • DTo encrypt data at rest in the Salesforce platform.
   Reveal Solution Discussion Select an answer first
5. 4expert · hard

   A customer is migrating 10 million records across multiple objects with complex relationships. They have a 12-hour maintenance window. They need to minimize downtime and avoid lock contention. They also have a requirement that all records must be visible to all internal users (OWD Public Read Only). Which migration plan best balances these constraints?

   • ALoad all objects in parallel but disable sharing rules until after the migration, then enable them.
   • BLoad objects sequentially, starting with parent objects, using parallel batches within each object, and set OWD to Public Read Only before the migration.
   • CLoad all objects in parallel with maximum concurrency, using batch size of 200, and set OWD to Public Read Only before the migration.
   • DUse a single batch for all records to avoid lock contention, and set OWD to Public Read Only after the migration.
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A team is migrating 2 million records into a custom object. They are using Data Loader with parallel batches. They notice that the migration is slow and they are not hitting API limits. What is the best way to improve performance?

   • AIncrease the batch size to 500.
   • BRun the migration during off-peak hours.
   • CUse the Bulk API instead of the REST API.
   • DIncrease the number of parallel batches.
   Reveal Solution Discussion Select an answer first