Rowing is ___ sport that demands enormous patience and a willingness to get up before dawn.

Explanation

The noun sport here puts rowing into a category, and a singular countable noun in that role takes a. The bare form belongs to the name of the activity itself, as in they go rowing every weekend, but not to the countable noun sport.