Skip to Content

Update February 2018

The C_HANATEC_11 exam is no longer available as of December 31, 2017.

For more information, see

For the latest version of this blog, see


Are you interested in getting certified as SAP HANA database administrator? In this blog, I will explain how you can prepare for the SAP Certified Technology Associate – SAP HANA certification exam. This exam covers the traditional DBA topics like monitoring, operations, security, backups, etc..


As all E_HANAINS exams will be retired by the end of 2016, C_HANATEC_11 also serves as the certification required for supported installations ( SAP HANA TDI – Overview). For more information, see Recent changes in the SAP HANA Technology certification program 2016.


This blog is part of a series:


About the Certification


At the time of writing there are four editions of the SAP Certified Technology Associate – SAP HANA certification:


If you are already certified for a previous edition of the exam, you might want to consider the SPS 10 delta certification, otherwise it is best to take the latest version.


Initially, the exam was numbered by year and version, so 151 would be for edition 2015 version 1, without any clear reference to the SAP HANA SPS release. This now has changed and we have HANATEC 11 for SPS 11 and HANATEC 10 for SPS 10.


For SPS 10, a delta exam is available with only half the number of questions (for half the price).


For the latest information for SAP Education, check the certification page on the SAP Training& Certification shop or see the blog by Haythem OUESLATI on SCN: SAP HANA SPS11 courses and certification program 2016. See also Frequently Asked Questions about SAP Certification for the FAQ (validity, etc.)


Topic Areas


There are 80 questions divided over 10 topic areas. Cut score = 64% for TEC 11 (56% for TEC151), which means that you need to answer at least 51 questions correct; a bit higher than usual.


There are 10 topics and as of TEC 11 they have the same relative weight (8-12%, or 5 – 10 questions):


  • System architecture
  • High Availability and Disaster Tolerance
  • Backup and Recovery
  • Troubleshooting
  • Monitoring
  • Operations
  • Installation and Upgrade
  • Security
  • Users and Authorization
  • Database Migration


In earlier editions the topics ‘Security’ and ‘Users and Authorization’ were grouped together and the topic ‘Data Provisioning‘ was also included. For TEC 11 there are no questions about provisioning topics like SLT, Data Services, BusinessObjects, etc. (at least, not in my exam).




There are three SAP Education training resources:


Training participation is not a requirement, however, because of the direct relation of the exam with the trainings, participation is certainly recommended. If you can only attend one training, make it HA200.


Additional resources as preparation for the exam are publicly available on the SAP Help Portal (


Note that the SAP Help Portal on only shows the latest documentation, SPS 12 at the time of writing. For SPS 11 and older you need to go to the SAP Service Marketplace on


The Database Migration Option (DMO) of the Software Update Manager (SUM) tool is not included in the SAP HANA documentation set but part of the System Landscape Toolset on the SAP Service Market Place (requires login). A good start is the SCN document Database Migration Option (DMO) of SUM – Introduction.


You also may want to take a look at SAP note 1905389Additional Material for HA200 and HA200R. This note contains additional information and documents. Most of the SAP Notes mentioned are also listed in the Server Installation and Update Guide under Important SAP Notes.


SAP HANA Academy


To help you prepare for the exam, there are several playlists with dozens of tutorial videos on the SAP HANA Academy channel on YouTube, free of charge.


Sample questions


On the certification page, a link to a PDF with sample questions is included. Below I marked the answers in bold and included a reference to the source with some tips and to do’s.




1. Your customer is performing a full data backup every week and a delta backup daily. You need to implement the shortest recovery method for an SAP HANA database.


a) 1. Full data backup; 2. Log backup; 3. Incremental backup

b) 1. Full data backup; 2. Incremental backup; 3. Log backup

c) 1. Full data backup; 2. Differential backup; 3. Log backup

d) 1. Full data backup; 2. Log backup; 3. Differential backup


This should be an easy question to answer.


Source: The difference between incremental and differential backup, and between data and log backups are explained in HA200 (Unit 8 Lesson 2), in the SAP HANA Administration Guide (SAP HANA Database Backup and Recovery – SAP HANA Administration Guide – SAP Library). See also SAP HANA SPS 10 What’s New: Database Backup and Recovery – by the SAP HANA Academy


Both incremental and differential only apply to data backups and the restore sequence is always: first data, then log. This rules out options d and a.

Incremental data backups provide short backup time but longer restore time, compared to differential. Hence, only answer c is correct.


To do: Study the backup and recover section of either HA200 or the Administration Guide and perform all tasks described. It is much easier to remember the different concepts and tasks if you have hand-on experience.


There is a complete playlist on the SAP HANA Academy channel: Database Backup and Recovery – YouTube


Tutorial video:





2. You plan to migrate a non-SAP database to SAP HANA using the Database Migration Option of the Software Update Manager SP16.


Which URL should you use?

a) http://<host>:<port>/lmsl/sumabap/<SID>/doc/sluigui

b) http://<host>:<port>/lmsl/HDBLCM/<SID>/index.html

c) http://<host>:<port>/lmsl/upgrade/<SID>/doc/gui

d) http://<host>:<port>/lmsl/sumabap/<SID>/doc/gui


Tricky question, all URL’s are valid.


Source: The URL is mentioned in HA250 Unit 3, Configuration of DMO Procedure and is also used in exercise 5. Other sources are, on SCN, Database Migration Option (DMO) of SUM – Introduction and  SAP First Guidance – Using the DMO Option to Mi… | SCN


The URL of b) is valid but returns the web user interface of the SAP HANA database lifecycle manager (HDBLCM), as documented in Use the Web User Interface to Perform Platform LCM Tasks – SAP HANA Administration Guide – SAP Library


The URL of c) and d) are valid for older SUM versions but not for SUM SP 16.


To do: As with question 1, do not only study the material but perform hands-on the exercises or tasks described. Focus on URLs, tabs, screens, etc., as questions can be very detailed.


Screen Shot 2016-08-17 at 10.59.38.png




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


a) async

b) syncmem

c) sync

d) full sync


This should be an easy question to answer. All the answers are valid replication modes but only one forces a suspension.


Source: The different log replication modes are explained in HA200 (Unit 11 Lesson13) and also in the Administration Guide (SAP HANA Disaster Recovery Support – SAP HANA Administration Guide – SAP Library).


Screen Shot 2016-08-17 at 11.34.21.png


To do: As with the previous questions; read the concepts but above all perform the activities. Experience counts here.


There is a complete playlist on the SAP HANA Academy channel: SAP HANA System Replication – YouTube


See also and


Tutorial video:





4. Which role do you need to have assigned to configure the kernel profiler?




c) sap.hana.xs.lm.roles::Administrator

d) sap.hana.admin.roles::Monitoring


This should be an easy question to answer.


Source: Configuring traces is discussed in HA200 (Unit 7, Lesson 5) and the SAP HANA Administration Guide (Getting Support – SAP HANA Administration Guide – SAP Library).


Screen Shot 2016-08-17 at 12.00.56.png

To do: Try out the different traces available, check the output and requirements.


Tutorial video:





5. What is the correct hierarchy of the SAP HANA component model?


a) Product > Package > Delivery Unit > Object

b) Package > Product > Delivery Unit > Object

c) Delivery Unit > Product > Package > Object

d) Product > Delivery Unit > Package > Object


Again, this should be an easy question to answer.


Source: Application Lifecycle Management is discussed in HA200 (Unit 7, Lesson 8) and the SAP HANA Administration Guide (SAP HANA Application Lifecycle Management – SAP HANA Administration Guide – SAP Library).




Screen Shot 2016-08-17 at 12.20.29.png

To do: Read about the concepts and practice with exporting and importing delivery units (DU) using the different interfaces for ALM (HANA studio, HALM web UI, command line).


See also:


Tutorial video:





6. You are planning a batch installation for a scale-out system. Which settings do you need to make in the configuration file? 2 correct answers.


a) The instances on all hosts must use an identical instance number.

b) The user ID of the <sid>adm user must be identical on all hosts.

c) The max_mem parameter must be specified for the sum of all hosts

d) The hostname specified must be identical on all hosts


Again, again, this should be an easy question to answer. Unfortunately most questions in the exam are not this easy!


When the hostname is the same on all hosts there is not way to tell them apart, so option d makes no sense. Option c seems to suggest that you need to sum up the memory of all hosts and set this on each host with the max_mem parameter. Makes no sense either. See max_mem – SAP HANA Server Installation and Update Guide – SAP Library


A distributed system has the same system identifier (SID), hence the same <sid>adm user, and the same instance number.


Source: How to install an SAP HANA scale out system is an exercise in HA200 (Unit 11, Lesson 2 and Exercise 23) and the SAP HANA Server Installation Guide (Installing a Multiple-Host System – SAP HANA Server Installation and Update Guide – SAP Library).


To do: As above, read the instructions and perform an installation. Getting your hands on a cluster might be a bit of a challenge of course, but at least go through the screens step by step.


There is a complete playlist on this topic on the SAP HANA Academy channel: SAP HANA Installation and Update – YouTube


Tutorial video:





7. What privileges can you manage with the SAP HANA Live authorization assistant? 2 correct answers.


a) Analytical

b) Application

c) System

d) Object


Tricky question as the authorization assistent is outside of the scope of the SAP HANA documentation. Unless you attended the training or have any experience with SAP HANA Live you might never have heard about it.


Source: The SAP HANA Live authorization assistent is discussed in HA200 (Unit 10, Lesson 6).


Screen Shot 2016-08-17 at 13.25.35.png


See also SAP HANA Live Authorization Assistant – SAP Library and Installing SAP HANA Live Authorization Assistant – SAP HANA Live Tools 1.0 – SAP Library


To do: No recommendation here except to attend the training for the off scope topics.




8. You have to load data in real time from external systems into SAP HANA. Which Data Provisioning tools can you use? 3 correct answers.


a) SAP LT Replication Server (SLT)

b) Smart Data Access (SDA)

c) SAP Replication Server (SRS)

d) SAP Data Services (SDS)

e) Smart Data Integration (SDI)


Questions about data provisioning are only relevant for SPS 10 and older exams, as the topic is no longer included in TEC 11.


Source: Data Provisioning is discussed in HA100 (Unit 4) and in the new HA 350 – SAP HANA Data Provisioning training. The topic is also explained in the SAP HANA Master Guide (SAP HANA Data Provisioning – SAP HANA Master Guide – SAP Library). See also


To do: You can ignore data provisioning for TEC 11. For the older exams, make sure you are familiar with what purpose each of the products (SLT, SRS, DXC, DS) or options (SDA, SDI, SDS) serves and how it works, e.g. how SLT connects to a non-SAP source.


There are multiple playlists about provisioning (SDI, SDQ, SDA, DWF, SDS, DT, DS) on the SAP HANA Academy:   SAP HANA Academy – Provisioning




9. You are using SAP Solution Manager to troubleshoot your SAP HANA database. What can you analyze? 3 correct answers.


a) Memory usage

b) Linux system logs

c) Locked users

d) Alert status

e) Services availability


You can expect a few questions about SAP Solution Manager, which might be challenging if you are not familiar with the product.


Source: Monitoring with SAP Solution Manager is discussed in HA200 (Unit 13 Lesson 1) and the SAP HANA Administration Guide (SAP Solution Manager for SAP HANA – SAP HANA Administration Guide – SAP Library). See also, SAP HANA Operations with SAP Solution Manager – Technical Operations – SCN Wiki


To do: Read up about how to configure SAP Solution Manager for SAP HANA and how to use it for monitoring. Ideally, create a sandbox environment and setup SAP Solution Manager monitoring for SAP HANA yourself.


Screen Shot 2016-08-17 at 14.12.50.png



10. Which of the following tools can you use to create and manage SAP HANA database users? 2 correct answers.


a) SAP Solution Manager

b) SAP Identity Management

c) SAP Web IDE

d) Microsoft Active Directory


This question should not be to hard to answer. You can create users in Microsoft AD of course and you can use Kerberos authentication to map AD users to HANA users, but you cannot use AD to create HANA users so this option can be discarded. Same for option a) as SAP Solution Manager is a systems management tool for SAP systems, not to create users. For this purpose, SAP offers its Identity Management solution. Native SAP HANA tools to create users are hdbsql (using SQL), HANA studio (using the User Editior or SQL) and the Web IDE.


Source: Monitoring with SAP Solution Manager is discussed in HA200 (Unit 10 Lesson 1) and the SAP HANA Administration Guide (Managing SAP HANA Users – SAP HANA Administration Guide – SAP Library)


To Do: familiarise yourself with creating and managing users and roles using the different tools available. See also SAP HANA User Management – SAP HANA Security Guide – SAP Library, SAP HANA Authentication and Single Sign-On – SAP HANA Security Guide – SAP Library and SAP HANA Authentication and Single Sign-On – SAP HANA Security Guide – SAP Library


There are several videos about authorisation and user management in the security playlist: SAP HANA Security – YouTube

For Web IDE, see SAP Web IDE – YouTube



More Questions?


Unfortunately, but very reasonably, those that have passed the exam are not allowed to share the questions with anyone else, so I can’t share any particular question with you here. However, a close study of the mentioned resources should provide you with enough knowledge to successfully pass the exam.


Additional Resources



Did you succeed?


Feel free to post a comment about how the exam went. If there is any information missing, please let me know.




Thank you for watching

The SAP HANA Academy provides free online video tutorials for the developers, consultants, partners and customers of SAP HANA.

Topics range from practical how-to instructions on administration, data loading and modeling, and integration with other SAP solutions, to more conceptual projects to help build out new solutions using mobile applications or predictive analysis.

For the full library, see SAP HANA Academy Library – by the SAP HANA Academy.

For the full list of blogs, see Blog Posts – by the SAP HANA Academy.

To report this post you need to login first.


You must be Logged on to comment or reply to a post.

    1. Denys Kempen Post author



      The official documentation is the student manual of course HA200 (and 240/250). However, as mentioned in the blog, you can find most of the same information in the mentioned guides on the SAP Help Portal.

  1. Former Member

    Hi Denys,

    Thanks for the information.

    Do you by any chance know of any resource that can be used for doing a hands-on with HANA administrative tasks? Any demo server or something on cloud?

    1. Denys Kempen Post author

      Hi Abhishek,


      See Try SAP HANA


      You can sign up for a free developer account on cloud-based servers, or, if you want full access for all administration tasks described above, try out SAP HANA One.



  2. Former Member

    Hi Denys,

    Currently I am preparing for C_HANATEC_11 exam after passing the C_HANATEC151 last year. Couple of questions I have
    1. Is the Unit 12 of HA200 i.e MDC included in the exam as it is not specifically mentioned in the exam syllabus?
    2. Is the appendix section important for the exam?
    3. As per your blog, data provisioning is out of scope of the exam. Please can you confirm the same.

    1. Denys van Kempen Post author

      Hi Amit,

      1. You are right. MDC is not mentioned as topic area, so it is not included.

      2. The appendix of the HA200 course book concerns monitoring with Solution Manager, Remote Support, and Early Watch Alert. Non of these topics are listed in the topic area so there should not be any questions about it. It might be prudent to read the appendix nevertheless, just in case.

      3. I wrote the blog to the best of my knowledge at that time. However, I do not work for SAP Education and do not have any inside knowledge and have to rely, just like you and anyone else about what is publicly available:—sap-hana-edition-2016-g/

      PS: According to–operations-sap-hana-sps12-g-en the SPS 12 exam will be available soon, so you might want to give Certification a call about how soon soon is.


  3. Former Member

    Many thanks Denys. I have already booked the C_HANATEC11 exam so I would be opting for that and I guess it will be valid for some time as all other E*/D*/C* Hanatec exams on previous versions are expiring on 31/12/2016.

  4. Former Member


    someone please confirm if “Multitenant Database containers” is part of exam questions for C_HANATEC_11/12 certification.

    As i was going through list of topic areas for C_HANATEC_12 certification and i did not find MDC in the list of topics for exam.



    1. Denys van Kempen Post author


      If it is not on the list of topics for the exam, there will be no questions about it.

      I confirm this for TEC_11, have not done TEC_12 yet but will give it try and let you know.

      1. Former Member


        Pleased to inform, i passed TEC_12 exam today. Today was the first day for certifications for version SP12.

        So the update is, although the scope of exam does not mention MDC anywhere, but there were atleast 8-10 questions on MDC topic in each group e.g HA, Backup, security, operations.

        1. Former Member

          Hi Vikas,


          I am about to give HANATEC 12 in April. I want to know is it necessary to go thruogh ADMIN guide or HA200,240,250 and 100 are enough. As i see admin guide is 1300 pages.

          I see Admin guide is detail  with MCD database.




          1. Former Member


            HA200, HA240, HA250  Yes

            HA100 Not needed.

            Admin Guide just for details on each topic already covered in training material.

            Good Luck

    1. Denys van Kempen Post author


      According to

      As a rule SAP considers certifications on the two most recent solution release levels to be current and valid but this can vary for some solutions 

      In other words, it depends.

      You can look them up here:

      Today (Jan 31, 2017), HANATEC 10, 11 and 12 are valid. So the certification lasts about 2 years, it seems. To be sure, contact Education.

  5. Former Member

    Hi Denys,

    In C_HANATEC_11 how many questions can expect from scale out, Table administration and redistribution, Security and DMO ?  My certification is scheduled for 17th 2017




  6. Former Member

    Hello Denys,

    Thanks for sharing the info..

    C_HANATEC_11 is very important point.

    The “SAP Certified Technology Associate – SAP HANA (Edition 2016)” certification exam verifies that the candidate possesses the required knowledge in the area of the SAP HANA (SPS11) for the profile of an SAP HANA technology consultant. This certificate builds on the basic knowledge gained through related SAP HANA training and preferably refined by practical experience within an SAP HANA project team, whereby the consultant applies the acquired knowledge practically in projects.

  7. Syed Rehman

    Hi Denys

    Quick question. If I take the C_Hanatech 11 cert this month. Will it still be valid going into 2018 and 2019?

    Thank you for your time.

      1. Syed Rehman

        I am a bit uncertain by what that means. Are you implying that if someone sat for and passed C_HANATEC_11 then the cert. is only valid for 1 more month, or is it that the exam will expire and no longer be offered?

        I appreciate your time and patience in answering questions. I am new to this industry and am only starting my journey.


        1. Denys van Kempen Post author

          You’re welcome and thanks for asking.

          Certification is a “product” from SAP Education, so my colleagues would be best positioned to answer this type of question.

          My understanding is that it will no longer be offered and no longer be valid.

          You can always contact Education directly, to get the ‘official’ answer.






Leave a Reply