ADM 201 - Data Management

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? (Choose 2)

• Excel Connector

• Import Wizard

• Mass Delete

• Data Loader

A marketing user has received a file of leads to import into Salesforce. What is the best way to avoid duplicating records?

• Validation rules

• Import Wizard

• Merge Leads Function

• Data Loader

Which functionality is available when using the data export service? (Choose 2)

• Schedule a recurring export

• Include the values for formula fields

• Include attachments

• Export a subset of records for a given object

Which tool can automatically prevent duplicate records?

• Import Wizard

• Connect for Office

• Excel connector

• Data Loader

Universal Containers requires that its Salesforce account data, including attachments, be backed up weekly. Which tool should a system administrator use to accomplish this?

• Account report export

• Data Loader

• Account analytic snapshot

• Data Export Service

Which field type can be used as an external ID? (Choose 3)

• Formula field

• URL field

• Email field

• Number field

• Text field

A system administrator at Universal Containers needs to mass update the lead source of opportunity records. How can this be accomplished? (Choose 2)

• Use similar opportunities to update the opportunities

• Export opportunities and update using the import wizard

• Create a list view for opportunities and update using inline editing

• Export opportunities and update using the data loader

Universal Containers needs to synchronize data between Salesforce and an external financial system. How can a system administrator accomplish this?

• Use the Excel connector to export records from both systems into Excel

• Use an external ID field to match records between the systems

• Use the data loader to match records between the systems

• Use the data loader to insert Salesforce records into the financial system

What should a system administrator consider before importing a set of records into Salesforce? (Choose 2)

• The import file should include a record owner for each record

• Currency field values will default to the personal currency of the record owner

• Data should be de-duplicated in the import file prior to import

• Validation rules are not triggered when importing data using the import wizard

A marketing user has received a file of leads to import into Salesforce. What tool can be used to avoid duplicate lead records?

• Merge leads function

• Validation rules

• Data loader

• Import wizard