C_DBADM_2404 Exam Dumps : SAP Certified Associate - Database Administrator - SAP HANA

Holding the object privilege "ALL PRIVILEGES" in SAP HANA provides a user with the ability to perform all available actions on specified database objects. Specifically:

• Functions: Users can create, execute, alter, and drop functions within the database, allowing for complex operations and calculations to be encapsulated within callable routines.
• Procedures: These are sets of SQL statements grouped into logical units and stored in the database. With "ALL PRIVILEGES", a user can create, execute, modify, and delete stored procedures.

References=This information aligns with SAP HANA security model guidelines which discuss object privileges and their impact on database objects such as functions and procedures.

User Management

To prevent changes to system properties in tenant databases within SAP HANA, you would use theglobal.inifile. This file is used to configure system-wide settings across the entire SAP HANA instance, including tenant databases.global.inihandles the global configuration parameters that affect all databases on the instance, making it the appropriate choice for enforcing settings that block or restrict modifications to system properties.

References=This approach is consistent with SAP HANA administration documentation that specifiesglobal.inias the key file for managing global configuration settings.

Database Administration

Savepoints in SAP HANA are triggered by:B. By issuing a transactional commit, which initiates a savepoint to ensure that all committed transactions are durably written to the disk.C. By a database soft shutdown, during which SAP HANA ensures that all changes are safely written to the disk in the form of a final savepoint to prevent any data loss.Savepoints are not directly triggered by performing a delta merge or a database backup; these processes may coincide with savepoints for consistency but do not inherently cause them.References= SAP HANA administration guide detailing how transactional data management is handled, including the automatic triggering of savepoints at specific operations like shutdowns and commits.

SAP HANA Architecture