CH 9 430

The word online in the term OLAP refers to the use of the Internet or other networks.

FALSE

The data in fact tables is always located faster in relational implementations than in the multidimensional implementations.

False

The multidimensional database cube always has three dimensions.

False

Creating a data warehouse involves using the functionalities of database management software to implement the data warehouse model as a collection of physically created and mutually connected database tables.

TRUE

Developing front-end applications includes creating a set of predeveloped queries and interfaces to those queries.

TRUE

OLAP/BI tools are designed for the analysis of dimensionally modeled data.

TRUE

The purpose of the drill down operation is to make the granularity of the data in the query result finer.

TRUE

The purpose of the drill up operation is to make the granularity of the data in the query result coarser.

TRUE

The process of transformation cannot involve standardizing different versions of the same data present in different data sources.

FALSE

Archived data from source systems is never present in the data warehouse.

FALSE

The process of deciding what to extract during the extraction process begins after the requirements and modeling stages are completed.

FALSE