Upgrade to remove ads
Only $35.99/year

Chapter 6 Quiz - MISY 3310

Terms in this set (20)

What is a foreign key?
A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables
Which of the following identifies the primary location where data is collected?
source data
Business intelligence can provide managers with the ability to make better decisions. Which of the following is not an example of how different industries use business intelligence?

A. Analyze popular vacation locations with current flight listings
B. Understand customer credit card usage and nonpayment rates
C. Compare the demographics of patients with critical illnesses
D. All of these choices are examples of how industries use business intelligence.
D. All of these choices are examples of how industries use business intelligence.

Business intelligence is information that people use to support their decision-making efforts
What moves beyond Excel graphs and charts into sophisticated analysis techniques such as pie charts, controls, instruments, maps, time-series graphs, and more?
data visualization tools
What is extraction, transformation, and loading?
ETL

a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse
What is the term for 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
Ben works at a top accounting firm in Salt Lake City and his responsibilities include developing reports for each salesperson, product, and part as well as departmental-wide sales reports by salesperson, product, and part.

Ben's duties provide value-added to his company and would be categorized as occurring at the different information ________.
granularities
What is the primary tool that retrieves information and helps users graphically design the answer to a question?
Query-by-example tool
Clustering assigns records to one of a predefined set of classes.
False.

Clustering: segments a heterogeneous population of records into a number of more homogenous subgroups

Classification: assigns records to one of a predefined set of classes
Transactional information is used when performing operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules to determine how much inventory to carry.
True.
Determining if information is updated weekly, daily, or hourly is an example of an accurate characteristic of high-quality information.
True.
A data warehouse is a ________ collection of information, gathered from many different ________ databases, that supports business analysis activities and decision-making tasks.
logical, operational
Data models are logical data structures that detail the relationships among data elements by using graphics or pictures.
True.
What segments a heterogeneous population of more homogeneous subgroups?
Clustering
The physical view of information deals with the physical storage of information on a storage device.
True.
A data set is an organized collection of data.
True.
Infographics (information graphics) displays information graphically so it can be easily understood.
True.
What are information integrity issues?
When a system produces incorrect, inconsistent, or duplicate data.
Business analysis is difficult to achieve from operational databases. Which of the following is not a reason why?
The data is standardized.
Determining if a name is spelled correctly is an example of an accurate characteristic of high-quality information.
True.
Students also viewed