Deck 12: Data and Database Administration With Focus on Data Quality

Question 1

Data quality problems can cascade when:

A) data are not deleted properly.
B) data are copied from legacy systems.
C) there is redundant data storage and inconsistent metadata.
D) there are data entry problems.

Answer 1

B

Question 2

Quality data can be defined as being:

A) unique.
B) inaccurate.
C) historical.
D) precise.

Answer 2

A

Question 3

One simple task of a data quality audit is to:

A) interview all users.
B) statistically profile all files.
C) load all data into a data warehouse.
D) establish quality metrics.

Answer 3

B

Question 4

Getting poor data from a supplier is a(n) ________ reason for deteriorated data quality.

A) external data source
B) inconsistent metadata
C) data entry problem
D) lack of organizational commitment

Question 5

Which of the following functions do cost/benefit models?

A) Database planning
B) Database analysis
C) Database design
D) Operations

Question 6

Data that are accurate, consistent, and available in a timely fashion are considered:

A) Oracle-based.
B) Microsoft-based.
C) high-quality.
D) low-quality.

Question 7

Conformance means that:

A) data have been transformed.
B) data are stored, exchanged, or presented in a format that is specified by its metadata.
C) data are stored in a way to expedite retrieval.
D) data is a harbinger.

Question 8

Data quality ROI stands for:

A) return on installation.
B) risk of incarceration.
C) rough outline inclusion.
D) rate of installation.

Question 9

One characteristic of quality data which pertains to the expectation for the time between when data are expected and when they are available for use is:

A) currency.
B) consistency.
C) referential integrity.
D) timeliness.

Question 10

Which of the following are key steps in a data quality program?

A) Avoid a data quality audit
B) Apply TQM principles and practices
C) Do not allow outside data
D) Keep all data on one server

Question 11

Which of the following functions design integrity controls?

A) Database planning
B) Database analysis
C) Database implementation
D) Database design

Question 12

Which of the following functions model business rules?

A) Database planning
B) Database analysis
C) Database design
D) Operations

Question 13

________ is a technical function responsible for database design, security, and disaster recovery.

A) Data administration
B) Database administration
C) Tech support
D) Operations

Question 14

Data governance can be defined as:

A) a means to slow down the speed of data.
B) high-level organizational groups and processes that oversee data stewardship.
C) a government task force for defining data quality.
D) a means to increase the speed of data.

Question 15

Which of the following is NOT true of poor data and/or database administration?

A) Data timing problems
B) Multiple entity definitions
C) Unknown meanings of stored data
D) Maintaining a secure server

Question 16

The best place to improve data entry across all applications is:

A) in the users.
B) in the level of organizational commitment.
C) in the database definitions.
D) in the data entry operators.

Question 17

An open source DBMS is:

A) a free source code RBMS that provides the functionality of an SQL-compliant DBMS.
B) a beta release of a commercial RDBMS.
C) an object-oriented database management system.
D) source code for a commercial RDBMS.

Question 18

External data sources present problems for data quality because:

A) data are not always available.
B) there is a lack of control over data quality.
C) there are poor data capture controls.
D) data are unformatted.

Question 19

Data quality is important for all of the following reasons EXCEPT:

A) it minimizes project delay.
B) it aids in making timely business decisions.
C) it provides a stream of profit.
D) it helps to expand the customer base.

Question 20

Including data capture controls (i.e., dropdown lists) helps reduce ________ deteriorated data problems.

A) external data source
B) inconsistent metadata
C) data entry
D) lack of organizational commitment

Question 21

A high-level function that is responsible for the overall management of data resources in an organization is called database administration.

Question 22

Dirty data can cause delays and extra work on information systems projects.

Question 23

Open source software always comes with complete documentation.

Question 24

A data steward is a person assigned the responsibility of ensuring the organizational applications properly support the organization's enterprise goals for data quality.

Question 25

All of the following are popular architectures for Master Data Management EXCEPT:

A) identity registry.
B) integration hub.
C) persistent.
D) normalization.

Question 26

The methods to ensure the quality of data across various subject areas are called:

A) Variable Data Management.
B) Master Data Management.
C) Joint Data Management.
D) Managed Data Management.

Question 27

Open source DBMS are free software that provide the core functionality of an SQL compliant DBMS.

Question 28

The role of database administration is typically a more hands-on, physical involvement with the management of databases.

Question 29

Specifying database access policies is done during the database implementation phase.

Question 30

In the ________ approach, one consolidated record is maintained from which all applications draw data.

A) persnickity
B) cautious
C) persistent
D) data-oriented

Question 31

TQM stands for:

A) Thomas Quinn Mann, a famous data quality innovator.
B) Total Quality Manipulation.
C) Transforming Quality Management.
D) Total Quality Management.

Question 32

Quality data are not essential for well-run organizations.

Question 33

One way to improve the data capture process is to:

A) allow all data to be entered manually.
B) provide little or no training to data entry operators.
C) check entered data immediately for quality against data in the database.
D) not use any automatic data entry routines.

Question 34

Data quality is essential for SOX and Basel II compliance.

Question 35

Databases are generally the property of a single department within an organization.

Question 36

A data governance committee is always made up of high-ranking government officials.

Question 37

In the ________ approach, one consolidated record is maintained, and all applications draw on that one actual "golden" record.

A) persistent
B) identity registry
C) federated
D) integration hub

Question 38

The data administrator takes responsibility for the overall management of data resources.

Question 39

Dirty data saves work for information systems projects.

Question 40

Specifications for transactions do not need to be reviewed quickly.

Question 41

Lack of organizational commitment is a potential reason for an organization's deteriorated data quality.

Question 42

Quality data does not have to be unique.

Question 43

Improving data capture process is a fundamental step in data quality improvement.

Question 44

What are some of the core roles of the traditional data administrator?

Question 45

What factors should one consider when choosing an open source DBMS?

Question 46

Sound data modeling is a central ingredient of a data quality program.

Question 47

Generally, records in a customer file never become obsolete.

Question 48

Retention refers to the amount of data that is not purged periodically from tables.

Question 49

Completeness means that all data that must have a value does not have a value.

Question 50

What are some of the core roles of a database administrator?

Question 51

Completeness means that all data that are needed are present.

Question 52

A review will thoroughly review all process controls on data entry and maintenance.

Question 53

The uncontrolled proliferation of spreadsheets, databases, and repositories leads to data quality problems.

Question 54

Conformance refers to whether the data is stored, exchanged, or presented in a format that is as specified by its metadata.

Question 55

Data which arrive via XML and B2B channels is always guaranteed to be accurate.

Question 56

A data expeditor is a person assigned the responsibility of ensuring that organizational applications properly support the organization's enterprise goals of data quality.

Question 57

Total quality management (TQM) focuses on defect correction rather than defect prevention.

Question 58

A data stewardship program does not help to involve the organization in data quality.

Question 59

Master data management is the disciplines, technologies, and methods to ensure the currency, meaning, and quality of data within one subject area.

Question 60

A data quality audit helps an organization understand the extent and nature of data quality problems.

Question 61

What are some of the characteristics of quality data?

Question 62

What are some of the reasons for deteriorated data quality?

Question 63

What are the key steps in a data quality program?

Question 64

What new trends and technologies have driven the need for changes in the data administration and database administration roles?

Question 65

Why is data quality important?

Question 66

Discuss Master Data Management.