BI and Data Warehousing

Question 1

The concept of a data warehouse is seen as a way to provide the following three things:

Answer 1

1. Reduce data redundancy
2. Improve the consistency of information
3. Enable an enterprise to use its data to make better decisions

Question 2

Planning, implementation, and control processes to provide decision support data and support knowledge workers engaged in reporting, query, and analysis is known as:

Answer 2

Data warehousing and business intelligence

Question 3

The primary driver for data warehousing is to support these three things:

Answer 3

1. Operational functions
2. Compliance requirements
3. BI activities

Question 4

The implementation of a Data Warehouse should follow these eight guiding principles:

Answer 4

1. Focus on business goals
2. Start with the end in mind
3. Think and design globally; act and build locally
4. Summarize and optimize last, not first
5. Promote transparency and self-service
6. Build metadata with the warehouse
7. Collaborate
8. One size does not fit all

Question 5

A data warehouse is a combination of two primary components:

Answer 5

1. An integrated decision support database
2. The related software programs used to collect, cleanse, transform, and store data from a variety of operational and external sources

Question 6

Unstructured data refers to data that is not predefined through a ______?

Answer 6

data model

Question 7

Bill Inmon approach - Inmon defines a data warehouse as a “_____ ______, integrated, time variant and non-volatile collection of data in support of managements decision making process”

Answer 7

subject oriented

Question 8

Kimball defines a warehouse as a “copy of ______ data specifically structured for query and analysis”

Answer 8

transaction

Question 9

Kimball’s approach calls for what type of model?

Answer 9

Dimensional

Question 10

In a data warehouse, data that needs correction is rejected, corrected at its source, and ideally ____?

Answer 10

re-fed through the system

Question 11

Often the content for the data dictionary comes directly from the ______ model.

Answer 11

logical

Question 12

Documented data lineage serves these three purposes:

Answer 12

1. Investigation of the root causes of data issues
2. Impact analysis for system changes or data issues
3. Ability to determine the reliability of data, based on its origin