Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)



1

Which of the following features usually applies to data in a data warehouse?
A)Data are often deleted
B)Most applications consist of transactions
C)Data are rarely deleted
D)Relatively few records are processed by applications
2

Which of the following statement is true?
A)The data warehouse consists of data marts and operational data
B)The data warehouse is used as a source for the operational data
C)The operational data are used as a source for the data warehouse
D)All of the above
3

The following is true of three-tier data warehouses:
A)Once created, the data marts will keep on being updated from the data warehouse at periodic times
B)Once created, the data marts will directly receive their new data from the operational databases
C)The data marts are different groups of tables in the data warehouse
D)A data mart becomes a data warehouse when it reaches a critical size
4

The following technology is not well-suited for data mining:
A)Expert system technology
B)Data visualization
C)Technology limited to specific data types such as numeric data types
D)Parallel architecture
5

What is true of the multidimensional model?
A)It typically requires less disk storage
B)It typically requires more disk storage
C)Typical business queries requiring aggregate functions take more time
D)Increasing the size of a dimension is difficult
6

The value at the intersection of the row labeled "India" and the column "Savings" in Table2 should be:
A)800,000
B)300,000
C)200,000
D)300,000
7

We want to add the following capabilities to Table2: show the data for 3 age groups (20-39, 40-60, over 60), 3 revenue groups (less than $10,000, $10,000-$30,000, over $30,000) and add a new type of account: Money market. The total number of measures will be:
A)4
B)More than 100
C)Between 10 and 30 (boundaries included)
D)Between 40 and 60 (boundaries included)
8

We want to add the following capability to Table2: for each type of account in each region, also show the dollar amount besides the number of customers. This adds to Table2:
A)Another dimension
B)Other column(s)
C)Other row(s)
D)Another measure for each cell
9

The most common source of change data in refreshing a data warehouse is:
A)Queryable change data
B)Cooperative change data
C)Logged change data
D)Snapshot change data
10

Which of the following statements is not true about refreshing a data warehouse:
A)It is a process of managing timing differences between the updating of data sources and the related data warehouse objects
B)Updates to dimension tables may occur at different times than the fact table
C)The data warehouse administrator has more control over the load time lag than the valid time lag
D)None of the above







Mannino DB Design 3eOnline Learning Center with Powerweb

Home > Chapter 16 > Multiple Choice Quiz