 |
1 | |
Despite the many potential benefits of a data warehouse, the downsides are that they take time to build, can perform slowly, and they are expensive. |
| | A) | True |
| | B) | False |
|
|
2 | |
The number of cells in a multidimension data cube should equal the number of records in the corresponding relational table. |
| | A) | True |
| | B) | False |
|
|
3 | |
In a typical star schema, the fact table is linked to the dimension tables using the primary and foreign keys. |
| | A) | True |
| | B) | False |
|
|
4 | |
Since dimension tables in a data warehouse are designed for retrieval, it is common to denormalize them in order to improve retrieval performance by eliminating join operations. |
| | A) | True |
| | B) | False |
|
|
5 | |
The CUBE, ROLLUP and GROUPING SETS operators can be combined in a SQL statement to provide exactly the summary totals needed. |
| | A) | True |
| | B) | False |
|
|
6 | |
The results of both the CUBE and ROLLUP operators can be achieved without these operators, by using a number of SELECT statements connected by the UNION operator. |
| | A) | True |
| | B) | False |
|
|
7 | |
The query rewriting process substitutes materialized views for fact and dimension tables in a query. |
| | A) | True |
| | B) | False |
|
|
8 | |
MOLAP has smaller storage requirements, but it also has a slower response time than ROLAP. |
| | A) | True |
| | B) | False |
|
|
9 | |
In populating a data warehouse, challenges may arise from differences in both data source formats and the timing of data source changes. |
| | A) | True |
| | B) | False |
|
|
10 | |
In determining the optimum refresh frequency of a data warehouse, the data warehouse administrator has to consider the value of data timeliness versus the cost of refresh, as well as the constraints on the refresh process. |
| | A) | True |
| | B) | False |
|