Every time Joe's customers purchase an item,he stores the sale in a database.The best option for him is to use an analytical database.

Question

Quizplus · Accepted Answer

Analytical databases are optimized for data analysis and aggregation, typically used for reporting and data mining rather than transaction processing. For storing sales transactions, a transactional database (also known as an OLTP database) is more appropriate as it is designed to handle rapid transaction processing.

Every Time Joe's Customers Purchase an Item,he Stores the Sale