FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Descriptive Analytics II: Business Intelligence and Data Warehousing

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Essay

Review LaterAdd Note

Review Later

What is the definition of a data warehouse (DW)in simple terms?

Correct Answer

verified

In simple terms,a data warehouse (DW)is a pool of data produced to support decision making; it is also a repository of current and historical data of potential interest to managers throughout the organization.

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

When representing data in a data warehouse,using several dimension tables that are each connected only to a fact table means you are using which warehouse structure?

A) star schema
B) snowflake schema
C) relational schema
D) dimensional schema

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

Correct Answer

verified

Show Answer

Question 3

Essay

Review LaterAdd Note

There are several basic information system architectures that can be used for data warehousing.What are they?

Operational or transaction databases are product oriented,handling transactions that update the database.In contrast,data warehouses are

Bill Inmon advocates the data mart bus architecture whereas Ralph Kimball promotes the hub-and-spoke architecture,a data mart bus architecture with conformed dimensions.

The ________ Model,also known as the EDW approach,emphasizes top-down development,employing established database development methodologies and tools,such as entity-relationship diagrams (ERD),and an adjustment of the spiral development approach.

Given that the size of data warehouses is expanding at an exponential rate,________ is an important issue.

A(n)________ data mart is a subset that is created directly from the data warehouse..

OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items.

Why is a performance management system superior to a performance measurement system?

Performing extensive ________ to move data to the data warehouse may be a sign of poorly managed data and a fundamental lack of a coherent data management strategy.

A common way of introducing data warehousing is to refer to its fundamental characteristics.Describe three characteristics of data warehousing.

Moving the data into a data warehouse is usually the easiest part of its creation.

A(n)________ data store (ODS)provides a fairly recent form of customer information file.

The role responsible for successful administration and management of a data warehouse is the ________,who should be familiar with high-performance software,hardware,and networking technologies,and also possesses solid business insight.

With the balanced scorecard approach,the entire focus is on measuring and managing specific financial goals based on the organization's strategy.

________ is a mechanism for pulling data from source systems to satisfy a request for information.It is an evolving tool space that promises real-time data integration from a variety of sources,such as relational databases,Web services,and multidimensional databases.

Subject oriented databases for data warehousing are organized by detailed subjects such as disk drives,computers,and networks.

What are the four processes that define a closed-loop BPM cycle?

Mention briefly some of the recently popularized concepts and technologies that will play a significant role in defining the future of data warehousing.