C_HANATEC_11 SAP Certified Technology Associate – SAP HANA (SPS11),SAP,170 Exam

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)

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

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

Sample questions

Question: 1
You are installing SAP HANA using hdblcmgui and want to ensure that the SAP Hana database is automatically started when the host is restarted.
How do you accomplish this?
Please choose the correct answer.
Response:

A. set the environment parameter ‘auto start = yes’ before you execute hdblcmgui
B. set the environment parameters ‘auto start = true’ before you execute hdblcmgui
C. Execute hdblcmgui and select ‘restart instance after machine reboot?’
D. execute the resident hdblcmgui and set the parameter to ‘autostart = 1’

Answer: D

Question: 2
A user is locked due to too many failed login attempts Which SQL commands can solve this problem?
Please choose the correct answer.
Response:

A. ALTER USER <username> DISABLE PASSWORD LIFETIME
B. ALTER USER <username> RESET CONNECT ATTEMPT
C. ALTER USER <username> FORCE PASSWORD CHANGE
D. ALTER USER <username> ACTIVE USER NOW

Answer: B

Question: 3
You want to measure the impact of a new workload on the memory usage of the SAP HANA services
Which memory indicator would you reset?
Please choose the correct answer.
Response:

A. virtual memory
B. Peak used memory
C. Used memory
D. Resident memory

Answer: B

Question: 4
Which delivered role is mandatory for a system administrator in SAP HANA?
Please choose the correct answer.
Response:

A. CONTENT_ADMIN
B. IC MODELER
C. SYS_ADMIN
D. SAP_ALL

Answer: A

Question: 5
How can you remove add data backups both from the backup catalog and physically from the server?
Please choose the correct answer.
Response:

A. Select a backup on the backup catalog tab of the backup console and select delete older backups from the context menu.
B. execute the command backup.sh -id -cl from the operating system
C. execute the SQL statement DELETE from m_backup_catalog where backup_ID = 2 <backup_ID> from the SQL console
D. open a shell and delete all files under $(DIR_INSTANCE) backup data

Answer: A