SAP Certified Development Associate – SAP HANA 2.0 SPS05

What’s New

Topics and Weight

Both the exam and the associated trainings for the C_HANADEV_17 certification for SAP HANA 2.0 SPS 05 are very similar to its predecessor C_HANADEV_16 for SAP HANA 2.0 SPS 04. What’s new and what’s changed?

There have been no changes to the topic areas and relative weights.

Minor changes were made to the HA450 course but this mostly concerns reshuffling of the content; six lessons from the appendix made their way back into the course again as Unit 2.

The same applies to the other source of input: HA300; some figures we updated, a bit of text added, some reshuffling, but overall the course is very similar.

SAP HANA 2.0 SPS 05

We already pointed out in a previous post that the focus for SAP HANA 2.0 SPS 05 was to provide a  rock-solid release for a five year maintenance window and not to introduce many new features (mainly targeted for SAP HANA Cloud) and we saw this reflected in the list of entries for the What’s New guide: 40 pages instead of 80 when compared to the previous two releases (even down to 21 pages when we leave out the SAP HANA cockpit administration tool).As consequence, the HA300 and HA450 training courses did not require a lot of changes.

For more information about the SPS 05 release, see

• SAP HANA 2.0 SPS 05 Highlights
• What’s New in SAP HANA 2.0 SPS 05

SAP HANA Cloud and SAP Business Application Studio

The SAP Certified Development Associate – SAP HANA 2.0 SPS05 only concerns SAP HANA platform on-premises and does not cover SAP HANA Cloud.

This also applies to the tool SAP introduced in 2020 for cloud-based application development: SAP Business Application Studio. The App Studio (or BAS) provides an extension for native SAP HANA database development.

• SAP HANA Cloud and SAP Business Application Studio

For the exam, all questions reference the SAP Web IDE for SAP HANA.

SAP HANA Studio and SAP HANA XS Classic

SAP HANA studio as modeling tool was already removed from the exam and course material some editions ago. Not does the exam cover the SAP HANA XS Classic (XSC) model, the SAP HANA repository, questions about _SYS_REPO, or any related material (e.g. SAP HANA Live).

When any of these terms are mentioned as answers, it is probably the wrong one!

For an update and overview on the topic, see

• A Field Guide to SAP (HANA) Development | How to Get Started or Keep on Going without Getting Lost
• SAP HANA 2.0 and 1.0 – What’s the difference?

About the Exam 

Associate Level

Information about the exam is published on the SAP Training website. This is also where you can book the exam (or get a certification hub subscription)

• C_HANADEV_17

Certification levels

• C = Associate (consultant)
• E = Associate add-on (expert)
• P = Professional

SAP HANA certification types

• DEV = Development
• IMP = Implementation
• TEC = Technology

Related Exams

With HANAIMP, this certification shares the HA300 course, in particular the calculation view and SQLScript topic areas.

Earlier versions of the exam referenced previous SAP HANA releases.

• C_HANADEV_16 > SPS04
• C_HANADEV_15 > SPS03
• C_HANADEV_14 > SPS02
• C_HANADEV_13 > SPS01
• C_HANADEV_12 > SAP HANA 1.0 SPS12 (Edition 2016)

Validity

You can check the validity of the certifications at training.sap.com/certification/validity. In general, the certifications are valid for two years.

For the certification FAQs, see

• SAP Global Certification FAQ – Overview
• SAP Global Certification FAQ – Exam Process
• SAP Global Certification FAQ – Post-Exam Process

To take the exam visit SAP Training and select Access the Certification Hub.

• training.sap.com/access

Acclaim

Once you passed the exam, you will receive a digital badge from Acclaim

• SAP Certified Development Associate – SAP HANA 2.0 (SPS05)

See the FAQ for more information about SAP Global Certification Digital badges.

About the Questions

Topics and Weight

Information about the topic areas covered is listed on the exam information page.

• training.sap.com/certification/C_HANADEV_17

Most material is sourced by the HA450 training, the modeling-related topics come from HA300, and the SQLScript topics from HA150 (see below).

Course Index

You can download the course index from the training page(s). This provides a more detailed list of the topics covered on the exam.

Below part of the course index for HA450.

How to Prepare

SAP Training

When you have the time and budget, take the SAP Training courses. Nothing beats a 2 week+ focus with hands-on exercises and training environment.

• HA150 – SQLScript for SAP (SPS05) – 3 days
• HA300 – Modeling (SPS05) – 5 days
• HA450 – Application Development for SAP HANA (SPS05) – 4 days

Note that the courses have as prerequisite

• HA100 – SAP HANA – 360° Introduction – 3 days

SAP Learning Hub

Alternatively, consider a subscription for the SAP Learning Hub and/or Certification Hub.

• SAP Learning Hub

For those new to the Learning Hub, you can try before you buy.

• Discover SAP Learning Hub free for 14 days

Sample Questions

On the exam page, there is a link to a sample exam similar to the real one from.

• ondemand.questionmark.eu

Learning Journey

The learning journey shows a visualisation of the courses to take. You can logon and mark your progress.

• SAP HANA – Development

The tiles for each of the courses show the available formats: classroom and e-books.

The tiles for each of the courses show the available formats: classroom and e-books. When subscribed to the learning hub, you also have access to an SAP HANA system for hands-on exercises (Live Access). The assessment contains the sample questions from the course.

The learning journey shows a visualisation of the courses to take (as listed above). You can logon and mark your progress.

openSAP

There are several courses about SAP HANA development available on the free openSAP platform including one dedicated to the exam preparation by Thomas Jung and Rich Heilman.

The latest update was for SPS 04 (2019).

• Software Development

For upcoming, running, and past courses about SAP HANA, you can filter the openSAP course catalog.

• SAP HANA (filter)

The most recent one was from 2020.

• A First Step Towards SAP HANA Query Optimization

Books

SAP Certification Success Guide by SAP PRESS

Whether you take the official training courses or not, the SAP PRESS Certification Success Guide(s) remain an excellent preparation for the exam. They cover all the core topics with references for additional study material, together with a glossary and hundreds of sample questions.

There is no success guide for the C_HANADEV exam but there is one for C_HANAIMP and C_HANATEC. The guide for the application associate exam covers many topics also found in the above-mentioned course although not all. The guide for the technology associate exam covers the material from HA100 but the main focus is on HA200, which is not part of C_HANADEV.

• SAP HANA 2.0 Certification Guide: Application Associate Exam | C_HANAIMP_15
• SAP HANA 2.0 Certification Guide: Technology Associate Exam | C_HANATEC_17

Additional Resources

Documentation – SAP Help Portal

The Development section of SAP HANA platform on the SAP Help Portal lists 20+ guides and this covers way more material than you need to know.

To help you find your way around, try the

• SAP HANA Development Metro Map
• SAP HANA Development Information Atlas
• SAP HANA Developer Quick Start Guide

SAP Development Center (Free)

Of course, the tutorials from the SAP Development Center also provide a great learning opportunity. This is also the place to download the free SAP HANA, express edition or find out how you can run this in a cloud environment.

• developers.sap.com/hana

Note that the focus these days is on SAP HANA Cloud, which in some domains works slightly differently. For more information, visit

• Getting Started with SAP HANA Cloud

Share and Connect

Questions? Please post as comment.

Useful? Give us 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

• Denys van Kempen