UPDATE t1
SET t1.Last_Exam_Date = t2.MaxDate
FROM T1 t1
INNER JOIN (SELECT Student_Id,MAX(Exam_Date) AS MaxDate
            FROM T2
            GROUP BY Student_id
           )t2
ON t2.Student_Id = t1.Student_Id