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

True/False

Review LaterAdd Note

Review Later

MOLAP is a logical choice for companies that already use relational databases for their operational data.

A) True
B) False

Correct Answer

verified

Show Answer

Question 2

Essay

Review LaterAdd Note

Review Later

What is a data cube?

Correct Answer

verified

Conceptually,MDBMS end users visualize t...

View Answer

Show Answer

Question 3

True/False

Review LaterAdd Note

Normalizing fact tables improves data access performance and saves data storage space.

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

______________________________ is a collection of concepts,techniques,and processes for the proper identification,definition,and management of data elements within an organization.

Data ____ implies that all business entities,data elements,data characteristics,and business metrics are described in the same way throughout the enterprise.

Conceptually,MDBMS end users visualize the stored data as a three-dimensional cube known as a ____.

A characteristic of operational data is ____.

____________________ use Web-based technologies to present key business performance indicators or information in a single integrated view,generally using graphics in a clear,concise,and easy to understand manner.

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

Describe the use of SQL in relation to ROLAP.

Data warehouse data are organized and summarized by table,such as CUSTOMER and ADDRESS.

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

The data warehouse designer must define common business dimensions that will be used by the data analyst to narrow a search,group information,or describe attributes.

The basic star schema has four components: facts,____,attributes,and attribute hierarchies.

____________________ are qualifying characteristics that provide additional perspectives to a given fact.

Data ____________________ tools provide advanced visual analysis and techniques to enhance understanding of business data.

____'s main goal is to provide a comprehensive and consistent definition of all data within an organization.

To support a(n)____________________ adequately,the DBMS might be required to use advanced hardware,such as multiple disk arrays,and even more importantly,to support multiple-processor technologies,such as a symmetric multiprocessor (SMP)or a massively parallel processor (MPP).

____________________ is a measurement of the density of the data held in the data cube and is computed by dividing the total number of actual values in the cube by the total number of cells in the cube.