A Salesforce administrator at a healthcare organization needs to import 45,000 Contact records into Salesforce. The import process must trigger active workflow rules and automatically prevent duplicate record creation based on matching email addresses. Which tool should the administrator use to fulfill these requirements?
- Data Import Wizard, because it supports up to 50,000 records for standard objects like Contacts and includes built-in duplicate matching features.Answer
- BData Loader, because it is the only utility capable of executing active workflow rules and validation rules during record insertion.
- CData Import Wizard, because it automatically bypasses validation rules to guarantee all records import without failure.
- DData Loader, because Data Import Wizard only supports custom objects and cannot import standard objects like Contacts.
Answer
Data Import Wizard should be used because it handles up to 50,000 records for supported standard objects like Contacts and includes native duplicate prevention.
The choice stating that Data Import Wizard should be used is correct because the import volume (45,000 records) is within its 50,000 limit, Contacts are a supported standard object, and Data Import Wizard provides native duplicate prevention options using field matching.
Step-by-Step Solution
Key Concept
Selecting between Data Import Wizard and Data Loader based on record volume limits (50,000 vs 5,000,000), standard object support, and built-in duplicate prevention capabilities.