Query impact in compound key for sharding

[Guru_Prashanth_Thana (Guru)]

Can anyone help here? I don’t have access to a sharded cluster yet