How does the admissions process work for US Ph.D. programs, particularly for weak or borderline students?

When applying to a PhD program in the US, how does the admissions process work? If an applicant is weak in a particular area, is it possible to offset that by being strong in a different area?

Note that this question originated from this meta answer. Please feel free to edit the question to improve it.