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
Explanation:
You have 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.
answer D
why not value-based fragment?: two source tables have the same columns type but different name. The dimension-based fragment or automatic complex fragment add the complexity of fragment.