Exam 2 b

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

 

• True

• False

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

 

• True

• False

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

 

• True

• False

Without middleware, different BI programs cannot easily connect to the data warehouse.

 

• True

• False

Data warehouses are subsets of data marts.

 

• True

• False

A Web client that connects to a Web server, which is in turn connected to a BI application server, is reflective of a

• two-tier architecture.

• one-tier architecture.

• three-tier architecture.

• four-tier architecture.

Oper marts are created when operational data needs to be analyzed

• in a dashboard.

• multidimensionally.

• linearly.

• unidimensionally.

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

•  

  volatile data mart

• sectional data mart

• public data mart

• independent data mart

Data warehouse administrators (DWAs) do not need strong business insight since they only handle the technical aspect of the infrastructure.

• True

• False

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

 

True

• True

• False