Free Access to Salesforce.Data-Architect.v2025-08-15.q120 with Valid Practice Test (Page 21)

Question 96

Universal Containers has a large volume of Contact data going into Salesforce.com. There are 100,000 existing contact records. 200,000 new contacts will be loaded. The Contact object has an external ID field that is unique and must be populated for all existing records. What should the architect recommend to reduce data load processing time?

A.Load new records via the Insert operation and existing records via the Update operation.
B.Delete all existing records, and then load all records together via the Insert operation.
C.Load all records via the Upsert operation to determine new records vs. existing records.
D.Load Contact records together using the Streaming API via the Upsert operation.

Question 97

NTO has a loyalty program to reward repeat customers. The following conditions exists:
1. Reward levels are earned based on the amount spent during the previous 12 months.
2. The program will track every item a customer has bought and grant them points for discount.
3. The program generates 100 million records each month.
NTO customer support would like to see a summary of a customer's recent transaction and reward level(s) they have attained.
Which solution should the data architect use to provide the information within the salesforce for the customer support agents?

A.Create a custom object in salesforce to capture and store all reward program. Populate nightly from the point-of-scale system, and present on the customer record.
B.Capture the reward program data in an external data store and present the 12 months trailing summary in salesforce using salesforce connect and then external object.
C.Provide a button so that the agent can quickly open the point of sales system displaying the customer history.
D.Create a custom big object to capture the reward program data and display it on the contact record and update nightly from the point-of-scale system.

Question 98

Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting reports in the Salesforce org.
Which solution should a data architect recommend to improve reporting performance?

A.Create a custom object to store aggregate data and run reports.
B.Contact Salesforce support to enable skinny table for cases.
C.Move data off of the platform and run reporting outside Salesforce, and give access to reports.
D.Build reports using custom Lightning components.

Correct Answer: B

According to the Salesforce documentation1, reporting performance can be affected by various factors, such as the volume and complexity of data, the design and configuration of reports and dashboards, the number and type of users accessing the reports, etc. To improve reporting performance, some of the recommended solutions are:
Move data off of the platform and run reporting outside Salesforce, and give access to reports (option C). This means using an external service or tool that can extract, transform, and load (ETL) data from Salesforce to another system or database, such as a data warehouse or a business intelligence platform.
This can improve reporting performance by reducing the load and latency on Salesforce, and enabling faster and more flexible reporting and analysis on the external system. Users can access the reports from the external system using a link or an embedded component in Salesforce.
Contact Salesforce support to enable skinny table for cases (option B). This means requesting Salesforce to create a custom table that contains a subset of fields from the Case object that are frequently used or queried. A skinny table can improve reporting performance by avoiding joins between standard and custom fields, omitting soft-deleted records, and leveraging indexes on the fields2.
Create a custom object to store aggregate data and run reports (option A). This means creating a custom object that contains summary or calculated data from the Case object, such as counts, sums, averages, etc. A custom object can improve reporting performance by reducing the number of records and fields that need to be queried and displayed.
Build reports using custom Lightning components (option D). This means creating custom components that use Lightning Web Components or Aura Components frameworks to display report data in Salesforce. A custom component can improve reporting performance by using client-side caching, pagination, lazy loading, or other techniques to optimize data rendering and interaction.

Question 99

Northern Trail Outfitters (NTO) has a variety of customers that include householder, businesses, and individuals.
The following conditions exist within its system:
NTO has a total of five million customers.
Duplicate records exist, which is replicated across many systems, including Salesforce.
Given these conditions, there is a lack of consistent presentation and clear identification of a customer record.
Which three option should a data architect perform to resolve the issues with the customer data?

A.Create a unique global customer ID for each customer and store that in all system for referential identity.
B.Create a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.
C.Use Salesforce CDC to sync customer data cross all systems to keep customer record in sync.
D.Duplicate customer records across the system and provide a two-way sync of data between the systems.
E.Invest in data duplicate tool to de-dupe and merge duplicate records across all systems.

Question 100

UC has millions of Cases and are running out of storage. Some user groups need to have access to historical cases for up to 7 years.
Which 2 solutions should a data architect recommend in order to minimize performance and storage issues?
Choose 2 answers:

A.Export data out of salesforce and store in Flat files on external system.
B.Create a custom object to store case history and run reports on it.
C.Leverage on premise data archival and build integration to view archived data.
D.Leverage big object to archive case data and lightning components to show archived data.

Question 96

Question 97

Question 98

Question 99

Question 100

Download PDF File