Question

Which of the following is the most important system if a company wants to consolidate fan data from multiple sources, i.e., external, internal, current and historical.
A. data model
B. data warehouse
C. relational database fan management system
D. database management system

Answer 1

Answer:

Option B is the correct answer for the above question.

Explanation:

• The data warehouse is a collection of large data or a database that includes historical and operational or current data. This database can be used to make the decisions for the prospects of the organization.
• The above question asked about to select the database which can collect the historical and operational data from various source. That type of database is a data warehouse that is described above. Hence option B is correct while the other is not because:-

1. Option a states about data model which is used to define the database structure.
2. Option c states about the relational database which is used to collect only current data.
3. Option d states about the DBMS which is used to manage the relational database.