フリー問題

問題文

The hospital group's policy requires that patient records be irretrievable 7 years after discharge. Which sequence expresses the design correctly?

選択肢

1. Apply a row filter that hides records older than 7 years from all users.
2. Set the retention threshold to 7 years and run the file cleanup on a schedule, which automatically removes the records once they pass that age. No separate deletion of the rows is therefore required.
3. Delete the rows, run the reorganization with the purge form if deletion vectors are enabled, and let VACUUM remove the older files once the retention period has elapsed.
4. Delete the rows and run the reorganization with the purge form if deletion vectors are enabled, which immediately makes the records irretrievable.