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?
Click on the arrows to vote for the correct answer
A. B. C. D.C
To ensure data integrity between Cloud Kicks' data warehouse and Salesforce, the consultant should recommend option 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.
Explanation: Option A, setting up an import of data from the data warehouse on a monthly basis using Data Loader, may transfer the data to Salesforce periodically but does not guarantee real-time synchronization or data integrity. It is also time-consuming and may result in data discrepancies if updates occur frequently.
Option B, setting up an encrypted field on the Account object with Read Only on the field security settings for all profiles except the admin profile, focuses on securing the field rather than ensuring data integrity. While it provides additional security measures, it does not address the requirement of synchronizing customer data between the systems.
Option D, setting up a Process Builder process on the Account object to check for unique values on a monthly basis, does not directly address the synchronization of customer data between the systems. It focuses on checking for unique values and does not ensure data integrity or real-time synchronization.
Option C, 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, is the most appropriate choice. An External ID field is a custom field in Salesforce that can hold unique identifiers from external systems. By configuring an External ID field on the Account object, Cloud Kicks can map the customer data from the data warehouse to Salesforce using this identifier. Read-only access for all profiles except the admin profile ensures that the field remains synchronized and prevents accidental modifications by unauthorized users. This approach enables the synchronization of customer data between the data warehouse and Salesforce while maintaining data integrity and minimizing the risk of data discrepancies.