Free Access Salesforce.Data-Architect.v2026-09-29.q136 Practice Test (Page 23)

Question 106

UC developers have created 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?

A.Use Splunk to query the system logs looking for transaction time and CPU usage.

B.Enable and use the query plan tool in the developer console.

C.Use salesforce's query optimizer to analyze the query in the developer console.

D.Open a ticket with salesforce support to retrieve transaction logs to e analyzed for processing time.

Question 107

Northern Trail Outfitters needs to implement an archive solution for Salesforce dat a. This archive solution needs to help NTO do the following:
1. Remove outdated Information not required on a day-to-day basis.
2. Improve Salesforce performance.
Which solution should be used to meet these requirements?

A.Identify a location to store archived data, and move data to the location using a time-based workflow.

B.Create a full copy sandbox, and use it as a source for retaining archived data.

C.Use a formula field that shows true when a record reaches a defined age and use that field to run a report and export a report into SharePoint.

D.Identify a location to store archived data and use scheduled batch jobs to migrate and purge the aged data on a nightly basis,

Question 108

Universal Containers (UC) has implemented Sales Cloud for its entire sales organization, UC has built a custom object called projects_c that stores customers project detail and employee bitable hours.
The following requirements are needed:
A subnet of individuals from the finance team will need to access to the projects object for reporting and adjusting employee utilization.
The finance users will not access to any sales objects, but they will need to interact with the custom object.
Which license type a data architect recommend for the finance team that best meets the requirements?

A.Service Cloud

B.Lighting platform plus

C.Sales Cloud

D.Light Platform Start

Question 109

Universal Containers (UC) has a multi-level master-detail relationship for opportunities, a custom opportunity line item object, and a custom discount request. UC has opportunity as master and custom line item object as detail in master-detail relationship. UC also has a custom line item object as master and a custom discount request object as detail in another master-detail relationship. UC has a requirement to show all sums of discounts across line items at an opportunity level. What is the recommended solution to address these requirements?

A.Update the master-detail relationships to lookup relationships in order to allow the discount amount to roll up.

B.Remove the master-detail relationships and rely completely on workflow/triggers to summarize the discount amount.

C.Use roll-up for the line-item-level summary and a trigger for the opportunity amount summary, as only one level roll-up is allowed.

D.Roll-up discount request amount at the line-item-level and line-item-level summary discount at the opportunity level.

Question 110

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 delete orders and order line items. 2. Ensure the customer has order information in another system.

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 aggregate order amount data to store in a custom object. 2. Delete those orders and order line items.

Other Version: 2760Salesforce.Data-Architect.v2025-09-05.q216; 2495Salesforce.Data-Architect.v2023-11-08.q173; 1946Salesforce.Data-Architect.v2023-02-06.q72

Latest Upload: 164SAP.C_THR81_2605.v2026-10-01.q71; 154Apple.SUP-2026.v2026-10-01.q109; 301CompTIA.N10-009.v2026-10-01.q342; 130Apple.App-Development-with-Swift-Certified-User.v2026-09-30.q14; 158Microsoft.AB-210.v2026-09-30.q53; 191Salesforce.OmniStudio-Consultant.v2026-09-30.q102; 167InsuranceLicensing.Life-and-Accident-and-Health-or-Sickness-Producer-Combo.v2026-09-30.q93; 199Salesforce.Data-Architect.v2026-09-29.q136; 210Huawei.H19-321.v2026-09-29.q100; 135SAP.C_S4CPB.v2026-09-28.q7

Question 106

Question 107

Question 108

Question 109

Question 110

Download PDF File