OLAP stands for Online Analytical Processing. In every Business application, this technology is used. It helps in performing multidimensional analysis of business data and provides solutions for complex calculations and data modeling.

OLAP OLTP
OLAP consists of a software tool that is used in Data Analysis OLTP consists of tools that support Transaction Oriented Applications.
It is characterized by a large volume of data. It is characterized by a huge number of short transactions.
In this data, the warehouse is created uniquely OLTP uses a traditional database
Benefits would be the consistency of calculations. Handles all daily transactions of an organization.
Responds in seconds to minutes Response in milliseconds
BY Best Interview Question ON 10 Nov 2020