Prolonged tap water consumption and switching from untreated water to tap water were associated with a decreased risk of cognitive dysfunction in older individuals. Additionally, exercising and drinking tap water was synergistically associated with the low incidence of cognitive dysfunction. These findings demonstrate the importance of prioritizing drinking water health in rural areas, indicating that purified tap water can enhance cognitive function among older adults.