Certified Platform Data Architect

Certified Platform Data Architect practice questions, page 3 of 3, with answer review and explanations.

Question 11

Universal Containers (UC) is migrating from an on-premise homegrown customer relationship management (CRM) system. During analysis, UC users highlight a pain point that there are multiple versions of many customers.What should the data architect do for a successful migration to mitigate the pain point?

  1. Store the data in a staging database, and de-duplicate identical records.
  2. Hire an intern manually de-duplicate the records after migrating to Salesforce.
  3. Have the users manually clean the data in the old system prior to migration.
  4. Migrate the data as is, and use Salesforce's de-duplicating feature.

Question 12

Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group membership processing. UC also has multiple admins on staff that perform manual adjustments to the role hierarchy. The automated tasks and manual tasks overlap daily, and UC is experiencing "lock errors" consistently.What should a data architect recommend to mitigate these errors?

  1. Enable granular locking.
  2. Enable sharing recalculations.
  3. Remove SOQL statements from Apex Loops.
  4. Ask Salesforce support for additional CPU power.

Question 13

A large retail company has recently chosen Salesforce as its CRM solution. They have the following record counts:2,500,000 Accounts25,000,000 ContactsWhen doing an initial performance test, the data architect noticed an extremely slow response-time for reports and list views.What should a data architect do to solve the performance issues?

  1. Create a Skinny Table to represent Account and Contact objects.
  2. Limit data loading to the 2,000 most recently created records.
  3. Load only data that the user is permitted to access.
  4. Add Custom Indexes on frequently searched Account and Contact fields.