Data-Architecture-And-Management-Designer Exam Questions and Answers (Page: 4)

QUESTION: 16

Universal Containers has two systems. Salesforce andan on -premise ERP system. An architect has been tasked with copying Opportunity records to the ERP once they reach a Closed/Won Stage. The Opportunity record in the ERP system will be read-only for all fields copied in from Salesforce.

What is the optimal real-time approach that achieves this solution?

Implement a Master Data Management system to determine system of record.
Implement a workflow rule that sends Opportunity data through Outbound Messaging.
Have the ERP poll Salesforce nightly andbring in the desired Opportunities.
Implement an hourly integration to send Salesforce Opportunities to the ERP system.

Answer(s): B

Reveal Solution Next Question

QUESTION: 17

To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce.
What common error should thedata architect be aware of when using upsert?

Errors with duplicate external Id values within the same CSV file.
Errors with records being updated and inserted in the same CSV file.
Errors when a duplicate Contact name is found cause upsert to fail.
Errors with using the wrong external Id will cause the load to fail.

Answer(s): A

Reveal Solution Next Question

QUESTION: 18

UC recently migrated 1 Billion customer related records from a legacy data store to Heroku Postgres. A subset of the data need to be synchronized with salesforce so that service agents are able to support customers directly within the service console. The remaining non- synchronized set of data will need to be accessed by salesforce at any point in time, but UC management is concerned about storage limitations.

What should a data architect recommend to meet these requirements with minimal effort?

Virtualize the remaining set of data with salesforce connect and external objects.
Use Heroku connect to bi-directional, sync all data between systems.
As needed, make call outs into Heroku postgres and persist the data in salesforce.
Migrate the data to big objects and leverage async SOQL with custom objects.

Answer(s): A

Reveal Solution Next Question

QUESTION: 19

UC needs to load a large volume of leads into salesforce on a weekly basis. During this process the validation rules are disabled.

What should a data architect recommend to ensure dataquality is maintained in salesforce.

Activate validation rules once the leads are loaded into salesforce to maintain quality.
Allow validation rules to be activated during the load of leads into salesforce.
Develop custom APEX batch process to improve quality once the load is completed.
Ensure the lead data is preprocessed for quality before loading into salesforce.

Answer(s): C

Reveal Solution Next Question

QUESTION: 20

A Customer is migrating 10 million order and 30 million order lines into Salesforce using Bulk API. The Engineer is experiencing time-out errors or long delays querying parents order IDs in Salesforce before importing related order line items.
What is the recommended solution?

Query only indexed ID field values on the imported order to import related order lines.
Leverage an External ID from source system orders to import related order lines.
Leverage Batch Apex to update order ID on related order lines after import.
Leverage a sequence of numbers on the imported orders to import related order lines.

Answer(s): B

Reveal Solution Next Question

Salesforce Data-Architecture-And-Management-Designer Exam (page: 4) Salesforce Certified Data Architecture and Management Designer Updated on: 07-Feb-2026

QUESTION: 16

QUESTION: 17

QUESTION: 18

QUESTION: 19

QUESTION: 20

Salesforce Data-Architecture-And-Management-Designer Exam (page: 4)
Salesforce Certified Data Architecture and Management Designer
Updated on: 07-Feb-2026