CIS78

1.

1 point

The Data Warehousing Institute estimates that low-quality information costs U.S. businesses $60 billion annually.

True

False

2.

1 point

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

True

False

3.

1 point

Which of the following types of information can be found in a database?

Inventory

Transactions

Employees

All of these

4.

1 point

A dimension is a particular attribute of information. Each layer in a data warehouse or data mart
represents information according to an additional dimension. What is the common term for the
representation of multidimensional information?

A. Table

B. Block

C. Cube

D. All of these

5.

1 point

What is an integration?

A. Allows separate systems to communicate directly with each other.

B. Takes information entered into a given system and sends it to the database.

C. Takes information entered into a given system and sends it to other processes.

Takes information entered into a given system and sends it to the DBMS. This is the definition of integration.

6.

1 point

A data-driven website is an interactive website kept constantly updated and relevant to the needs of
its customers through the use of a database.

True

False

7.

1 point

All of the following are advantages of database-stored information except:

A. Increased flexibility

B. Increased performance

C. Increased information redundancy

D. Increased information integrity

8.

1 point

Achieving perfect information is almost impossible. The more complete and accurate an
organization wants its information to be, the more it costs. Which two variables are used to
determine the trade-off for perfect information?

A. Accuracy versus completeness.

B. Accessibility versus completeness.

C. Accuracy versus complexity.

D. Accessibility versus complexity.

9.

1 point

What is a backward integration?

Takes information entered into a given system and sends it to the application-generation component.

Takes information entered into a given system and sends it automatically to all downstream systems and processes.systems and processes.

Takes information entered into a given system and sends it automatically to all upstream systems and processes.

Takes information entered into a given system and sends it to the DBMS.

10.

1 point

Lands' End created an organization-wide data warehouse so all its employees could access
organizational information. Lands' End soon found out that there could be "too much of a good
thing." Many of its employees would not use the data warehouse, because it was simply too big, too
complicated, and had too much irrelevant information. Lands' End knew there was valuable
information in its data warehouse, and it had to find a way for its employees to easily access the
information. What was Lands' End's solution?

A. Build a better, more efficient data warehouse.

B. Build a better, more efficient transactional database.

C. Build a data mart.

Build a data-driven website.

11.

1 point

Which of the following is true in regard to eliminating redundant information?

Uses additional hard disk space.

Makes performing information updates harder.

Improves information quality.

All of these

12.

1 point

4. Which of the following statements is true?

A. The more complete an organization wants to get its information, the less it costs.

B. The more accurate an organization wants to get its information, the less it costs.

C. The less accurate an organization wants to get its information, the more it costs.

D. The more complete and accurate an organization wants to get its information, the more it costs.

13.

1 point

What is the primary problem with redundant information?

A. It is difficult to determine which values are the most current.

B. It is often inconsistent.

C. It is difficult to determine which values are the most accurate.

D. All of these.

14.

1 point

3. Which of the following describes ETL?

A. A process that extracts information from internal and external databases.

B. A process that transforms information using a common set of enterprise definitions.

C. A process that loads information into a data warehouse.

All of these

15.

1 point

5. What is the primary purpose of a data warehouse?

To aggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities.

To disaggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities.

To aggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities.

To disaggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities.

16.

1 point

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

True

False

17.

1 point

What is information redundancy?

A. Duplication of information.

B. Storing the same information in multiple places.

C. Storing duplicate information in multiple places.

D. All of these.

18.

1 point

What refers to how well a system can adapt to increased demands?

A. Scalability

B. Performance

C. Redundancy

D. Information integrity

19.

1 point

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.

True

False

20.

1 point

A relational database contains information in a series of two-dimensional tables. How is data
contained in a data warehouse and data mart?

A. Information is multidimensional, meaning it contains a single layer of data in a table format.

B. Information is two-dimensional, meaning it contains a single layer of data in a table format.

C. Information is two-dimensional, meaning it contains layers of columns and rows.

D. Information is multidimensional, meaning it contains layers of columns and rows.

21.

1 point

What is a dimension?

A. A particular attribute of information.

B. A particular entity of information.

C. A particular relational database.

D. A particular single repository.

22.

1 point

What is a forward integration?

Takes information entered into a given system and sends it to the application-generation component.

Takes information entered into a given system and sends it automatically to all downstream systems and processes.

Takes information entered into a given system and sends it automatically to all upstream systems and processes.

Takes information entered into a given system and sends it to the DBMS. This is the definition of forward integration.

23.

1 point

A data warehouse is a _________ collection of information - gathered from many different
___________ databases - that supports business-analysis activities and decision-making tasks.

A. physical; transactional

B. physical; operational

C. logical; transactional

D. logical; operational

24.

1 point

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

True

False