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