Most transactional databases are not set up to be simultaneously accessed for reporting and analysis. As a consequence:
A) navigational databases are being preferred over transactional databases.
B) data is not efficiently transformed into information.
C) firms prefer to outsource data mining operations to third-party firms.
D) analysts must also become transactional specialists.
E) most firms incur additional expenditure to effectively record transactions.

Question

Quizplus · Accepted Answer

Transactional databases are primarily designed for operations such as insert, update, and delete. These operations support the day-to-day transactions of an organization. When it comes to reporting and analysis, these databases may not be optimized for such tasks, leading to inefficiencies in transforming data into actionable information. This is because the structure and indexing of transactional databases are optimized for transactional integrity and speed, not for complex queries and analysis, which are typically required for reporting and transforming data into information.

Most Transactional Databases Are Not Set Up to Be Simultaneously