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 31

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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

A) data store
B) ETL tools
C) data visualization tool
D) data analysis tool

E) C) and D)
F) None of the above

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

The ____________________ hierarchy provides the capability to perform drill-down and roll-up searches in a data warehouse.

What is one of the main characteristics of OLAP systems?

When you ____________________ data,you are aggregating the data to a higher level.

Describe the use of SQL in relation to ROLAP.

The BI architecture is composed of data,people,processes,technology,and the management of such components.

To tie a KPI to the strategic master plan of an organization,a KPI will be compared to a desired goal within a specific time frame.

____________________ online analytical processing provides OLAP functionality by using relational databases and familiar relational query tools to store and analyze multidimensional data.

Data warehouses usually have one fact table.

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

____ are in charge of presenting the data to the end user in a variety of ways.

From the data analyst's point of view,decision support data differ from operational data in three main areas: time span,granularity,and ____.

A ____ schema is a type of star schema in which the dimension tables can have their own dimension tables.

Periodicity,usually expressed as current year only,previous years,or all years,provides information about the time span of the data stored in the table.

Fact and dimension tables are related by ____ keys.

A characteristic of operational data is ____.

Multidimensional data analysis techniques include advanced computational functions.

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

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