Salesforce Data-Architecture-And-Management-Designer Exam (page: 5)
Salesforce Certified Data Architecture and Management Designer
Updated on: 24-Mar-2026

UC developers havecreated a new lightning component that uses an Apex controller using a SOQL query to populate a custom list view. Users are complaining that the component often fails to load and returns a time-out error.

What tool should a data architect use to identify why the query is taking too long?

  1. Use Splunk to query the system logs looking for transaction time and CPU usage.
  2. Enable and use the query plan tool in the developer console.
  3. Use salesforce's query optimizer to analyze the query in the developer console.
  4. Open a ticket with salesforce support to retrieve transaction logs to e analyzed for processing time.

Answer(s): B



Universal Containers (UC) uses the following Salesforce products:

Sales Cloud for customer management.

Marketing Cloud for marketing.

Einstein Analytics for business reporting.

UC occasionally gets a list of prospects from third-party source as comma-separated values (CSV) files for marketing purposes. Historically, UC would load contact Lead object in Salesforce and sync to Marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing process.

What should a data architect recommend to UC in order to immediately avoid storage issues in thefuture?

  1. Load the CSV files in Einstein Analytics and sync with Marketing Cloud prior to sending marketing communications ;
  2. Load the CSV files in an external database and sync with Marketing Cloud prior to sending marketing communications.
  3. Load thecontacts directly to Marketing Cloud and have a reconciliation process to track prospects that are converted to customers.
  4. Continue to use the existing process to use Lead object to sync with Marketing Cloud and delete Lead records from Sales after thesync is complete.

Answer(s): A



Northern Trail outfitters in migrating to salesforce from a legacy CRM system that identifies the agent relationships in a look-up table.

What should the data architect do in order to migrate the data to Salesfoce?

  1. Create custom objects to store agent relationships.
  2. Migrate to Salesforce without a record owner.
  3. Assign record owner based on relationship.
  4. Migrate the data and assign to a non-person system user.

Answer(s): A



Universal Containers (UC) has a data model as shown in the image. The Project object has a private sharing model, and it hasRoll -Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project.
What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.com?

  1. Load all data using external IDs to link to parent records.
  2. Use workflow to calculate summary values instead of Roll -Up.
  3. Use triggers to calculate summary values instead of Roll -Up.
  4. Load all data after deferring sharing calculations.

Answer(s): D



Universal Containers (UC) is implementing a formal, cross -business -unit data governance program As part of the program, UC will implement a team to make decisions on enterprise -wide data governance.

Which two roles are appropriate as members of thisteam? Choose 2 answers

  1. Analytics/BI Owners
  2. Data Domain Stewards
  3. Salesforce Administrators
  4. Operational Data Users

Answer(s): A,B



Viewing Page 5 of 46



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

Mfc 10/23/2023 3:35:00 PM

only got thru 5 questions, need more to evaluate
Anonymous


Whizzle 7/24/2023 6:19:00 AM

q26 should be b
Anonymous


sarra 1/17/2024 3:44:00 AM

the aaa triad in information security is authentication, accounting and authorisation so the answer should be d 1, 3 and 5.
UNITED KINGDOM


DBS 5/14/2023 12:56:00 PM

need to attend this
UNITED STATES


Da_costa 8/1/2023 5:28:00 PM

these are free brain dumps i understand, how can one get free pdf
Anonymous


vikas 10/28/2023 6:57:00 AM

provide access
EUROPEAN UNION


Abdullah 9/29/2023 2:06:00 AM

good morning
Anonymous


Raj 6/26/2023 3:12:00 PM

please upload the ncp-mci 6.5 dumps, really need to practice this one. thanks guys
Anonymous


Miguel 10/5/2023 12:21:00 PM

question 16: https://help.salesforce.com/s/articleview?id=sf.care_console_overview.htm&type=5
SPAIN


Hiren Ladva 7/8/2023 10:34:00 PM

yes i m prepared exam
Anonymous


oliverjames 10/24/2023 5:37:00 AM

my experience was great with this site as i studied for the ms-900 from here and got 900/1000 on the test. my main focus was on the tutorials which were provided and practice questions. thanks!
GERMANY


Bhuddhiman 7/20/2023 11:52:00 AM

great course
UNITED STATES


Anuj 1/14/2024 4:07:00 PM

very good question
Anonymous


Saravana Kumar TS 12/8/2023 9:49:00 AM

question: 93 which statement is true regarding the result? sales contain 6 columns and values contain 7 columns so c is not right answer.
INDIA


Lue 3/30/2023 11:43:00 PM

highly recommend just passed my exam.
CANADA


DC 1/7/2024 10:17:00 AM

great practice! thanks
UNITED STATES


Anonymus 11/9/2023 5:41:00 AM

anyone who wrote this exam recently?
SOUTH AFRICA


Khalid Javid 11/17/2023 3:46:00 PM

kindly share the dump
Anonymous


Na 8/9/2023 8:39:00 AM

could you please upload cfe fraud prevention and deterrence questions? it will be very much helpful.
Anonymous


shime 10/23/2023 10:03:00 AM

this is really very very helpful for mcd level 1
ETHIOPIA


Vnu 6/3/2023 2:39:00 AM

very helpful!
Anonymous


Steve 8/17/2023 2:19:00 PM

question #18s answer should be a, not d. this should be corrected. it should be minvalidityperiod
CANADA


RITEISH 12/24/2023 4:33:00 AM

thanks for the exact solution
Anonymous


SB 10/15/2023 7:58:00 AM

need to refer the questions and have to give the exam
INDIA


Mike Derfalem 7/16/2023 7:59:00 PM

i need it right now if it was possible please
Anonymous


Isak 7/6/2023 3:21:00 AM

i need it very much please share it in the fastest time.
Anonymous


Maria 6/23/2023 11:40:00 AM

correct answer is d for student.java program
IRELAND


Nagendra Pedipina 7/12/2023 9:10:00 AM

q:37 c is correct
INDIA


John 9/16/2023 9:37:00 PM

q6 exam topic: terramearth, c: correct answer: copy 1petabyte to encrypted usb device ???
GERMANY


SAM 12/4/2023 12:56:00 AM

explained answers
INDIA


Andy 12/26/2023 9:35:00 PM

plan to take theaws certified developer - associate dva-c02 in the next few weeks
SINGAPORE


siva 5/17/2023 12:32:00 AM

very helpfull
Anonymous


mouna 9/27/2023 8:53:00 AM

good questions
Anonymous


Bhavya 9/12/2023 7:18:00 AM

help to practice csa exam
Anonymous