adplus-dvertising
frame-decoration

Question

Why is metadata management in a data warehouse different from that in an operational system?

a.

Metadata in a data warehouse doesn't need to keep track of revisions.

b.

Metadata in a data warehouse only comes from a single source.

c.

Metadata in a data warehouse must capture metadata from a variety of sources and keep track of revisions.

d.

Metadata in a data warehouse only comes from data extraction and transformation tools.

Answer: (c).Metadata in a data warehouse must capture metadata from a variety of sources and keep track of revisions. Explanation:Metadata management in a data warehouse is different from that in an operational system because it must capture metadata from a variety of sources and keep track of revisions over time.

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Why is metadata management in a data warehouse different from that in an operational system?

Similar Questions

Discover Related MCQs

Q. What is a key challenge in metadata management for data warehouses?

Q. In metadata standardization, what is essential for tools that represent data structures?

Q. How must metadata revisions ripple throughout the data warehouse when changes occur?

Q. What is essential for metadata about data structures, data elements, events, and rules in a data warehouse?

Q. What must be possible for end-users while they use front-end tools for information access?

Q. What should metadata management provide to end-users in a data warehouse environment?

Q. Why is it important to establish a general list of metadata sources for a data warehouse?

Q. Which of the following is NOT a usual source of metadata in a data warehouse?

Q. Where can you find specifications for mapping data staging files to load images?

Q. Which source provides information about the list of query and report tools?

Q. What do COBOL copybooks, program specifications, and physical file layouts have in common in the context of data warehouse metadata?

Q. In which area of a data warehouse can you find data models for centralized data warehouses and dependent data marts?

Q. Where would you typically find criteria for merging into initial extract files on each platform?

Q. What is a major challenge in metadata management when using multiple software tools in a data warehouse?

Q. What is a challenge associated with version control of metadata in a data warehouse?

Q. What is a purpose of a metadata repository in a data warehouse?

Q. Which challenge involves dealing with conflicting standards, formats, and data naming conventions in a data warehouse with numerous source systems?

Q. How is a metadata repository in a data warehouse often divided to serve different purposes?

Q. What is the function of the information navigator in a metadata repository in a data warehouse?

Q. What is one of the functions of the information navigator in a metadata repository?