What will happen if I cannot make my appointment? Does it count as an attempt?

Yes, it counts as an attempt.  If you do not keep your appointment and you do not cancel or re-schedule it prior to the start date and time, then your appointment will be regarded as an attempt. The proctor will update the status of the appointment to "No Show" and this will be reflected in the Certification Hub under Exam Appointments | Previous Appointments.