According to "Exercise, brain, and cognition across the life span" which was cited in the original question, there are different effects that differ for various populations.
Developing Brains
There is no research on the effects resistance training in children. However, general exercise has significant benefits:
a meta-analysis that aggregated results across 44 studies found an
overall effect size of 0.32 for the association between childhood
physical activity and fitness and cognition, with significant effects
across a range of abilities, such as perceptual skills (0.49),
creativity and concentration (0.40), academic readiness (0.39) and
achievement (0.30), IQ (0.34), and math (0.20) and verbal (0.17) tests
Aerobic exercise has specifically been shown to increase the capabilities of relational memory and accuracy of cognitive performance.
Adult Brains
Since young brains are relatively stable, little research has been done on the effects of exercise on this population. All that has been determined behaviourly is:
aerobic fitness effects on behavior may only emerge in this
high-functioning group when the task is extremely difficult or that
young adults have a greater range of compensatory strategies compared
with children and older adults to achieve enhanced performance
Ageing Brains
Aerobic training has many positive effects on ageing across a broad range of intensities, however resistance training appears to only have benefits with higher resistance levels.