A company’s Database Administrator has divided the region table into two tables so that the
region “West” is in one table and all the other regions are in another single table. What kind
of partition is being used?
A.
Fact-based
B.
Time-based
C.
Mixed
D.
Complex
D.
C Mixed
there are three sort of fragmentation:
Fact-based / Dimension-based fragmentation
Content-based / Value-based fragmentation
Level-based fragmentation / aggregate navigation
You can combine the techniques above to construct powerful design that are known as Complex partitioning / fragmentation. When you fragment a dimension, you are automatically in a complex fragmentation.
D), dimension fragmentation + value base fragmentation , thus is D)
http://ssssupport.blogspot.ca/2012/10/obiee-10g-and-11g-fragmentation-in-obiee_19.html