Free Access to Salesforce.Data-Architect.v2025-11-17.q171 with Valid Practice Test (Page 14)

Question 61

UC migrating 100,000 Accounts from an enterprise resource planning (ERP) to salesforce and is concerned about ownership skew and performance.
Which 3 recommendations should a data architect provide to prevent ownership skew?
Choose 3 answers:

A.Assigned a default user as owner of accounts, and assign role in hierarchy.
B.Keep users out of public groups that can be used as the source for sharing rules.
C.Assign a default user as owner of account and do not assign any role to default user.
D.Assign "view all" permission on profile to give access to account.
E.Assign a default user as owner of accounts and assigned top most role in hierarchy.

Question 62

Universal Containers is integrating a new Opportunity engagement system with Salesforce. According to their Master Data Management strategy, Salesforce is the system of record for Account, Contact, and Opportunity dat a. However, there does seem to be valuable Opportunity data in the new system that potentially conflicts with what is stored in Salesforce. What is the recommended course of action to appropriately integrate this new system?

A.The MDM strategy defines Salesforce as the system of record, so Salesforce Opportunity values prevail in all conflicts.
B.A policy should be adopted so that the system whose record was most recently updated should prevail in conflicts.
C.The Opportunity engagement system should become the system of record for Opportunity records.
D.Stakeholders should be brought together to discuss the appropriate data strategy moving forward.

Question 63

Universal Containers (UC) has over 10 million accounts with an average of 20 opportunities with each account. A Sales Executive at UC needs to generate a daily report for all opportunities in a specific opportunity stage.
Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?

A.Number of queries running at a time.
B.Number of joins used in report query.
C.Number of records returned by report query.
D.Number of characters in report query.

Question 64

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 65

NTO has decided that it is going to build a channel sales portal with the following requirements:
1. External resellers are able to authenticate to the portal with a login.
2. Lead data, opportunity data and order data are available to authenticated users.
3. Authenticated users many need to run reports and dashboards.
4. There is no need for more than 10 custom objects or additional file storage.
Which community cloud license type should a data architect recommend to meet the portal requirements?

A.Customer community.
B.Lightning external apps starter.
C.Customer community plus.
D.Partner community.

Question 61

Question 62

Question 63

Question 64

Question 65

Download PDF File