Help! Transferring

Hi after high school I went to cc I wasn’t sure what I wanted to do so I didn’t take it seriously I’m graduating this semester with a 3.0, I applied to Stony brook(my dream school) and I didn’t get in so now I’m stuck going to SUNY old Westbury I heard it wasn’t the best plus it’s soo far from me. My question is would I be able to attend there for a year and get my GPA up and transfer to Stony brook to finish my bachelors? Would that be possible and a good idea? Thanks!