ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 221 - Certified Data Architect discussion

Report
Export

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?

A.
Hire an intern manually de-duplicate the records after migrating to Salesforce.
Answers
A.
Hire an intern manually de-duplicate the records after migrating to Salesforce.
B.
Migrate the data as is, and use Salesforce's de-duplicating feature.
Answers
B.
Migrate the data as is, and use Salesforce's de-duplicating feature.
C.
Have the users manually clean the data in the old system prior to migration.
Answers
C.
Have the users manually clean the data in the old system prior to migration.
D.
Store the data in a staging database, and de-duplicate identical records.
Answers
D.
Store the data in a staging database, and de-duplicate identical records.
Suggested answer: D

Explanation:

Storing the data in a staging database and de-duplicating identical records (option D) is the best solution for a successful migration to mitigate the pain point, as it allows the data architect to identify and merge duplicate customers before they are imported into Salesforce. Hiring an intern manually de-duplicate the records after migrating to Salesforce (option A) is not a good solution, as it may be time-consuming and error-prone, and it does not prevent duplicate records from being created in Salesforce. Migrating the data as is and using Salesforce's de-duplicating feature (option B) is also not a good solution, as it may cause data quality issues and conflicts, and it does not address the root cause of the duplication. Having the users manually clean the data in the old system prior to migration (option C) is also not a good solution, as it may be unrealistic and impractical, and it does not leverage any automated tools or processes.

asked 23/09/2024
antoine sala
35 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first