ADM-201 · Question #54
What are three considerations when a user is importing data via Data Loader? Choose 3 answers
The correct answer is A. Importing data into checkbox fields allows for the use of TRUE/FALSE. B. Field-Level Security access determines which fields will be visible. C. Unrestricted picklists, a new picklist value will be applied but will not be added to the picklist. When importing data with Data Loader, administrators must account for data formatting, field security, and picklist behavior to ensure successful imports.
Question
What are three considerations when a user is importing data via Data Loader? Choose 3 answers
Options
- AImporting data into checkbox fields allows for the use of TRUE/FALSE.
- BField-Level Security access determines which fields will be visible.
- CUnrestricted picklists, a new picklist value will be applied but will not be added to the picklist.
- DValidation rules do not execute when importing data.
- ERestricted picklists, a new picklist value will be Ignored and the default value applied.
How the community answered
(25 responses)- A92% (23)
- D4% (1)
- E4% (1)
Why each option
When importing data with Data Loader, administrators must account for data formatting, field security, and picklist behavior to ensure successful imports.
For checkbox fields, Data Loader accepts 'TRUE' or '1' to mark the box as checked and 'FALSE' or '0' to uncheck it, providing flexibility for boolean data input.
Data Loader respects Field-Level Security (FLS) and object permissions, meaning users can only import data into fields for which their profile or permission sets grant them write access, maintaining data security.
When importing new values into an unrestricted picklist, Data Loader will successfully apply the new value to the record, but it will not automatically add that value to the picklist's master list definition, requiring manual addition for future use.
Validation rules *do* execute during Data Loader imports, and any records that violate these rules will fail to import, ensuring data integrity.
For restricted picklists, if an imported value does not exist in the defined picklist, Data Loader will reject the record with an error message; it will not ignore the value and apply a default.
Concept tested: Data Loader considerations (data formats, FLS, picklist behavior)
Source: https://help.salesforce.com/s/articleView?id=sf.data_loader.htm&type=5
Topics
Community Discussion
No community discussion yet for this question.