Home » Microsoft » 70-767 » 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
Correct Answer: C
Explanation/Reference:
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)