Exam 13: Business Intelligence and Data Warehouses

Computed or derived facts, at run time, are sometimes called to differentiate them from stored facts.

To provide better performance, some OLAP systems merge data warehouse and data mart approaches by storing small extracts of the data warehouse at end-user workstations.

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

To deliver efficient decision support, OLAP tools must have advanced data features.

To support a(n) _____ adequately, the DBMS might be required to support advanced storage technologies, and even more importantly, to support multiple-processor technologies, such as a symmetric multiprocessor (SMP) or a massively parallel processor (MPP).

In business intelligence framework, data are captured from a production system and placed in on a near real- time basis.

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

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

In the prognosis phase, the data-mining findings are used to predict future behavior and forecast business outcomes.

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

Operational data are commonly stored in many tables, and the stored data represent information about a given only.

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

_____ are quantifiable measurements (numeric or scale based) that assess a company's effectiveness or success in reaching its strategic and operational goals.

Bill Inmon and Chuck Kelley created a set of 12 rules to define a(n) .

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

What is the ROLLUP extension to the GROUP BY clause? Provide the syntax for this extension.

Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a .

Decision support data tend to be non-normalized, , and pre-aggregated.

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

In star schema representation, a fact table is related to each dimension table in a relationship.