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

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

A) unique
B) duplicated
C) optimized
D) sorted

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

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

A) decomposition
B) de-normalization
C) normalization
D) aggregation

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

Correct Answer

verified

D

Question 3

Multiple Choice

Review LaterAdd Note

Data implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise.

Decision support data are a snapshot of the operational data at a given point in time.

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

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

Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a .

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

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

Which of the following is a personal analytics vendor for BI applications?

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

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

In multidimensional terms, the ability to focus on slices of the cube to perform a more detailed analysis is known as _____.

In the prognosis phase, the data-mining findings are used to predict future behavior and forecast business outcomes.

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

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

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

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

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.

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