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 21

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 22

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

Business intelligence (BI) architecture is composed of data, people, processes, and technology working together to facilitate and enhance a business's management and governance.

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

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

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

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

What is data visualization? Name different techniques of data visualization.

_____ is a collection of concepts, techniques, and processes for the proper identification, definition, and management of data elements within an organization.

From a data analyst's point of view, decision support data differ from operational data in three main areas: time span, granularity, and _____.

The CUBE extension enables you to get a subtotal for each column listed in the expression, in addition to a grand total for the last column listed.

A _____ schema is a type of star schema in which dimension tables can have their own dimension tables.

A(n)_____ is a read-only database optimized for data analysis and query processing.

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

Advanced OLAP feature become more useful when access to them is kept simple.

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

A star schema is designed to optimize data query operations rather than data update operations.

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

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

Which type of data describes numeric facts or measuresthat can becan be counted, ordered, and aggregated?