The main difference between a database and data warehouse is that:
A)databases are designed and optimized to store data,whereas data warehouses are designed and optimized to respond to analysis questions that are critical for a business.
B)databases are designed and optimized to analyze data,whereas data warehouses are designed and optimized to store data for sharing.
C)databases are designed to detect trends in the data,whereas data warehouses are designed to support supply chains.
D)databases are designed to support traditional commerce,whereas data warehouses are designed to support e-commerce.

Question

Quizplus · Accepted Answer

Databases are more focused on storing and managing data while data warehouses are used for analyzing data to see patterns, trends, and insights for making better business decisions. Data warehouses are optimized for querying and data analysis rather than data transactions.

The Main Difference Between a Database and Data Warehouse Is