Salesforce DEV401 - Data Import

Question 1

Can Data Loader be run through the Command Line?
A. Yes
B. No

Answer 1

A. Yes

Question 2

What happens during an upsert operation when two records have the same External ID?
A. Both records are updated
B. First record gets updated; error is thrown for second record
C. First record gets updated; second record gets created
D. Error is reported

Answer 2

D. Error is reported

Question 3

Is it possible to set the System Fields like Created date to any date value during the initial load?
A. Yes
B. No
C. Yes, a Case needs to be raised with Salesforce.com
D. Yes, appropriate Profile permission needs to be given

Answer 3

C. Yes, a Case needs to be raised with Salesforce.com

Question 4

How many Asset records can be imported via Import Wizard?
A. 500
B. 5,000
C. 50,000
D. Asset Records cannot be imported via Import Wizard

Answer 4

D. Asset Records cannot be imported via Import Wizard

Question 5

Which of the following objects cannot be imported via the Import Wizard?
A. Leads
B. Solution
C. Cases
D. Person Accounts

Answer 5

C. Cases

Question 6

When would a developer NOT use upsert and external IDs?
A. To integrate with an external system
B. To load related records without knowing Salesforce record IDs
C. To migrate customizations from sandbox to production
D. All of the above

Answer 6

C. To migrate customizations from sandbox to production

Question 7

How can an automated data load be performed at 2:00 a.m.?
A. Schedule manager of Import Wizard
B. Command Line Interface (CLI) of Data Loader
C. Use Export Scheduler of Data Loader GUI
D. Use Data Export Service

Answer 7

B. Command Line Interface (CLI) of Data Loader

Question 8

What type of data cannot be imported through the wizard?
A. Accounts and Contacts
B. Leads
C. Custom Objects
D. Users

Answer 8

D. Users

Question 9

Which of the following are NOT capabilities of the data loader? (2 answers)
A. Import greater than 50,000 records
B. Import data into 2 objects in a single transaction
C. Rollback import transactions
D. Run by command line

Answer 9

B. Import data into 2 objects in a single transaction

C. Rollback import transactions

Question 10

When would a developer use upsert and external IDs? (2 answers)
A. To integrate with an external system
B. To migrate customizations from sandbox to production
C. To load related records without knowing Salesforce record IDs
D. To use the Force.com API to query for data

Answer 10

A. To integrate with an external system

C. To load related records without knowing Salesforce record IDs

Question 11

In Data loader 50,000 or more records can be uploaded at a time
A. True
B. False

Answer 11

A. True

Question 12

If two records have the same External ID, what would happen if an upsert action occurred for that External ID?
A. The first matching external id record would be updated
B. Both matching external id records would be updated
C. A new record is created
D. An error would be reported

Answer 12

D. An error would be reported

Question 13

Salesforce.com has notified you that they have enabled the ability to update audit fields for your organization.  When inserting a record which field can you set?
A. CreatedDate
B. IsDeleted
C. SysModStamp
D. UpdatedDate

Answer 13

A. CreatedDate

Question 14

What type of data cannot be imported through the import wizard?
A. Accounts and Contacts
B. Leads
C. Custom Objects
D. Users

Answer 14

D. Users