Data Management

Question 1 of 43

1

When are Data validation Rules Enforced?

Select one of the following:

Upon opening a record
Upon editing a field
Upon saving a record
Upon closing the record

Explanation

Question 2 of 43

1

What should a system administrator consider before importing a set of records into Salesforce?

Select one or more of the following:

The import file should include a record owner for each record
Validation rules are not triggered when importing data using the import wizard
Data should of de-duplicated in the import file prior to import
Currency field values will default to the personal currency of the record owner

Explanation

Question 3 of 43

1

Fields which are hidden using Field-Level-Security are still subject to Validation Rules?

Select one of the following:

True
False

Explanation

Question 4 of 43

1

What is the maximum number of records you can import with the Import Wizard?

Select one of the following:

50.000
100.000
25.000
500.000

Explanation

Question 5 of 43

1

What types of records can be imported with the Import Wizard?

Select one or more of the following:

Custom objects
Opportunities
Accounts
Contacts

Explanation

Question 6 of 43

1

How many days will the recycle bin hold deleted data?

Select one of the following:

10
50
25
15

Explanation

Question 7 of 43

1

Universal Containers wants to automatically back up all the Salesforce data on a monthly basis.
Which tool can a system administrator use to meet this requirement?

Select one of the following:

Data export service
Analytic Snapshot
Import Wizard
Scheduled report

Explanation

Question 8 of 43

1

What are the common ways Administrators can back up Salesforce data?

Select one or more of the following:

Reports
Custom objects
Scheduled backups
Manual backups

Explanation

Question 9 of 43

1

In order to update records using the Data Loader, what field must be present in the csv file?

Select one of the following:

Owner
Salesforce ID
Record Owner
Object Name

Explanation

Question 10 of 43

1

A customer has 7 million records that need to be loaded into Salesforce. How would you suggest to load these records?

Select one of the following:

Use a third party data loading tool
It is not possible to load 7 million records
Data Loader
Data Import Wizard

Explanation

Question 11 of 43

1

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)

Select one or more of the following:

Excel Connector
Import Wizard
Mass Delete
Data Loader

Explanation

Question 12 of 43

1

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

Select one of the following:

Validation rules
Import Wizard
Merge Leads Function
Data Loader

Explanation

Question 13 of 43

1

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

Select one or more of the following:

Schedule a recurring export
Include the values for formula fields
Include attachments
Export a subset of records for a given object

Explanation

Question 14 of 43

1

Which tool can automatically prevent duplicate records?

Select one of the following:

Import Wizard
Connect for Office
Excel connector
Data Loader

Explanation

Question 15 of 43

1

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

Select one of the following:

Account report export
Data Loader
Account analytic snapshot
Data Export Service

Explanation

Question 16 of 43

1

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

Select one or more of the following:

Formula field
URL field
Email field
Number field
Text field

Explanation

Question 17 of 43

1

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

Select one or more of the following:

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

Explanation

Question 18 of 43

1

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

Select one of the following:

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

Explanation

Question 19 of 43

1

When importing data, what happens if some records do NOT meet the data validation criteria?

Select one of the following:

Import process fails only for the records with invalid data
Import process ignores the data validation criteria
Import process aborts when it encounters the first invalid record
Import process requires user authorization to import the invalid records

Explanation

Question 20 of 43

1

When can a validation rule be used to prevent invalid data? (3 answers)

Select one or more of the following:

When records are updated by a workflow rule
When records are imported
When records are edited by a user
When records are submitted using web-to-lead
When records are deleted by a user

Explanation

Question 21 of 43

1

What can be transferred from one user to another user during mass transfer of account records? (3 answers)

Select one or more of the following:

Open cases
Related custom object records
Closed cases
Closed activities
Open activities

Explanation

Question 22 of 43

1

A system administrator at Universal Containers needs to transfer records from one user to another.
What object can be transferred using the mass transfer tool? (2 answers)

Select one or more of the following:

Campaigns
Quotas
Accounts
Leads

Explanation

Question 23 of 43

1

When importing records using the Data Import Wizard, what conditions will cause a record to not be imported? Pick two.

Select one or more of the following:

The value of a field doesn't meet the data validation criteria.
The import file does not contain the Salesforce ID.
A universally required field is left blank.
A picklist value does not exist in Salesforce.

Explanation

Question 24 of 43

1

What are the benefits of using the Data Import Wizard to import data into Salesforce? Pick two.

Select one or more of the following:

Import greater than 50,000 records.
Choose whether or not to trigger workflow rules.
Prevent duplicate records from entering the system.
Load data for all standard and custom objects.

Explanation

Question 25 of 43

1

Why would a user choose data loader instead of the Data Import Wizard? Pick two.

Select one or more of the following:

Export or delete data.
Choose whether or not to run data validation rules.
Import lead records and prevent duplicate records.
Save field mappings for later use.

Explanation

Question 26 of 43

1

What features provides an automated way to obtain a complete set of Salesforce data for archiving? Pick two.

Select one or more of the following:

Data Import Wizard
Data export service
Data loader
Reports

Explanation

Question 27 of 43

1

An administrator at AW Computing incorrectly imported a set of records into Salesforce. Which tools can the administrator use to remove the records from Salesforce? Pick two.

Select one or more of the following:

Salesforce roll-back
Data loader
Mass delete records
Data Import Wizard

Explanation

Question 28 of 43

1

How often can Export requests be made using the Data Export tool? (Choose 2)

Select one or more of the following:

Every day
Once every week
Once a month
No Limit

Explanation

Question 29 of 43

1

Data Cleansing is the process of:

Select one of the following:

Transferring data from one repository to another
Improving existing data by linking additional data sources
Creating format consistency and removing bad data
Identifying and merging duplicate records

Explanation

Question 30 of 43

1

What is the most common identifier when searching for duplicate records?

Select one of the following:

Address
Phone number
Record Name
Record ID

Explanation

Question 31 of 43

1

Which of the following statements are true about Data Validation? (Choose 2)

Select one or more of the following:

Validation rules apply to all new and updated records for an object.
Validation rules can update fields which are not included in a page layout.
Validation rules can refer fields which are not included in a page layout.
If an error message is not set, a default message will be prompted instead.

Explanation

Question 32 of 43

1

How many cases records can be imported via Import Wizard?

Select one of the following:

500
5,000
50,000
Any number over 50,000
Case records cannot be imported via Import Wizard

Explanation

Question 33 of 43

1

What are the limits for the Account + Contacts Import Wizard per session?

Select one of the following:

1000 records for end users. 10,000 records for Administrators importing for multiple users
50 records for end users. 5,000 records for Administrators importing for multiple users
500 records for end users. 50,000 records for Administrators importing for multiple users
End users cannot import records. 50,000 records for Administrators importing for multiple users.

Explanation

Question 34 of 43

1

If you need to insert, delete, or extract data, what is the best tool to use?

Select one of the following:

Import Wizard
Connect for office
Excel connector
Data Loader

Explanation

Question 35 of 43

1

How can an import be undone?

Select one of the following:

By repeating the import
Using Mass Update records
Using Mass Transfer records
Using Mass Delete records

Explanation

Question 36 of 43

1

What is data validation rules executed on?

Select one of the following:

Record
Object
Page Layout
Field

Explanation

Question 37 of 43

1

A system administrator wants to schedule a weekly data export. What can they select to include?
(Choose 4 answers)

Select one or more of the following:

A specific objects data
The folder you want it exported to
The organization's attachment
All of the data for the organization
Replace the carriage return with spaces
You can specify who the export gets sent to

Explanation

Question 38 of 43

1

A marketing user imported a list of leads into Salesforce using the lead import wizard, but missed a custom field when mapping the data for upload. What strategies can you employ to ensure this does not happen again? (Select 2 answers)

Select one or more of the following:

Instruct users to test upload a limited number of records (e.g. 3-5 records) to ensure that the data is properly mapped prior to importing a data file with a large number of records.
Instruct users to run the data correction wizard when they've discovered there was a problem with the data import.
When a mass import (e.g. 300 records) is performed incorrectly, instruct users to manually correct the data.
Provide users a lead upload template file that matches the field naming convention used in Salesforce. This will ensure that fields are automatically mapped when using an import wizard.

Explanation

Question 39 of 43

1

The sales team wants to prevent sales reps from entering an opportunity close date more than 1 year from today's date. Instead of pushing the close date this far, the opportunity should be marked as Closed/Lost and the account revisited in one year. How should this be enforced?

Select one of the following:

Opportunity Stage Configuration
Opportunity Settings
Validation Rule
Page Layout

Explanation

Question 40 of 43

1

One sales rep leaves your company, and another sales rep joins the company. All account records owned by the previous sales rep should be transferred to the new sales rep. The number of accounts to transfer is less than 200. What is the easiest way to accomplish this?

Select one of the following:

Use the Data Import Wizard.
Use the Mass Transfer Records wizard.
Use the data loader to extract and then update the account records.
When deactivating the old user, select the transfer records option.

Explanation

Question 41 of 43

1

Your organization requires a regular backup of all Salesforce data to adhere to its disaster recovery policies set by the IT department. What is the easiest way for you as an administrator to regularly export all of your Salesforce data?

Select one of the following:

Use the Data Loader to export data from all objects.
Use a 3rd party data tool.
Schedule a recurring data export within Salesforce; include all data when creating the export job.
Use the mass export data wizard.

Explanation

Question 42 of 43

1

Which automation tool will prevent a record from being created in Salesforce if the rule conditions are not met?

Select one of the following:

Validation Rules
Escalation Rules
Workflow Rules
Auto-Response Rules

Explanation

Question 43 of 43

1

An administrator created a validation rule to ensure that users do not change the Close Date of an opportunity to a day in the past. What happens when a users tries to save an opportunity that has a Close Date from last month? Pick two.

Select one or more of the following:

The validation failure is logged on the field history tracking related list
The error message defined in the validation rule displays on the record
The record will not save
The user receives an email with the reason the validation rule failed

	Created by Judith Gräve almost 7 years ago

Quiz on Data Management, created by Judith Gräve on 13/01/2018.

Data Management

Question 1 of 43

When are Data validation Rules Enforced?

Select one of the following:

Explanation

Question 2 of 43

What should a system administrator consider before importing a set of records into Salesforce?

Select one or more of the following:

Explanation

Question 3 of 43

Fields which are hidden using Field-Level-Security are still subject to Validation Rules?

Select one of the following:

Explanation

Question 4 of 43

What is the maximum number of records you can import with the Import Wizard?

Select one of the following:

Explanation

Question 5 of 43

What types of records can be imported with the Import Wizard?

Select one or more of the following:

Explanation

Question 6 of 43

How many days will the recycle bin hold deleted data?

Select one of the following:

Explanation

Question 7 of 43

Universal Containers wants to automatically back up all the Salesforce data on a monthly basis. Which tool can a system administrator use to meet this requirement?

Select one of the following:

Explanation

Question 8 of 43

What are the common ways Administrators can back up Salesforce data?

Select one or more of the following:

Explanation

Question 9 of 43

In order to update records using the Data Loader, what field must be present in the csv file?

Select one of the following:

Explanation

Question 10 of 43

A customer has 7 million records that need to be loaded into Salesforce. How would you suggest to load these records?

Select one of the following:

Explanation

Question 11 of 43

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)

Select one or more of the following:

Explanation

Question 12 of 43

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

Select one of the following:

Explanation

Question 13 of 43

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

Select one or more of the following:

Explanation

Question 14 of 43

Which tool can automatically prevent duplicate records?

Select one of the following:

Explanation

Question 15 of 43

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

Select one of the following:

Explanation

Question 16 of 43

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

Select one or more of the following:

Explanation

Question 17 of 43

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

Select one or more of the following:

Explanation

Question 18 of 43

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

Select one of the following:

Explanation

Question 19 of 43

When importing data, what happens if some records do NOT meet the data validation criteria?

Select one of the following:

Explanation

Question 20 of 43

When can a validation rule be used to prevent invalid data? (3 answers)

Universal Containers wants to automatically back up all the Salesforce data on a monthly basis.
Which tool can a system administrator use to meet this requirement?

A system administrator at Universal Containers needs to transfer records from one user to another.
What object can be transferred using the mass transfer tool? (2 answers)

A system administrator wants to schedule a weekly data export. What can they select to include?
(Choose 4 answers)