Filters
Question type

Study Flashcards

Why would a business use a data warehouse that offers strategic level,external,integrated,and historical information?


A) Identify trends.
B) Make projections.
C) Decide key business issues.
D) All of these.

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

Which of the following does not draw a parallel between the challenges in business and the challenges of war?


A) Collecting information.
B) Discerning patterns and meaning in the information.
C) Accurate and complete information.
D) Responding to the resultant information.

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

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

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

Which of the following statements is true regarding customer information?


A) Customer information can exist in several operational systems.
B) Customer information in each operational system could change.
C) Customer information in each operational system can be different.
D) All of these.

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

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.

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

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.
D) Build a data-driven website.

E) B) and D)
F) B) and C)

Correct Answer

verifed

verified

Which of the following is not one of the principal BI enablers?


A) Technology
B) Corporate processes
C) People
D) Corporate culture

E) All of the above
F) None of the above

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

False

What is information that people use to support their decision-making efforts?


A) Information cleansing and scrubbing
B) Data-mining tools
C) Data mining
D) Business intelligence

E) B) and C)
F) All of the above

Correct Answer

verifed

verified

D

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

E) B) and D)
F) C) and D)

Correct Answer

verifed

verified

What do data warehouses support?


A) OLAP
B) Analytical processing
C) OLTP
D) OLAP and analytical processing

E) C) and D)
F) A) and D)

Correct Answer

verifed

verified

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.

E) C) and D)
F) A) and B)

Correct Answer

verifed

verified

A

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

Correct Answer

verifed

verified

An organization must maintain high-quali...

View Answer

Data information in a data warehouse contains layers of columns and rows,and this is known as __________ databases.

Correct Answer

verifed

verified

A(n)___________ is the common term for the representation of multidimensional information.

Correct Answer

verifed

verified

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) True
B) False

Correct Answer

verifed

verified

A(n)__________ is a particular attribute of information.

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

The primary difference between a databas...

View Answer

Showing 1 - 20 of 41

Related Exams

Show Answer