ExamTopics Logo
Mail Us[email protected]
Menu
Salesforce Discussions
exam questions

Exam Certified Data Architect All Questions

View all questions & answers for the Certified Data Architect exam
Go to Exam

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 Hide Answer
Suggested Answer: C 🗳️
by [deleted] at Feb. 9, 2024, 7:44 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
haniaetry
7 months, 1 week ago
Selected Answer: C
C is correct, as D only works on newly created
upvoted 1 times
...
d6e5edd
8 months, 4 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
9 months, 4 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 2 times
...
lizbette
1 year, 2 months ago
Selected Answer: C
C looks correct.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel