DAMA DMF-1220 Question Answer
The purpose for adding redundancy to a data model (denormalisation) is to:
Make it easier for developers to join tables
Avoid the loss of data by storing key values more than once
Improve aggregate database performance across read requests
Fully utilize all the indexes
Ensure surrogate keys are retaining their unique values in all satellite tables
TESTED 06 Jul 2025
Copyright © 2014-2025 ACE4Sure. All Rights Reserved