You are running an SAP HANA database in log mode "normal". Under what circumstances does the database automatically execute a regular log backup? Note: There are 2 correct answers to this question.

Question

Options

• AWhen a commit occurs
• BWhen the log buffer is full
• CWhen the time threshold is exceeded
• DWhen the log segment is full

• A
  9% (6)
• B
  18% (12)
• C
  73% (48)

Explanation

In an SAP HANA database running in log mode "normal," regular log backups are automatically executed under specific circumstances. One such circumstance is when the log segment is full (D), necessitating a backup to free up space for new log entries. Additionally, a regular log backup is triggered when a predefined time threshold is exceeded (C), ensuring that log backups occur at regular intervals even if the log segment isn't full. This mechanism helps in maintaining a balance between performance and data safety, ensuring that log data is preserved for database recovery without overwhelming the system's storage with frequent backups.

No community discussion yet for this question.