Salesforce Certified Platform App Builder — Question 199

Universal Containers is importing 10,000 contact records in Salesforce. They want to avoid duplicate records from being created during the import.
How can this requirement be met?

Answer options

• A. When importing the file, select the "Prevent Duplicates" option on the last step of the Data Loader.
• B. Include in a column in the import file that corresponds to a field in Salesforce that requires unique values.
• C. After importing all the contacts, run a duplicate check report, export the report to a CSV file, and run a mass delete to purge any duplicates.
• D. After importing all of the contact records, review all records created and manually merge or delete any duplicate records.

Correct answer: B

Explanation

The correct answer is B because including a column with unique values allows Salesforce to check for and prevent duplicate records during the import. Option A is incorrect as the 'Prevent Duplicates' option does not exist in Data Loader. Options C and D involve post-import actions, which do not prevent duplicates from being created in the first place.