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

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

Correct Answer

verified

Show Answer

Question 42

Essay

Review LaterAdd Note

Review Later

Describe the use of SQL in relation to ROLAP.

Correct Answer

verified

Most decision support data requests requ...

View Answer

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

A is optimized for decision support and is generally represented by a data warehouse or a data mart.

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.

tools focus on the strategic and tactical use of information.

Multidimensional data analysis techniques include advanced computational functions.

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

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

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

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.

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.

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

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

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