Data Import & Export

Question 1

What three operations are possible while importing Data in Salesforce?

Answer 1

Insert (Creating new records in Salesforce)
Update (Modifying existing records using record id/external id)
Upsert (Combination of insert and update)

Question 2

3 Ways to import/export data

Answer 2

Data Loader - Importing and exporting data
Data Import Wizard - Importing Data
Data Export - Exporting data

Question 3

What data import/export tool do you need to install on your PC?

Answer 3

Data Loader

Question 4

How many records can data loader support up to?

Answer 4

5 million records

Question 5

These import/export tools allows you to map fields

Answer 5

Data Loader
Data Import Wizard

Question 6

This import/export tool supports all objects including customs

Answer 6

Data Loader

Question 7

This import/export tool provides detailed success and error log files in CSV format

Answer 7

Data Loader

Question 8

How many records Data Import Wizard can import up to?

Answer 8

50,000 records

Question 9

Data Import Wizard cannot import records for custom object?

Answer 9

False, Data Import Wizard can import custom object records.

Question 10

Between Data Import Wizard vs Dataloader, which is more ideal to import complex data?

Answer 10

Dataloader

Question 11

Data Import Wizard can import records for all standard objects.

Answer 11

False, Data Import Wizard can only import records for Account, Contact, Campaign members, person accounts, Leads, and Solutions standard objects.

Question 12

Which import tool would you choose to import records from cases and opportunity?

Answer 12

Data Loader, Data Import Wizard cannot import records for Cases and Opportunity object.

Question 13

Before importing records into Salesforce, how do you differentiate check and uncheck in the excel file?

Answer 13

Checked value = 1, Unchecked value = 0

Question 14

To find duplicates in the records, which importing tools are ideal?

Answer 14

Dataloader, Data Import Wizard could ignore duplicates

Question 15

Before importing records into Salesforce, how do you separate value in the multi-select picklist?

Answer 15

by Semicolon ;

Question 16

Can you import Formula fields into Salesforce?

Answer 16

No, because they are read-only

Question 17

Will validation rule trigger when importing records through Dataloader or Data Import Wizard?

Answer 17

Yes