When might a database designer elect to store derived data in a database?

Group of answer choices

When a repeating group, such as the number of insurance companies for a patient, are predictable and constant and the database designer decides it is important to de$-$normalize the database in order to improve performance.

When a transitive dependency is found.

When a calculation like a checking account balance must be done frequently and very quickly, such as when the data is accessed from an automatic teller machine.

When an aggregate value, such as a count of checks processed, is performed occasionally.

When a database is already consistently providing sub$-$second response time.