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)
Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Themes
T
Themes
Community Contributor
Quizzes Created: 420 | Total Attempts: 896,840
Questions: 80 | Attempts: 4,447

SettingsSettingsSettings
SAP HANA Certification Exam Prep Test - Quiz

HANA


Questions and Answers
  • 1. 

    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:

    • A.

      Hdbcons 

    • B.

      HANASitter 

    • C.

      HDBAdmin 

    • D.

      Sapcontrol 

    Correct Answer(s)
    A. Hdbcons 
    D. 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:

  • 2. 

    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. 

    • A.

      SELECT on the _SYS_STATISTICS scheme

    • B.

      CATALOG READ

    • C.

      SELECT on the _SYS_TELEMETRY schema

    • D.

      RESOURCE ADMIN 

    Correct Answer(s)
    A. SELECT on the _SYS_STATISTICS scheme
    B. 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:

  • 3. 

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

    • A.

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

    • B.

      The SAP HANA database server is shut down. 

    • C.

      The host has access to the installation directories. 

    • D.

      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. 
    C. 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:

  • 4. 

    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. 

    • A.

      When the time threshold is exceeded. 

    • B.

      When a commit occurs. 

    • C.

      When the log segment is full. 

    • D.

      When the log buffer is full. 

    Correct Answer(s)
    A. When the time threshold is exceeded. 
    C. 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:

  • 5. 

    Which SAP HANA features are secured by certificates saved in the SAP HANA certificate store? Note:There are 2 correct answers to this question.

    • A.

      A. Internal communication channels with the system PKI 

    • B.

      Client-server communication over JDBC 

    • C.

       SAP HANA tenant database replication 

    • D.

       HTTPS client access using the SAP HANA Web Dispatcher 

    Correct Answer(s)
    B. Client-server communication over JDBC 
    C.  SAP HANA tenant database replication 
    Explanation
    The correct answers are "Client-server communication over JDBC" and "SAP HANA tenant database replication". These features are secured by certificates saved in the SAP HANA certificate store to ensure secure communication and replication between different components of the SAP HANA system.

    Rate this question:

  • 6. 

    Which tool do you use during the Database Migration Option (DMO) procedure to monitor table splitting? 

    • A.

      The R3LDCTL 

    • B.

      The Process Bucket monitor 

    • C.

      The Observer Monitor 

    • D.

      The Log viewer

    Correct Answer
    D. The Log viewer
    Explanation
    During the Database Migration Option (DMO) procedure, the Log viewer tool is used to monitor table splitting. The Log viewer allows users to view and analyze the logs generated during the migration process, providing insights into the splitting of tables. It helps in tracking the progress of the migration and identifying any issues or errors that may occur during the table splitting process.

    Rate this question:

  • 7. 

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

    • A.

      Views

    • B.

      Tables

    • C.

      Procedures

    • D.

      Sequences

    Correct Answer(s)
    A. Views
    B. 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:

  • 8. 

    What is a characteristic of the Delta Data Shipping operation mode in SAP HANA system replication?

    • A.

      Delta data shipping takes place in addition to continuous log replay.

    • B.

      Delta data shipping takes place with continuous read-only access to the secondary system.

    • C.

      Delta data shipping takes place every 5 minutes.

    • D.

      Delta data shipping takes place in addition to continuous log shipping.

    Correct Answer
    D. Delta data shipping takes place in addition to continuous log shipping.
    Explanation
    In SAP HANA system replication, a characteristic of the Delta Data Shipping operation mode is that it occurs in addition to continuous log shipping. Delta data shipping complements continuous log shipping by sending only the delta changes or differences that have occurred since the last data shipping, allowing for efficient synchronization between the primary and secondary systems. This helps in reducing the network and resource load compared to a full data copy each time.

    Rate this question:

  • 9. 

     Which parameters do you need to change before you can analyse the memory usage of running SOL statements? Note: There are 2 correct answers to this question. Which one do you like?

    • A.

      Enable_tracking

    • B.

      Use_in_memory_tracing

    • C.

      Statement_memory_limit

    • D.

      Memory_tracking 

    Correct Answer(s)
    A. Enable_tracking
    D. Memory_tracking 
    Explanation
    To analyze the memory usage of running SOL statements, you need to change the parameters "enable_tracking" and "memory_tracking". These parameters allow you to enable tracking of memory usage and enable memory tracking for SOL statements, respectively. By changing these parameters, you can accurately monitor and analyze the memory usage of running SOL statements.

    Rate this question:

  • 10. 

    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?

    • A.

      1.0 TB 

    • B.

      1.5 TB 

    • C.

      375 GB 

    • D.

      512 GB

    Correct Answer
    D. 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:

  • 11. 

    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.

    • A.

      Communication port 1129 is open.

    • B.

      SAP HANA database system in any version. 

    • C.

      Installed SAP Host Agent on the SAP HANA host. 

    • D.

      SAP HANA Client software locally installed. 

    Correct Answer(s)
    A. Communication port 1129 is open.
    C. 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:

  • 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.

    • A.

      Scopes 

    • B.

      Privileges 

    • C.

      Role collections

    • D.

      Roles 

    Correct Answer(s)
    B. Privileges 
    D. 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. 

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

    • A.

      On the Primary Application Server (PAS) host 

    • B.

      On the remote target database host 

    • C.

      On the Additional Application Server (AAS) host 

    • D.

      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:

  • 14. 

    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. 

    • A.

      Sandbox 

    • B.

      Test 

    • C.

       Development 

    • D.

      Production 

    Correct Answer(s)
    B. Test 
    C.  Development 
    D. 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:

  • 15. 

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

    • A.

      Page Management and logger 

    • B.

      Column Store and Row Store

    • C.

      Metadata Manager and Transaction Manager 

    • D.

      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:

  • 16. 

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

    • A.

      _SYS_TELEMETRY 

    • B.

       _SYS_WORKLOAD_REPLAY

    • C.

      _SYS_SQL_ANALYZER

    • D.

      _SYS_STATISTICS 

    Correct Answer
    D. _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:

  • 17. 

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

    • A.

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

    • B.

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

    • C.

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

    • D.

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

    Correct Answer
    D.  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:

  • 18. 

    Which preparation steps do you need to perform before replaying a captured workload using the SAP HA NA capture and replay tool? Note: There are 3 correct answers to this question. 

    • A.

      Restore the source system tenant backup to the target tenant. 

    • B.

      Store the logon credentials of the replayer user in the secure store. 

    • C.

      Create a replayer user account on the target operating system. 

    • D.

      Create a replayer user account in the target database system. 

    • E.

      Preprocess the captured workload on the source system. 

    Correct Answer(s)
    B. Store the logon credentials of the replayer user in the secure store. 
    D. Create a replayer user account in the target database system. 
    E. Preprocess the captured workload on the source system. 
    Explanation
    Before replaying a captured workload using the SAP HA NA capture and replay tool, there are three preparation steps that need to be performed. Firstly, the logon credentials of the replayer user need to be stored in the secure store. Secondly, a replayer user account needs to be created in the target database system. Lastly, the captured workload needs to be preprocessed on the source system. These steps ensure that the necessary credentials and user accounts are set up correctly and that the captured workload is ready to be replayed accurately.

    Rate this question:

  • 19. 

    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.

    • A.

      The DBACOCKPIT user of the tenant database 

    • B.

      The SYSTEM user of the system database

    • C.

      The SAP• user in client 000 of the ABAP system

    • D.

      The S-user for the SAP Support Portal connection 

    • E.

      The DDIC user in client 000 of the A BAP system 

    Correct Answer(s)
    A. The DBACOCKPIT user of the tenant database 
    B. The SYSTEM user of the system database
    E. 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:

  • 20. 

    Which types of backups can you use to copy an SAP HANA tenant? Note:There are 2 correct answers to this question. 

    • A.

      Delta database backup

    • B.

      Fallback snapshot 

    • C.

      Data snapshot 

    • D.

      Full database backup 

    Correct Answer(s)
    C. Data snapshot 
    D. Full database backup 
    Explanation
    Data snapshot and Full database backup are the correct answers for this question. These types of backups can be used to copy an SAP HANA tenant. A data snapshot is a point-in-time copy of the data in the database, allowing for easy restoration or duplication of the data. A full database backup, on the other hand, includes all the data and log files necessary to restore the entire database to a specific point in time. Both of these backups provide a means to copy and restore the SAP HANA tenant.

    Rate this question:

  • 21. 

    Which file systems are supported for the SAP HANA database system? Note: There are 2 correct answers to this question. 

    • A.

      EXT3 

    • B.

      XFS 

    • C.

      GPFS 

    • D.

      MPFS 

    Correct Answer(s)
    B. XFS 
    C. GPFS 
    Explanation
    For the SAP HANA database system, the supported file systems include:
    XFS
    GPFS (General Parallel File System, now known as IBM Spectrum Scale)
    EXT3 is not recommended for SAP HANA due to its limitations with large files and performance. MPFS (MultiPath File System) is not listed among the commonly supported file systems for SAP HANA. Therefore, the correct answers are XFS and GPFS.

    Rate this question:

  • 22. 

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

    • A.

      Unknown 

    • B.

      Syncing 

    • C.

      Error 

    • D.

      Initializing 

    Correct Answer
    B. 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:

  • 23. 

    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. 

    • A.

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

    • B.

      Both must have the same SAP HANA version. 

    • C.

      The CPU architecture must be identical. 

    • D.

      Both systems are located in the same data center. 

    Correct Answer(s)
    B. Both must have the same SAP HANA version. 
    C. 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:

  • 24. 

    What do you have to consider when you perform a Tailored Data Center Integration (TDI) installation for a productive SAP HANA database system? Note:There are 2 correct answers to this question. 

    • A.

      Obtaining the hardware certification from SAP for the existing hardware you are going to use. 

    • B.

      Having 10 GBit/s for storage zone and 1 GBit/s for internal zone for network connect vity. 

    • C.

      Obtaining C_HANATEC_XX Certification. 

    • D.

      Having the data and log volumes on the different disks

    Correct Answer(s)
    A. Obtaining the hardware certification from SAP for the existing hardware you are going to use. 
    D. Having the data and log volumes on the different disks
    Explanation
    When performing a Tailored Data Center Integration (TDI) installation for a productive SAP HANA database system, there are two important considerations. Firstly, obtaining the hardware certification from SAP for the existing hardware that will be used ensures compatibility and reliability. Secondly, it is crucial to have the data and log volumes on different disks to optimize performance and ensure data integrity.

    Rate this question:

  • 25. 

    How are hosts assigned to the shared storage in an SAP HANA scale-out system? Note:There are 2 correct answers to this question.

    • A.

      The standby server is assigned to the master data volume

    • B.

      The master name server is assigned to its master data volume. 

    • C.

      The master server is assigned to all data volumes. 

    • D.

      The slave servers are assigned to their own data volumes. 

    Correct Answer(s)
    B. The master name server is assigned to its master data volume. 
    D. The slave servers are assigned to their own data volumes. 
    Explanation
    In an SAP HANA scale-out system, the master name server is assigned to its master data volume. This means that the master name server is responsible for managing and coordinating the data stored in its assigned master data volume. Additionally, the slave servers are assigned to their own data volumes. Each slave server is responsible for managing and storing data in its own assigned data volume. This distribution of hosts to shared storage ensures efficient data management and storage in the scale-out system.

    Rate this question:

  • 26. 

    What is the first node limit for planning an SAP S/4HANA scale-out system? Note: There are 2 correct answers to this question. 

    • A.

      >= 6TB

    • B.

      >= 8TB 

    • C.

      >= 12CPU

    • D.

      >= 8CPU 

    Correct Answer(s)
    B. >= 8TB 
    D. >= 8CPU 
    Explanation
    For planning an SAP S/4HANA scale-out system, the first node limit typically involves having at least 8TB of memory and 8 CPUs. These requirements ensure that the system can handle the large volumes of data and processing power needed for optimal performance.

    Rate this question:

  • 27. 

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

    • A.

      SAP Web IDE for SAP HANA

    • B.

      SAP Solution Manager 

    • C.

      SAP Master Data Governance

    • D.

      SAP HANA cockpit 

    Correct Answer(s)
    B. SAP Solution Manager 
    D. 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:

  • 28. 

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

    • A.

      SAP NetWeaver Application Server Java 

    • B.

      SAP HANA XS Advanced 

    • C.

      SAP NetWeaver Application Server ABAP 

    • D.

      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:

  • 29. 

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

    • A.

      An Intel-based system with operating system Microsoft Windows

    • B.

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

    • C.

      16 GB RAM on a dedicated server 

    • D.

      10 GBit/s network bandwidth 

    Correct Answer(s)
    B. An IBM Power System with operating system SUSE Linux Enterprise Server (SLES) 
    C. 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:

  • 30. 

    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. 

    • A.

      ASYNC 

    • B.

      SYNC 

    • C.

      SYNCMEM 

    • D.

      FULL SYNC

    Correct Answer(s)
    B. SYNC 
    C. 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:

  • 31. 

    What are the supported operating systems for SAP HANA on IBM Power Servers? Note:There are 2 correct answers to this question. 

    • A.

      For SAP HANA 1.0, Red Hat Enterprise Linux (RHEL) 6. 10 

    • B.

      For SAP HANA 2.0,Red Hat Enterprise Linux (RHEL) 7.2 

    • C.

      For SAP HANA 2.0,SUSE Linux Enterprise Server (SLES) 12 and 15 

    • D.

      For SAP HANA 1.0, SUSE Linux Enterprise Server (SLES) 11 SP4

    Correct Answer(s)
    C. For SAP HANA 2.0,SUSE Linux Enterprise Server (SLES) 12 and 15 
    D. For SAP HANA 1.0, SUSE Linux Enterprise Server (SLES) 11 SP4
    Explanation
    The correct answer for the supported operating systems for SAP HANA on IBM Power Servers is SUSE Linux Enterprise Server (SLES) 12 and 15 for SAP HANA 2.0, and SUSE Linux Enterprise Server (SLES) 11 SP4 for SAP HANA 1.0.

    Rate this question:

  • 32. 

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

    • A.

      Main 2

    • B.

      Main 1

    • C.

      Delta 1 

    • D.

      Delta 2

    Correct Answer(s)
    A. Main 2
    D. 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:

  • 33. 

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

    • A.

      Data and Log path

    • B.

      Installation path 

    • C.

      Password of the user sapadm

    • D.

      SAP HANA System ID (SID)

    Correct Answer(s)
    C. Password of the user sapadm
    D. 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 file system locations are suggested to install an SAP HANA multi -host system? Note:There are 2 correct answers to this question.

    • A.

       /hana/< sid> 

    • B.

       /hana/< hostname> 

    • C.

      Hana/log/< sid> 

    • D.

       /hana/shared 

    Correct Answer(s)
    C. Hana/log/< sid> 
    D.  /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:

  • 35. 

    Which default users will be created during the installation of the SAP HANA database system? Note: There are 2 correct answers to this question. 

    • A.

      Ldapadm 

    • B.

      < sid>crypt

    • C.

      Sapadm

    • D.

      Sap< sid> 

    Correct Answer(s)
    B. < sid>crypt
    C. Sapadm
    Explanation
    During the installation of the SAP HANA database system, the following users are automatically created:
    <sid>adm: This is the operating system administrator required for administrative tasks such as starting and stopping the system.
    sapadm: This is the SAP Host Agent administrator.
    SYSTEM: This is the database superuser.
    <sid>crypt: This user owns the storage of the encryption keys and other similarly sensitive data.
    So, the correct answers to your question are sapadm and <sid>crypt. These users are created by default during the installation of the SAP HANA database system. The ldapadm and sap<sid> users are not created by default.

    Rate this question:

  • 36. 

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

    • A.

      RESOURCEADMIN

    • B.

       INIFILE ADMIN 

    • C.

      WORKLOAD ADMIN 

    • D.

      DATABASE ADMIN

    Correct Answer
    B.  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:

  • 37. 

    How can the system database administrator disable tenant database functionalities? 

    • A.

      Using the Manage Blacklisted Parameter app

    • B.

      Using the Manage Restricted Features app 

    • C.

      Using the hdbuserstore tool 

    • D.

      Using the resident hdblcm tool 

    Correct Answer
    B. Using the Manage Restricted Features app 
    Explanation
    The system database administrator can disable tenant database functionalities in a Multitenant Database Container (MDC) system by using the "Manage Restricted Features" app. This app provides control over which features and functionalities are accessible to individual tenants or databases within the MDC, allowing the administrator to restrict or disable specific capabilities as needed.

    Rate this question:

  • 38. 

    Which properties can you adjust in SAP HANA Admission Control? Note:There are 3 correct answers to this question. 

    • A.

      Memory limit for queuing requests 

    • B.

      SQL statement request memory limit 

    • C.

      Maximum request queue size

    • D.

      CPU threshold for rejecting requests 

    • E.

      Maximum parallel 10 requests 

    Correct Answer(s)
    A. Memory limit for queuing requests 
    C. Maximum request queue size
    D. CPU threshold for rejecting requests 
    Explanation
    In SAP HANA Admission Control, there are three properties that can be adjusted. The first property is the memory limit for queuing requests, which determines the maximum amount of memory that can be used for queuing requests. The second property is the maximum request queue size, which determines the maximum number of requests that can be queued. The third property is the CPU threshold for rejecting requests, which sets the threshold for CPU usage at which requests will be rejected. These three properties allow for better control and optimization of resource allocation in SAP HANA.

    Rate this question:

  • 39. 

    What do you need in a Multitenant Database Container (MDC) system to run queries across tenant databases? Note: There are 2 correct answers to this question. 

    • A.

      The bidirectional communication channel must be whitelisted.

    • B.

      The user in the source system must have sufficient privileges in the target database

    • C.

      The cross-tenant database communication must be explicitly activated.

    • D.

      The user in the source system must be associated with a user in the target database. 

    Correct Answer(s)
    B. The user in the source system must have sufficient privileges in the target database
    C. The cross-tenant database communication must be explicitly activated.
    D. The user in the source system must be associated with a user in the target database. 
    Explanation
    In a Multitenant Database Container (MDC) system to run queries across tenant databases, you need the following:
    The user in the source system must have sufficient privileges in the target database: This ensures that the user running the query has the necessary permissions to access and retrieve data from the target database.
    The user in the source system must be associated with a user in the target database: This establishes a connection between the user in the source system and a corresponding user in the target database, allowing for authenticated and authorized access to the data across tenant databases.

    Rate this question:

  • 40. 

    Which role do you need in order to assign users to groups in SAP HANA cockpit? 

    • A.

      Cockpit Administrator 

    • B.

      Cockpit Resource Administrator 

    • C.

      Cockpit User Administrator

    • D.

      Cockpit User 

    Correct Answer
    C. Cockpit User Administrator
    Explanation
    To assign users to groups in SAP HANA cockpit, you need the role of Cockpit User Administrator. This role is specifically designed to manage user accounts and their group memberships within the SAP HANA cockpit environment.

    Rate this question:

  • 41. 

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

    • A.

      SAP Adaptive Server Enterprise 

    • B.

      SAP Intelligent Query

    • C.

      SAP Analytics Cloud 

    • D.

      SAP Business Intelligence

    Correct Answer
    D. 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:

  • 42. 

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

    • A.

      BACKUP ADMIN

    • B.

      DATABASE ADMIN

    • C.

      BACKUP OPERATOR 

    • D.

      TENANT ADMIN 

    Correct Answer
    B. 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:

  • 43. 

    Which is the relationship between the user group operators and the user groups? Note:There are 2 correct answers to this question. 

    • A.

      Multiple user groups per user group operator

    • B.

      Only one user group operator per user group 

    • C.

      Only one user group per user group operator

    • D.

      Multiple user group operators per user group

    Correct Answer(s)
    A. Multiple user groups per user group operator
    B. Only one user group operator per user group 
    Explanation
    The relationship between user group operators and user groups is that there can be multiple user groups per user group operator, and there can also be only one user group operator per user group.

    Rate this question:

  • 44. 

    Which rules should you consider when creating a table distribution plan for SAP Business Suite on SAP HANA to get the best possible results? Note:There are 2 correct answers to this question. 

    • A.

      Keep the number of key columns low.

    • B.

      Keep the number of partitions per table high.

    • C.

      Keep all partitions on different hosts. 

    • D.

      Keep the number of partitioned tables low. 

    Correct Answer(s)
    A. Keep the number of key columns low.
    B. Keep the number of partitions per table high.
    Explanation
    To get the best possible results when creating a table distribution plan for SAP Business Suite on SAP HANA, it is recommended to keep the number of key columns low. This is because having a lower number of key columns simplifies the distribution process and improves performance. Additionally, keeping the number of partitions per table high is also important as it allows for better parallel processing and distribution of data across multiple nodes, leading to improved query performance.

    Rate this question:

  • 45. 

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

    • A.

      ODBC 

    • B.

      OLEDB 

    • C.

      ADO.NET 

    • D.

      JDBC

    Correct Answer(s)
    A. ODBC 
    D. 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:

  • 46. 

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

    • A.

      The tenant database is stopped. 

    • B.

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

    • C.

      The database that is not in move operation. 

    • D.

      The tenant database must be unloaded from memory.

    Correct Answer(s)
    A. The tenant database is stopped. 
    C. 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:

  • 47. 

    Which backup and recovery scenario is allowed in multitenant database containers? 

    • A.

      The system database should be recovered first in order to recover the tenant databases.

    • B.

      A backup of a tenant database can be recovered to the system database. 

    • C.

      A tenant database can initiate its own backup, but the system database executes the recovery. 

    • D.

      After the recovery of a tenant database, the system database needs a backup

    Correct Answer
    C. A tenant database can initiate its own backup, but the system database executes the recovery. 
    Explanation
    In a multitenant database, each tenant database can initiate its own backup. However, the recovery process is executed by the system database. This means that if a tenant database needs to be recovered, it can initiate its own backup, but the system database is responsible for executing the recovery process. This scenario allows for each tenant database to have control over their own backups while ensuring that the recovery process is managed centrally by the system database.

    Rate this question:

  • 48. 

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

    • A.

      User mapping 

    • B.

      Role assignment 

    • C.

      User creation 

    • D.

      Password policy configuration

    Correct Answer(s)
    B. Role assignment 
    C. 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:

  • 49. 

    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. 

    • A.

      When you need to measure total memory. 

    • B.

      When you need to optimize the standby node memory. 

    • C.

      When you need to extend the scale-out memory. 

    • D.

      When you need to actively free up memory. 

    Correct Answer(s)
    A. When you need to measure total memory. 
    D. 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:

  • 50. 

    Which SAP HANA cockpit application can you use to investigate a system offline situation?

    • A.

      CPU usage monitor

    • B.

      Full system information dump

    • C.

      Troubleshoot unresponsive system 

    • D.

      Out-of-memory event monitor 

    Correct Answer(s)
    B. Full system information dump
    C. Troubleshoot unresponsive system 
    Explanation
    The SAP HANA cockpit application that can be used to investigate a system offline situation is the Full system information dump. This feature allows users to gather comprehensive information about the system, including logs, traces, and other diagnostic data, which can be helpful in troubleshooting and resolving issues. Additionally, the Troubleshoot unresponsive system feature can also be used to investigate and resolve system unresponsiveness problems.

    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 +

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.