Salesforce Certified Data Architect — Question 63

Northern Trail Outfitters (NTO) has a variety of customers that include households, businesses, and individuals.
The following conditions exist within its system:
1. NTO has a total of five million customers.
2. Duplicate records exist, which is replicated across many systems, including Salesforce.
Given these conditions, there is a lack of consistent presentation and clear identification of a customer record.
Which three options should a data architect perform to resolve the Issues with the customer data? (Choose three.)

Answer options

• A. Invest in data duplication tool to de-dupe and merge duplicate records across all systems.
• B. Use Salesforce CDC to sync customer data across all systems to keep customer record in sync.
• C. Create a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.
• D. Create a unique global customer ID for each customer and store that in all systems for referential identity.
• E. Duplicate customer records across the systems and provide a two-way sync of data between the systems.

Correct answer: A, C, D

Explanation

Option A is correct because investing in a data duplication tool directly addresses the issue of duplicate records, allowing for their removal and merging. Option C is also valid as creating a master database helps maintain a single source of truth, while option D ensures each customer can be uniquely identified across systems. Options B and E do not effectively resolve the duplicate issues and only address synchronization without eliminating the underlying problem.