Free Access Salesforce.Data-Architect.v2023-11-08.q173 Practice Test (Page 3)

Question 6

Universal Containers (UC) needs to run monthly and yearly reports on opportunities and orders for sales reporting. There are 5 million opportunities and 10 million orders. Sales users are complaining that the report will regularly timeout.
What is the fastest and most effective way for a data architect to solve the time-out issue?

A.Create a skinny table in Salesforce, and copy order and opportunity fields into the skinny table and create the required reports on It.

B.Extract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.

C.Create custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunity object.

D.Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.

Question 7

Universal Containers would like to have a Service-Level Agreement (SLA) of 1 day for any data loss due to unintentional or malicious updates of records in Salesforce. What approach should be suggested to address this requirement?

A.Build a daily extract job and extract data to on-premise systems for long-term backup and archival purposes.

B.Evaluate a third-party AppExchange app, such as OwnBackup or Spanning, etc., for backup and archival purposes.

C.Schedule a Weekly Extract Service for key objects and extract data in XL sheets to on-premise systems.

D.Store all data in shadow custom objects on any updates and deletes, and extract them as needed .

Question 8

NTO has outgrown its current salesforce org and will be migrating to new org shortly. As part of this process NTO will be migrating all of its metadata and dat a. NTO's data model in the source org has a complex relationship hierarchy with several master detail and lookup relationships across objects, which should be maintained in target org.
What 3 things should a data architect do to maintain the relationship hierarchy during migration?
Choose 3 answers:

A.Use data loader to export the data from source org and then import or Upsert into the target org in sequential order.

B.Create a external id field for each object in the target org and map source record ID's to this field.

C.Redefine the master detail relationship fields to lookup relationship fields in the target org.

D.Replace source record ID's with new record ID's from the target org in the import file.

E.Keep the relationship fields populated with the source record ID's in the import file.

Question 9

Universal Container has a Sales Cloud implementation for a sales team and an enterprise resource planning (ERP) as a customer master Sales team are complaining about duplicate account and data quality issues with account data.
Which two solution should a data architect recommend to resolve the complaints?

A.Build a nightly sync job from ERP to Salesforce.

B.Integrate Salesforce with ERP, and make ERP as system of truth.

C.Implement a de-dupe solution and establish account ownership in Salesforce

D.Build a nightly batch job to de-dupe data, and merge account records.

Question 10

Universal Containers (UC) is implementing Salesforce Sales Cloud and Service Cloud. As part of their implementation, they are planning to create a new custom object (Shipments), which will have a lookup relationship to Opportunities. When creating shipment records, Salesforce users need to manually input a customer reference, which is provided by customers, and will be stored in the Customer_Reference__c text custom field. Support agents will likely use this customer reference to search for Shipment records when resolving shipping issues. UC is expecting to have around 5 million shipment records created per year. What is the recommended solution to ensure that support agents using global search and reports can quickly find shipment records?

A.Set Customer-Reference_c as an External ID (unique).

B.Implement an archiving process for shipment records created after three years.

C.Implement an archiving process for shipment records created after five years.

D.Set Customer-Reference_c as an External ID (non-unique).

Other Version: 1921Salesforce.Data-Architect.v2025-09-05.q216; 1626Salesforce.Data-Architect.v2023-02-06.q72

Latest Upload: 200PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 290Nokia.4A0-113.v2026-05-01.q69; 244EC-COUNCIL.312-49v11.v2026-04-30.q214; 226Microsoft.MB-820.v2026-04-30.q101; 204Salesforce.MC-202.v2026-04-30.q57; 203BICSI.INSTC_V8.v2026-04-29.q53; 332NMLS.MLO.v2026-04-28.q82; 241NCARB.Project-Management.v2026-04-28.q27; 453EMC.D-AV-DY-23.v2026-04-27.q184; 1107ServiceNow.CSA.v2026-04-27.q483

Question 6

Question 7

Question 8

Question 9

Question 10

Download PDF File