32) In an online analytical processing (OLAP) report, a data item that is to be processed is called a ________.
A) measure
B) dimension
C) cube
D) target
33) Which of the following is an example of a measure in an online analytical processing (OLAP) report?
A) sales region
B) average cost
C) customer location
D) customer type
34) In an online analytical processing (OLAP) report, the purchase date is an example of a(n) ________.
A) measure
B) attribute
C) dimension
D) variable
35) In the case of online analytical processing (OLAP), a presentation of a measure with associated dimensions is referred to as an ________.
A) OLAP database
B) OLAP server
C) OLAP service
D) OLAP cube
36) An online analytical processing (OLAP) cube can also be referred to as an ________.
A) OLAP database
B) OLAP report
C) OLAP service
D) OLAP server
37) Which of the following is a drawback of online analytical processing (OLAP) reports?
A) They have a single or no dimension.
B) Their format is static in nature.
C) They require a lot of computing power.
D) They can perform arithmetic operations only on single sets of data.
38) Which of the following statements is true of dimensional databases?
A) They store millions of static online analytical processing (OLAP) reports.
B) They are structured to support OLAP processing.
C) They specialize in sorting functions alone.
D) They specialize in filtering functions alone.
39) In online analytical processing (OLAP) reports, a dimension refers to an item that is to be processed in the report.
40) An online analytical processing (OLAP) cube is a characteristic of a measure in an OLAP report.
41) Users are not allowed to alter the format of online analytical processing (OLAP) reports.
42) The process of dividing the data in online analytical processing (OLAP) reports into more details is termed
drill down.
43) An online analytical processing (OLAP) server reads data from an operational database, performs preliminary calculations, and stores the results of those calculations in an OLAP database.
44) Describe online analytical processing (OLAP).