Chap 9 DRM

data warehouse that is limited in scope

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

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

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

data mart created by a relational view of a slightly denormalized data warehouse

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

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

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

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

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

reconciled

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

Periodic

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

surrogate

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

drill-down

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

Fact

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

running a business in real time.

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

Pivoting

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

information processing

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

Data are immediately transformed and loaded into the warehouse.

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

B) on-line analytical processing (OLAP)

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

data in the warehouse contain a time dimension so that they may be used to study trends and changes.

When we consider data in the data warehouse to be time-variant, we mean: Question options: A) that time is relative. 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 there is a time delay between when data are posted and when we report on the data.

Clustering and signal processing

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

Rule discovery

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

Businesses need an integrated view of company information.

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

Big data

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