HANA Database Administrator Practice Exam 2025 – Complete Test Prep

The main types of backup strategies in HANA include Full, Incremental, and Differential backups. Understanding these types is essential for effective database management and disaster recovery planning.

A Full backup encompasses the entire database at a specific point in time and serves as the foundational backup from which all other backup strategies derive. Incremental backups capture only the data changes made since the last backup, either full or incremental, thus saving space and time, while still allowing restoration to points in time by effectively stacking a series of backups. Differential backups, on the other hand, capture all changes made since the last full backup. This means that rather than continuously capturing changes from the last incremental backup, a differential backup will continue to grow in size until another full backup occurs, making it a balance between the storage use of incremental backups and the retrieval speed of a full backup.

The concept of combining these three types allows for flexibility in backup strategies, enabling efficient management of data while ensuring that recovery time and storage capacity remain optimized.

The other options suggesting transactional and snapshot backups do not correctly reflect the prescribed backup strategies used in HANA. Transactional backups are not defined as a primary strategy in this context, and although snapshot backups play a role in some systems for quick recovery, they are