Salesforce Platform Developer I (legacy) — Question 274

A SSN__c custom field exists on the Candidate__c custom object. The field is used to store each candidate's social security number and is marked as Unique in the schema definition.
As part of a data enrichment process, Universal Containers has a CSV file that contains updated data for all candidates in the system. The file contains each
Candidate's social security number as a data point. Universal Containers wants to upload this information into Salesforce, while ensuring all data rows are correctly mapped to a candidate in the system.
Which technique should the developer implement to streamline the data upload?

Answer options

• A. Update the SSN__c field definition to mark it as an External Id.
• B. Upload the CSV into a custom object related to Candidate__c.
• C. Create a before insert trigger to correctly map the records.
• D. Create a Process Builder on the Candidate__c object to map the records.

Correct answer: C

Explanation

The correct answer is C because a before insert trigger can ensure that the records from the CSV are accurately mapped to the existing Candidate__c records based on the SSN__c field. Option A is incorrect because marking the field as an External Id does not facilitate the mapping directly during the upload. Option B does not ensure that the data is linked back to the Candidate__c object. Option D, while useful for automating processes, would not handle the immediate mapping required during the upload.