Skip to Content

Update March, 2017

For the most recent version of this blog series, see 

SAP Certified Technology Associate: C_HANATEC_12 – by the SAP HANA Academy

Introduction

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

 

Resources

 

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 (help.sap.com):

 

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 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 http://scn.sap.com/community/hana-in-memory/blog/2015/05/19/sap-hana-system-replication and http://scn.sap.com/docs/DOC-47702

 

Tutorial video:

 

 

==

 

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

 

a) MONITORING

b) SAP_INTERNAL_HANA_SUPPORT

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: http://scn.sap.com/community/it-management/alm/software-logistics/blog/2015/03/31/transport-of-hana-objects-with-halm

 

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 http://scn.sap.com/community/developer-center/hana/blog/2016/07/05/the-various-data-provisioning-options-for-hana

 

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.

 

Success!

 

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.

27 Comments

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

    1. Denys van Kempen Post author

      Hi,

       

      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.

      (0) 
  1. Abhishek Singh

    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?

    (0) 
    1. Denys van 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.

       

      Success!

      (0) 
  2. Amit Acharya

    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.

    (0) 
    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: 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.

      Success
      D

      (0) 
  3. Amit Acharya

    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.

    (0) 
  4. Vikas Kaul

    Hi,

    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.

    Thanks

     

    (0) 
    1. Denys van Kempen Post author

      Hi,

      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.

      (0) 
      1. Vikas Kaul

        Hi,

        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.

        (0) 
        1. Abhishek Saraswat

          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.

           

          Thanks

          Abhishek

          (0) 
          1. Vikas Kaul

            Hi,

            HA200, HA240, HA250  Yes

            HA100 Not needed.

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

            Good Luck

            (0) 
    1. Denys van Kempen Post author

      Hi,

      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.

      (0) 
  5. Ibrahim Yooseff

    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

     

    Thanks

    Ibrahim

    (0) 
  6. Sara jain

    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.

    (0) 
  7. Syed Rehman

    If you look at the current pdf link of practice questions for Hanatec11. There are questions about data provisioning. You may not have had any but it doesnt necessarily mean they dont exist.

    (0) 
    1. Denys van Kempen Post author

      Hi Syed,

      For the blog, I turned the argument around.

      The fact that there is a sample question about Data Provisioning does not mean you get questions about the topic on the exam.

      For each certification, SAP Education publishes the topic area. For HANATEC11, Data Provisioning is no longer included (it was for earlier versions). Hence my suggestion not to focus too much on the topic.

      However, you are right, of course, SAP Education also states that:

      … below the list of topics that may be covered within this certification and the courses that cover them. Its accuracy does not constitute a legitimate claim; SAP reserves the right to update the exam content (topics, items, weighting) at any time.

      So, the exam may have been changed.

      Did you take the exam and had questions about data provisioning?

       

      (0) 
      1. Syed Rehman

        Thanks for the reply, I appreciate it.

        I am taking the exam in two days. I will let you know if I see any questions regarding data provisioning.

        Regards
        Syed

        (0) 

Leave a Reply