Exam 13: Business Intelligence and Data Warehouses

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

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

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

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

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

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

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

___________ is a method or process of government.

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

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

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

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.

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

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

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