SAP C-hanatec-15 Certification Exam Practice Test

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Hana Banana
H
Hana Banana
Community Contributor
Quizzes Created: 1 | Total Attempts: 2,740
| Attempts: 2,740
SettingsSettings
Please wait...
  • 1/76 Questions

    Where do you investigate a failed uninstall of an SAP HANA scale-out system? 

    • /var/tmp/hdblcm.log
    • /var/lib/hdb/
    • /var/run/saphostexec.run
    • /var/log/messages
Please wait...
About This Quiz

SAP C-HANATEC-15 Certification is mainly concerning to those candidates who are from SAP HANA and business consulting area and want to build their career as an SAP Certified Technology Associate- SAP HANA 2.0 (SPS03). This certification exam validates that the candidate has a good hold on fundamental knowledge and proven skills in this area so he/she can practically implement this knowledge in projects. This practice test has over 76 questions of the same, so start the test and happy learning!

SAP C-hanatec-15 Certification Exam Practice Test - Quiz

Quiz Preview

  • 2. 

    What tool must you use to add an additional host to an SAP HANA scale-out system? 

    • Hdpupd

    • Hdbinst

    • Hdbsetup

    • Hdblcm

    Correct Answer
    A. Hdblcm
    Explanation
    To add an additional host to an SAP HANA scale-out system, the tool that must be used is hdblcm. This tool is specifically designed for managing the lifecycle of SAP HANA systems, including the installation, configuration, and maintenance of the system. It allows for the seamless addition of new hosts to the existing scale-out system, ensuring smooth scalability and performance optimization.

    Rate this question:

  • 3. 

    What can you monitor? In the tenant database status of the SAP HANA cockpit? 

    • … status of the tenant

    • Security status of the tenant

    • Progress statues of tenant creation

    • CPU, disk and memory of the tenant

    Correct Answer
    A. CPU, disk and memory of the tenant
    Explanation
    In the SAP HANA cockpit, you can monitor the CPU, disk, and memory usage of the tenant database. This allows you to keep track of the resource utilization and performance of the tenant, ensuring efficient operation and identifying any potential bottlenecks or issues. Monitoring these parameters helps in optimizing the overall performance and stability of the tenant database.

    Rate this question:

  • 4. 

    You are setting up a disaster recovery system replication. You want the transaction processing of the primary system to be suspended if the network to the secondary system fails. Which log replication mode must you use? 

    • Sync

    • Async

    • Full sync

    • Syncmen

    Correct Answer
    A. Full sync
    Explanation
    To ensure that the transaction processing of the primary system is suspended if the network to the secondary system fails, the appropriate log replication mode to use is "full sync." In full sync mode, the primary system waits for acknowledgment from the secondary system after each transaction before proceeding with the next one. This ensures that the primary system is aware of the status of the secondary system and suspends transaction processing if the network connection is lost.

    Rate this question:

  • 5. 

    Why does SAP HANA have a persistence storage layer that is disk based? (2 correct) 

    • To enable ROW store in the SAP HANA dB

    • To provide an area to unload data when memory is full

    • To enable data recovery if the power fails

    • To provide an area to generate indexes for the ROW store

    Correct Answer(s)
    A. To provide an area to unload data when memory is full
    A. To enable data recovery if the power fails
    Explanation
    The persistence storage layer in SAP HANA is disk-based to provide an area to unload data when memory is full. This allows the system to free up memory by storing less frequently accessed data on disk, ensuring efficient memory usage. Additionally, the disk-based storage enables data recovery if the power fails, as the data is persisted on disk and can be restored when the system restarts.

    Rate this question:

  • 6. 

    You install a SAP HANA database and NetWeaver AS ABAP 7.5 on one server. This system will be the customer's productive system. Which of the following installation requirements are correct (2 answers)? 

    • The System ID(SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different

    • The instance number for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same

    • The disk resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same

    • The memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added

    Correct Answer(s)
    A. The System ID(SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different
    A. The memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added
    Explanation
    The System ID (SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different because they are separate systems and should have unique identifiers. On the other hand, the memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added together because both systems require memory for their operations.

    Rate this question:

  • 7. 

    A user is complaining about missing privileges when executing a query in the SAP HANA studio. How do you need to configure the index server trace to obtain the missing privileges? 

    • Select trace level Info for the authorization component

    • Select trace level Error for the auditing component

    • Select trace level Debug for the authenticationcodec component

    • Select trace level Warning for the authentication component

    Correct Answer
    A. Select trace level Info for the authorization component
    Explanation
    To obtain the missing privileges when executing a query in the SAP HANA studio, the index server trace needs to be configured by selecting trace level Info for the authorization component. This will enable the system to provide detailed information about the authorization process and help identify any missing privileges that may be causing the issue. By setting the trace level to Info, the system will log relevant authorization events and provide valuable insights for troubleshooting and resolving the user's complaint.

    Rate this question:

  • 8. 

    What do you need to size before you install SAP HANA in a Tailored Data Centre Integration (TDI) scenario? (3 correct) 

    • CPU

    • Input/Output operations per second(IOPS)

    • Disk

    • Main memory

    • Network throughput

    Correct Answer(s)
    A. CPU
    A. Disk
    A. Main memory
    Explanation
    In order to install SAP HANA in a Tailored Data Centre Integration (TDI) scenario, you need to size the CPU, disk, and main memory. These components are essential for the proper functioning of SAP HANA and ensuring optimal performance. The CPU is responsible for processing the data and executing instructions, while the disk is used for storing the data. Main memory, also known as RAM, is used for temporary storage and fast access to data. Sizing these components correctly is crucial to meet the system requirements and ensure smooth operation of SAP HANA.

    Rate this question:

  • 9. 

    Which role must be assigned to you to configure the kernel profiler? 

    • MONITORING

    • Sap.hana.xs.lm.roles::Administrator

    • Sap.hana.admin.roles::Monitoring

    • SAP_INTERNAL_HANA_SUPPORT

    Correct Answer
    A. SAP_INTERNAL_HANA_SUPPORT
    Explanation
    The correct role that must be assigned to configure the kernel profiler is SAP_INTERNAL_HANA_SUPPORT. This role provides the necessary permissions and access rights to configure and monitor the kernel profiler in SAP HANA. The MONITORING role and sap.hana.admin.roles::Monitoring are not specifically related to the kernel profiler configuration. The sap.hana.xs.lm.roles::Administrator role is related to the XS Advanced application lifecycle management and does not have direct relevance to the kernel profiler configuration.

    Rate this question:

  • 10. 

    You are using your own user account and need to activate the Kernel Profiler trace to analyse a performance issue. The Kernel Profiler is inactive and you cannot activate it. What is the root cause of this problem? 

    • You are missing the system privilege TRACE ADMIN

    • The kernel Profiler needs to be activated by SAP Support

    • The kernel Profiler requires the SYSTEM user

    • You are missing the role SAP_INTERNAL_HANA_SUPPORT

    Correct Answer
    A. You are missing the role SAP_INTERNAL_HANA_SUPPORT
    Explanation
    The root cause of the problem is that the user is missing the role SAP_INTERNAL_HANA_SUPPORT. This role is required to activate the Kernel Profiler trace and analyze performance issues. Without this role, the user does not have the necessary privileges to activate the profiler.

    Rate this question:

  • 11. 

    Which SAP HANA features ensure that committed data is NOT lost if there is a power failure? (2 correct) 

    • Persisted redo logs

    • Storage snapshots

    • Automatic savepoints 

    • Pre-load tables

    Correct Answer(s)
    A. Persisted redo logs
    A. Automatic savepoints 
    Explanation
    Persisted redo logs and automatic savepoints are features in SAP HANA that ensure that committed data is not lost if there is a power failure.

    Persisted redo logs are logs that record all changes made to the database and are stored on persistent storage. In the event of a power failure, these logs can be used to recover the database to a consistent state.

    Automatic savepoints are periodic points in time where the system automatically saves the data to disk. This ensures that even if there is a power failure, the system can recover to the most recent savepoint, minimizing the loss of data.

    Rate this question:

  • 12. 

    What kinds of patches are available in the SAP HANA revision strategy? (2 correct) 

    • Feature Package Stack

    • Support Package

    • Maintenance Package

    • Support Package Stack

    Correct Answer(s)
    A. Support Package
    A. Support Package Stack
    Explanation
    The correct answer is Support Package and Support Package Stack. In the SAP HANA revision strategy, Support Packages are available to provide bug fixes and enhancements to the system. Support Package Stacks, on the other hand, are a collection of Support Packages that are released at regular intervals and contain a larger set of fixes and improvements. Both types of patches are important for keeping the SAP HANA system up to date and ensuring its stability and performance.

    Rate this question:

  • 13. 

    In which SAP HANA configuration file can you view the assignments of hosts to their scale-out role (master, worker, and standby)? 

    • Nameserver.ini

    • Sapprofile.ini

    • Indexserver.ini

    • Multidb.ini

    Correct Answer
    A. Nameserver.ini
    Explanation
    In the SAP HANA configuration file "Nameserver.ini", you can view the assignments of hosts to their scale-out role (master, worker, and standby). This file contains the necessary information regarding the configuration and management of the SAP HANA nameserver, including the allocation of roles to different hosts in a scale-out system.

    Rate this question:

  • 14. 

    Which command can you use to bring a scale-out SAP HANA database to a fully operational state? 

    • Sapcontrol -nr -function Start

    • Sapcontrol -nr -function StartSystem

    • HDB start

    • Startsap

    Correct Answer
    A. Sapcontrol -nr -function StartSystem
    Explanation
    The correct answer is "sapcontrol -nr -function StartSystem". This command is used to start a scale-out SAP HANA database and bring it to a fully operational state. The "-nr" parameter specifies the instance number of the database, and the "-function StartSystem" parameter indicates that the entire system should be started.

    Rate this question:

  • 15. 

    You want to handle your SAP HANA user provisioning with SAP Identity Management. Which operations are supported? (2 correct) 

    • Add/delete SAP HANA users

    • Event based updates

    • Add/delete SAP HANA objects

    • Add/delete SAP HANA roles

    Correct Answer(s)
    A. Add/delete SAP HANA users
    A. Add/delete SAP HANA roles
    Explanation
    SAP Identity Management supports the operations of adding and deleting SAP HANA users and adding and deleting SAP HANA roles. This means that with SAP Identity Management, you can easily manage the provisioning of users and roles in SAP HANA. However, event-based updates and adding/deleting SAP HANA objects are not supported operations in this context.

    Rate this question:

  • 16. 

    You migrate a database using the Database Migration Option (DMO). Which tools are available to monitor the migration? (2 correct) 

    • Table Splitting monitor

    • Process Bucket monitor

    • Log Tail Viewer monitor

    • Table Depooling monitor

    Correct Answer(s)
    A. Process Bucket monitor
    A. Log Tail Viewer monitor
    Explanation
    The correct answer is Process Bucket monitor and Log Tail Viewer monitor. These tools are available to monitor the migration process when using the Database Migration Option (DMO). The Process Bucket monitor helps to track the progress of data migration by monitoring the processing of data in different buckets. The Log Tail Viewer monitor allows monitoring the transaction log tail to ensure that all transactions are captured and replicated correctly during the migration process. Both tools are essential for ensuring a smooth and successful migration of the database.

    Rate this question:

  • 17. 

    You are using USER01 and are modelling a calculation view that combines existing Calculation views with tables that belong to SCHEMA02. You want to activate the new calculation view but you get the error "User is not authorized". What is the cause of the error? 

    • The calculation view was created in the "system-local" package

    • The calculation view was created in the SAP package

    • User SYS_REPO is missing object privileges for the SCHEMA02

    • USER01 is missing object privileges for SCHEMA02

    Correct Answer
    A. USER01 is missing object privileges for SCHEMA02
    Explanation
    The cause of the error is that USER01 does not have the necessary object privileges for SCHEMA02. This means that USER01 does not have the permission to access or modify the tables in SCHEMA02 that are used in the calculation view. Therefore, when trying to activate the calculation view, the system throws an error stating that the user is not authorized.

    Rate this question:

  • 18. 

    How can you minimize the Database Migration Option (DMO) downtime? 

    • During benchmarking, provide the measured table migration duration for table sequencing

    • Use the benchmarking tool for a productive database migration with the DMO procedure

    • Adjust the number of R3load processes during benchmarking and the DMO procedure

    • Run the benchmarking tool parallel to the DMO to automatically adjust the number of R3load processes

    Correct Answer
    A. Adjust the number of R3load processes during benchmarking and the DMO procedure
    Explanation
    Adjusting the number of R3load processes during benchmarking and the DMO procedure can help minimize the Database Migration Option (DMO) downtime. This allows for better control and optimization of the data migration process, potentially speeding up the migration and reducing the overall downtime. By adjusting the number of R3load processes, the system can handle the migration more efficiently, ensuring a smoother and faster transition to the new database.

    Rate this question:

  • 19. 

    You are installing SAP HANA for procedure usage but the installation stops because the hardware check failed. How do you resolve this issue? 

    • Add an additional scale-out node to your hardware configuration.

    • Use a hardware configuration listed in the Product Availability Matrix.

    • Run the script HanaHwCheck.py after the installation failed.

    • Disable the hardware check before starting the installation

    Correct Answer
    A. Use a hardware configuration listed in the Product Availability Matrix.
    Explanation
    To resolve the issue of the installation stopping due to a failed hardware check, you should use a hardware configuration that is listed in the Product Availability Matrix. This matrix provides a list of hardware configurations that are compatible and supported for SAP HANA installation. By using a hardware configuration listed in the matrix, you can ensure that the installation process will not be interrupted by hardware compatibility issues.

    Rate this question:

  • 20. 

    Which prerequisites apply when you perform an SAP HANA dB copy of a single tenant system? (2 correct)

    • The number of nodes on the target dB is the same or lower than the source dB

    • The version of the target dB is the same or higher than the source dB

    • The restore point in time (PIT) of the target dB is the same or earlier than the source dB

    • The number and type of services on the target dB can be different from the source dB

    Correct Answer(s)
    A. The number of nodes on the target dB is the same or lower than the source dB
    A. The version of the target dB is the same or higher than the source dB
    Explanation
    When performing an SAP HANA dB copy of a single tenant system, there are two prerequisites that apply. Firstly, the number of nodes on the target dB must be the same or lower than the source dB. This means that the target system cannot have more nodes than the source system. Secondly, the version of the target dB must be the same or higher than the source dB. This ensures compatibility and prevents any issues that may arise from using an older version of the dB.

    Rate this question:

  • 21. 

    You are analysing an SQL execution with the SQL Plan Cache in a distributed system. Execution time is poor and the master node is overloaded. Where do you change the configuration parameters to improve the execution time? 

    • Statisticsserver.ini

    • Executor.ini

    • Global.ini

    • Indexserver.ini

    Correct Answer
    A. Indexserver.ini
    Explanation
    To improve the execution time in a distributed system with poor performance and an overloaded master node, you need to change the configuration parameters in the indexserver.ini file. This file contains the configuration settings for the index server, which is responsible for executing SQL queries and managing data in the system. By adjusting the parameters in this file, such as memory allocation, parallel processing, and query optimization settings, you can optimize the execution time and alleviate the load on the master node.

    Rate this question:

  • 22. 

    Which parameter setting enables you to activate the load distribution and statement routing in a scale-out SAP HANA system? 

    • Client_distribution_mode

    • Distributed_reconfig_delay

    • Idle_connection_timeout

    • Reserved_connections

    Correct Answer
    A. Client_distribution_mode
    Explanation
    The parameter setting "Client_distribution_mode" enables the activation of load distribution and statement routing in a scale-out SAP HANA system. This setting determines how client connections are distributed among the different nodes in the system, allowing for efficient utilization of resources and improved performance. By enabling load distribution and statement routing, the system can effectively distribute incoming client requests across multiple nodes, balancing the workload and optimizing the overall system performance.

    Rate this question:

  • 23. 

    You are setting up a high available, distributed SAP HANA system. Which prerequisites must be met? (2 correct) 

    • The column tables were assigned to an index server manually

    • The shared storage is connected to every host

    • The index server is started on all nodes

    • The synchronized backup savepoint is set

    Correct Answer(s)
    A. The shared storage is connected to every host
    A. The index server is started on all nodes
    Explanation
    In order to set up a high available, distributed SAP HANA system, two prerequisites must be met. Firstly, the shared storage needs to be connected to every host. This ensures that all nodes have access to the same data and can operate in a distributed manner. Secondly, the index server needs to be started on all nodes. This allows for parallel processing and load balancing across the system.

    Rate this question:

  • 24. 

    You need to reset the Database Migration Option (DMO) procedure due to a hardware failover. What are the prerequisites if you want to use the DMO Reset option? (2 correct) 

    • The 'before downtime' backup needs to be available

    • The source database needs to be available

    • The clean-up procedure needs to be performed

    • The SUM folder needs to exist

    Correct Answer(s)
    A. The source database needs to be available
    A. The SUM folder needs to exist
    Explanation
    To use the DMO Reset option, two prerequisites must be met. Firstly, the source database needs to be available. This means that the database should be accessible and operational. Secondly, the SUM folder needs to exist. The SUM folder is a specific directory where the Software Update Manager (SUM) tool is located. It contains necessary files and resources for the migration process. Both these prerequisites are essential for successfully resetting the Database Migration Option (DMO) procedure after a hardware failover.

    Rate this question:

  • 25. 

    You are implementing a Tailored Data Centre Integration (TDI) multi-host SAP HANA system with failover capabilities. What are the requirements for the disk storage? (2 correct) 

    • The standby host has file access

    • The slave node is set to backup standby

    • The master node is fully clustered

    • The failed worker host gets fenced during failover

    Correct Answer(s)
    A. The standby host has file access
    A. The failed worker host gets fenced during failover
    Explanation
    The requirements for the disk storage in a Tailored Data Centre Integration (TDI) multi-host SAP HANA system with failover capabilities are that the standby host should have file access and the failed worker host should get fenced during failover. This means that the standby host should be able to access the files stored on the disk storage in order to ensure seamless failover. Additionally, the failed worker host should be fenced off during failover to prevent any potential issues or conflicts.

    Rate this question:

  • 26. 

    Which security infrastructures can you integrate with SAP HANA? 

    • Linux syslog

    • Identity management

    • Intrusion detection

    • Radius server 

    Correct Answer(s)
    A. Linux syslog
    A. Identity management
    Explanation
    The correct answer is Linux syslog and Identity management. Linux syslog is a logging system that can be integrated with SAP HANA to monitor and record system events and activities. Identity management refers to the process of managing user identities and their access to resources within an organization. Integrating identity management with SAP HANA ensures that only authorized users have access to the system and its data, enhancing security.

    Rate this question:

  • 27. 

    Due to a hardware failure, you are using a different host to recover a crashed SAP HANA dB. Which of the following configuration files must you use for the recovery? (2 correct) 

    • Xsengine.ini

    • Nameserver.ini

    • Sapprofile.ini

    • Indexserver.ini

    Correct Answer(s)
    A. Nameserver.ini
    A. Indexserver.ini
    Explanation
    To recover a crashed SAP HANA dB using a different host, you need to use the nameserver.ini and indexserver.ini configuration files. The nameserver.ini file contains the configuration settings for the SAP HANA name server, which manages the overall system landscape. The indexserver.ini file contains the configuration settings for the SAP HANA index server, which is responsible for processing queries and managing data storage. By using these two configuration files, you can ensure that the recovered dB functions properly on the new host.

    Rate this question:

  • 28. 

    What are the benefits of the Database Migration Option (DMO)? (2 correct) 

    • It supports any target database

    • It combines a dual-stack split

    • It requires only one maintenance phase

    • It supports in-place migration

    Correct Answer(s)
    A. It requires only one maintenance phase
    A. It supports in-place migration
    Explanation
    The Database Migration Option (DMO) offers several benefits. Firstly, it requires only one maintenance phase, which means that the migration process can be completed more efficiently and with less downtime. Additionally, it supports in-place migration, allowing the database to be migrated without the need for a separate target database. This simplifies the migration process and reduces the complexity.

    Rate this question:

  • 29. 

    Which backup scenarios are allowed in multitenant database containers? (2 correct) 

    • The system database can initiate its own backup and the backup of tenant databases

    • The backup of the tenant’s databases can be initiated ONLY by the system database

    • A tenant database can initiate its own backup and the backup of the other tenant databases

    • A database can initiate its own backup unless this is prohibited by the system configuration

    Correct Answer(s)
    A. The system database can initiate its own backup and the backup of tenant databases
    A. A database can initiate its own backup unless this is prohibited by the system configuration
    Explanation
    The correct answer is that the system database can initiate its own backup and the backup of tenant databases, and a database can initiate its own backup unless this is prohibited by the system configuration. This means that in a multitenant database container, the system database has the ability to back up its own data as well as the data of the tenants. Additionally, individual tenant databases can also initiate their own backups unless there are specific restrictions set by the system configuration.

    Rate this question:

  • 30. 

    Which operating system users are created when you install an SAP HANA dB? (2 correct) 

    • Sapsys

    • Sapadm

    • Adm

    • Hdb

    Correct Answer(s)
    A. Sapadm
    A. Adm
    Explanation
    When you install an SAP HANA dB, two operating system users that are created are sapadm and adm. These users are necessary for managing and administering the SAP HANA database. The sapadm user is used for administrative tasks related to the SAP HANA system, while the adm user is a standard system administration user. Both users have specific roles and permissions within the SAP HANA environment.

    Rate this question:

  • 31. 

    You need to analyse bottlenecks and forecast the requirements for your SAP HANA dB. Which tile of the SAP HANA cockpit do you select? 

    • Configure alerts

    • Disk usage

    • Number of dumps

    • Database status

    Correct Answer
    A. Disk usage
    Explanation
    To analyze bottlenecks and forecast requirements for the SAP HANA dB, the appropriate tile to select in the SAP HANA cockpit is "Disk usage." This tile provides information on the amount of disk space being used by the database, allowing you to monitor and manage storage utilization. By analyzing disk usage, you can identify any potential bottlenecks related to storage capacity and plan for future requirements accordingly.

    Rate this question:

  • 32. 

    What happens when an SAP HANA system is restarted? (2 correct)

    • Redo log is replayed since the last savepoint

    • Log mode parameter is set to normal

    • All row tables are loaded into the memory except the row tables that are configured to be loaded on demand

    • All row tables and row table attributes are loaded into the memory

    Correct Answer(s)
    A. Redo log is replayed since the last savepoint
    A. All row tables and row table attributes are loaded into the memory
    Explanation
    When an SAP HANA system is restarted, the redo log is replayed since the last savepoint. This ensures that any changes made to the database since the last savepoint are applied. Additionally, all row tables and row table attributes are loaded into the memory. This allows for quick access to the data stored in these tables.

    Rate this question:

  • 33. 

    What is the minimum memory requirement for a delta merge operation in SAP HANA? 

    • Future size of main storage + current size of delta storage + some additional memory

    • Current size of main storage + future size of main storage + current size of delta storage + some additional free memory

    • Current size of main storage + current size of delta storage + some additional memory

    • Future size of main storage + current size of delta storage + future size of delta storage + 1GB free memory

    Correct Answer
    A. Current size of main storage + future size of main storage + current size of delta storage + some additional free memory
    Explanation
    The minimum memory requirement for a delta merge operation in SAP HANA is determined by the current size of the main storage, the future size of the main storage, the current size of the delta storage, and some additional free memory. This combination of memory is necessary to ensure that the merge operation can be successfully executed without any memory constraints.

    Rate this question:

  • 34. 

    Which combination of source and target systems is allowed when you perform a database copy in a scale-out scenario? 

    • The source system can have 4 index servers The target system can have 2 index servers

    • The source system can have 2 hosts The target system can have 4 hosts

    • The source system can have 4 hosts The target system can have 2 hosts

    • The source system can have 2 index servers The target system can have 4 index servers

    Correct Answer
    A. The source system can have 4 hosts The target system can have 2 hosts
    Explanation
    In a scale-out scenario, the source system can have 4 hosts while the target system can have 2 hosts. This means that when performing a database copy, the data can be copied from a source system with 4 hosts to a target system with 2 hosts. The number of index servers is not relevant in this scenario.

    Rate this question:

  • 35. 

    The data storage of your productive SAP HANA instance crashed and you need to recover the database. The log storage is still intact. You have a full data backup that is nine hours old and an incremental backup that is four hours old. To which point in time can you recover the database?

    • The database can be recovered to the 9-hour old data backup

    • The database can be recovered to the 4-hour old incremental backup

    • The database can be recovered until the crash occurred

    • The database can be recovered to the latest log backup

    Correct Answer
    A. The database can be recovered to the latest log backup
    Explanation
    The latest log backup contains the most recent changes made to the database before the crash occurred. Therefore, recovering the database to the latest log backup will bring it back to the most up-to-date state possible before the crash.

    Rate this question:

  • 36. 

    How is a savepoint triggered in SAP HANA? (2 correct) 

    • By updating the memory

    • By committing a transaction

    • By performing a soft shutdown

    • By starting a data backup

    Correct Answer(s)
    A. By performing a soft shutdown
    A. By starting a data backup
    Explanation
    A savepoint in SAP HANA can be triggered by performing a soft shutdown or by starting a data backup. When a soft shutdown is performed, it allows the system to save the current state of the database and create a savepoint. Similarly, starting a data backup also triggers a savepoint as it involves saving the current state of the database. By updating the memory or committing a transaction, savepoints are not triggered.

    Rate this question:

  • 37. 

    You need to troubleshoot invalid object errors for stored procedures with complex structures. Which interface do you use? 

    • Visualize plan

    • Load Graph

    • Blocked Transactions

    • Dependency Viewer

    Correct Answer
    A. Dependency Viewer
    Explanation
    The Dependency Viewer interface is used to troubleshoot invalid object errors for stored procedures with complex structures. It allows you to view the dependencies between different objects in the database, such as tables, views, and stored procedures. By using the Dependency Viewer, you can identify any missing or invalid objects that may be causing the errors in the stored procedures.

    Rate this question:

  • 38. 

    You migrated an SAP Business Warehouse system to the SAP HANA platform and want use SAP HANA models in your custom ABAP reports. What must you do to make sure that the end user authorizations work properly? 

    • Regenerate the active authorizations in SAP NetWeaver AS ABAP

    • Execute the control report RSUSR_DBMS_USERS_CHECK

    • Replicate the SAP Business Warehouse authorizations to SAP HANA from the Data Warehousing Workbench

    • Map the ABAP users to the corresponding database users

    Correct Answer
    A. Execute the control report RSUSR_DBMS_USERS_CHECK
    Explanation
    To ensure that the end user authorizations work properly after migrating an SAP Business Warehouse system to the SAP HANA platform and using SAP HANA models in custom ABAP reports, it is necessary to execute the control report RSUSR_DBMS_USERS_CHECK. This report checks and synchronizes the user authorizations between the ABAP system and the underlying database, in this case, SAP HANA. By executing this report, any inconsistencies or discrepancies in the user authorizations can be identified and resolved, ensuring that the end user authorizations function correctly in the new system.

    Rate this question:

  • 39. 

    How can you check the diagnosis files when an SAP HANA database is down? (2 correct) 

    • By Viewing the files under the /usr/SAP//HDB//trace path

    • By using the Number of Dumps tile in the SAP HANA Cockpit for SAP HANA Database Administration

    • By viewing the files under the /usr/SAP//HDB//log path

    • By using the Diagnosis Files tile in the SAP HANA Cockpit for Offline Administration

    Correct Answer(s)
    A. By Viewing the files under the /usr/SAP//HDB//trace path
    A. By using the Diagnosis Files tile in the SAP HANA Cockpit for Offline Administration
    Explanation
    The correct answer is "By Viewing the files under the /usr/SAP//HDB//trace path" and "By using the Diagnosis Files tile in the SAP HANA Cockpit for Offline Administration". These options provide ways to access the diagnosis files when the SAP HANA database is down. The first option allows users to directly view the files located in the specified path, while the second option provides a specific tool, the Diagnosis Files tile in the SAP HANA Cockpit, for offline administration, which includes accessing the diagnosis files.

    Rate this question:

  • 40. 

    What do you do to prepare a database migration option (DMO) of software update manager(SUM) procedure? (3 correct)

    • Move the R3trans update archive into the download folder

    • Extract the SAP HANA Client installation archive

    • Extract the SAP HANA Database installation archive

    • Move the stack.xml update file into the download folder

    • Move the SPAM update archive into the download folder

    Correct Answer(s)
    A. Extract the SAP HANA Client installation archive
    A. Move the stack.xml update file into the download folder
    A. Move the SPAM update archive into the download folder
    Explanation
    To prepare a database migration option (DMO) of software update manager (SUM) procedure, you need to extract the SAP HANA Client installation archive, move the stack.xml update file into the download folder, and move the SPAM update archive into the download folder. These steps are necessary for the successful execution of the migration process.

    Rate this question:

  • 41. 

    Which of the following are characteristics of a design-time role (3 correct)? 

    • It is revoked if the grantee user is deleted

    • It is granted through the execution of stored procedures

    • It is granted and revoked directly by an administrator

    • It can be transported between systems

    • It is created by the technical user _SYS_REPO

    Correct Answer(s)
    A. It is granted through the execution of stored procedures
    A. It can be transported between systems
    A. It is created by the technical user _SYS_REPO
    Explanation
    A design-time role is granted through the execution of stored procedures because these procedures are responsible for assigning the necessary privileges and authorizations to the role. It can be transported between systems, meaning that it can be exported from one system and imported into another, allowing for consistent role assignments across different environments. Lastly, it is created by the technical user _SYS_REPO, indicating that this user has the authority and capability to define and manage design-time roles.

    Rate this question:

  • 42. 

    You need to analyse data points which are continuously sent from a factory robot to SAP HANA. Which of the following SAP HANA services do you use? 

    • SAP Landscape Transformation

    • SAP Smart Data Integration

    • SAP Remote Data Sync

    • SAP Smart Data Streaming

    Correct Answer
    A. SAP Smart Data Streaming
    Explanation
    SAP Smart Data Streaming is the correct answer because it is a service specifically designed for real-time data analysis and processing. It allows for the continuous analysis of data points sent from the factory robot to SAP HANA, enabling real-time decision-making and monitoring. SAP Landscape Transformation is used for data migration and system consolidation, SAP Smart Data Integration is used for data integration and replication, and SAP Remote Data Sync is used for remote data synchronization, but they are not specifically designed for real-time data analysis like SAP Smart Data Streaming.

    Rate this question:

  • 43. 

    Which backup scenarios can you perform in multitenant database containers? (2 correct) 

    • Backups of all the tenant databases from the system database

    • Log backups for your own tenant database from your tenant database

    • Storage snapshot backups per tenant database

    • Backup of your own tenant database

    Correct Answer(s)
    A. Backups of all the tenant databases from the system database
    A. Backup of your own tenant database
    Explanation
    In a multitenant database container, you can perform backups of all the tenant databases from the system database. This means that you can create backups of all the databases within the container, including those belonging to other tenants. Additionally, you can also perform a backup of your own tenant database, ensuring that your data is protected.

    Rate this question:

  • 44. 

    You want to protect your SAP HANA scale-out system from hardware failures. Which option do you choose to benefit from automatic failure detection? 

    • System replication

    • Standby mode

    • Storage replication

    • Automatic save point

    Correct Answer
    A. Standby mode
    Explanation
    Standby mode is the correct option to choose in order to benefit from automatic failure detection in a SAP HANA scale-out system. Standby mode allows for automatic detection and recovery from hardware failures by maintaining a standby instance that can take over in case of a failure. This ensures high availability and minimizes downtime in the event of hardware failures. System replication, storage replication, and automatic save point do not provide the same level of automatic failure detection and recovery as standby mode.

    Rate this question:

  • 45. 

    Which of the following tasks can you perform using the resident SPA HANA database lifecycle manager (HDBLCM)? (3 correct) 

    • Import of delivery units

    • Configure inter-service communication

    • Transport application changes

    • Update the system components

    • Unregister the SAP HANA system

    Correct Answer(s)
    A. Configure inter-service communication
    A. Update the system components
    A. Unregister the SAP HANA system
    Explanation
    The resident SPA HANA database lifecycle manager (HDBLCM) allows users to configure inter-service communication, update the system components, and unregister the SAP HANA system. These tasks can be performed using the HDBLCM tool to manage and maintain the HANA database effectively. Import of delivery units and transport application changes are not tasks that can be performed using HDBLCM.

    Rate this question:

  • 46. 

    Which authorization assignments are possible when you set up an authorization concept in the SAP HANA database? (2 correct) 

    • A privilege can be granted to a user

    • A role can be granted to a role

    • A role can be granted to a catalog object

    • A user can be granted to a role

    Correct Answer(s)
    A. A privilege can be granted to a user
    A. A role can be granted to a role
    Explanation
    In the SAP HANA database, when setting up an authorization concept, it is possible to grant a privilege to a user. This means that specific privileges, such as the ability to access certain data or perform specific actions, can be assigned to individual users. Additionally, a role can be granted to a role, allowing for the delegation of authorization responsibilities within the system. This means that a higher-level role can be assigned to another role, granting the same set of authorizations to multiple users associated with that role.

    Rate this question:

  • 47. 

    You created a repository object in SAP HANA. Who can access the generated runtime object right after the activation? 

    • The _SYS_REPO user

    • The user who created the repository object

    • The user who started the activation

    • The SYSTEM user

    Correct Answer
    A. The user who created the repository object
    Explanation
    After creating a repository object in SAP HANA, the user who created the object can access the generated runtime object right after the activation. Since the user is the one who created the object, they have the necessary privileges and permissions to access it immediately.

    Rate this question:

  • 48. 

    Which of the following security KPI’s can you monitor in the SAP HANA cockpit? (2 correct)

    • Password Policy

    • Manage users

    • Data backup

    • Data storage security

    Correct Answer(s)
    A. Password Policy
    A. Data storage security
    Explanation
    In the SAP HANA cockpit, you can monitor the security KPIs related to Password Policy and Data storage security. Password Policy refers to the rules and requirements set for user passwords, such as complexity and expiration. Monitoring this KPI ensures that strong password policies are in place to protect against unauthorized access. Data storage security involves monitoring the security measures implemented to protect the data stored in SAP HANA, such as encryption, access controls, and backups. Monitoring this KPI helps ensure the confidentiality, integrity, and availability of the data.

    Rate this question:

  • 49. 

    You are implementing a system replication for an SAP HANA system. How is the secondary SAP HANA database synchronized with the with the primary SAP HANA database (choose 2)? 

    • Each service on the secondary database establishes a connection with its primary database

    • Each transaction committed on the primary database is also committed on the secondary database

    • Every commit is written to a shared sub directory between the primary database and secondary database

    • An initial snapshot and the redo log are transferred from the primary database to the secondary database

    Correct Answer(s)
    A. Each service on the secondary database establishes a connection with its primary database
    A. An initial snapshot and the redo log are transferred from the primary database to the secondary database
    Explanation
    The secondary SAP HANA database is synchronized with the primary database through two methods. Firstly, each service on the secondary database establishes a connection with its primary database, allowing for real-time data replication and synchronization. Secondly, an initial snapshot and the redo log are transferred from the primary database to the secondary database, ensuring that all changes made on the primary database are replicated on the secondary database. These two methods work together to keep the secondary database synchronized with the primary database in real-time.

    Rate this question:

Quiz Review Timeline (Updated): Aug 29, 2023 +

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

  • Current Version
  • Aug 29, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Aug 10, 2017
    Quiz Created by
    Hana Banana
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.