Posted by: Pdfprep
Post Date: November 6, 2020
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
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)
Leave a Reply