Ace the HANA TEC Test 2026 – Unleash Your Analytical Superpowers!

Setting the retention policy for logs in SAP HANA specifies the duration for which logs are retained before they are eligible for deletion. This is crucial for database management as it directly affects how long historical transaction data is maintained, which can be important for auditing, compliance, and recovery purposes. By managing the retention period effectively, users can optimize storage utilization and ensure that they retain necessary logs for the required time frame without accumulating excessive data that may not be needed in the future.

While the other options touch on important aspects of logging and performance management, they do not accurately reflect the primary function of a retention policy. For example, log files need to be managed appropriately to ensure performance and efficiency, but the core effect of the retention policy is the explicit timeframe for log retention. Thus, acknowledging how long logs are kept is the main purpose of setting this policy in SAP HANA.