Data Management- SF Admin 2019
Data Management- SF Admin 2019
33 flashcards · Other · by Grant Parkis
what is SF ID?
globally unique ID for each record created 15 digits, case sens, displayed in UI 18 digits case INSENS from API/Data Loader
what happens to deleted records
recycle bin 15 days or if bin limit exceeded - permanently deleted
how does storage work in SF
split into data or file storage data storage = records = 2KB in size file storage = attachments files and documents
when would you use an external ID
need to use identifies from an eternal system to import or update date
what are the options for importing and exporting data
data import wizard data loader 3rd party tools for integration export from reports data export service
how can knowledge articles be imported to SF
import articles tool - allows articles and translations be imported into knoweldge
main tools for data import
data import wizard data loader
up to how many records can data import wizard and data loader import
import wizard = 50000 data loader = 5 million
what format is data imported, exported or deleted?
csv format
what are steps to import data
data selection mapping import
which of the data management tools cannot export data
data import wizard
which of the data import tool can only be used by admins
data loader
how can knowledge articles outside of SF be imported into SF
import articles tool
what can be done with the mass transfer tool
accounts leads custom objects and some related data can be transferred from one owner to another.
how can data be mass deleted
mass delete tool
how do validation rules work
formula expression is defined on an object and checked before a record is created or edited and saved. if formula returns true and error message is displayed and record is not saved.
how can data be automatically exported
data export service can be used to export all or selected data weekly or monthly. email is sent with a link to a downloadable zip file.
what is the difference between a matching rule and a duplicate rule
matching rule = identify duplicates duplicate rules define what HAPPENS to duplicates - allow or block.
what actions can be taken by the administrator to ensure the date quality of an org?
data standards and naming conventions, import clean data, remove duplicate records and use validation rules.
when are validation rules enforced
immediately upon record save, prior to workflow or process builders
how can system validation be used
to enforce data type, data length, required fields or unique entries
when are custom validation rules used?
for custom complex validation rules that can involve one or more fields(std or cust)
what are the implications of validation rules
validates data type field length enforces req fields and enforces unique setting.
what happens when loading records through a data import tool and the required fields are blank or not matched?
those records fail to load
what happens when a formula in a validation rule returns a result "true"
the record is NOT created or saved and an error message is displayed.
how does the unique field requirement differ from duplication rules
unique field looks at specific fields and ensures there is no other record with that entry - its unique. Duplication rules used for the record as a whole when only one record should exist.
what formula function is used to ensure the correct formatting of a field entry?
RegEx
after selecting the objects to be exported what else can be optionally included in the export?
images documents / attachments chatter files SF CRM content
what are the formats available for exporting reports?
CSV XLS (excel
how does the data export service work?
all or selected data is exported weekly monthly or on demand (max is once every 7 days). An email is sent with a link to download zip file inactive link after 48hours
in which case would a user run into issues with exporting data
accessing export download link 3 days after link was sent exporting data from a sandbox environment.
what are the options for exporting data
data loader export from reports data export service
which SF feature for lightning experience allow finding duplicates across the org and merging them?
duplicate jobs and duplicate record sets note duplicate jobs are only in lightning