Exam 13: Business Intelligence and Data Warehouses

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

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

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

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

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

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

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

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

Describe the use of SQL in relation to ROLAP.

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

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.

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

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

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

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

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

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

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 star schema is designed to optimize data query operations rather than data update operations.