Weekend Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Exactprep Data-Architect Questions

Salesforce Certified Data Architect (SP25) Questions and Answers

Question 53

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?

Options:

A.

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

B.

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

C.

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

D.

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

Question 54

Universal Containers (UC) has a requirement to create an Account plan object that is related to the Account object. Each Account plan needs to have an Account object, but the accessibility requirement of the Account plan is different from the Account object. What should an Architect recommend?

Options:

A.

Create a custom account plan object as detail with Account as mater in a master-detail relationship.

B.

Create a custom account plan object as detail with Account as master with additional sharing rules to allow access.

C.

Create an account plan object with a lookup relations to Account without any validation rules to enforce the Account association.

D.

Create an account plan object with a lookup relationship to Account with validation rules to enforce the Account association.

Question 55

Northern Trail Outfitters (NTO) plans to maintain contact preferences for customers and employees. NTO has implemented the following:

1. Customers are Person Accounts for their retail business.

2. Customers are represented as Contacts for their commercial business.

3. Employees are maintained as Users.

4. Prospects are maintained as Leads.

NTO needs to implement a standard communication preference management model for Person Accounts, Contacts, Users, and Leads.

Which option should the data architect recommend NTO to satisfy this requirement?

Options:

A.

Create custom fields for contact preferences in Lead, Person Account, and Users objects.

B.

Create case for contact preferences, and use this to validate the preferences for Lead, Person Accounts, and Users.

C.

Create a custom object to maintain preferences and build relationships to Lead, Person Account, and Users.

D.

Use Individual objects to maintain the preferences with relationships to Lead, Person Account, and Users.

Question 56

Universal Containers is integrating a new Opportunity engagement system with Salesforce. According to their Master Data Management strategy, Salesforce is the system of record for Account, Contact, and Opportunity data. However, there does seem to be valuable Opportunity data in the new system that potentially conflicts with what is stored in Salesforce. What is the recommended course of action to appropriately integrate this new system?

Options:

A.

The MDM strategy defines Salesforce as the system of record, so Salesforce Opportunity values prevail in all conflicts.

B.

A policy should be adopted so that the system whose record was most recently updated should prevail in conflicts.

C.

The Opportunity engagement system should become the system of record for Opportunity records.

D.

Stakeholders should be brought together to discuss the appropriate data strategy moving forward.