Dimensional databases are used to track historical data,and therefore must have a ________.
A)time dimension
B)customer dimension
C)sales dimension
D)A or B
E)A and B

Question

Quizplus · Accepted Answer

Dimensional databases are designed to handle historical data, and it is necessary to have a time dimension to be able to track data over time. While a customer dimension could be useful in certain scenarios, it is not essential for tracking historical data in the same way that a time dimension is. Therefore, option A is the best choice for the required dimension in a dimensional database that tracks historical data.

Dimensional Databases Are Used to Track Historical Data,and Therefore Must