Mi Primera Certificación: Data Management

A.W. Inc. uses Salesforce for managing their sales orders. It is very sensitive data and they need to backup this data at their internal server location automatically.

Which tool should their Salesforce administrator use to achieve this?

Choose 1 answer

• Export the data after running a report

• Use the command line interface of Data Loader and schedule the export

• Raise a case with Salesforce to backup the data every day

• Use Data Loader every day, running export all

The Salesforce Administrator found records with duplicate values in a text field even though they were marked as unique when the custom field was created. What could be the problem?

Choose 1 answer

• Salesforce only enforces the unique restriction when data is loaded using Data Loader

• Salesforce only looks at the first 10 characters when fields are marked as unique

• Salesforce always treats case sensitive and insensitive data as the same

• The option to treat the field as case insensitive was not selected when it was created

What record attribute is required to update a record using Data Loader?

Choose 1 answer

• Created By Id

• Record Id

• Record Type Id

• Record Name

Universal Containers needs to synchronize data between Salesforce and an external financial system.

What should an administrator do to accomplish this?

Choose 1 answer

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

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

• Use the data loader to match records between the systems

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

A marketing user has received a file of leads to import into Salesforce.

What tool can be used to avoid duplicate lead records?

Choose 1 answer

• Validation rules

• Merge leads function

• Data loader

• Data Import Wizard

The Salesforce Administrator of Cosmic Solutions is required to update all opportunity records in Salesforce. He has exported all the opportunity data using Data Loader. Changes have been made to the downloaded file, and Data Loader has been used again to update the records. However, the update fails for a large number of records due to validation rules. After analyzing the situation, the Salesforce Administrator has determined that most of the records that fail the validation are old records that were added before the validation rules were created. The rules do not need to apply to these old records. Which process should be used in order to complete the update?

Choose 1 answer

• Deactivate the validation rules, run the update for the old records, activate the validation rules again, and then run the update for the new records.

• Deactivate the validation rules, run the update for all the records, and activate the validation rules again.

• Deactivate the validation rules, run the update for the new records, activate the validation rules again, and then run the update for the old records.

• Remove the validation rules, run the update for all the records, and re-create the validation rules.

A Salesforce Administrator has identified about 200 leads that were generated incorrectly through the Web-to-Lead form. What are the best ways to remove these?

Choose 2 answers

• Use the Archive Leads link on the Leads page

• Use the Mass Delete Leads link

• Select the records from a Leads list view and use the Delete button

• Use the Delete function of Data Loader

An account record owned by an inactive user needs to be updated. Who has the ability to update the record?

Choose 1 answer

• System administrators and all users with visibility to the record and create or edit permissions on the account object

• Records owned by inactive users cannot be updated; the user must be reactivated first

• System Administrators only

• All active users

When using the ‘Data Export’ page in Setup, which file type is used to export a backup of Salesforce data on a weekly or monthly basis?

Choose 1 answer

• CSV

• HTML

• ZIP

• SFDC

Sam has created a matching rule on the Contact object to detect duplicates. What is true in this situation?

Choose 2 answers

• Duplicate contacts will be blocked or allowed based on the setting in the Duplicate Rule

• Only one field can be used for matching in the matching rule

• Only one duplicate rule can be active at one time

• Nothing will happen unless a duplicate rule is defined that uses the matching rule