Final answer:
The correct answer is that both OLTP and OLAP involve retrieval and presentation of data. OLTP is used for day-to-day transactional processing, while OLAP is used for data analysis and business intelligence. OLAP systems typically query and report on historical data and may use dimensional modeling, but OLTP systems do not require such modeling.
Step-by-step explanation:
The question pertains to the difference between Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP), which are concepts in the field of data processing and databases within Computers and Technology.
The correct answer is a. Both OLTP and OLAP involve retrieval and presentation of data. OLTP is designed to manage transaction-oriented applications and is used for data entry, data retrieval, and other day-to-day operations. In contrast, OLAP is used for complex analysis of data, often in a data warehouse, and involves querying and reporting for business intelligence purposes.
Options b, c, and d are not correct because OLAP systems are primarily read-only, focusing on querying and analyzing historic data rather than ongoing transactional changes such as deletion, modification, or insertion of data. Option e is incorrect because, although OLAP commonly uses dimensional modeling (such as star schema), OLTP systems do not require data to be dimensionally modeled; they often use normalized schemas suitable for operational transactions.