Data Management & Migration Flashcards
Q. What is data management in Salesforce?
A. Data management refers to the processes of storing, maintaining, securing, and optimizing data in Salesforce.
Q. What are the key components of Salesforce data management?
- Data Storage & Limits
- Data Import & Export
- Data Cleaning & Deduplication
- Data Migration & Integration
- Data Backup & Archiving
Q. What are Salesforce’s data storage limits?
A. Data storage varies by edition, typically starting at 10GB + additional per-user storage.
Q. What are the main ways to import data into Salesforce?
- Data Import Wizard
- Data Loader
- Third-party ETL tools (e.g., MuleSoft, Informatica, Jitterbit)
- Bulk API for large datasets
Q. What is the Salesforce Data Import Wizard?
A. A built-in tool that allows users to import standard and custom object records with limited data volume.
Q. What is the difference between the Data Import Wizard and Data Loader?
A. - Data Import Wizard: UI-based, supports up to 50,000 records, provides duplicate detection.
- Data Loader: Supports up to 5 million records, requires installation, and allows complex mappings.
Q. When should you use the Bulk API for data imports?
A. When working with large data volumes (more than 50,000 records) for optimized performance.
Q. What are the primary ways to export data from Salesforce?
- Data Export Service (Scheduled Export)
- Data Loader
- SOQL Queries
- API Calls (REST, SOAP, Bulk API)
Q. What is the Data Export Service in Salesforce?
A. A tool that allows scheduled exports of all Salesforce data in CSV format.
Q. What is the difference between Data Export and Data Loader for exporting data?
- Data Export: Scheduled, extracts full org data.
- Data Loader: On-demand, allows filtered record selection
Q. What tools are available for data deduplication in Salesforce?
- Duplicate Rules & Matching Rules
- Data.com (legacy, now retired)
- Third-party tools (e.g., DemandTools, Cloudingo, Ringlead)
Q. What are duplicate rules in Salesforce?
A. Duplicate rules define how the system detects and prevents duplicate records.
Q. What are matching rules in Salesforce?
A. Rules that define how duplicates are identified based on field values.
Q. What is the best practice for maintaining clean data in Salesforce?
- Use duplicate detection rules
- Implement validation rules
- Regularly merge duplicate records
- Conduct scheduled data audits
Q. What are best practices for maintaining high-quality data?
- Enforce required fields and validation rules
- Use picklists instead of free text fields
- Standardize naming conventions
- Implement regular data audits