Question
What architectural benefit does partitioning a large fact table by date provide?
Select an option. Your answer will be checked instantly.
Correct Answer: C. Data can be managed and queried in smaller, independent segments
Explanation:
Date partitions support targeted loads, retention, maintenance, and pruning.
They make very large tables easier to operate and scale.
Leave a Reply