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

Describe the use of SQL in relation to ROLAP.

Correct Answer

verified

Most decision support data requests requ...

View Answer

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

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

A) tables
B) sales
C) facts
D) dimensions

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

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

Operational data and decision support data serve the same purpose.

_____ provide a unified,single point of entry for information Distribution.

The CUBE extension enable you to get a grand total for each column listed in the expression

_____ makes a copy of a table and places it in a different location to improve access time.

Business intelligence is a framework that allows a business to transform data into information,information into knowledge,and knowledge into wisdom.

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

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

The most distinctive characteristic of modern OLAP tools is their capacity for _____ analysis.

Master data management's main goal is to provide a partial and segmented definition of all data within an organization.

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

ROLAP and MOLAP vendors are working toward the integration of their respective solutions within a unified decision support framework.

Relational data warehouses use multidimensional data schema support to handle multidimensional data.

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

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

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

_____ 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 warehouse designer must define common business dimensions that will be used by a data analyst to narrow a search,group information,or describe attributes.

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