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 https://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 https://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
Click
here to view complete Q&A of C_HANATEC_11 exam
Certkingdom Review,
Certkingdom PDF Torrents
Best SAP HANA C_HANATEC_11 Certification, SAP HANA Certification C_HANATEC_11 Training at certkingdom.com