Exam Certified Data Architect topic 1 question 105 discussion

Actual exam question from Salesforce's Certified Data Architect

Question #: 105
Topic #: 1

[All Certified Data Architect Questions]

Universal Containers has been a customer of Salesforce for 10 years. Currently they have 2 million accounts in the system. Due to an erroneous integration built 3 years ago, it is estimated there are 500,000 duplicates in the system.

Which solution should a data architect recommend to remediate the duplication issue?

A. Extract the data using data loader and use excel to merge the duplicate records
B. Utilize a data warehouse as the system of truth
C. Develop an ETL process that utilizes the merge API to merge the duplicate records
D. Implement duplicate rules

Show Suggested Answer

Suggested Answer: C 🗳️

by [deleted] at Feb. 9, 2024, 7:44 a.m.

Comments

Submit Cancel

haniaetry

5 days, 6 hours ago

Selected Answer: C

C is correct, as D only works on newly created

upvoted 1 times

...

d6e5edd

1 month, 3 weeks ago

Selected Answer: D

merge API doesn't exist, so D should be the answer, despite being an incomplete one

upvoted 1 times

...

17354ae

2 months, 3 weeks ago

Selected Answer: D

there is no such thing as merge api. D should be the answer. Although running duplicate jobs would be more appropriate but isn't an option here

upvoted 1 times

...

lizbette

7 months, 2 weeks ago

Selected Answer: C

C looks correct.

upvoted 2 times

...

[Removed]

9 months, 4 weeks ago

D is correct, C is overkill.

upvoted 2 times

...