Exam Certified Data Architect topic 1 question 6 discussion

Actual exam question from Salesforce's Certified Data Architect

Question #: 6
Topic #: 1

[All Certified Data Architect Questions]

Universal Containers has a Sales Cloud implementation for a sales team and an enterprise resource planning (ERP) as a customer master. Sales teams are complaining about duplicate account records and data quality issues with account data.
Which two solutions should a data architect recommend to resolve the complaints? (Choose two.)

A. Build a nightly batch job to de-dupe data, and merge account records.
B. Integrate Salesforce with ERP, and make ERP as system of truth.
C. Build a nightly sync job from ERP to Salesforce.
D. Implement a de-dupe solution and establish account ownership in Salesforce.

Show Suggested Answer

Suggested Answer: BD 🗳️

by thneeb at July 11, 2023, 3:42 p.m.

Comments

Submit Cancel

tobicky

Highly Voted 1 year, 7 months ago

B. Integrate Salesforce with ERP, and make ERP as system of truth. This would ensure that the data in Salesforce is always up-to-date and consistent with the data in the ERP system, which is the customer master. D. Implement a de-dupe solution and establish account ownership in Salesforce. This would help to prevent the creation of duplicate account records in Salesforce and improve data quality. Establishing account ownership would also help to manage the account data more effectively. These solutions would address both the issue of duplicate records and the data quality issues that the sales teams are experiencing

upvoted 6 times

...

dsousa98

Most Recent 11 months, 2 weeks ago

Selected Answer: BD

Data Quality issues are solved using ERP as system of truth (B). Duplicate issues would be solved with a de-dupe solution (D). B and C together would not solve dupe issues

upvoted 2 times

...

lizbette

1 year, 2 months ago

Selected Answer: BD

B is right because we're told that the master is in ERP, so we want ERP as truth. However, the second part needs to consider how we de-dupe. That leaves A,C,or D. C doesn't make sense because it doesn't consider de-duping. While A could apply, it doesn't make sense, as thneeb points out, we wouldn't make dedupe in the child system if ERP is the parent, so the better answer is D. Also as tobicky points out, it's easier to maintain the account going forward if ownership is established.

upvoted 3 times

...

thneeb

1 year, 11 months ago

Selected Answer: BC

I would say B and C make sense together. ERP should stay the system of truth (system of record) (D). And if ERP is the system of truth we should not make deduplication in a slave system (this time Salesforce. (A)

upvoted 4 times

tobicky

1 year, 7 months ago

Option C, “Build a nightly sync job from ERP to Salesforce,” could indeed be a part of the solution. However, it doesn’t address the issue of duplicate records already existing in the system. On the other hand, option D, “Implement a de-dupe solution and establish account ownership in Salesforce,” directly addresses the problem of duplicate records. It suggests implementing a solution to identify and merge duplicates, and establishing clear ownership rules for accounts to prevent future duplicates. Therefore, while both options could be part of a comprehensive solution, option D is more directly aligned with resolving the complaints of the sales team. It’s also important to note that a sync job (option C) would ideally be part of an overall integration strategy with the ERP system (option B), rather than a standalone solution.

upvoted 9 times

...