08 Salesforce Admin Exam Prep: Data Management

A

A marketing user has received a file of leads to import into Salesforce. What is the best way to avoid duplicating records? A. Import Wizard B. Merge Leads Function C. Data Loader D. Validation rules

B, D

A system administrator at Universal Containers incorrectly imported a set of records and needs to remove them from Salesforce. Which tool should the administrator use to complete the task? (Select 2) A. Import Wizard B. Mass Delete C. Excel Connector D. Data Loader

B

In order to update records using the Data Loader, what field must be present in the CSV file? A. Owner B. Record ID C. Record Owner D. Object Name

A, B, D

Regardless of the data import tool used, the number of records you can import depends on which of the following? (Select 3) A. Your permissions B. The type of data you're importing C. The types of objects you're importing D. The overall data storage limits for your organization

A

Universal Containers requires that its Salesforce account data, including attachments, be backed up weekly. Which tool should a system administrator use to accomplish this? A. Data Export Service B. Data Loader C. Account report export D. Account analytic snapshot

A, B, D

What can be transferred from one user to another user during a mass transfer of account records? (Select 3) A. Open activities B. Open cases C. Related custom object records D. Closed cases E. Closed activities

A, C

What should a system administrator consider before importing a set of records into Salesforce? (Select 2) A. The import file should include a record owner for each record B. Currency field values will default to the personal currency of the record owner C. Data should be de-duplicated in the import file prior to import D. Validation rules are not triggered when importing data using the import wizard

A

What type of data import tool would you use if you want to automate the data import process? (Select 1) A. Data Loader B. Data Importer C. Data Import Wizard D. Data Loading Wizard

C

When importing data, what happens if some records do NOT meet the data validation criteria? A. Import process ignores the data validation criteria B. Import process requires user authorization to import the invalid records C. Import process fails only for the records with invalid data D. Import process aborts when it encounters the first invalid record

B, C, E

Which field type can be used as an external ID? (Select 3) A. Formula field B. Email field C. Number field D. URL field E. Text field

C

Which of the following data import tools can import up to 50,000 records at a time, and provides a simple interface to specify the configuration parameters, data sources, and the field mappings that map the field names in your import file with the field names in Salesforce? (Select 1) A. Data Loader B. Data Importer C. Data Import Wizard D. Data Loading Wizard

A

Which of the following data import tools can import up to five million records at a time, of any data type, either from files or a database connection, and can be operated either through the user interface or the command line? (Select 1) A. Data Loader B. Data Importer C. Data Import Wizard D. Data Loading Wizard

C

Which tool can automatically prevent duplicate records? A. Data Loader B. Connect for Office C. Import Wizard D. Excel Connector

A

You cannot cancel an import after it has started processing. A. True B. False

A

You must include universally required fields in your import files or the import will fail. A. True B. False