Exam 13: Business Intelligence and Data Warehouses

Business intelligence is a framework that allows a business to transform data into information, information into knowledge, and knowledge into wisdom.

(True/False)

4.9/5

(86)

Question 21

_____ are qualifying characteristics that provide additional perspectives to a given fact.

(Short Answer)

4.9/5

(72)

Question 22

The basic star schema has four components: facts, , attributes, and attribute hierarchies.

(Multiple Choice)

4.7/5

(81)

Question 23

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

(Multiple Choice)

4.8/5

(87)

Question 24

can serve as a test vehicle for companies exploring the potential benefits of data warehouses.

(Multiple Choice)

4.8/5

(77)

Question 25

functionality ranges from simple data gathering and transformation to very complex data analysis and presentation.

(Short Answer)

5.0/5

(93)

Question 26

In a star schema, attributes are often used to search, filter, or classify .

(Multiple Choice)

4.9/5

(81)

Question 27

OLAP systems are designed to use both operational and data _____ data.

(Short Answer)

4.7/5

(82)

Question 28

A data _____ is a small, single-subject data warehouse subset that provides decision support to a small group of people.

(Short Answer)

4.8/5

(86)

Question 29

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

(Multiple Choice)

4.9/5

(88)

Question 30

A data warehouse designer must define common business dimensions that will be used by a data analyst to narrow a search, group information, or describe attributes.

(True/False)

4.9/5

(90)

Question 31

In a typical star schema, each dimension record is related to thousands of records.

(Multiple Choice)

4.9/5

(82)

Question 32

The schema must support complex (non-normalized) data representations.

(Multiple Choice)

4.8/5

(72)

Question 33

Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS.

(True/False)

4.9/5

(76)

Question 34

An multidimensional database management systems (MDBMS) uses proprietary techniques to store data in ?n-dimensional arrays.

(Multiple Choice)

4.9/5

(84)

Question 35

_____ provide a unified, single point of entry for information distribution.

(Multiple Choice)

4.8/5

(83)

Question 36

A index is based on 0 and 1 bits to represent a given condition.

(Multiple Choice)

4.9/5

(70)

Question 37

ROLAP and MOLAP vendors are working toward the integration of their respective solutions within a unified decision support framework.

(True/False)

5.0/5

(93)

Question 38

Business intelligence tools use the data warehouse data as the raw materials for data analytics to generate business knowledge.

(True/False)

4.9/5

(91)

Question 39

The data warehouse development life cycle differs from classical systems development.

(True/False)

4.8/5

(84)

Question 40

Showing 21 - 40 of 75

Business intelligence is a framework that allows a business to transform data into information, information into knowledge, and knowledge into wisdom.

_____ are qualifying characteristics that provide additional perspectives to a given fact.

The basic star schema has four components: facts, , attributes, and attribute hierarchies.

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

can serve as a test vehicle for companies exploring the potential benefits of data warehouses.

functionality ranges from simple data gathering and transformation to very complex data analysis and presentation.

In a star schema, attributes are often used to search, filter, or classify .

OLAP systems are designed to use both operational and data _____ data.

A data _____ is a small, single-subject data warehouse subset that provides decision support to a small group of people.

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

A data warehouse designer must define common business dimensions that will be used by a data analyst to narrow a search, group information, or describe attributes.

In a typical star schema, each dimension record is related to thousands of records.

The schema must support complex (non-normalized) data representations.

Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS.

An multidimensional database management systems (MDBMS) uses proprietary techniques to store data in ?n-dimensional arrays.

_____ provide a unified, single point of entry for information distribution.

A index is based on 0 and 1 bits to represent a given condition.

ROLAP and MOLAP vendors are working toward the integration of their respective solutions within a unified decision support framework.

Business intelligence tools use the data warehouse data as the raw materials for data analytics to generate business knowledge.

The data warehouse development life cycle differs from classical systems development.

Database Systems

Data Models

The Relational Database Model

Entity Relationship Er Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language Sql

Advanced Sql

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Database Connectivity and Web Technologies

Database Administration and Security

Filters