How do colleges view a D in a class that will be unrelated to the major one is to choose?
A D on your transcript will depend upon which class you received the grade and which schools you are targeting to apply.
For highly selective/competitive colleges, a D will definitely impact your chances negatively.