Question 1

Describe the broad levels, formats, and granularities of information.

Accepted Answer

The answer of Describe the broad levels, formats, and granularities...

Question 2

Bill Inmon, who is known as the "Father of Data Warehousing." describes a data warehouse as a subject-oriented, integrated, time-variant, and non-volatile collection of information. What do these terms mean?

Accepted Answer

The answer of Bill Inmon, who is known as the...

Question 3

__________ analysis performs such functions as information correlations, distributions, calculations, and variance analysis.

Accepted Answer

The answer of __________ analysis performs such functions as information...

Question 4

Data warehousing is about extending the transformation of data into _________.

Accepted Answer

The answer of Data warehousing is about extending the transformation...

Question 5

Explain the relationship between business intelligence and a data warehouse.

Accepted Answer

The answer of Explain the relationship between business intelligence and...

Question 6

Explain the primary difference between a database and a data warehouse.

Accepted Answer

The answer of Explain the primary difference between a database...

Question 7

List and describe the various benefits an organization can expect to receive from BI deployment?

Accepted Answer

The answer of List and describe the various benefits an...

Question 8

Data warehousing is about extending the transformation of transactional data into ______ information.

Accepted Answer

The answer of Data warehousing is about extending the transformation...

Question 9

Compare relational integrity constraints and business-critical integrity constraints.

Accepted Answer

The answer of Compare relational integrity constraints and business-critical integrity...

Question 10

Distinguish between information accuracy and completeness with examples.

Accepted Answer

The answer of Distinguish between information accuracy and completeness with...

Question 11

Describe the role and purpose of a database management system.

Accepted Answer

The answer of Describe the role and purpose of a...

Question 12

Explain why an organization cannot achieve 100 percent accurate and complete information.

Accepted Answer

The answer of Explain why an organization cannot achieve 100...

Question 13

Evaluate the advantages of the relational database model.

Accepted Answer

The answer of Evaluate the advantages of the relational database...

Question 14

Describe three types of data-mining analysis capabilities.

Accepted Answer

The answer of Describe three types of data-mining analysis capabilities....

Question 15

Market __________ analysis analyzes such items as websites and checkout scanner information to detect customers' buying behaviour and predicts future behaviour by identifying affinities among customers' choices of products and services.

Accepted Answer

The answer of Market __________ analysis analyzes such items as...

Question 16

List the four primary sources of low-quality information.

Accepted Answer

The answer of List the four primary sources of low-quality...

Question 17

Assess the impact of low-quality information on an organization and the benefits of high-quality information on an organization.

Accepted Answer

The answer of Assess the impact of low-quality information on...

Question 18

Explain the multi-dimensional nature of data warehouses (and data marts) and the business value gained from multidimensional analysis.

Accepted Answer

The answer of Explain the multi-dimensional nature of data warehouses...

Question 19

Identify the importance of ensuring the cleanliness of information throughout an organization.

Accepted Answer

The answer of Identify the importance of ensuring the cleanliness...

Question 20

_____________ cleansing or scrubbing is the process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Accepted Answer

The answer of _____________ cleansing or scrubbing is the process...

Quiz 4: Ethics and Information Security