Exercise throughout a person's life plays a significant role in reducing the risk of developing dementia, a study spanning 35 years has found.