PAS-C01 Operations and Maintenance Practice Question

Exhibit

Refer to the exhibit.

# hdbsql -U backupuser -d SYSTEMDB -j "SELECT * FROM M_BACKUP_CATALOG WHERE ENTRY_TYPE_NAME = 'complete data backup' ORDER BY UTC_END_TIME DESC"

BACKUP_ID | UTC_END_TIME          | STATE_NAME
123       | 2023-01-15 03:00:00   | successful
124       | 2023-01-16 03:00:00   | successful
125       | 2023-01-17 03:00:00   | failed
126       | 2023-01-18 03:00:00   | successful

Refer to the exhibit. An administrator has run a query to check the backup status of an SAP HANA database. The output shows that the backup on January 17 failed. What is the most appropriate next step?

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

Investigate the backup logs for the failed backup to identify the cause.

A failed backup requires investigation to determine the root cause before taking any corrective action. Checking the backup logs will provide details on why the backup failed, such as insufficient permissions, disk space issues, or configuration errors. Option A is incorrect because restoring the database is premature without diagnosing the failure. Option C is incorrect because restarting the backup without investigation may lead to the same failure. Option D is incorrect because ignoring the failure could allow a recurring issue to affect future backups.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
Restore the database from the last successful backup to ensure data integrity.
Why it's wrong here
Restoring is not needed; the failure is in the backup process, not data corruption.
✓
Investigate the backup logs for the failed backup to identify the cause.
Why this is correct
Understanding the root cause is essential before taking further action.
✗
Immediately restart the failed backup from the catalog.
Why it's wrong here
Restarting without investigation may not resolve the underlying issue.
✗
Ignore the failure because subsequent backups are successful.
Why it's wrong here
The failure could be a sign of a recurring problem.

Go deeper

PAS-C01 Operations and Maintenance Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question