UC has a roll-up summary field on Account to calculate the count of contacts associated with an account.
During the account load, SF is throwing an "Unable to lock a row" error.
Which solution should a data architect recommend, to resolve the error?

• A.Perform Batch job in parallel mode and reduce Batch size
• B.Perform Batch job in serial mode and reduce batch size
• C.Defer roll-up summary fields calculation during data migration.
• D.Leverage data loader platform API to load data.

Comment: *

Name: *

Email: *

Verification: *

UC has one SF org (Org A) and recently acquired a secondary company with its own Salesforce org (Org B). UC has decided to keep the orgs running separately but would like to bidirectionally share opportunities between the orgs in near-real time.
Which 3 options should a data architect recommend to share data between Org A and Org B?
Choose 3 answers.

• A.Leverage middleware tools to bidirectionally send Opportunity data across orgs.
• B.Use Salesforce Connect and the cross-org adapter to visualize Opportunities into external objects
• C.Install a 3rd party AppExchange tool to handle the data sharing
• D.Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.
• E.Develop an Apex class that pushes opportunity data between orgs daily via the Apex schedule.

Comment: *

Name: *

Email: *

Verification: *

DreamHouse Realty has an integration that creates records in a Salesforce Custom Object. The Custom Object has a field marked as required on the page layout.
DreamHouse Realty has noticed that many of the records coming from the external system are missing data in this field.
The Architect needs to ensure this field always contains data coming from the source system.
Which two approaches should the Architect take? Choose 2 answers

• A.Blame the customer's external system for bad data.
• B.Mark the field required in setup at the field level.
• C.Set up a Validation Rule to prevent blank values.
• D.Create a Workflow to default a value into this field.

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Leave the data in Salesforce alone and assume that it will auto-correct itself over time.
• B.Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.
• C.Extract the Salesforce data into Excel and manually compare this against the trusted source.
• D.Load the Trusted Source data into Salesforce and run an Apex Batch job to find difference.

Comment: *

Name: *

Email: *

Verification: *

Every year, Ursa Major Solar has more than 1 million orders. Each order contains an average of 10 line items. The Chief Executive Officer (CEO) needs the Sales Reps to see how much money each customer generates year-over-year. However, data storage is running low in Salesforce.
Which approach for data archiving is appropriate for this scenario?

• A.1. Annually export and delete order line items. 2. Store them in a zip file in case the data is needed later.
• B.1. Annually aggregate order amount data to store in a custom object. 2. Delete those orders and order line items.
• C.1. Annually export and delete orders and order line items. 2. Store them in a zip file in case the data is needed later.
• D.1. Annually delete orders and order line items. 2. Ensure the customer has order information in another system.

Comment: *

Name: *

Email: *

Verification: *