DRM Ch 9

A dependent data mart: A) is filled exclusively from the enterprise data warehouse with reconciled data. B) is dependent upon an operational system. C) is filled with data extracted directly from the operational system. D) participates in a relationship with an entity.

A) is filled exclusively from the enterprise data warehouse with reconciled data.

Data that are never physically altered once they are added to the store are called ________ data. A) periodic B) transient C) override D) complete

A) periodic

Data that are detailed, current, and intended to be the single, authoritative source of all decision support applications are called ________ data. A) reconciled B) derived C) detailed D) subject

A) reconciled

________ is an ill-defined term applied to databases where size strains the ability of commonly used relational DBMSs to manage the data. A) Mean data B) Big data C) Star data D) Small data

B) Big data

Which of the following factors drive the need for data warehousing? A) Reduce virus and Trojan horse threats. B) Businesses need an integrated view of company information. C) Data warehouses generally have better security. D)Informational data must be kept together with operational data.

B) Businesses need an integrated view of company information

Going from a summary view to progressively lower levels of detail is called data: A) drill-down. B) dicing. C) cubing. D) pivoting.

B) Clustering and signal processing

When we consider data in the data warehouse to be time-variant, we mean: A) that there is a time delay between when data are posted and when we report on the data. B) data in the warehouse contain a time dimension so that they may be used to study trends and changes. C) that the time of storage varies. D) that time is relative.

B) data in the warehouse contain a time dimension so that they may be used to study trends an changes

The real-time data warehouse is characterized by which of the following? A) It accepts batch feeds of transaction data. B) It is based on Oracle technology. C) Data are immediately transformed and loaded into the warehouse. D) It provides periodic access for the transaction processing systems to an enterprise data warehouse.

C) Data are immediately transformed and loaded into the warehouse.

A logical data mart is a(n): A) integrated, subject-oriented, detailed database designed to serve operational users. B) data mart consisting of only logical data. C) data mart created by a relational view of a slightly denormalized data warehouse. D) centralized, integrated data warehouse.

C) data mart created by a relational view of a slightly denormalized data warehouse.

A data mart is a(n): A) generic on-line shopping site. B) smaller system built upon file processing technology. C) data warehouse that is limited in scope. D) enterprisewide data warehouse.

C) data warehouse that is limited in scope

Grain and duration have a direct impact on the size of ________ tables. A) grain B) figure C) fact D) selection

C) fact

The analysis of summarized data to support decision making is called: A) operational processing. B) data scrubbing. C) informational processing. D) artificial intelligence.

C) information processing

All of the following are limitations of the independent data mart EXCEPT: A) separate extraction, transformation, and loading processes are developed for each data mart. B) there is no capability to drill down into greater detail in other data marts. C) it is often more expedient to build a data mart than a data warehouse. D) data marts may not be consistent with one another

C) it is often more expedient to build a data mart than a data warehouse.

Rotating the view of a multidimensional database for a particular data point is called data: A) dicing. B) cubing. C) pivoting. D) drill-down.

C) pivoting

Informational systems are designed for all of the following EXCEPT: A) supporting decision making. B) complex queries. C) running a business in real time. D) data mining.

C) running a business in real time

Which of the following data-mining techniques identifies clusters of observations with similar characteristics? A) Neural nets B) Clustering and signal processing C) Case reasoning D) Rule discovery

D) Rule discovery

Which of the following data-mining techniques searches for patterns and correlations in large data sets? A) Signal processing B) Neural nets C) Case reasoning D) Rule discovery

D) Rule discovery

An operational data store (ODS) is a(n): A) place to store all unreconciled data. B) small-scale data mart. C) representation of the operational data. D) integrated, subject-oriented, updateable, current-valued, detailed database designed to serve the decision support needs of operational users.

D) integrated, subject-oriented, updateable, current-valued, detailed database designed to serve the decision support needs of operational users.

The use of a set of graphical tools that provides users with multidimensional views of their data is called: A) drill-down analysis. B) on-line geometrical processing (OGP). C) on-line datacube processing (ODP). D) on-line analytical processing (OLAP).

D) on-line analytical processing (OLAP)

Every key used to join the fact table with a dimension table should be a ________ key. A) secondary B) primary C) foreign D) surrogate

D) surrogate