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…

The correct answer is D. Complex. 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 /…

Adding Multiple Logical Table Sources to a Logical Table

Question

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?

Options

AFact-based
BTime-based
CMixed
DComplex

How the community answered

(54 responses)

A
13% (7)
B
7% (4)
C
2% (1)
D
78% (42)

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

Topics

#partition#fragmentation#region table#data splitting

Community Discussion

No community discussion yet for this question.

Full 1Z0-591 Practice