Salesforce Certified Platform Data Architect Sample Questions:

1. Universal Containers (UC) has an open sharing model for its Salesforce users to allow all its Salesforce internal users to edit all contacts, regardless of who owns the contact. However, UC management wants to allow only the owner of a contact record to delete that contact. If a user does not own the contact, then the user should not be allowed to delete the record. How should the architect approach the project so that the requirements are met?

A) Create a "before delete" trigger to check if the current user is not the owner.
B) Set the profile of the users to remove delete permission from the Contact object.
C) Set the Sharing settings as Public Read Only for the Contact object.
D) Create a validation rule on the Contact object to check if the current user is not the owner.

2. Which solution improves performance for frequently accessed fields?

A) Skinny Tables
B) External Objects
C) Big Objects
D) Data Categories

3. Universal Containers has implemented Salesforce for its operations. In order for customers to be created in their MDM solution, the customer record needs to have the following attributes:
1. First Name
2. Last Name
3. Email
Which option should the data architect recommend to mandate this when customers are created in Salesforce?

A) Configure Page Layout marking attributes as required fields.
B) Build validation in Integration with MDM to check required attributes.
C) Mark Fields for the attributes as required under Setup.
D) Create validation rules to check If the required attributes are entered.

4. Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity management in Saiesforce 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?

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

5. 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 data. 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) Stakeholders should be brought together to discuss the appropriate data strategy moving forward.
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) The MDM strategy defines Salesforce as the system of record, so Salesforce Opportunity values prevail in all conflicts.

Solutions: