Salesforce administrator interview questions

Salesforce administrator interview questions – Data Loaders

Check salesforce interview questions and answers, sfdc interview questions and answers 2014, 2015 in PDF format, Salesforce interview answers, Salesforce interview questions for admin, Salesforce interview questions for developers.

Salesforce administrator interview questions – Data Loaders

1.Briefly describe about Data Loader?

Data Loader is a tool or Application used in salesforce to import and export bulk data. ThroughApex Data Loader we are able to Update, Insert, Delete, Upsert, Export and Export All. Each operation will be different from each other.

Insert – insertion of new records
Update – Updating existed records.
Upsert – Update and Insertion of records
Delete – Deletion of records.
Export – Extraction of all records.
Export All – It extracts all records from salesforce including Recycle Bin records.

2.What are the different actions that can be made using data loaders?

Using Data loaders we can perform 6 type of action.They are

Insert – insertion of new records
Update – Updating existed records.
Upsert – Update and Insertion of records
Delete – Deletion of records.
Export – Extraction of all records.
Export All – It extracts all records from salesforce including Recycle Bin records.

3.How can we insert a record using Data Loader?

Before inserting records we are required to prepare CSV File. CSV file will be created in Ms-Excel application .

4.How to delete a record using Data loader?

Check the link : How to delete a record using data loader.

5.How to update a record using Data Loader?

Data Loader Update is the process of Updating the field in Salesforce Object by using Data Loader.

6.How to export records from Salesforce using Data Loader?

Check the link : How to export records from salesforce using data loaders.

7.Explain about UPSERT?

UPSERT means update and inserting a record. Data Loader UPSERT is an operation in Data Loader in which we can operate both Update and Insert to an existing record in salesforce.

8.How to handle comma fields while uploading using Data loader?

Data Loader cannot handle commas implicitly because there is no logical path to follow. If we have any comma field in the Data Loader CSV file for import of the field content, we have to close the content with double quotation marks “content “. Then data Loader will be able to handle this operation.

9.After Exporting data using Data Loader, Some time it appears that data is on New Line (Carriage Return) when we open CSV file in Microsoft Excel. For example, Address Data separated on different lines. How can we override this problem?

Excel does all sorts of “useful” operations when it opens a CSV file. It will re-format dates, strip leading zeros, corrupt record IDs if you have them in your report, and also break line. Best way as per my experience is Upload document to Google Drive. Export document back from Google drive as Excel.

10.Explain me about Export and Export all in Data Loader?

Difference between Data loader ‘Export’ & ‘Export All’ is very small. Export button is used to export all records of a particular object in the system to a .csv file( excluding records present in Recycle Bin). But when we use Export All, all records (including records present in Recycle Bin) for that particular object are exported to a .csv file. Deleted records present in recycle bin are also called ‘soft Deleted’ records.

Bookmark our website to check salesforce interview questions and answers, sfdc interview questions and answers 2014, 2015 in PDF format, Salesforce interview answers, Salesforce interview questions for admin, Salesforce interview questions for developers.