That is correct but how it will do?

Say in our case TestTable if we update DeptID of any user then the actual data page of clustered index will be updated first (this is the only actual physical page), and question comes to Non-clustered will the Depid also update at the non-clustered leaf level?

That means two updates at page levels?

Thank you