Question 1

In refreshing a data warehouse,________________ change data involves notification from a source system,and typically occurs after a transaction is completed using a trigger.

Accepted Answer

The answer of In refreshing a data warehouse,________________ change data...

Question 2

______________ indicates the extent of empty cells in a data cube.

Accepted Answer

The answer of ______________ indicates the extent of empty cells...

Question 3

A stored view created to provide fast response for queries involving large fact tables is a(n)____________________ view.

Accepted Answer

The answer of A stored view created to provide fast...

Question 4

One of the decision support operations that can be performed on a data cube is the _______________ operation,which allows users to navigate from a specific level of a hierarchical dimension to a more general level.

Accepted Answer

The answer of One of the decision support operations that...

Question 5

A ___________ is a storage engine that directly stores and manipulates data cubes.___________ engines generally offer the best query performance but place limits on the size of data cubes.

Accepted Answer

The answer of A ___________ is a storage engine that...

Question 6

One of the decision support operations that can be performed on a data cube is the _______________ operation,in which one or more dimensions are set to specific values and the remaining data cube is displayed.

Accepted Answer

The answer of One of the decision support operations that...

Question 7

One of the decision support operations that can be performed on a data cube is the _______________ operation,which allows users to navigate from a more general level of a hierarchical dimension to a more specific level.

Accepted Answer

The answer of One of the decision support operations that...

Question 8

Numeric values such as unit sales dollars contained in the cells of a data cube are known as ______________.

Accepted Answer

The answer of Numeric values such as unit sales dollars...

Question 9

The subjects that data are grouped by in a data cube are known as ____________________.

Accepted Answer

The answer of The subjects that data are grouped by...

Question 10

One of the decision support operations that can be performed on a data cube is the _______________ operation,which rearranges the dimensions in a data cube so that the data can be presented in a more visually appealing order.

Accepted Answer

The answer of One of the decision support operations that...

Question 11

In refreshing a data warehouse,________________ change data involves files that record changes or other user activity.

Accepted Answer

The answer of In refreshing a data warehouse,________________ change data...

Question 12

__________________ is a substitution process that replaces references to fact and dimension tables with a materialized view.

Accepted Answer

The answer of __________________ is a substitution process that replaces...

Question 13

A multidimensional data model used in relational databases that has multiple fact tables in the center linked to multiple dimension tables,some of which are shared by the fact tables,is known as a(n)_____________________ schema.

Accepted Answer

The answer of A multidimensional data model used in relational...

Question 14

Vendors of relational DBMSs have extended their products with additional features to support operations and storage structures for multidimensional data.These product extensions are collectively known as _________._________ engines support a variety of storage and optimization techniques for summary data retrieval.

Accepted Answer

The answer of Vendors of relational DBMSs have extended their...

Question 15

A multidimensional data model used in relational databases that has a fact table in the center linked in a radial manner to multiple dimension tables is known as a(n)_____________________ schema.

Accepted Answer

The answer of A multidimensional data model used in relational...

Question 16

The _____________ operator is an extension of the SQL GROUP BY clause that produces all combinations of subtotals in addition to the normal totals.

Accepted Answer

The answer of The _____________ operator is an extension of...

Question 17

A multidimensional data model used in relational databases that has multiple levels of dimension tables related to one or more fact tables is known as a(n)_____________________ schema.

Accepted Answer

The answer of A multidimensional data model used in relational...

Question 18

In refreshing a data warehouse,________________ change data involves a periodic dump of source data which is compared using a difference operation to the previous dump.

Accepted Answer

The answer of In refreshing a data warehouse,________________ change data...

Quiz 16: Data Warehouse Technology and Management

In refreshing a data warehouse,________________ change data involves notification from a source system,and typically occurs after a transaction is completed using a trigger.

______________ indicates the extent of empty cells in a data cube.

A stored view created to provide fast response for queries involving large fact tables is a(n)____________________ view.

One of the decision support operations that can be performed on a data cube is the _______________ operation,which allows users to navigate from a specific level of a hierarchical dimension to a more general level.

A _ is a storage engine that directly stores and manipulates data cubes._ engines generally offer the best query performance but place limits on the size of data cubes.

One of the decision support operations that can be performed on a data cube is the _______________ operation,in which one or more dimensions are set to specific values and the remaining data cube is displayed.

One of the decision support operations that can be performed on a data cube is the _______________ operation,which allows users to navigate from a more general level of a hierarchical dimension to a more specific level.

Numeric values such as unit sales dollars contained in the cells of a data cube are known as ______________.

The subjects that data are grouped by in a data cube are known as ____________________.

One of the decision support operations that can be performed on a data cube is the _______________ operation,which rearranges the dimensions in a data cube so that the data can be presented in a more visually appealing order.

In refreshing a data warehouse,________________ change data involves files that record changes or other user activity.

__________________ is a substitution process that replaces references to fact and dimension tables with a materialized view.

A multidimensional data model used in relational databases that has multiple fact tables in the center linked to multiple dimension tables,some of which are shared by the fact tables,is known as a(n)_____________________ schema.

Vendors of relational DBMSs have extended their products with additional features to support operations and storage structures for multidimensional data.These product extensions are collectively known as _._ engines support a variety of storage and optimization techniques for summary data retrieval.

A multidimensional data model used in relational databases that has a fact table in the center linked in a radial manner to multiple dimension tables is known as a(n)_____________________ schema.

The _____________ operator is an extension of the SQL GROUP BY clause that produces all combinations of subtotals in addition to the normal totals.

A multidimensional data model used in relational databases that has multiple levels of dimension tables related to one or more fact tables is known as a(n)_____________________ schema.

In refreshing a data warehouse,________________ change data involves a periodic dump of source data which is compared using a difference operation to the previous dump.