CompTIA Security+ Exam Prep

Answer: D - Savepoints are used to make sure that if a system failure occurs, the database can attempt to return to a point before the system crashed. Savepoints are easy to implement within databases and applications, but a balance must be struck between too many and not enough savepoints. Having too many savepoints can degrade the performance, whereas not having enough savepoints runs the risk of losing data and decreasing user productivity because the lost data would have to be reentered.