Exam 13: Business Intelligence and Data Warehouses

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

Queries against operational data typically are broad in scope and high in complexity.

Relational data warehouses use multidimensional data schema support to handle multidimensional data.

The most distinctive characteristic of modern OLAP tools is their capacity for _____ analysis.

Explanatory analytics employs mathematical and statistical algorithms, neural networks, artificial intelligence, and other advanced modeling tools to create actionable predictive models based on available data.

A _____ is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.

A data store is used by data analysts to create queries that access the database.

tools focus on the strategic and tactical use of information.

Describe the use of SQL in relation to ROLAP.

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

Periodicity, usually expressed as current year only, previous years, or all years, provides information about the time span of the data stored in a table.

Operational data and decision support data serve the same purpose.

Multidimensional data analysis techniques include advanced computational functions.

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 is optimized for decision support and is generally represented by a data warehouse or a data mart.