Salesforce Certified Data Architect — Question 32

Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity management in Salesforce is implemented as follows:
1. Sales users enter their opportunities in Salesforce for forecasting and reporting purposes.
2. NTO has a product pricing system (PPS) that is used to update the Opportunity Amount field on opportunities on a daily basis.
3. PPS is the trusted source within NTO for Opportunity Amount.
4. NTO uses Opportunity Forecast for its sales planning and management.
Sales users have noticed that their updates to the Opportunity Amount field are overwritten when PPS updates their opportunities.
How should a data architect address this overwriting issue?

Answer options

• A. Change PPS integration to update only Opportunity Amount field when the value is null.
• B. Create a custom field for Opportunity Amount that sales users update separating the field that PPS updates.
• C. Create a custom field for Opportunity amount that PPS updates separating the field sales user updates.
• D. Change Opportunity Amount field access to Read Only for sales users using field-level security.

Correct answer: D

Explanation

The correct answer is D because making the Opportunity Amount field Read Only for sales users prevents their manual entries from being overwritten by PPS, which is the trusted source for the Opportunity Amount. Options A, B, and C do not effectively address the issue since they either allow for conflicting updates or create additional complexity without ensuring data integrity.