What should the consultant recommend to ensure data integrity?

Cloud Kicks has an integration between the data warehouse and Salesforce. The VP of operations wants to synchronize customer data between the systems.

What should the consultant recommend to ensure data integrity?
A . Set up a Process Builder process on the Account object to check for unique values on a monthly basis.
B . Set up an encrypted field on the Account object with Read Only on the field security settings for all profiles except the admin profile.
C . Set up an External ID field on the Account object with Read Only on the field security settings for all profiles except the admin profile.
D . Set up an import of the data from the data warehouse on a monthly basis using Data Loader

View Answer

Answer: C

Explanation:

Setting up an External ID field on the Account object with Read Only on the field security settings for all profiles except the admin profile ensures data integrity between the data warehouse and Salesforce. An External ID field is a custom field that has the “External ID” attribute, meaning that it contains unique record identifiers from a system outside of Salesforce. By making it Read Only for all profiles except the admin profile, the field value can only be updated by the integration or by the admin, preventing any accidental or intentional changes by other users. The External ID field can also be used to match records during data import or update operations, avoiding duplicate records or incorrect data.