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 41

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

BI busines...

View Answer

Show Answer

Question 42

Short Answer

Review LaterAdd Note

Review Later

___________ is a method or process of government.

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

Business intelligence (BI)architecture is composed of data,people,processes,technology,and the management of such components.

________.means to decompose data into more atomic components or data at lower levels of aggregation.

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

The ROLLUP extension is used with the GROUP BY clause to generate aggregates by the listed columns,including the last one.

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

_____ are numeric measurements (values)that represent a specific business aspect or activity.

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

_____ 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 data to the end user in a variety of ways.

_____ is a measurement of the density of the data held in the data cube and is computed by dividing the total number of actual values in the cube by the total number of cells in the cube.

A data _____ is a centralized,consolidated database that integrates data derived from the entire organization and from multiple sources with diverse formats.

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

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.