adplus-dvertising
frame-decoration

Question

What is one major difference between a data warehouse and an operational system like an order processing application?

a.

The type of data they store

b.

The way they process data

c.

The usage and information access

d.

The number of users

Answer: (c).The usage and information access Explanation:The major difference is in the usage and information access in a data warehouse compared to an operational system.

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. What is one major difference between a data warehouse and an operational system like an order processing application?

Similar Questions

Discover Related MCQs

Q. How do users typically retrieve information in an operational system like an order processing application?

Q. Why do data warehouse users need metadata?

Q. Why is metadata more critical in today's data warehouses compared to earlier data mart implementations?

Q. What does a data extraction and transformation expert need in order to perform tasks in building the data extraction and transformation component of the data warehouse?

Q. If you are the database administrator (DBA) for the data warehouse database, what information do you need to perform tasks related to physical design and loading?

Q. Why is metadata essential for building a data warehouse?

Q. Why is substantial metadata necessary for administering modern data warehouses?

Q. How is metadata described in the context of a data warehouse?

Q. Who are the two main groups of people that need individual parts of metadata in the data warehouse environment?

Q. Why does a business analyst need metadata when analyzing data from the data warehouse?

Q. What is the role of metadata for end-users of a data warehouse?

Q. How is the user of a data warehouse similar to a customer in an industrial warehouse?

Q. What role does metadata play in a data warehouse for end-users?

Q. In the context of a data warehouse, what does metadata help end-users do?

Q. Why is easily accessible metadata crucial for end-users of a data warehouse?

Q. In data warehouse development, metadata is crucial for which group primarily responsible for design and administration?

Q. What processes in data warehouse development require metadata for IT?

Q. What new role is metadata assuming in data warehousing?

Q. How does metadata enable the automation of warehousing tasks?

Q. What are the two main categories of tools used in a data warehouse environment?