Question 1

Reports for each sales person, product, and part are examples of detail or fine information granularities.

Accepted Answer

Information granularities include detailed (or fine) information such as reports for each sales person, product, or parts.

Question 2

The data warehouse is a location for all of business information.

Accepted Answer

The data warehouse is not a location for all of a business's information.

Question 3

A foreign key is a field (or group of fields) that uniquely identifies a given entity in a table.

Accepted Answer

A primary key is a field (or group of fields) that uniquely identifies a given entity in a table.

Question 4

One of the advantages found in a relational database is increased information redundancy.

Accepted Answer

Relational databases reduce information redundancy, not increase information redundancy.

Question 5

Extraction, transformation, and loading is a process that extracts information from internal databases, transforms the information using a common set of enterprise definitions, and loads the information into an external database.

Accepted Answer

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

Question 6

A data mart is the process of analyzing data to extract information not offered by the raw data alone.

Accepted Answer

Data mining is the process of analyzing data to extract information not offered by the raw data alone.

Question 7

Data-mining tools use a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making.

Accepted Answer

This is the definition of data-mining tools.Data-mining tools use a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making.

Question 8

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

Accepted Answer

This is the definition of relational integrity constraints.

Question 9

The primary purpose of a data warehouse is to perform transactional processes.

Accepted Answer

The primary purpose of a data warehouse is to perform analytical process.

Question 10

The financial industry uses business intelligence to predict hardware failures.

Accepted Answer

The technology industry uses business intelligence to predict hardware failures, where the retail industry uses it to predict sales, inventory levels, and distribution.

Question 11

Many organizations find themselves in the position of being data rich and information poor.Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence.

Accepted Answer

Many organizations find themselves in the position of being data rich and information poor.Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence.

Question 12

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.

Accepted Answer

Transactional information is used to perform operational tasks.

Question 13

Within the data warehouse model, the internal databases could include marketing, sales, inventory, and billing.

Accepted Answer

Within the data warehouse model, the internal databases are marketing, sales, inventory, and billing.

Question 14

Text mining analyzes structured data to find trends and patterns in words and sentences.

Accepted Answer

Text mining analyzes unstructured data to find trends and patterns in words and sentences.

Question 15

The banking industry uses business intelligence to understand customer credit card usage and nonpayment rates.

Accepted Answer

The banking industry uses business intelligence to understand customer credit card usage and nonpayment rates.

Question 16

Within the data warehouse model, the external databases could include competitor information, industry information, and stock market analysis.

Accepted Answer

Within the data warehouse model, the external databases are competitor information, industry information, mailing lists, and stock market analysis.

Question 17

ETL, within a data warehouse model, stands for exit, track, and load.

Accepted Answer

ETL stands for extraction, transformation, and loading.

Question 18

A data miner contains a subset of data warehouse information.

Accepted Answer

This is the definition of a data mart.

Question 19

Organizational information comes at different levels and in different formats and granularities.

Accepted Answer

Employees must be able to correlate the different formats, levels, and granularities of information.

Question 20

Timely information must be up-to-the-second to be accurate.

Accepted Answer

Timely information can change for each business decision.Some decisions require weekly information while others require daily information.

Quiz 6: Data: Business Intelligence

Reports for each sales person, product, and part are examples of detail or fine information granularities.

The data warehouse is a location for all of business information.

A foreign key is a field (or group of fields) that uniquely identifies a given entity in a table.

One of the advantages found in a relational database is increased information redundancy.

Extraction, transformation, and loading is a process that extracts information from internal databases, transforms the information using a common set of enterprise definitions, and loads the information into an external database.

A data mart is the process of analyzing data to extract information not offered by the raw data alone.

Data-mining tools use a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making.

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

The primary purpose of a data warehouse is to perform transactional processes.

The financial industry uses business intelligence to predict hardware failures.

Many organizations find themselves in the position of being data rich and information poor.Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence.

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.

Within the data warehouse model, the internal databases could include marketing, sales, inventory, and billing.

Text mining analyzes structured data to find trends and patterns in words and sentences.

The banking industry uses business intelligence to understand customer credit card usage and nonpayment rates.

Within the data warehouse model, the external databases could include competitor information, industry information, and stock market analysis.

ETL, within a data warehouse model, stands for exit, track, and load.

A data miner contains a subset of data warehouse information.

Organizational information comes at different levels and in different formats and granularities.

Timely information must be up-to-the-second to be accurate.