Data Quality

Question 1

What is the first step in assessing data quality?

Answer 1

Understanding how the data is used to support business objectives

Question 2

How can the age of a set of records be measured?

Answer 2

Run a report on the last modify date of the records, and determine what percentage have been modified recently.

Question 3

How can the completeness of a set of records be measured?

Answer 3

Run a report based on a set of required fields and assess the percentage of blanks for those fields.

or

Use a data quality app from App Exchange

Question 4

How can data accuracy be measured?

Answer 4

Using a data quality app from App Exchange that can match your records against a trusted source and tell you how it can be improved.

Question 5

How can the consistency of data be measured?

Answer 5

Run a report to show the values used for date, currency, state, country and region and determine how many variations are used for a single value

Question 6

How can data usage be assessed?

Answer 6

Review the available tools and resources your business uses and ensuring the data use is optimized.

Question 7

What are two key impacts of maintaining clean and accurate data in Salesforce?

Answer 7

It builds the trust of your sales teams and helps work toward data protection and privacy compliance

Question 8

What is one of the most important aspects of using Salesforce?

Answer 8

Maintaining clean and accurate data

Question 9

Describe how data standards can be enforced with regards to naming.

Answer 9

By setting naming conventions for records

Question 10

Describe how data standards can be enforced with regards to

Answer 10

Set naming conventions for records. Always include suffixes (Inc., Corp.)? Abbreviations?

Question 11

Describe how data standards can be enforced with regards to formatting

Answer 11

Figure out how dates and money are represented.

Question 12

Describe how data standards can be enforced with regards to workflow

Answer 12

Determine processes for record creation, reviewing, updating, and archiving. Determine all the stages a record goes through during its life cycle.

Question 13

Describe how data standards can be enforced with regards to quality

Answer 13

Set appropriate standards for data quality, including the ability to measure or score records. Put a value on age, completeness, usage, accuracy, consistency, and duplicates, along with any other quality or value metrics specific to your business.

Question 14

Describe how data standards can be enforced with regards to roles/ownership

Answer 14

Determine who owns records, who’s accountable for changes to data, and who’s notified when there are changes to data.

Question 15

Describe how data standards can be enforced with regards to security/permissions

Answer 15

Determine the appropriate levels of privacy for data. Make sure to comply with regulatory, legal, and contractual obligations.

Question 16

Describe how data standards can be enforced with regards to monitoring

Answer 16

Outline a process for ensuring quality control of data. Determine the frequency, scope, owners, and checks, including ways for updating data, preventing duplicates, merging records, adding records, and archiving records. Determine metrics that can be easily monitored in a dashboard.

Question 17

How do required fields support data management plans in Salesforce?

Answer 17

Required fields ensure that data that supports business objectives has been populated

Question 18

How do validation rules support data management plans in Salesforce?

Answer 18

Validation rules can help enforce formatting of specific formats and to ensure data has been populated.

Question 19

How do workflow rules support data management plans in Salesforce?

Answer 19

Workflows can be used to automate internal processes and remove the burden from a user

Question 20

How do page layouts support data management plans in Salesforce?

Answer 20

By quickly highlighting/surfacing specific information relevant to a specific user type/role without overwhelming them with info they don’t need.

Question 21

How do dashboards support data management plans in Salesforce?

Answer 21

By quickly highlighting issues with data within the org

Question 22

How do data enrichment tools support data management plans in Salesforce?

Answer 22

By regularly matching salesforce data against a trusted source to ensure its validity

Question 23

How does duplication management support data management plans in Salesforce?

Answer 23

By ensuring there is a single record to represent specific types of key/important data in salesforce

Question 24

How can a custom field types support data management plans in Salesforce?

Answer 24

by implementing specific data types and enforcing specific formats for custom field types

Question 25

How do state and country lists contribute to data quality?

Answer 25

By providing a standardized list of values that can be selected.

Question 26

What are the considerations of data quality?

Answer 26

Age
Completeness
Accuracy
Consistency
Duplication
Usage

Question 27

What is data governance?

Answer 27

The management of availability, usability, Integrity and security. Usually includes a committee or council who defines procedures and plans the execution of those procedures.

Question 28

What is data stewardship?

Answer 28

the management of an organization’s data assets, to give users high-quality data (ex: BI/Reporting dept)

Question 29

What is data architecture?

Answer 29

Management of a data policies, models, rules/standards that govern data within an organization