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 51

Multiple Choice

Review LaterAdd Note

Review Later

The ____ dimension of a data cube provides a framework from which sales patterns can be analyzed and possibly predicted.

A) time
B) cube
C) third
D) multi-

E) C) and D)
F) A) and C)

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

In a MOLAP system,the MOLAP ____ allows end users to interact with the MOLAP server and request data for analysis.

A) GUI
B) operational database
C) multidimensional database
D) data cube

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 53

True/False

Review LaterAdd Note

In most implementations,the data warehouse and OLAP are stand-alone,independent environments.

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

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

____________________ is a term used to describe a comprehensive,cohesive,and integrated set of tools and processes used to capture,collect,integrate,store,and analyze data with the purpose of generating and presenting information used to support business decision making.

Multidimensional data analysis techniques include advanced computational functions.

A(n) ____ is a dynamic table that not only contains the SQL query command to generate the rows,but also stores the actual rows.

The ____ contains business data extracted from the operational database and from external data sources.

In practice,_________________________ provides a well-orchestrated framework for the management of data that works across all levels of the organization.

In multidimensional terms,the ability to focus on slices of the cube to perform a more detailed analysis is known as ____________________.

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

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

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

____ can serve as a test vehicle for companies exploring the potential benefits of data warehouses.

___________________________________ are quantifiable measurements (numeric or scale based)that assess the company's effectiveness or success in reaching its strategic and operational goals.

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

Queries against operational data typically are broad in scope and high in complexity.

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.

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