Data in databases are constantly in use or undergoing changes.As a result,it is impossible to use them for complex decision making or problem solving tasks.Which of the following is an appropriate solution to this problem?
A)Set aside specific time windows each day for halting data changes or new inputs to the database so that decision making or problem solving applications can use the data.
B)Conduct decision making or problem solving tasks prior to transferring data to the database.
C)Use the database data anyway since the results are better than not conducting any decision or problem solving analysis at all.
D)Extract,transform and load database data into a data warehouse where it can be formatted for further analysis.

Question

Quizplus · Accepted Answer

Extracting, transforming, and loading data into a data warehouse is a common practice to make data suitable for analytical purposes. A data warehouse is designed to support complex decision-making and problem-solving tasks by offering a stable and consistent view of the data. Thus, it is the most appropriate solution in this scenario as it separates analytical processing from operational processing and allows for data to be used without interruption. Option A is not ideal as it may disrupt daily operations, and option B may not always be feasible or practical. Option C is not recommended as it may lead to erroneous or incomplete results.

Data in Databases Are Constantly in Use or Undergoing Changes