Hi Ken,
You can achieve this via two ways:
1) Dedup: You can also define these list of parameters for dedup and then select option for dedup method: 'using a list of values'.
2) Query Activity: Use Group by in Advanced parameters. Define aggregate condition for fields on which you want to find latest records.
Thanks,
Jyoti