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

Question 26

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.Schedule a Weekly Extract Service for key objects and extract data in XL sheets to on-premise systems.
C.Store all data in shadow custom objects on any updates and deletes, and extract them as needed .
D.Evaluate a third-party AppExchange app, such as OwnBackup or Spanning, etc., for backup and archival purposes.

Question 27

Northern Trail Outfitters (NTO) has recently implemented Salesforce to track opportunities across all their regions. NTO sales teams across all regions have historically managed their sales process in Microsoft Excel.
NTO sales teams are complaining that their data from the Excel files were not migrated as part of the implementation and NTO is now facing low Salesforce adoption.
What should a data architect recommend to increase Salesforce adoption?

A.Use the Excel connector to Salesforce to sync data from individual Excel files.
B.Define a standard mapping and train sales users to import opportunity data.
C.Load data in external database and provide access to database to sales users.
D.Create a chatter group and upload all Excel files to the group.

Question 28

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: C

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 29

NTO would like to retrieve their SF orgs meta data programmatically for backup within a various external. Which API is the best fit for accomplishing this task?

A.SOAP API
B.Tooling API
C.Metadata API
D.Bulk API in serial mode

Question 30

Get Cloudy Consulting is migrating their legacy system's users and data to Salesforce. They will be creating 15,000 users, 1.5 million Account records, and 15 million Invoice records. The visibility of these records is controlled by a 50 owner and criteria-based sharing rules.
Get Cloudy Consulting needs to minimize data loading time during this migration to a new organization.
Which two approaches will accomplish this goal? (Choose two.)

A.Create the users, upload all data, and then deploy the sharing rules.
B.Defer sharing calculations until the data has finished uploading.
C.Contact Salesforce to activate indexing before uploading the data.
D.First, load all account records, and then load all user records.

Question 26

Question 27

Question 28

Question 29

Question 30

Download PDF File