 |
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 |
|