SAP Certified Technology Associate: C_HANATEC_11 – by the SAP HANA Academy
LATEST UPDATE: November, 2020 =========================================
The SAP Certified Technology Associate: C_HANATEC_11 certification is no longer valid.
For the latest information, visit our blog post series about SAP HANA certification:
For the SAP Press Certification Success Guide, see
For the blog post, see
Update January 2020
For the latest version of this blog, see
- SAP Certified Technology Associate: C_HANATEC_16 (SAP HANA 2.0 SPS 04)
Update February 2018
The C_HANATEC_11 exam is no longer available as of December 31, 2017.
For more information, see https://training.sap.com/certification/validity
For the latest version of this blog, see
- SAP Certified Technology Associate: C_HANATEC_13 (SAP HANA 2.0 SPS 00)
- SAP Certified Technology Associate: C_HANATEC_12 (SAP HANA 1.0 SPS 12)
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:
- SAP Certified Technology Associate: C_HANATEC_11 – by the SAP HANA Academy (this blog)
- SAP Certified Technology Associate: SAP HANA (Edition 2013 / 2014) (previous version)
- SAP Certified Technology Specialist: SAP HANA Installation (Edition 2015) (due to retire end of 2016)
- SAP Certified Technology Specialist: SAP HANA Installation (Edition 2013 / 2014) (due to retire end of 2016)
About the Certification
At the time of writing there are four editions of the SAP Certified Technology Associate – SAP HANA certification:
- Edition 2016 (SPS 11) – C_HANATEC_11
- Edition 2015 Delta (SPS 10) – D_HANATEC_10
- Edition 2015 (SPS 10) – C_HANATEC_10
- Edition 2015 (SPS 09) – C_HANATEC151
- Edition 2014 (SPS 08) – C_HANATEC142
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.)
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
- Installation and Upgrade
- 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:
- HA200 SAP HANA – Operations & Administration – 5 days, most topics
- HA240 Authorization, Security and Scenarios – 2 days, for topics ‘Users and Authorization’ and ‘Security’
- HA250 Migration to SAP HANA using DMO – 2 days, for the topic ‘Database Migration’
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 (help.sap.com):
- SAP HANA Administration Guide (1326 pages)
- SAP HANA Security Guide (270 p.)
- SAP HANA Troubleshooting and Performance Analysis Guide (212 p.)
- SAP HANA Master Guide (100 p.)
- SAP HANA Server Installation and Update Guide (224 p.)
Note that the SAP Help Portal on http://help.sap.com/hana_platform 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 http://service.sap.com/hana.
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 1905389 – Additional 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.
- SAP HANA Installation and Update
- SAP HANA Administration
- SAP HANA Security
- SAP HANA System Replication
- Backup and Recovery
- Multitenant Database Containers
- Monitoring SAP HANA
- Sizing SAP HANA
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
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?
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.
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?
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).
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
4. Which role do you need to have assigned to configure the kernel profiler?
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).
To do: Try out the different traces available, check the output and requirements.
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).
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).
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
7. What privileges can you manage with the SAP HANA Live authorization assistant? 2 correct answers.
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).
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).
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.
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
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.
- SAP HANA – a guide to Documentation and Education
- Blog: SAP HANA for Beginners | SAP HANA
- Want to learn SAP HANA? Where to Start? Certification?
- The SAP Hana Reference for SAP Basis Administrators
- SAP HANA Administration. of Richard Bremer, Lars Breddemann – by SAP PRESS
Did you succeed?
Feel free to post a comment about how the exam went. If there is any information missing, please let me know.
Share and Connect
Questions? Post as comment.
Useful? Give a like and share on social media. Thanks!
If you would like to receive updates, connect with me on
- LinkedIn > linkedin.com/in/dvankempen
- Twitter > @dvankempen
For the author page of SAP Press, visit
Nice work and important info.
Thanks for sharing.
how soon C_HANATEC_11 will be valid? C_HANATEC_12 has just came.
Is there any official learning documentation for HANATEC_11?
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.
Thanks for sharing the info. Exclusion of HA100 in C_HANATEC_11 is very important point.
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?
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.
Thanks for sharing your experience Denys, I will take the HANATEC soon, and your article is so helpful.
Best regards from Chile,
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: https://training.sap.com/shop/certification/c_hanatec_11-sap-certified-technology-associate---sap-hana-edition-2016-g/
PS: According to https://training.sap.com/g/en/curriculum/hana_install_sps12-sap-hana-installation--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.
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.
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.
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.
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.
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.
HA200, HA240, HA250 Yes
HA100 Not needed.
Admin Guide just for details on each topic already covered in training material.
Do you n ow how long c_hanatec_12 exam will be valid ?
According to https://training.sap.com/shop/help-center/faq/topic/do-current-certificates-retain-their-validity
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: https://training.sap.com/shop/certification/validity
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.
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
According to https://training.sap.com/shop/certification/c_hanatec_11-sap-certified-technology-associate---sap-hana-edition-2016-g/ 8% -12% of the questions are on each of these topics.
80 questions in total, so that would make 6 to 10 questions on each of these topics.
Very informative, blog... Have book marked this.
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.
For validity, see: https://training.sap.com/certification/validity
C_HANATEC_11 – SAP Certified Technology Associate – SAP HANA (SPS11) is listed to expire December 31, 2017.
Thanks for watching,
Denys / SAP HANA Academy
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.
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.
Thank you again.
I will contact them. But I have decided to take a more recent exam.