SAP Certified Associate Changed C_DBADM_2404 Questions

To stop the SAP HANA database system using the SAP HANA cockpit, you need credentials associated with:

• sap: This OS level user has the necessary permissions to stop and start the SAP HANA system.
• Root: Root user access is typically required for administrative actions at the operating system level.
• adm: This is the SAP system administration user who has the necessary privileges to manage the SAP HANA instance.

References=The use of these user credentials in stopping the SAP HANA system is standard practice, as outlined in SAP HANA technical operation manuals and security guides.

Database Administration

In SAP HANA Cloud, native storage extension utilizes dynamic tiering. This approach integrates dynamic tiering by extending in-memory tables with disk-based storage, allowing data to be managed across different storage tiers. Dynamic tiering is particularly effective for managing large volumes of data where not all data needs to reside in memory, thus balancing performance with cost efficiency.References= SAP HANA Cloud documentation on storage and data management, which explains the functionality and benefits of using dynamic tiering within the database system.

SAP HANA Architecture

In the SAP HANA cockpit, from the SYSTEMDB Manage Services app, you can stop the following services:

• Web dispatcher: Manages HTTP traffic to SAP HANA, and stopping this service affects access via web-based applications.
• Compile server: Supports the compilation of SQLScript functions and stored procedures, and can be managed directly from the SYSTEMDB.

References=Details on managing SAP HANA services through the SAP HANA cockpit are provided in SAP HANA administration guides and official documentation.

Database Administration

When renaming a tenant database in the SAP HANA cockpit, the following occurs:

• The tenant database is stopped: Renaming requires that the database be stopped to change its identifier and update related metadata.
• The tenant database is unloaded from memory: To apply the new name and ensure all configurations and metadata are updated, the database must be unloaded from memory.

References=This process is detailed in the SAP HANA administration guide, which outlines the steps and implications of database renaming, including the requirement to stop and unload the database.

Database Administration