Data Governance & Stewardship Flashcards Preview

SFDC Data Architecture & Management > Data Governance & Stewardship > Flashcards

Flashcards in Data Governance & Stewardship Deck (17)
Loading flashcards...
1
Q

What are some of the questions you can ask when looking at data governance?

A

What is being collected
How is it being kept secure
Who can create / update / manage the data
What quality rules and standards need to be met
How available and usable the data is (are)
Processes for managing conflicting data flows

2
Q

How should you design integration to ensure it does not impact Data governance?

A

Design interfaces to collect quality data

Transformation of data (when importing, ensure your csv file has been setup correctly)

3
Q

How do Profiles and Permission Sets impact Data Governance?

A

Control the fields people can access

Control CRED access to objects

4
Q

What are some De-Duplication options?

A

Matching rules

De-Duplication rules

Data.com

AppExchange tools (ex: Demand tools)

Lightning page - duplicate indicators

5
Q

What options do you have for great quality data (as part of data governance)?

A

Validation Rules

Defaults

Actions with pre-defined field values

Field settings - unique/required

Page layouts and record types

Validation rules

Automation!

Data.com

6
Q

What is part of data stewardship?

A

Monitoring data collection

Maintaining standards

Responding to questions about data

Resolving conflicting data problems

7
Q

What are some stewardship tools?

A

Data Quality scoring

Data Quality dashboards

Good AppExchange analysers e.g. Field Trip

Chatter

Clinics

Good old-fashioned conversations

8
Q

What 4 types of data are there?

A

Master data (Customers, Partners, Products)

Transactional data (Orders, contracts)

Reference Data (Currencies, Industry classifications)

Metadata (Login History)

9
Q

Who could be data stewards?

A

End users in Sales, Support, Marketing who create the data

Admins, champions and Ops people who work with users to maintain the standards of the data

Admins and architects who monitor the flow of data and resolve / escalate issues

10
Q

What does the data governance committee do?

A

Resolves escalated problems

Defines governance metrics

Manages integrity and quality of data

11
Q

Who is the data governance council?

A

People who set policies and provide strategic direction

12
Q

Who is the steering committee?

A

Business sponsors who campion policies and strategies

Oversees the success of the data governance office

13
Q

Who is the data governance office

A

Works with the business to build implement governance solutions

Administers and reports on data governance activities

14
Q

What is the main reason for having data governance?

A

It drives data quality

15
Q

What is Data Governance?

A

It refers to the overall management of the availability, usability, integrity, and security of the data employed in an enterprise. A sound data governance program includes a governing body or council, a defined set of procedures, and a plan to execute those procedures

16
Q

What is Data Stewardship?

A

Management and oversight of an organization’s data assets to help provide business users with high-quality data that is easily accessible in a consistent manner

17
Q

In the context of a formal data governance program, which two activities are the responsibility of the Data Architect?

A. Create and maintain database backups

B. Translate business requirements into data models

C. Maintain data architecture metadata repository

D. Manage the data governance program

A

B. Translate business requirements into data models

C. Maintain data architecture metadata repository