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

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

A) True
B) False

Correct Answer

verified

False

Question 2

True/False

Review LaterAdd Note

Review Later

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.

A) True
B) False

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

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.

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

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

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

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

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

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

Describe the use of SQL in relation to ROLAP.

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

________ 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.

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

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

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

Operational data and decision support data serve the same purpose.

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

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