Salesforce Data-Architecture-And-Management-Designer Exam (page: 4)
Salesforce Certified Data Architecture and Management Designer
Updated on: 28-Jul-2025

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?

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

Answer(s): B



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?

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

Answer(s): A



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?

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

Answer(s): A



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.

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

Answer(s): C



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?

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

Answer(s): B



Viewing Page 4 of 46



Share your comments for Salesforce Data-Architecture-And-Management-Designer exam with other users:

John 8/7/2023 12:09:00 AM

has anyone recently attended safe 6.0 certification? is it the samq question from here.
Anonymous


Blessious Phiri 8/14/2023 3:49:00 PM

expository experience
Anonymous


concerned citizen 12/29/2023 11:31:00 AM

52 should be b&c. controller failure has nothing to do with this type of issue. degraded state tells us its a raid issue, and if the os is missing then the bootable device isnt found. the only other consideration could be data loss but thats somewhat broad whereas b&c show understanding of the specific issues the question is asking about.
UNITED STATES


deedee 12/23/2023 5:10:00 PM

great help!!!
UNITED STATES


Samir 8/1/2023 3:07:00 PM

very useful tools
UNITED STATES


Saeed 11/7/2023 3:14:00 AM

looks a good platform to prepare az-104
Anonymous


Matiullah 6/24/2023 7:37:00 AM

want to pass the exam
Anonymous


SN 9/5/2023 2:25:00 PM

good resource
UNITED STATES


Zoubeyr 9/8/2023 5:56:00 AM

question 11 : d
FRANCE


User 8/29/2023 3:24:00 AM

only the free dumps will be enough for pass, or have to purchase the premium one. please suggest.
Anonymous


CW 7/6/2023 7:37:00 PM

good questions. thanks.
Anonymous


Farooqi 11/21/2023 1:37:00 AM

good for practice.
INDIA


Isaac 10/28/2023 2:30:00 PM

great case study
UNITED STATES


Malviya 2/3/2023 9:10:00 AM

the questions in this exam dumps is valid. i passed my test last monday. i only whish they had their pricing in inr instead of usd. but it is still worth it.
INDIA


rsmyth 5/18/2023 12:44:00 PM

q40 the answer is not d, why are you giving incorrect answers? snapshot consolidation is used to merge the snapshot delta disk files to the vm base disk
IRELAND


Keny 6/23/2023 9:00:00 PM

thanks, very relevant
PERU


Muhammad Rawish Siddiqui 11/29/2023 12:14:00 PM

wrong answer. it is true not false.
SAUDI ARABIA


Josh 7/10/2023 1:54:00 PM

please i need the mo-100 questions
Anonymous


VINNY 6/2/2023 11:59:00 AM

very good use full
Anonymous


Andy 12/6/2023 5:56:00 AM

very valid questions
Anonymous


Mamo 8/12/2023 7:46:00 AM

will these question help me to clear pl-300 exam?
UNITED STATES


Marial Manyang 7/26/2023 10:13:00 AM

please provide me with these dumps questions. thanks
Anonymous


Amel Mhamdi 12/16/2022 10:10:00 AM

in the pdf downloaded is write google cloud database engineer i think that it isnt the correct exam
FRANCE


Angel 8/30/2023 10:58:00 PM

i think you have the answers wrong regarding question: "what are three core principles of web content accessibility guidelines (wcag)? answer: robust, operable, understandable
UNITED STATES


SH 5/16/2023 1:43:00 PM

these questions are not valid , they dont come for the exam now
UNITED STATES


sudhagar 9/6/2023 3:02:00 PM

question looks valid
UNITED STATES


Van 11/24/2023 4:02:00 AM

good for practice
Anonymous


Divya 8/2/2023 6:54:00 AM

need more q&a to go ahead
Anonymous


Rakesh 10/6/2023 3:06:00 AM

question 59 - a newly-created role is not assigned to any user, nor granted to any other role. answer is b https://docs.snowflake.com/en/user-guide/security-access-control-overview
Anonymous


Nik 11/10/2023 4:57:00 AM

just passed my exam today. i saw all of these questions in my text today. so i can confirm this is a valid dump.
HONG KONG


Deep 6/12/2023 7:22:00 AM

needed dumps
INDIA


tumz 1/16/2024 10:30:00 AM

very helpful
UNITED STATES


NRI 8/27/2023 10:05:00 AM

will post once the exam is finished
UNITED STATES


kent 11/3/2023 10:45:00 AM

relevant questions
Anonymous