Exam 3: Data Warehousing

In the Michigan State Agencies case, the approach used was a(n) ________ one, instead of developing separate BI/DW platforms for each business area or state agency.

A(n) ________ architecture is used to build a scalable and maintainable infrastructure that includes a centralized data warehouse and several dependent data marts.

The ________ Model, also known as the data mart approach, is a "plan big, build small" approach. A data mart is a subject-oriented or department-oriented data warehouse. It is a scaled-down version of a data warehouse that focuses on the requests of a specific department, such as marketing or sales.

Because the recession has raised interest in low-cost open source software, it is now set to replace traditional enterprise software.

All of the following statements about metadata are true EXCEPT

________, or "The Extended ASP Model," is a creative way of deploying information system applications where the provider licenses its applications to customers for use as a service on demand (usually over the Internet)

Active data warehousing can be used to support the highest level of decision making sophistication and power. The major feature that enables this in relation to handling the data is

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?

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.

Which approach to data warehouse integration focuses more on sharing process functionality than data across systems?

With ________ data flows, managers can view the current state of their businesses and quickly identify problems.

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

Which data warehouse architecture uses a normalized relational warehouse that feeds multiple data marts?

________ is a mechanism that integrates application functionality and shares functionality (rather than data) across systems, thereby enabling flexibility and reuse.

The "islands of data" problem in the 1980s describes the phenomenon of unconnected data being stored in numerous locations within an organization.

Organizations seldom devote a lot of effort to creating metadata because it is not important for the effective use of data warehouses.

Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates?

The ________ data warehouse architecture involves integrating disparate systems and analytical resources from multiple sources to meet changing needs or business conditions.

When querying a dimensional database, a user went from summarized data to its underlying details. The function that served this purpose is