Free Access Salesforce.Data-Architect.v2025-09-05.q216 Practice Test (Page 44)

Question 211

Universal Containers (UC) has users complaining about reports timing out or simply taking too long to run What two actions should the data architect recommend to improve the reporting experience? Choose 2 answers

A.Index key fields used in report criteria.

B.Enable Divisions for large data objects.

C.Create one skinny table per report.

D.Share each report with fewer users.

Question 212

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 213

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?

A.Virtualize the remaining set of data with salesforce connect and external objects.

B.Use Heroku connect to bi-directional, sync all data between systems.

C.As needed, make call outs into Heroku postgres and persist the data in salesforce.

D.Migrate the data to big objects and leverage async SOQL with custom objects.

Question 214

Northern Trail Outfitter has implemented Salesforce for its associates nationwide, Senior management is concerned that the executive dashboard are not reliable for their real-time decision-making. On analysis , the team the following issues with data entered in Salesforce.
Information in certain records is incomplete.
Incorrect entry in certain fields causes records to be excluded in report fitters.
Duplicate entries cause incorrect counts.
Which three steps should a data architect recommend to address the issues?

A.Leverage Salesforce features, such as validate rules, to avoid incomplete and incorrect records.

B.Explore third-party data providers to enrich and augment information entered in salesforce.

C.Build a sales data warehouse with purpose-build data marts for dashboards and senior management reporting.

D.design and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect

E.Periodically export data to cleanse data and import them back into Salesforce for executive reports.

Question 215

UC has migrated its Back-office data into an on-premise database with REST API access. UC recently implemented Sales cloud for its sales organization. But users are complaining about a lack of order data inside SF.
UC is concerned about SF storage limits but would still like Sales cloud to have access to the data.
Which design patterns should a data architect select to satisfy the requirement?

A.Build a UI for the on-premise system and iframe it in Salesforce

B.Develop a bidirectional integration between the on-premise system and Salesforce.

C.Migrate and persist the data in SF to take advantage of native functionality.

D.Use SF Connect to virtualize the data in SF and avoid storage limits.

Other Version: 550Salesforce.Data-Architect.v2026-09-29.q136; 2657Salesforce.Data-Architect.v2023-11-08.q173; 2043Salesforce.Data-Architect.v2023-02-06.q72

Latest Upload: 125Oracle.1z0-1195-26.v2026-10-19.q18; 140Salesforce.Salesforce-Slack-Administrator.v2026-10-19.q126; 162Salesforce.JS-Dev-101.v2026-10-19.q106; 198PaloAltoNetworks.SSE-Engineer.v2026-10-17.q44; 388Cisco.300-420.v2026-10-17.q324; 221Salesforce.MCE-Con-201.v2026-10-15.q108; 211EMC.NCA.v2026-10-15.q25; 311Apple.Apple-Device-Support.v2026-10-15.q159; 219F5.F5CAB3.v2026-10-14.q47; 207Oracle.1Z0-1048-25.v2026-10-14.q67

Question 211

Question 212

Question 213

Question 214

Question 215

Download PDF File