Salesforce Certified Platform Data Architect (Plat-Arch-201) Exam - Topic 2 Question 54 Discussion

Actual exam question for Salesforce's Salesforce Certified Platform Data Architect (Plat-Arch-201) exam

Question #: 54
Topic #: 2

[All Salesforce Certified Platform Data Architect (Plat-Arch-201) Questions]

Universal Containers (UC) is concerned about the accuracy of their Customer information in Salesforce. They have recently created an enterprise-wide trusted source MDM for Customer data which they have certified to be accurate. UC has over 20 million unique customer records in the trusted source and Salesforce. What should an Architect recommend to ensure the data in Salesforce is identical to the MDM?

AExtract the Salesforce data into Excel and manually compare this against the trusted source.

BLoad the Trusted Source data into Salesforce and run an Apex Batch job to find difference.

CUse an AppExchange package for Data Quality to match Salesforce data against the Trusted source.

DLeave the data in Salesforce alone and assume that it will auto-correct itself over time.

Show Suggested Answer

Suggested Answer: C

A master-detail field on VTOTime__c to Project__c is the data relationship that the data architect should use to support the requirement when creating the custom VTOTime__c object. A master-detail relationship creates a parent-child relationship between two objects, where the master record controls certain behaviors of the detail record, such as security, ownership, deletion, and roll-up summary fields. By using a master-detail field on VTOTime__c to Project__c, you can ensure that the ability to view or edit the VTOTime__c object is the same as the Project__c record, and that managers can see the total hours volunteered while viewing the Project__c record using a roll-up summary field.

by Katina at Jan 15, 2025, 11:59 PM

Limited Time Offer

25%

Off

Get Premium Salesforce Certified Platform Data Architect (Plat-Arch-201) Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Blondell

3 months ago

Manual comparison in Excel? No way, that’s way too tedious!

upvoted 0 times

...

Rosio

3 months ago

Can we really trust the auto-correct idea in option D? Seems risky.

upvoted 0 times

...

Gene

3 months ago

Wow, 20 million records? That's a huge dataset!

upvoted 0 times

...

Ivory

4 months ago

I disagree, using an AppExchange package could save time!

upvoted 0 times

...

Yolando

4 months ago

Option B sounds like the best approach for accuracy.

upvoted 0 times

...

Lai

4 months ago

I can't believe anyone would suggest leaving the data alone! That just seems risky and counterproductive.

upvoted 0 times

...

Desiree

4 months ago

Loading the trusted source data into Salesforce and running an Apex Batch job sounds familiar. I feel like we practiced something similar in class.

upvoted 0 times

...

Denise

4 months ago

I think using an AppExchange package could be a good option, but I'm not sure which one would be best for this situation.

upvoted 0 times

...

An

5 months ago

I remember discussing the importance of automation in data management. Manually comparing data in Excel seems really inefficient.

upvoted 0 times

...

Jani

5 months ago

Leave it alone and hope it fixes itself? No way, that's just asking for trouble. We need to ensure the data is accurate and in sync across the systems. The AppExchange package seems like the easiest solution, but I'd want to evaluate the options carefully.

upvoted 0 times

...

Moon

5 months ago

Hmm, I'm not sure I fully understand the difference between the Salesforce data and the trusted source. Do we know if there are any known issues or conflicts between the two? That could help guide the best approach.

upvoted 0 times

...

Alyce

5 months ago

20 million records? Manually comparing that in Excel would be a nightmare. I think the Apex Batch job approach might be the most efficient way to programmatically find and fix any discrepancies.

upvoted 0 times

...

Jeannine

5 months ago

This seems like a straightforward data reconciliation problem. I'd probably start by looking at the AppExchange options to see if there's a pre-built tool that can handle the comparison and sync.

upvoted 0 times

...

Reena

10 months ago

Option B seems like a good approach, but I wonder if an Apex Batch job might be overkill for a 20 million record dataset. Maybe a scheduled data sync job would be more efficient.

upvoted 0 times

Wilda

8 months ago

C) Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.

upvoted 0 times

...

Rickie

9 months ago

Option B seems like a good approach, but I wonder if an Apex Batch job might be overkill for a 20 million record dataset. Maybe a scheduled data sync job would be more efficient.

upvoted 0 times

...

Daniel

10 months ago

B) Load the Trusted Source data into Salesforce and run an Apex Batch job to find difference.

upvoted 0 times

...

Janessa

10 months ago

A) Extract the Salesforce data into Excel and manually compare this against the trusted source.

upvoted 0 times

...

Alesia

10 months ago

Haha, Option A might work if you have a lot of free time and enjoy manual data entry. I'd rather not spend my days staring at Excel sheets and trusted sources.

upvoted 0 times

Jerry

9 months ago

C) Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.

upvoted 0 times

...

Francis

10 months ago

B) Load the Trusted Source data into Salesforce and run an Apex Batch job to find difference.

upvoted 0 times

...

Jaime

10 months ago

I'm not sure about option D. Leaving the data in Salesforce alone and assuming it will auto-correct itself over time doesn't sound like a good idea. We need to actively ensure data accuracy.

upvoted 0 times

...

Luisa

11 months ago

I agree with Deeanna. Option B seems like the most efficient way to ensure the data in Salesforce is identical to the MDM. It's important to have accurate customer information.

upvoted 0 times

...

Magdalene

11 months ago

I disagree with Option D. Assuming the data will auto-correct itself is risky and could lead to significant data quality issues. Proactive measures should be taken to ensure the data is accurate.

upvoted 0 times

...

Deeanna

11 months ago

I think option B is the best choice. Loading the Trusted Source data into Salesforce and running an Apex Batch job sounds like a reliable way to find any differences.

upvoted 0 times

...

Detra

11 months ago

Option C seems like the most efficient and reliable solution. An AppExchange package for Data Quality can automate the process of matching the Salesforce data against the trusted source, saving a lot of manual effort.

upvoted 0 times