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

Multiple Choice

Review LaterAdd Note

Review Later

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

A) many-to-one (M:1)
B) many-to-many (M:M)
C) one-to many (1:M)
D) one-to-one (1:1)

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

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

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

A) transaction
B) database
C) table
D) concept

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

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

______ is a method or process of government.

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