Database Management Systems (DBMS)
Data warehouse is best defined as which of the following?
- A. A set of techniques used in a DBMS to ensure correct results for concurrent transaction operations.
- B. A large, centralized repository of integrated data from multiple sources used for reporting and analysis. ✓
- C. A subset of SQL commands used to define and modify database structures, such as CREATE and ALTER.
- D. A DBMS component that determines the most efficient way to execute a given database query.
Correct answer
B. A large, centralized repository of integrated data from multiple sources used for reporting and analysis.
Explanation
Data warehouse refers to a large, centralized repository of integrated data from multiple sources used for reporting and analysis.