SAP HANA Certification Exam Prep Test

Reviewed by Godwin Iheuwa
Godwin Iheuwa, MS (Computer Science) |
Database Administrator
Review Board Member
Godwin Iheuwa, a Database Administrator at MTN Nigeria, holds an MS in Computer Science, specializing in Agile Methodologies and Database Administration from the University of Bedfordshire and a Bachelor's in Computer Science from the University of Port Harcourt. His proficiency in SQL Server Integration Services (SSIS) and SQL Server Management Studio contributes to his expertise in database management.
 , MS (Computer Science)
By Themes
T
Themes
Community Contributor
Quizzes Created: 424 | Total Attempts: 1,019,578
| Attempts: 4,519
SettingsSettings
Please wait...
  • 1/80 Questions

    What is the additional disk space factor required during delta merge operations

    • 4.0
    • 1.2
    • 3.0
    • 1.6
Please wait...
About This Quiz

This SAP HANA Certification Exam Prep Test assesses proficiency in managing and troubleshooting SAP HANA systems. It covers tools for system investigation, user privileges, scale-out systems, log backup procedures, and secure communication features, essential for technical roles involving SAP HANA.

SAP HANA Certification Exam Prep Test - Quiz

Quiz Preview

  • 2. 

    Where are the R3load processes located when performing the Database Migration Option (DMO) procedure using the in-place migration?

    • On the Primary Application Server (PAS) host 

    • On the remote target database host 

    • On the Additional Application Server (AAS) host 

    • On the source and target host

    Correct Answer
    A. On the Primary Application Server (PAS) host 
    Explanation
    During the Database Migration Option (DMO) procedure using the in-place migration, the R3load processes are located on the Primary Application Server (PAS) host. This means that the R3load processes responsible for migrating the database are running on the PAS host, where the primary application server is located.

    Rate this question:

  • 3. 

    Which SAP HANA database system usage types are automatically assigned to tiles in the SAP HANA cockpit? Note:There are 3 correct answers to this question. 

    • Sandbox 

    • Test 

    •  Development 

    • Production 

    Correct Answer(s)
    A. Test 
    A.  Development 
    A. Production 
    Explanation
    The SAP HANA cockpit automatically assigns the Test, Development, and Production usage types to tiles in the system. These usage types represent different environments in which the SAP HANA database system can be used. The Test environment is used for testing purposes, the Development environment is used for developing and modifying applications, and the Production environment is used for running live applications.

    Rate this question:

  • 4. 

    Which system schema provides performance data and system alerts details to review in SAP HANA MiniChecks ? 

    • _SYS_TELEMETRY 

    •  _SYS_WORKLOAD_REPLAY

    • _SYS_SQL_ANALYZER

    • _SYS_STATISTICS 

    Correct Answer
    A. _SYS_STATISTICS 
    Explanation
    The system schema _SYS_STATISTICS provides performance data and system alerts details that can be reviewed in SAP HANA MiniChecks.

    Rate this question:

  • 5. 

    You are checking and monitoring SAP HANA system replication.Which status indicates a temporary connection loss of the secondary system? 

    • Unknown 

    • Syncing 

    • Error 

    • Initializing 

    Correct Answer
    A. Syncing 
    Explanation
    The status "Syncing" indicates a temporary connection loss of the secondary system. This means that the secondary system is currently catching up with the changes made on the primary system and is in the process of synchronizing the data. Once the synchronization is complete, the status will change to "Synced" indicating that the secondary system is fully up to date with the primary system.

    Rate this question:

  • 6. 

    What is a prerequisite when you install the SAP Landscape Management tool? 

    • SAP NetWeaver Application Server Java 

    • SAP HANA XS Advanced 

    • SAP NetWeaver Application Server ABAP 

    • SAP Fiorilaunchpad 

    Correct Answer
    A. SAP NetWeaver Application Server Java 
    Explanation
    The prerequisite when installing the SAP Landscape Management tool is the SAP NetWeaver Application Server Java. This means that before installing the tool, the user must ensure that the SAP NetWeaver Application Server Java is already installed on their system.

    Rate this question:

  • 7. 

    During the delta merge process, to which memory areas is data inserted? Note:There are 2 correct answers to this question.

    • Main 2

    • Main 1

    • Delta 1 

    • Delta 2

    Correct Answer(s)
    A. Main 2
    A. Delta 2
    Explanation
    During the delta merge process, data is inserted into both Main 2 and Delta 2 memory areas. The delta merge process involves merging the changes made in the delta memory areas (Delta 1 and Delta 2) into the main memory areas (Main 1 and Main 2). Therefore, data is inserted into both the current main memory area (Main 2) and the delta memory area that contains the latest changes (Delta 2).

    Rate this question:

  • 8. 

    Which connections do you need to enable explicitly for a Restricted User? Note:There are 2 correct answers to this question. 

    • ODBC 

    • OLEDB 

    • ADO.NET 

    • JDBC

    Correct Answer(s)
    A. ODBC 
    A. JDBC
    Explanation
    Restricted users typically have limited access to resources and privileges on a system. In order to enable these users to connect to databases, explicit permissions need to be granted. ODBC (Open Database Connectivity) and JDBC (Java Database Connectivity) are both connection technologies that allow applications to connect to databases. By enabling ODBC and JDBC connections explicitly, restricted users will have the necessary access to connect to and interact with databases. Therefore, ODBC and JDBC are the correct answers for this question.

    Rate this question:

  • 9. 

     In which scenario do you need SAP expert sizing? Note:There are 2 correct answers to this question. 

    • Customers want to migrate their existing SAP NetWeaver-based systems to run on SAP HANA 

    • Consolidating multiple ERP source systems into one ERP system on SAP HANA 

    • Carving out ERP functionality from the source system to the ERP on SAP HANA system. 

    • Customers are new to SAP applications and SAP HAN

    Correct Answer(s)
    A. Consolidating multiple ERP source systems into one ERP system on SAP HANA 
    A. Carving out ERP functionality from the source system to the ERP on SAP HANA system. 
    Explanation
    SAP expert sizing is needed in scenarios where customers want to consolidate multiple ERP source systems into one ERP system on SAP HANA, as well as when they want to carve out ERP functionality from the source system to the ERP on SAP HANA system. This process requires expert sizing to determine the appropriate hardware and infrastructure requirements for the migration and consolidation.

    Rate this question:

  • 10. 

    Which preparation tasks do you need to perform before starting the Database Migration Option (DMO) procedure? Note:There are 2 correct answers to this question.

    • Move the latest R3trans update archive into the download folder.

    • Check if the latest SPAM/SAINT update is applied. 

    • Extract the SAP HANA database software installation archive. 

    • Update the SAP Host Agent to the latest version 

    Correct Answer(s)
    A. Check if the latest SPAM/SAINT update is applied. 
    A. Update the SAP Host Agent to the latest version 
    Explanation
    Before starting the Database Migration Option (DMO) procedure, two preparation tasks that need to be performed are checking if the latest SPAM/SAINT update is applied and updating the SAP Host Agent to the latest version. These tasks ensure that the system is up to date and compatible with the migration process.

    Rate this question:

  • 11. 

    In an SAP HANA database system running in log mode "normal", in which situation does the system automatically execute a regular log backup? Note: There are 2 correct answers to this question. 

    • When the time threshold is exceeded. 

    • When a commit occurs. 

    • When the log segment is full. 

    • When the log buffer is full. 

    Correct Answer(s)
    A. When the time threshold is exceeded. 
    A. When the log segment is full. 
    Explanation
    The SAP HANA database system running in log mode "normal" automatically executes a regular log backup when the time threshold is exceeded. This means that after a certain amount of time has passed since the last log backup, the system will initiate a new backup to ensure data consistency and recovery options. Additionally, the system also triggers a regular log backup when the log segment is full. This occurs when the current segment used to store transaction logs reaches its maximum capacity, prompting the system to create a new segment and backup the filled segment to free up space for new logs.

    Rate this question:

  • 12. 

    What can you directly assign to a user with the Manage Users app in SAP HANA cockpit? Note:There are 2 correct answers to this question.

    • Scopes 

    • Privileges 

    • Role collections

    • Roles 

    Correct Answer(s)
    A. Privileges 
    A. Roles 
    Explanation
    In the Manage Users app in SAP HANA cockpit, you can directly assign privileges and roles to a user. Privileges are specific authorizations that determine what actions a user can perform, while roles are a collection of privileges and authorizations grouped together for easier management. By assigning privileges and roles, you can control the access and permissions of a user within the SAP HANA system.

    Rate this question:

  • 13. 

    How can you perform a complete back up of an SAP HANA database system? 

    • Backup the complete storage system.

    • Back up the system database and all tenant databases individually

    • Back up the system database and all tenant databases in one step. 

    • Back up the complete database system. 

    Correct Answer
    A. Back up the system database and all tenant databases individually
    Explanation
    To perform a complete backup of an SAP HANA database system, it is necessary to back up the system database and all tenant databases individually. This means that each database within the system needs to be backed up separately to ensure that all data is properly preserved. Backing up the complete storage system or the complete database system may not be sufficient as it may not capture all the necessary data from each individual database. Therefore, the correct approach is to perform individual backups for each database within the system.

    Rate this question:

  • 14. 

    Which user credentials are requested during the initial run of the configuration phase when performing the Database Migration Option (DMO) procedure to an SAP HANA 2.0 database tenant? Note:There are 3 correct answers to this question.

    • The DBACOCKPIT user of the tenant database 

    • The SYSTEM user of the system database

    • The SAP• user in client 000 of the ABAP system

    • The S-user for the SAP Support Portal connection 

    • The DDIC user in client 000 of the A BAP system 

    Correct Answer(s)
    A. The DBACOCKPIT user of the tenant database 
    A. The SYSTEM user of the system database
    A. The DDIC user in client 000 of the A BAP system 
    Explanation
    During the initial run of the configuration phase when performing the Database Migration Option (DMO) procedure to an SAP HANA 2.0 database tenant, the following user credentials are requested:

    1. The DBACOCKPIT user of the tenant database is required to access and configure the specific tenant database.
    2. The SYSTEM user of the system database is needed to perform administrative tasks and manage the overall system.
    3. The DDIC user in client 000 of the ABAP system is necessary for executing the migration process and accessing the ABAP system.

    These user credentials are essential for ensuring a smooth and successful migration to the SAP HANA 2.0 database tenant.

    Rate this question:

  • 15. 

    Which technology does the SAP DBA Cockpit use to store the performance indicators?

    • SAP Adaptive Server Enterprise 

    • SAP Intelligent Query

    • SAP Analytics Cloud 

    • SAP Business Intelligence

    Correct Answer
    A. SAP Business Intelligence
    Explanation
    The SAP DBA Cockpit uses SAP Business Intelligence to store the performance indicators. SAP Business Intelligence is a technology that provides a comprehensive platform for data analysis, reporting, and visualization. It allows users to gather, analyze, and interpret business data, including performance indicators, to make informed decisions and monitor the performance of SAP systems.

    Rate this question:

  • 16. 

    What additional action do you need to perform after you created a new tenant in an SAP HANA system replication configuration? 

    • Restart secondary system. 

    • Copy tenant database. 

    • Start tenant database. 

    • Back up tenant database 

    Correct Answer
    A. Back up tenant database 
    Explanation
    After creating a new tenant in an SAP HANA system replication configuration, it is necessary to perform the additional action of backing up the tenant database. This is important to ensure the data integrity and availability of the newly created tenant. By backing up the tenant database, any potential data loss or system failure can be mitigated, allowing for easy recovery and restoration of the tenant's data if needed.

    Rate this question:

  • 17. 

    What is the correct sequence of the following four steps in the restart of the SAP HANA database system? 

    • 1. Aborted transactions are rolled back. 2. Open transactions are recovered. 3. Row tables are loaded into memory. 4. Column tables are loaded.

    • 1. Row tables are loaded into memory. 2. Open transactions are recovered. 3. Aborted transactions are rolled back. 4. Column tables are loaded. 

    • 1. Row tables are loaded into memory. 2. Column tables are loaded. 3. Open transactions are recovered. 4. Aborted transactions are rolled back.

    • 1. Aborted transactions are rolled back. 2. Row tables are loaded into memory. 3. Open transactions are recovered. 4. Column tables are loaded. 

    Correct Answer
    A. 1. Row tables are loaded into memory. 2. Open transactions are recovered. 3. Aborted transactions are rolled back. 4. Column tables are loaded. 
    Explanation
    The correct sequence for the restart of the SAP HANA database system is as follows: first, row tables are loaded into memory. Then, open transactions are recovered. After that, aborted transactions are rolled back. Finally, column tables are loaded. This sequence ensures that the necessary data is loaded into memory and any incomplete or failed transactions are properly handled before loading the column tables.

    Rate this question:

  • 18. 

    Your customer has purchased a 1.5 TB SAP HANA license. To which value do you set the GLOBAL_ALLOCATION_LIMIT parameter when you have four 1TB nodes in an SAP HANA scale-out system with three worker and one standby nodes?

    • 1.0 TB 

    • 1.5 TB 

    • 375 GB 

    • 512 GB

    Correct Answer
    A. 512 GB
    Explanation
    In a SAP HANA scale-out system, the GLOBAL_ALLOCATION_LIMIT parameter determines the maximum amount of memory that can be allocated by a single node. Since there are four 1TB nodes in the system, the total available memory is 4TB. However, since the customer has purchased a 1.5TB license, the maximum memory that can be allocated is limited to the license size. Therefore, the GLOBAL_ALLOCATION_LIMIT parameter should be set to 512 GB, which is the closest value to the license size.

    Rate this question:

  • 19. 

    Which replication modes keep the primary system waiting until a timeout is exceeded when the secondary system is not available? Note:There are 2 correct answers to this question. 

    • ASYNC 

    • SYNC 

    • SYNCMEM 

    • FULL SYNC

    Correct Answer(s)
    A. SYNC 
    A. SYNCMEM 
    Explanation
    SYNC and SYNCMEM replication modes keep the primary system waiting until a timeout is exceeded when the secondary system is not available. These replication modes ensure that the primary system does not proceed with any further operations until it receives confirmation from the secondary system. This helps maintain data consistency and integrity between the primary and secondary systems.

    Rate this question:

  • 20. 

    Which system privilege must you have to manage black listed parameters in SAP HANA cockpit?

    • RESOURCEADMIN

    •  INIFILE ADMIN 

    • WORKLOAD ADMIN 

    • DATABASE ADMIN

    Correct Answer
    A.  INIFILE ADMIN 
    Explanation
    The correct answer is "INIFILE ADMIN". This privilege is required to manage blacklisted parameters in SAP HANA cockpit. The INIFILE ADMIN privilege allows the user to modify and manage the INI files, which are used to configure various settings and parameters in SAP HANA. By having this privilege, the user can effectively manage and control the blacklisted parameters in the system.

    Rate this question:

  • 21. 

    What are the merge methods that are triggered by the SAP HANA system processes? Note:There are 2 correct answers to this question. 

    • Smart 

    • AUTO

    • HARD

    • CRITICAL

    Correct Answer(s)
    A. AUTO
    A. CRITICAL
    Explanation
    The SAP HANA system processes trigger two merge methods: AUTO and CRITICAL. The AUTO merge method is automatically triggered by the system to merge delta storage with main storage when certain conditions are met. On the other hand, the CRITICAL merge method is triggered when the system detects that the delta storage is reaching its maximum capacity and needs to be merged with the main storage immediately to prevent data loss or performance issues.

    Rate this question:

  • 22. 

    Who owns an SAP HANA Deployment Infrastructure (HDI) role

    • The _SYS_REPO technical user

    • The user who created the role

    • The SYSTEM user of the tenant database 

    • The container-specific technical user 

    Correct Answer
    A. The container-specific technical user 
    Explanation
    The container-specific technical user owns an SAP HANA Deployment Infrastructure (HDI) role.

    Rate this question:

  • 23. 

    Which SAP HANA trace must you activate to analyze performance issues with systems where third-party software cannot be installed?

    • SQL

    • User-Specific

    • Kernel profiler

    • End-to-End

    Correct Answer
    A. Kernel profiler
    Explanation
    The Kernel profiler trace must be activated to analyze performance issues with systems where third-party software cannot be installed. This trace allows for monitoring and analyzing the performance of the SAP HANA kernel, which is the core component of the SAP HANA system. By enabling the Kernel profiler trace, administrators can gather detailed information about the system's performance, including CPU usage, memory usage, and database access times, which can help identify and resolve performance issues.

    Rate this question:

  • 24. 

    Which SAP HANA database service can you stop from the system database? Note:There are 2 correct answers to this question.

    • Index server

    • Compile server

    • Preprocessor

    • XS Engine

    Correct Answer(s)
    A. Compile server
    A. Preprocessor
    Explanation
    The Compile server and Preprocessor are the two SAP HANA database services that can be stopped from the system database. Stopping these services can help in optimizing the performance of the system and managing the resources effectively. By stopping the Compile server, the system can be relieved from the task of compiling SQLScript procedures and functions. Similarly, stopping the Preprocessor can help in reducing the load on the system by disabling the preprocessing of SQLScript code.

    Rate this question:

  • 25. 

    Which table provides a customizing interface that can be used for the dynamic management of partitions and locations?

    • EFFECTIVE_TABLE_PLACEMENT

    • B. UPDATE_LANDSCAPE_CONFIGURAT ION

    • TABLE_PLACEMENT

    • TABLE_GROUP

    Correct Answer
    A. TABLE_PLACEMENT
    Explanation
    The table that provides a customizing interface for the dynamic management of partitions and locations is TABLE_PLACEMENT. This table allows for the customization and management of how data is partitioned and stored in different locations within a database. It provides a flexible and dynamic approach to managing data placement, allowing for efficient storage and retrieval of data based on specific requirements and criteria.

    Rate this question:

  • 26. 

    Which file system locations are suggested to install an SAP HANA multi -host system? Note:There are 2 correct answers to this question.

    •  /hana/< sid> 

    •  /hana/< hostname> 

    • Hana/log/< sid> 

    •  /hana/shared 

    Correct Answer(s)
    A. Hana/log/< sid> 
    A.  /hana/shared 
    Explanation
    The correct answers for installing an SAP HANA multi-host system are "/hana/log/" and "/hana/shared". These file system locations are suggested because "/hana/log/" is used for storing log files specific to each SAP HANA system, and "/hana/shared" is used for storing shared data and configuration files that are common to all SAP HANA systems in the multi-host setup.

    Rate this question:

  • 27. 

    How are savepoints triggered?  Note:There are 2 correct answers to this question

    • By a database soft shutdown

    • By performing a database backup

    • By performing a delta merge

    • By issuing a transactional commit 

    Correct Answer(s)
    A. By a database soft shutdown
    A. By performing a database backup
    Explanation
    Savepoints are triggered by a database soft shutdown and by performing a database backup. A savepoint is a point in a transaction where you can roll back to if necessary. When a database undergoes a soft shutdown or a backup is performed, it triggers a savepoint to ensure that the transaction can be rolled back to a specific point in case of any issues or errors.

    Rate this question:

  • 28. 

    Which system privilege must you have to redistribute tables across the hosts in your scale- out system?

    • DATA ADMIN 

    • WORKLOAD ADMIN 

    • OPTIMIZER ADMIN 

    • RESOURCE ADMIN

    Correct Answer
    A. RESOURCE ADMIN
    Explanation
    To redistribute tables across the hosts in a scale-out system, you need the RESOURCE ADMIN system privilege. This privilege allows you to manage system resources, including redistributing tables to balance the workload and optimize performance. The RESOURCE ADMIN privilege gives you the authority to make changes and adjustments to the system's resource allocation, ensuring efficient distribution of tables across the hosts in the scale-out system.

    Rate this question:

  • 29. 

    Which tasks can you perform using the SAP HANA database lifecycle manager (HDBLCM) on installation media? Note:There are 2 correct answers to this question

    • Update SAP HANA and its components.

    • Rename the SAP HANA database system.

    • Uninstall SAP HA NA database components.

    • Extract components.

    Correct Answer(s)
    A. Update SAP HANA and its components.
    A. Extract components.
    Explanation
    The SAP HANA database lifecycle manager (HDBLCM) on installation media allows you to update SAP HANA and its components, as well as extract components. This means that you can use HDBLCM to apply updates and patches to the SAP HANA database system, ensuring that it remains up to date with the latest features and bug fixes. Additionally, you can extract components from the installation media, which can be useful for various purposes such as troubleshooting or creating backups.

    Rate this question:

  • 30. 

    Which prerequisites must you consider to add hosts to an SAP HANA scale-out system? Note:There are 2 correct answers to this question. 

    • The SAP HANA system installation should be on a shared file system. 

    • The SAP HANA database server is shut down. 

    • The host has access to the installation directories. 

    • The additional host is placed in a different data center 

    Correct Answer(s)
    A. The SAP HANA system installation should be on a shared file system. 
    A. The host has access to the installation directories. 
    Explanation
    To add hosts to an SAP HANA scale-out system, two prerequisites must be considered. Firstly, the SAP HANA system installation should be on a shared file system. This ensures that all hosts in the system have access to the necessary installation files and can operate seamlessly. Secondly, the host being added must have access to the installation directories. This ensures that the new host can retrieve the required files and configurations to join the scale-out system successfully. The other two options, shutting down the SAP HANA database server and placing the additional host in a different data center, are not prerequisites for adding hosts to the system.

    Rate this question:

  • 31. 

    What is the correct minimum requirement for log volume and/hana/shared/ file system for an SAP HANA database system? 

    • For 512 GB system, Log volume = 512 GB,/hana/shared/ = 256 GB 

    • For 2 TB system, Log volume = 1 TB,/hana/shared/ = 1TB

    • For 1 TB system, Log volume = 1 TB,/hana/shared/ = 1TB

    •  For 256 GB system, Log volume = 128 GB,/hana/shared/ = 256 GB 

    Correct Answer
    A.  For 256 GB system, Log volume = 128 GB,/hana/shared/ = 256 GB 
    Explanation
    The correct minimum requirement for the log volume and /hana/shared/ file system for an SAP HANA database system is as follows: For a 256 GB system, the log volume should be 128 GB and the /hana/shared/ file system should be 256 GB. This means that for every 256 GB system, the log volume should be half the size at 128 GB, while the /hana/shared/ file system should remain the same at 256 GB.

    Rate this question:

  • 32. 

    Which prerequisites are necessary for productively using SAP HANA cockpit 2.0? Note:There are 2 correct answers to this question

    • An Intel-based system with operating system Microsoft Windows

    • An IBM Power System with operating system SUSE Linux Enterprise Server (SLES) 

    • 16 GB RAM on a dedicated server 

    • 10 GBit/s network bandwidth 

    Correct Answer(s)
    A. An IBM Power System with operating system SUSE Linux Enterprise Server (SLES) 
    A. 16 GB RAM on a dedicated server 
    Explanation
    The prerequisites necessary for productively using SAP HANA cockpit 2.0 are an IBM Power System with operating system SUSE Linux Enterprise Server (SLES) and 16 GB RAM on a dedicated server. These requirements indicate that the system needs to be running on an IBM Power System with SLES as the operating system. Additionally, it needs to have a minimum of 16 GB RAM allocated to it on a dedicated server.

    Rate this question:

  • 33. 

    Which parameters are mandatory when using the hdblcm tool in batch mode? Note:There are 2 correct answers to this question. 

    • Data and Log path

    • Installation path 

    • Password of the user sapadm

    • SAP HANA System ID (SID)

    Correct Answer(s)
    A. Password of the user sapadm
    A. SAP HANA System ID (SID)
    Explanation
    The hdblcm tool in batch mode requires the password of the user sapadm and the SAP HANA System ID (SID) to be provided as mandatory parameters. These parameters are necessary for the tool to authenticate the user and identify the specific SAP HANA system for installation or configuration. The data and log path, as well as the installation path, are not mentioned as mandatory parameters in this context.

    Rate this question:

  • 34. 

    Which products do you use for SAP HANA administration? Note:There are 2 correct answers to this question. 

    • SAP Web IDE for SAP HANA

    • SAP Solution Manager 

    • SAP Master Data Governance

    • SAP HANA cockpit 

    Correct Answer(s)
    A. SAP Solution Manager 
    A. SAP HANA cockpit 
    Explanation
    The correct answer for this question is SAP Solution Manager and SAP HANA cockpit. These two products are used for SAP HANA administration. SAP Solution Manager is a centralized tool that helps in managing and monitoring SAP systems, including SAP HANA. It provides functionalities such as system landscape management, incident management, and change control. On the other hand, SAP HANA cockpit is a web-based tool that allows administrators to monitor and manage SAP HANA databases. It provides features such as performance monitoring, configuration management, and user management. Both of these products are essential for efficient SAP HANA administration.

    Rate this question:

  • 35. 

    Which prerequisites must you consider to rename a tenant database in the SAP HANA cockpit? Note:There are 2 correct answers to this question.

    • The tenant database is stopped. 

    • The on-disk tenant directory should be a mount point.

    • The database that is not in move operation. 

    • The tenant database must be unloaded from memory.

    Correct Answer(s)
    A. The tenant database is stopped. 
    A. The database that is not in move operation. 
    Explanation
    To rename a tenant database in the SAP HANA cockpit, there are two prerequisites to consider. Firstly, the tenant database must be stopped. This ensures that there are no active processes or connections to the database during the renaming process. Secondly, the database should not be in a move operation, meaning there should be no ongoing data migration or relocation processes happening with the database. These prerequisites ensure a stable and consistent state for the renaming operation to avoid any potential conflicts or data loss.

    Rate this question:

  • 36. 

    What can you use the Secure User Store (hdbuserstore) for? Note:There are 2 correct answers to this question

    • To configure failover supporting a 3-tier scenario

    • . To store connection information on the SAP HANA database client

    • To store connection information on the SAP HANA XS Advanced engine

    • To configure an SAP HANA Auto-Restart Fault Recovery Support

    Correct Answer(s)
    A. To configure failover supporting a 3-tier scenario
    A. . To store connection information on the SAP HANA database client
    Explanation
    The Secure User Store (hdbuserstore) can be used to configure failover supporting a 3-tier scenario by storing the connection information on the SAP HANA database client. This allows for seamless switching between different database instances in case of a failure. Additionally, it can also be used to store connection information on the SAP HANA XS Advanced engine, enabling secure and efficient access to the database.

    Rate this question:

  • 37. 

    The recovery of your productive SAP HANA tenant database fails. In which cases can you resume the incomplete recovery? Note:There are 2 correct answers to this question.

    • Aborted recovery of a delta data backup 

    • Aborted recovery of a complete data backup 

    • Aborted recovery of the configuration files 

    • Aborted recovery of a log backup 

    Correct Answer(s)
    A. Aborted recovery of a delta data backup 
    A. Aborted recovery of a log backup 
    Explanation
    You can resume the incomplete recovery in the cases of an aborted recovery of a delta data backup and an aborted recovery of a log backup.

    Rate this question:

  • 38. 

    Which tool do you use to investigate an SAP HANA system that is started but can't be reached using SQL? Note: There are 2 correct answers to this questions:

    • Hdbcons 

    • HANASitter 

    • HDBAdmin 

    • Sapcontrol 

    Correct Answer(s)
    A. Hdbcons 
    A. Sapcontrol 
    Explanation
    The tools hdbcons and Sapcontrol can be used to investigate an SAP HANA system that is started but cannot be reached using SQL. Hdbcons is a command-line tool that allows you to connect to the HANA database system and perform various diagnostic and troubleshooting tasks. Sapcontrol is a central control and monitoring tool for SAP systems, which can be used to check the status of various components and services of the SAP HANA system. Both tools provide different functionalities to investigate and resolve issues with the SAP HANA system.

    Rate this question:

  • 39. 

    Which prerequisites of the primary system and the secondary system are mandatory before you can activate the SAP HANA system replication with secondary time travel? Note:There are 2 correct answers to this question. 

    • An explicit read-only connect on between both systems must be available.

    • Both must have the same SAP HANA version. 

    • The CPU architecture must be identical. 

    • Both systems are located in the same data center. 

    Correct Answer(s)
    A. Both must have the same SAP HANA version. 
    A. The CPU architecture must be identical. 
    Explanation
    Before activating SAP HANA system replication with secondary time travel, it is mandatory for both the primary and secondary systems to have the same SAP HANA version. Additionally, the CPU architecture of both systems must be identical.

    Rate this question:

  • 40. 

    Which user management tasks can be performed by a Lightweight Directory Access Protocol (LDAP) server? Note:There are 2 correct answers to this question. 

    • User mapping 

    • Role assignment 

    • User creation 

    • Password policy configuration

    Correct Answer(s)
    A. Role assignment 
    A. User creation 
    Explanation
    LDAP servers can perform the tasks of role assignment and user creation. Role assignment involves assigning specific roles or permissions to users within an organization's directory. User creation refers to the process of creating new user accounts within the directory.

    Rate this question:

  • 41. 

    Which privileges are assigned automatically when you create a technical user during the register resource procedure in SAP HANA cockpit? Note: There are 2 correct answers to this question. 

    • SELECT on the _SYS_STATISTICS scheme

    • CATALOG READ

    • SELECT on the _SYS_TELEMETRY schema

    • RESOURCE ADMIN 

    Correct Answer(s)
    A. SELECT on the _SYS_STATISTICS scheme
    A. CATALOG READ
    Explanation
    When you create a technical user during the register resource procedure in SAP HANA cockpit, the user is automatically assigned the privileges of SELECT on the _SYS_STATISTICS scheme and CATALOG READ. These privileges allow the user to access and retrieve statistical information from the _SYS_STATISTICS scheme and read the catalog information.

    Rate this question:

  • 42. 

    Which prerequisites are necessary for using the SAP HANA database lifecycle manager (HDBLCM) Web user interface? Note:There are 2 correct answers to this question.

    • Communication port 1129 is open.

    • SAP HANA database system in any version. 

    • Installed SAP Host Agent on the SAP HANA host. 

    • SAP HANA Client software locally installed. 

    Correct Answer(s)
    A. Communication port 1129 is open.
    A. Installed SAP Host Agent on the SAP HANA host. 
    Explanation
    The prerequisites necessary for using the SAP HANA database lifecycle manager (HDBLCM) Web user interface are having communication port 1129 open and having the SAP Host Agent installed on the SAP HANA host. These requirements allow for the proper communication and management of the SAP HANA database through the HDBLCM Web user interface. The other options, such as having the SAP HANA database system in any version or having the SAP HANA Client software locally installed, are not necessary for using the HDBLCM Web user interface.

    Rate this question:

  • 43. 

    In a Multiple Database Container (MDC) system, which privilege do you need to perform database-specific backups on all tenant databases? 

    • BACKUP ADMIN

    • DATABASE ADMIN

    • BACKUP OPERATOR 

    • TENANT ADMIN 

    Correct Answer
    A. DATABASE ADMIN
    Explanation
    In a Multiple Database Container (MDC) system, the privilege needed to perform database-specific backups on all tenant databases is DATABASE ADMIN. This privilege grants the user the authority to perform administrative tasks specific to a database, including performing backups.

    Rate this question:

  • 44. 

    Which alert configuration properties can you configurein SAP HANA cockpit? Note:There are 3 correct answers to this question.

    • Email alert notification

    • Alert threshold values

    • Schedule period 

    • Schedule activation

    • Alert checker category 

    Correct Answer(s)
    A. Email alert notification
    A. Alert threshold values
    A. Alert checker category 
    Explanation
    In SAP HANA cockpit, you can configure the following alert configuration properties:
    1. Email alert notification: This allows you to set up email notifications for alerts, so that you can be informed about any critical issues or events.
    2. Alert threshold values: You can define the threshold values for different alerts, specifying the conditions under which an alert should be triggered.
    3. Alert checker category: This allows you to categorize different types of alerts based on their severity or importance, making it easier to prioritize and manage them effectively.

    Rate this question:

  • 45. 

    What are the two features of the storage engine in the SAP HANA index server that enable data consistency and maintain durable changes? 

    • Page Management and logger 

    • Column Store and Row Store

    • Metadata Manager and Transaction Manager 

    • Session Management and log Volumes

    Correct Answer
    A. Page Management and logger 
    Explanation
    Page Management and logger are the two features of the storage engine in the SAP HANA index server that enable data consistency and maintain durable changes. Page Management ensures efficient allocation and management of data pages in memory and on disk, while the logger records all changes made to the database in a persistent and sequential log. These features work together to ensure that data is stored and updated consistently and that changes are durable and recoverable in case of system failures.

    Rate this question:

  • 46. 

    Which SAP HANA features can you use to manage the database peak load? Note:There are 2 correct answers to this question.

    • Thread throttling

    • Capture and replay

    • Workload classes

    • Admission control 

    Correct Answer(s)
    A. Workload classes
    A. Admission control 
    Explanation
    Workload classes and admission control are two SAP HANA features that can be used to manage the database peak load. Workload classes allow for the classification and prioritization of different types of workloads, allowing the system to allocate resources accordingly. Admission control helps in managing the system resources by controlling the number of concurrent sessions or requests, ensuring that the system does not get overloaded during peak load periods. These features help optimize performance and ensure efficient resource allocation during high demand periods.

    Rate this question:

  • 47. 

    Which system privileges are required for administrating tenant databases when being connected to the system database? Note:There are 2 correct answers to this question.

    • MONITOR ADMIN

    • BACKUP ADMIN

    • DATA ADMIN 

    • DATABASE A DMIN

    Correct Answer
    A. DATABASE A DMIN
    Explanation
    The correct answers for this question are MONITOR ADMIN and DATABASE ADMIN. When connected to the system database, MONITOR ADMIN privileges are required to monitor the system and tenant databases. DATABASE ADMIN privileges are required to administer the tenant databases, including tasks such as creating, modifying, and deleting databases. BACKUP ADMIN and DATA ADMIN privileges are not specifically required for administrating tenant databases when connected to the system database.

    Rate this question:

  • 48. 

    When can you load and unload individual tables and table columns manually in an SAP HANA tenant database? Note:There are 2 correct answers to this question. 

    • When you need to measure total memory. 

    • When you need to optimize the standby node memory. 

    • When you need to extend the scale-out memory. 

    • When you need to actively free up memory. 

    Correct Answer(s)
    A. When you need to measure total memory. 
    A. When you need to actively free up memory. 
    Explanation
    You can load and unload individual tables and table columns manually in an SAP HANA tenant database when you need to measure total memory and when you need to actively free up memory.

    Rate this question:

  • 49. 

    Which database objects can you manipulate if you have the ALL PRIVILEGES activity? Note: There are 2 correct answers to this question

    • Views

    • Tables

    • Procedures

    • Sequences

    Correct Answer(s)
    A. Views
    A. Tables
    Explanation
    If a user has the ALL PRIVILEGES activity, they can manipulate views and tables in the database. Views are virtual tables that display the result of a query, and users with ALL PRIVILEGES can modify, create, or delete views. Tables are the main objects in a database that store data, and users with ALL PRIVILEGES can perform various operations on tables such as inserting, updating, deleting, or altering the structure of tables. However, procedures and sequences are not directly related to the manipulation of database objects, so they are not included in the correct answer.

    Rate this question:

Godwin Iheuwa |MS (Computer Science) |
Database Administrator
Godwin Iheuwa, a Database Administrator at MTN Nigeria, holds an MS in Computer Science, specializing in Agile Methodologies and Database Administration from the University of Bedfordshire and a Bachelor's in Computer Science from the University of Port Harcourt. His proficiency in SQL Server Integration Services (SSIS) and SQL Server Management Studio contributes to his expertise in database management.

Quiz Review Timeline (Updated): Sep 1, 2024 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Sep 01, 2024
    Quiz Edited by
    ProProfs Editorial Team

    Expert Reviewed by
    Godwin Iheuwa
  • Dec 18, 2020
    Quiz Created by
    Themes
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.