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 21

Multiple Choice

Review LaterAdd Note

Review Later

In business intelligence framework,data are captured from a production system and placed in the____ on a near real- time basis.

A) decision support system
B) portal
C) data warehouse
D) dashboard

E) A) and B)
F) None of the above

Correct Answer

verified

Show Answer

Question 22

Essay

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Key performance indi...

View Answer

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

Computed or derived facts,at run time,are sometimes called to differentiate them from stored facts.

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

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

Decision support data tend to be non-normalized,,and pre-aggregated.

What is the difference between decision support data and operational data from the point of view of data analyst?

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

Multidimensional data analysis techniques include advanced computational functions.

To provide better performance,some OLAP systems merge data warehouse and data mart approaches by storing small extracts of the data warehouse at end-user workstations.

A multidimensional database management systems (MDBMS) uses proprietary techniques to store data in n-dimensional arrays.

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

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.

Operational data are commonly stored in many tables,and the stored data represent information about a given only.

A(n)_____ is a read-only database optimized for data analysis and query processing.

The data warehouse development life cycle differs from classical systems development.

The schema must support complex (non-normalized) data representations.

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

What is data visualization? Name different techniques of data visualization.

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