Aerobic exercise may be associated with changes in brain activity within the default mode network (DMN) and dorsal attention network (DAN). We hypothesized that changes in functional connectivity (FC) within the DMN and DAN might be most effectively activated by moderate-intensity exercise. Resting-state functional magnetic resonance imaging scans and visuospatial attention tests after resting were performed before and after each of moderate- and high-intensity aerobic exercises (10 min each) in 15 healthy male volunteers. The reaction time during the attention test increased significantly, and the rate of correct responses decreased from moderate-intensity exercise condition to high-intensity exercise condition. FC within the DMN under high-intensity exercise condition was higher than that under pre-exercise and moderate-intensity exercise conditions. FC within the DAN under moderate-intensity exercise condition was the highest, whereas FC between the DMN and DAN under moderate-intensity exercise condition was the lowest. Changes in cognitive domain functions were associated with changes in FC between the DMN and DAN. Our results support the inverted-U hypothesis of maximum arousal efficacy during moderate exercise. Both cognitive domains, namely, the attention system and brain activity domains, may be better under moderate-intensity exercise than under high-intensity exercise.