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

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

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

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

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

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

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.

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.

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

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

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?

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

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

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

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.

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

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

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.

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

________ 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.

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