1. Please anser the following questoins. Also, ple

Chapter 9:

Why do you think metadata is important in a data warehouse environment? Give a

general explanation in one or two paragraphs.

2. Explain how metadata is critical for data warehouse development and administration.

3. Examine the concept that metadata is like a nerve center. Describe how the concept

applies to the data warehouse environment.

4. List and describe three major reasons why metadata is vital for end-users.

5. Why is metadata essential for IT? List six processes in which metadata is significant for

IT and explain why.

6. Pick three processes in which metadata assists in the automation of these processes.

Show how metadata plays an active role in these processes.

7. What is meant by establishing the context of information? Briefly explain with an

example of how metadata establishes the context of information in a data warehouse.

8. List four metadata types used in each of the three areas of data acquisition, data storage, and information delivery.

9. List any ten examples of business metadata.

10. List four major requirements that metadata must satisfy. Describe each of these four

requirements.

EXERCISES

Indicate if true or false:

The importance of metadata is the same in a data warehouse as it is in an operational system.

Metadata is needed by IT for data warehouse administration.

Technical metadata is usually less structured than business metadata.

Maintaining metadata in a modern data warehouse is just for documentation.

220 THE SIGNIFICANT ROLE OF METADATA

Metadata provides information on predefined queries.

Business metadata comes from sources more varied than those for technical

metadata.

Technical metadata is shared between business users and IT staff.

A metadata repository is like a general purpose directory tool.

Metadata standards facilitate metadata interchange among tools.

Business metadata is only for business users; business metadata cannot be understood or used by IT staff.

As the project manager for the development of the data warehouse for a domestic soft drinks manufacturer, your assignment is to write a proposal for providing metadata. Consider the options and come up with what you think is needed and how you plan to implement a metadata strategy.

As the data warehouse administrator, describe all the types of metadata you would need for performing your job. Explain how these types would assist you.

You are responsible for training the data warehouse end-users. Write a short procedure for your casual end-users to use the business metadata and run queries. Describe the procedure in user terms without using the word metadata.

As the data acquisition specialist, what types of metadata can help you? Choose one of the data acquisition processes and explain the role of metadata in that process.

ase share all answers.