C_DBADM Exam Questions: Free SAP System Tasks [2026]

Step-by-Step Execution:

1. In the SAP HANA Cloud Central instance Overview page, select Manage Configuration.
2. In the Additional Nodes section, select Add ECN.
3. Enter a name for the ECN, preferably using the acronym "ecn" in the name for easy identification in location lists.
4. In the Add Elastic Compute Node window, select a Performance Class for the new node.
5. Use the plus (+) and minus (-) symbols to modify the values for Memory and Storage for the ECN, then save to provision.
6. Navigate to the Workload Classes Management page and select Create (or edit an existing class).
7. Define the workload class properties and assign the newly created ECN in the Routing Location column.

Example Values:

• ECN Name: ecn_group1.
• Routing Location Hint: ecn_group1.

Expected Result: The ECN is successfully provisioned and starts with a "Running" status. Queries mapped to the specific workload class are now actively routed to the ECN rather than the coordinator node.

Quick Mistakes:

• Trying to assign a workload class to an ECN that has not finished provisioning.
• Deprovisioning an active ECN before removing its routing location hint from the workload class, causing routing failures.
• Attempting to reduce the ECN storage size after provisioning, as storage capacity can only be increased later, never reduced.

Exam Insight:

• Concept Tested: Cloud elasticity, dynamic resource management, and workload routing.
• Why it matters: Elastic scaling is a core value proposition of SAP HANA Cloud. The exam tests your ability to optimize Total Cost of Ownership (TCO) by using temporary capacity (ECNs) and workload classes to handle ad-hoc or recurring peak loads rather than purchasing permanently oversized hardware.

Step-by-Step Execution:

1. Start the SAP HANA Cloud Central application.
2. Select your database instance.
3. Open the °°° (More) menu and select the Manage Configuration application.
4. Locate the backup retention time setting.
5. Enter a new retention value between 1 and 215 days.
6. Save the configuration to apply the new backup retention time.

Example Values:

• Backup Retention Time: 30.

Expected Result: The database will now retain automatic backups for the newly specified number of days instead of the default 14 days, ensuring older backup generations remain available for a longer point-in-time recovery window.

Quick Mistakes:

• Entering a value higher than 215 days, which is the maximum allowed retention time.
• Assuming the change does not impact storage costs, as specifying a longer backup retention time increases required backup storage and affects costs.

Exam Insight:

• Concept Tested: Database backup configuration and retention management.
• Why it matters: In the SAP HANA Cloud exam, you must know what backup features are automated by SAP (like the 14-day default cycle) and what can be customized by the administrator, such as adjusting the retention time up to a maximum of 215 days for compliance reasons.

Step-by-Step Execution:

1. On the Overview page of the SAP HANA cockpit, choose the Alerts card.
2. Open the Alert Definitions application to view an overview of all the available SAP HANA alerts.
3. Use the Configure Email feature to specify the email sender, SMTP server, and SMTP port.
4. Enter the email addresses for the default recipients.
5. (Optional) To add a recipient specifically for an alert definition, select the alert and use the Edit button.

Example Values:

• Feature: Configure Email

Expected Result: After the email notification is set up, the SAP HANA database system sends notification emails to the default recipients whenever an alert occurs. If an alert is not issued the next time the checker runs, indicating the issue is resolved, a final email is sent.

Quick Mistakes:

1. Adding a recipient specifically for an alert definition, which causes the default recipients to no longer receive that specific alert.
2. Deactivating the alert checker entirely using the Edit Alert Definition button instead of configuring thresholds, which only stops notifications but does not solve the underlying problem.

Exam Insight:

1. This task tests your knowledge of the internal monitoring infrastructure and statistics service.
2. For the certification exam, remember that if checker-specific recipients are configured, default recipients are not notified, and if you delete all checker-specific recipients, default recipients will be notified again.

Resolution (Step-by-Step Fix):

1. Log in as a user administrator via SAP HANA Cockpit or SQL Console.
2. Grant the user the AUDIT OPERATOR, AUDIT READ, or AUDIT ADMIN system privilege.

Prevention Tip:

Segregate security duties by explicitly granting AUDIT READ only to designated security compliance personnel rather than standard administrators.

Resolution (Step-by-Step Fix):

• Contact the SAP BTP global account administrator to add the connectivity_proxy service plan to the connectivity service.
• Navigate to Subaccount -> Instances and Subscription -> Applications -> SAP HANA Cloud -> Migrations.

Prevention Tip: Validate all connectivity service entitlements and proxies before attempting hybrid (on-premises to cloud) migrations.