Which option does not describe Aggregate tables?
A.
Aggregate tables increase query performance by pre-calculating frequently accessed measure
aggregations.
B.
Aggregate tables relieve bottlenecks and pre-calculate and store the data for better query
response.
C.
Aggregate tables typically have fewer rows than the non aggregate tables and, therefore,
processing should be quicker.
D.
Aggregate tables are created and stored on the BI Server.
C
I believe correct answer is C
It’s D:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/biee/r1013/aggpersist/aggpersist.htm
It is D!
C is true: “Aggregate tables should have fewer rows than the nonaggregate tables and, therefore, processing should be quicker.”
It is D!
A is True:”(…)This tutorial shows you how to use the Aggregate Persistence Wizard to create and model aggregate tables to increase query performance by precalculating frequently accessed measure aggregations.”
B is True: “Data warehouse performance bottlenecks are often due to measure aggregation (for example, summing orders at different levels of a dimensional hierarchy) that is being performed at run time. Having identified candidate aggregate tables for inclusion in your data warehouse, you use the Aggregate Persistence Wizard to create and model aggregates to relieve the bottleneck and precalculate and store the data for better query response.”
C is true: “Aggregate tables should have fewer rows than the nonaggregate tables and, therefore, processing should be quicker.”