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

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Business intelligence

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

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

A) table-like
B) matrix-like
C) network-like
D) cube-like

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

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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

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

By default, the fact table's primary key is always formed by combining the superkeys pointing to the dimension tables to which they are related.

_____ extends SQL so that it can differentiate between access requirements for data warehouse data and operational data.

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

_____ functionality ranges from simple data gathering and transformation to very complex data analysis and presentation.

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

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

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

Bill Inmon and Chuck Kelley created a set of 12 rules to define a(n) _____.

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

In star schema representation, a fact table is related to each dimension table in a _____ relationship.

The reliance on _____ as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.

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

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

______ is a method or process of government.

What is the ROLLUP extension to the GROUP BY clause? Provide the syntax for this extension.

_____ tools focus on the strategic and tactical use of information.