Exam 6: The Data Warehouse

Use the OLAP cube to answer questions 10 through 12. Each cell of the cube contains a dollar amount representing total dollars spent for the specified time, region and category. -Which of the following is an example of a dice operation?

Free

(Multiple Choice)

4.7/5

(42)

Question 1

Correct Answer:

Verified

Use the OLAP cube to answer questions 10 through 12. Each cell of the cube contains a dollar amount representing total dollars spent for the specified time, region and category. -Consider the OLAP cube shown above. The vertical arrow points to:

Free

(Multiple Choice)

4.9/5

(28)

Question 2

Correct Answer:

Verified

The level of detail of the information stored in a data warehouse.

Free

(Multiple Choice)

4.8/5

(29)

Question 3

Correct Answer:

Verified

Defines each dimension of the multidimensional space of a star schema.

(Multiple Choice)

4.7/5

(31)

Question 4

Operational databases are designed to support _ whereas decision support systems are design to support ______.

(Multiple Choice)

4.8/5

(24)

Question 5

A variation of the star schema that allows more than one central fact table.

(Multiple Choice)

4.9/5

(48)

Question 6

Which of the following is not a primary function of a decision support system?

(Multiple Choice)

4.8/5

(28)

Question 7

Use the OLAP cube to answer questions 10 through 12. Each cell of the cube contains a dollar amount representing total dollars spent for the specified time, region and category. -A mapping that allows the attributes of an OLAP cube to be viewed from varying levels of detail.

(Multiple Choice)

4.9/5

(28)

Question 8

Which of the following is not a characteristic of a data warehouse?

(Multiple Choice)

4.8/5

(28)

Question 9

A one-to-many relationship.

(Multiple Choice)

4.9/5

(27)

Question 10

Use the OLAP cube to answer questions 10 through 12. Each cell of the cube contains a dollar amount representing total dollars spent for the specified time, region and category. -Which of the following is not an example of a slice operation?

(Multiple Choice)

4.8/5

(40)

Question 11

The purpose of an intersection entity is to replace

(Multiple Choice)

4.8/5

(37)

Question 12

This process removes redundancies that may be present in a data model.

(Multiple Choice)

4.9/5

(35)

Question 13

Showing 1 - 13 of 13

Use the OLAP cube to answer questions 10 through 12. Each cell of the cube contains a dollar amount representing total dollars spent for the specified time, region and category. -Which of the following is an example of a dice operation?

Use the OLAP cube to answer questions 10 through 12. Each cell of the cube contains a dollar amount representing total dollars spent for the specified time, region and category. -Consider the OLAP cube shown above. The vertical arrow points to:

The level of detail of the information stored in a data warehouse.

Defines each dimension of the multidimensional space of a star schema.

Operational databases are designed to support _ whereas decision support systems are design to support ______.

A variation of the star schema that allows more than one central fact table.

Which of the following is not a primary function of a decision support system?

Use the OLAP cube to answer questions 10 through 12. Each cell of the cube contains a dollar amount representing total dollars spent for the specified time, region and category. -A mapping that allows the attributes of an OLAP cube to be viewed from varying levels of detail.

Which of the following is not a characteristic of a data warehouse?

A one-to-many relationship.

Use the OLAP cube to answer questions 10 through 12. Each cell of the cube contains a dollar amount representing total dollars spent for the specified time, region and category. -Which of the following is not an example of a slice operation?

The purpose of an intersection entity is to replace

This process removes redundancies that may be present in a data model.

Data Mining: a First View

Data Mining: a Closer Look

Basic Data Mining Techniques

An Excel-Based Data Mining Tool

Knowledge Discovery in Databases

Formal Evaluation Techniques

Neural Networks

Building Neural Networks With Ida

Statistical Techniques

Specialized Techniques

Rule-Based Systems

Managing Uncertainty in Rule-Based Systems

Intelligent Agents

Filters

Exam 6: The Data Warehouse

Use the OLAP cube to answer questions 10 through 12. Each cell of the cube contains a dollar amount representing total dollars spent for the specified time, region and category. -Which of the following is an example of a dice operation?

Use the OLAP cube to answer questions 10 through 12. Each cell of the cube contains a dollar amount representing total dollars spent for the specified time, region and category. -Consider the OLAP cube shown above. The vertical arrow points to:

The level of detail of the information stored in a data warehouse.

Defines each dimension of the multidimensional space of a star schema.

Operational databases are designed to support _____ whereas decision support systems are design to support __________.

A variation of the star schema that allows more than one central fact table.

Which of the following is not a primary function of a decision support system?

Use the OLAP cube to answer questions 10 through 12. Each cell of the cube contains a dollar amount representing total dollars spent for the specified time, region and category. -A mapping that allows the attributes of an OLAP cube to be viewed from varying levels of detail.

Which of the following is not a characteristic of a data warehouse?

A one-to-many relationship.

Use the OLAP cube to answer questions 10 through 12. Each cell of the cube contains a dollar amount representing total dollars spent for the specified time, region and category. -Which of the following is not an example of a slice operation?

The purpose of an intersection entity is to replace

This process removes redundancies that may be present in a data model.

Data Mining: a First View

Data Mining: a Closer Look

Basic Data Mining Techniques

An Excel-Based Data Mining Tool

Knowledge Discovery in Databases

Formal Evaluation Techniques

Neural Networks

Building Neural Networks With Ida

Statistical Techniques

Specialized Techniques

Rule-Based Systems

Managing Uncertainty in Rule-Based Systems

Intelligent Agents

Filters

Operational databases are designed to support _ whereas decision support systems are design to support ______.