Which column should you identify?

You have a fact table in a data warehouse that stores financial data.

The table contains eight column configured as shown in the following table.

You need to identify a column that can be aggregated across all dimensions.

Which column should you identify?
A . OpeningPrice
B . StockID
C . NumberOfTrades
D . MarketID

View Answer

Answer: C

Explanation:

Aggregates are sometimes referred to as pre-calculated summary data, since aggregations are usually precomputed, partially summarized data, that are stored in new aggregated tables.

References: https://en.wikipedia.org/wiki/Aggregate_(data_warehouse)