A Salesforce administrator at a logistics enterprise is evaluating tools for two data management operations:
1. Exporting 300,000 Opportunity and Product records nightly for offsite database backup.
2. Weekly importing of 20,000 Lead records while preventing duplicate record creation based on matching Email addresses.
Which two statements correctly describe the utility requirements and tool capabilities for these operations? (Choose 2 options)
- Data Loader must be used for the nightly export operation because Opportunities and Products are unsupported by the Data Import Wizard and the volume exceeds 50,000 records.Answer
- BThe Data Import Wizard can be configured in Setup to run automated nightly scheduled exports of Opportunity records.
- The Data Import Wizard is the recommended utility for importing the Lead records because it natively provides built-in duplicate matching on fields like Email for up to 50,000 records.Answer
- DData Loader is required for the Lead import because the Data Import Wizard does not support duplicate matching or upsert operations on standard objects.
Answer
Data Loader must be used to export Opportunity and Product records exceeding 50,000 records, while the Data Import Wizard is recommended for Lead imports under 50,000 records that require built-in duplicate detection.
Data Loader is required for exporting Opportunity and Product records because the Data Import Wizard does not support export operations, does not support Opportunity or Product standard objects, and cannot handle volumes exceeding 50,000 records. Conversely, the Data Import Wizard is ideal for importing 20,000 Lead records because it operates under the 50,000 record threshold and includes built-in duplicate detection based on Lead Email fields.
Step-by-Step Solution
Key Concept
Selecting between Data Import Wizard and Data Loader based on object support, volume limits, operation type (import vs export), and native duplicate matching capabilities.