Data Migration: 15% Flashcards
1
Q
What are some techniques to improve data quality?
A
- Flow Builder
- Validation Rules
- Client-side validation
- App-exchange Apps
- Data Loader / Data Import Wizard
- Picklist Fields
- Duplicate Management
- Lightning Data
2
Q
What is a “Serial Load”?
A
Refers to loading data serially so that the data ‘insert’ operations are performed one at a time
- Used for inserting a public group or a set of users
3
Q
When does “Record Lock” typically happen?
A
- Importing a large number of child records with the Bulk API and parallel mode
4
Q
What is the load limit of Bulk API?
A
A single batch can include 10,000 records
5
Q
What are some techniques for optimizing loading data?
A
- Setting up users and the role hierarchy
- Using Public Read/Write sharing on the objects that will be loaded
- Enable ‘defer sharing calculations’
- Use Bulk API in parallel mode
- Ordering child records by the parent ID
- Use ‘insert’ and ‘update’ instead of an ‘upsert’ operation
6
Q
What is the upper limit of records in a single file for data loader?
A
5 million records
7
Q
What file size can Bulk API retreive in terms of data?
A
15GB split into 1GB files
8
Q
What command has to be entered in the header for Pk Chunking?
A
Sforce-Enable-PKChunking
9
Q
A
10
Q
A
11
Q
A
12
Q
A
