Chapter 6 Concept Review

A ______ is a type of distributed ledger, consisting of blocks of data that maintain a permanent and tamper-proof record of transactional data

Blockchain

Integrity ______ are rules that help ensure the quality of data.

Constraints

Select two terms that describe the process for weeding out, fixing, or discarding inconsistent, incorrect, or incomplete data.

Data cleansing Data scrubbing

What is the common term for the representation of multidimensional data?

Data cube

What is the smallest or basic unit of data?

Data element

What refers to the extent of detail within the data?

Data granularity

What occurs when the same data element has different values?

Data inconsistency

What is a measure of the quality of data?

Data integrity

What is the time it takes for data to be stored or retrieved?

Data latency

What are logical data structures that detail the relationships among data elements using graphics or pictures?

Data models

What determines the accuracy and completeness of its data?

Data quality audits

What is the duplication of data, or the storage of the same data in multiple places?

Data redundancy

What is the 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?

Data stewardship

What maintains data about various types of objects (inventory), events (transactions), people (employees), and places (warehouses)?

Database

What is a process that extracts data from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse?

Extraction, Transformation, and Loading

Data ______ refers to the extent of detail within the data (fine and detailed or coarse and abstract).

Granularity

What presents the results of data analysis, displaying the patterns, relationships, and trends in a graphical format?

Infographics

______ present the results of data analysis, displaying the patterns, relationships, and trends in a graphical format.

Infographics

Data ______ is a measure of the quality of data.

Integrity

What are rules that help ensure the quality of data?

Integrity constraints

The ______ view of data focuses on how individual users logically access data to meet their own particular business needs.

Logical

What focuses on how individual users logically access data to meet their own particular business needs?

Logical view of data

Data ______ contains a subset of data warehouse data.

Mart

What provides details about data?

Metadata

______ provides details about data.

Metadata

Data ______ are logical data structures that detail the relationships among data elements using graphics or pictures.

Models

The ______ view of data deals with the physical storage of data on a storage device.

Physical

What deals with the physical storage of data on a storage device?

Physical view of data

______ -time data means immediate, up-to-date data.

Real

Which system provides real-time data in response to requests?

Real-time

What means immediate, up-to-date data?

Real-time data

Which of the following are rules that enforce basic and fundamental information-based constraints, such as not creating an order for a nonexistent customer?

Relational integrity constraints

Data ______ is the 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.

Stewardship

What is the tool that consists of lines of code (in contrast to a graphical design) for answering questions against a database?

Structured Query Language

Real-time __________ provide real-time data in response to requests.

Systems

When do data integrity issues occur?

When a system produces incorrect, inconsistent, or duplicate data.

Data ______ is the collection of data from various sources for the purpose of data processing.

aggregation

What is a type of distributed ledger, consisting of blocks of data that maintain a permanent and tamper-proof record of transactional data?

blockchain

Select the four functions that a database management system can perform on data in a database? Analyze data Govern data create data update data read data delete data

create data update data read data delete data

A data ______ is the common term for the representation of multidimensional data.

cube

What is the collection of data from various sources for the purpose of data processing?

data aggregation

What is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete data?

data cleansing

Select a term that is a synonym for data element, the smallest or basic unit of data in a database.

data field

What occurs when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps or where missing data might exist?

data gap analysis

What occurs when a system produces incorrect, inconsistent, or duplicate data?

data integrity issues

What is a storage repository that holds a vast amount of raw data in its original format until the business needs it?

data lake

What contains a subset of data warehouse data?

data mart

What is an individual item on a graph or a chart?

data point

What is a logical collection of data, gathered from many different operational databases, that supports business analysis activities and decision-making tasks?

data warehouse

A(n) ______ maintains data about various types of objects (inventory), events (transactions), people (employees), and places (warehouses).

database

What creates, reads, updates, and deletes data in a database while controlling access and security?

database management system

______ data is erroneous or flawed data.

dirty

What is erroneous or flawed data?

dirty data

______ computing processes and manages algorithms across many machines in a computing environment.

distributed

What processes and manages algorithms across many machines in a computing environment?

distributed computing

______, transformation, and loading is a process that extracts data from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse.

extraction

A data ________ analysis occurs when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps or where missing data might exist.

gap

Data ______ occurs when the same data element has different values.

inconsistency

A data point is an ______ item on a graph or a chart.

individual

A data ______ is a storage repository that holds a vast amount of raw data in its original format until the business needs it.

lake

Data ______ is the time it takes for data to be stored or retrieved.

latency

A ______ records classified and summarized transactional data

ledger

What records classified and summarized transactional data?

ledger

Many firms complete data ______ audits to determine the accuracy and completeness of its data.

quality

A(n) ______ by-example tool helps users graphically design the answer to a question against a database.

query

Which tool helps users graphically design the answer to a question against a database?

query by example

______ data is data that has not been processed for use.

raw

What is data that has not been processed for use?

raw data

Data ______ is the duplication of data, or the storage of the same data in multiple places.

redundancy

______ integrity constraints are rules that enforce basic and fundamental information-based constraints.

relational

______ data identifies the primary location where data is collected.

source

What identifies the primary location where data is collected?

source data

A(n) ______ query language asks users to write lines of code to answer questions against a database.

structured

A data ______ is a logical collection of data, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.

warehouse