I also wanted to add that for Duplicate Geometry check, this will look for features that are within the database XY tolerance. If the redundant point features may be slightly offset from each other, you can use the Geometry on Geometry check and apply a tolerance.
Both Geometry on Geometry and Duplicate Geometry allows you to select which fields you want to compare to determine if it's has the same field values. You can also exclude metadata fields, like last edited date or last edited by, when comparing the fields.