What should a consultant recommend meeting this requirement?

Cloud Kicks’ (CK) VP of technology wants to start using Salesforce for all the sales team’s automation. CK migrated 70 million records from a legacy database to the data warehouse that will be synced with Salesforce. CK wants to search and cross-reference records with the original source database.

What should a consultant recommend meeting this requirement?
A . Use the standard External ID field and map this to the source record ID value.
B . Use a custom External ID field and map this to the source record ID value.
C . Use the standard External ID field and map this to the Salesforce record ID value.
D . Use a custom field named External ID and map this to the Salesforce record ID value.

View Answer

Answer: B

Explanation:

This is the recommended solution for Cloud Kicks if they want to search and cross-reference records with the original source database after migrating 70 million records from a legacy database to the data warehouse that will be synced with Salesforce. Using a custom External ID field and mapping it to the source record ID value will allow Cloud Kicks to uniquely identify each record and match it with its corresponding record in the source database. A custom External ID field is a custom field that has the External ID attribute enabled, which means that it can be used as a unique identifier for data import or integration purposes.