FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 15: Databases for Decision Support

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

A ____ schema is a type of star schema in which the dimension tables can have their own dimension tables.

A) snowflake
B) starflake
C) mesh
D) matrix

E) All of the above
F) A) and C)

Correct Answer

verified

Show Answer

Question 22

Essay

Review LaterAdd Note

Review Later

What is the ROLLUP extension to the GROUP BY clause? Provide the syntax for this extension.

Correct Answer

verified

The ROLLUP extension is used with the GR...

View Answer

Show Answer

Question 23

True/False

Review LaterAdd Note

It is a relatively easy task to provide a precise list of characteristics of data-mining tools.

What is a characteristic of ROLAP?

In 2008, Wal-Mart, the world's largest company, had over four ____ of data in its data warehouses.

What is a data cube?

The attribute hierarchy provides a top-down data organization that is used for two main purposes: ____ and drill-down/roll-up data analysis.

What is one of the main characteristics of OLAP systems?

The star schema is designed to optimize data query operations rather than data update operations.

Data mining is part of the "____" section of the business intelligence framework.

The data warehouse development life cycle differs from classical systems development.

Multidimensional data analysis techniques include advanced computational functions.

____________________ online analytical processing provides OLAP functionality by using relational databases and familiar relational query tools to store and analyze multidimensional data.

Had ____ been as pivotal to business operations a few years back, crises precipitated by the likes of Enron, WorldCom, and Arthur Andersen might have been avoided.

In a star schema, attributes are often used to search, filter, or classify ____.

To tie a KPI to the strategic master plan of an organization, a KPI will be compared to a desired goal within a specific time frame.

Because a data cube's dimensions are predefined, all cells are populated.

The most distinct characteristic of modern OLAP tools is their capacity for ____________________ analysis.

BusinessObjects is a(n) ____ tool.

A data ____________________ is a small, single-subject data warehouse subset that provides decision support to a small group of people.