FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 13: Business Intelligence and Data Warehouses

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Essay

Review LaterAdd Note

Review Later

OLAP systems share three main characteristics.What are they?

Correct Answer

verified

Multidimensional dat...

View Answer

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

A MOLAP system stores data in an MDBMS,using proprietary ____ and array technology to simulate the multidimensional cube.

A) table
B) matrix
C) network
D) cube

E) A) and B)
F) None of the above

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

ROLAP extends ____ so that it can differentiate between access requirements for data warehouse data and operational data.

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

____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.

A data store is used by the data analyst to create the queries that access the database.

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

The decision support database query optimizer must be enhanced to support non-normalized structures.

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

A data mart is part of the "____" section of the business intelligence framework.

A(n)______________________________ is an arrangement of computerized tools used to assist managerial decision making within a business.

Once data enter the data warehouse,they are never removed.

Data ____________________ tools are tools that provide advanced statistical analysis to uncover problems and opportunities hidden within business data.

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

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

To deliver efficient decision support,OLAP tools must have advanced data ____________________ features.

Implementing BI in an organization involves capturing not only business data (internal and external) but also the ____.

____ systems provided no data extraction/integration process.

A data ____________________ is a centralized,consolidated database that integrates data derived from the entire organization and from multiple sources with diverse formats.

____ provide a unified,single point of entry for information distribution.