SAP Certified Application Associate – SAP HANA 2.0 SPS05
In this blog, you will find some personal suggestions about how to get certified as SAP Certified Application Associate – SAP HANA 2.0 SPS 05.
This exam is available as of December 2020.
For the blog posts about the SAP HANA 2.0 SPS 05 exams, see
For the blog post about the previous edition, see
For the blog posts about the SAP Cloud Platform exams, see
About braindumps and cheat sheets, see
Questions? Post as comment.
Useful? Give us a like and share on social media.
Once you passed the exam, you will receive a digital badge from Acclaim
See the FAQ for more information about SAP Global Certification Digital badges.
About the Exam
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)
There are multiple types of certifications:
- TEC = Technology (system administration)
- IMP = Application (implementation, here modeling)
- DEV = Development (native development)
- AW = ABAP
- BW = Business Warehouse
- ADM = Administration (SAP (NetWeaver AS BASIS)
The levels are
- C = Associate (consultant)
- E = Associate add-on (expert)
- P = Professional
For each release there is an exam. Currently valid are
- 17 = SAP HANA 2.0 SPS 05 | until 2025
- 16 = SAP HANA 2.0 SPS 04 | until 2021
- 12 = SAP HANA 1.0 SPS 12 | until 2021
You can check the validity of the certifications at training.sap.com/certification/validity.
Certifications expire a couple of months after the maintenance support for the SAP HANA release. For this reason your certification for SPS 12 from 2016 is still valid while those for 2017 (SPS 01), 2018 (SPS 02), and 2019 (SPS 03) no longer are.
Unless there is a special requirement, take the SPS 05 release of the exam
For the certification FAQs, see
Information about the topic areas covered is also listed on the exam information page.
Note the small print: SAP reserves the right to update the exam content (topics, items, weighting) at any time. So make sure to check the page before applying.
Major Topics > 12%
- Configure Modeling Functions
- Describe the Architecture and Deployment Scenarios
- Build Calculation Views
- Optimizing the performance of models
- Managing and administering models
- Describing advanced analytical processing
Minor Topics <8%
- Working with SQL and SQL Script in models
- Securing models
Compared to the previous edition, the list has been “simplified”. Apart from the Advanced Analytical Processing topic, all topic areas reference course HA 300 (see below).
How to Prepare
Whether you take the official training courses or not, the SAP PRESS Certification Success Guide(s) remain an excellent preparation for the exam. The book covers all the core topics with references for additional study material, together with a glossary and hundreds of sample questions.
The most recent guide for this exam is from 2019 (SPS 03 release).
When you have the time and budget, take the SAP Training courses. Nothing beats a week+ focus with hands-on exercises and training environment.
Note that the courses have as requirement
- HA100 – SAP HANA – 360° Introduction – 3 days
Not required but recommended for those a little rusty on their SQL and SQLScript knowledge is course
- HA150 – SQLScript for SAP HANA – 3 days
SAP Learning Hub
Alternatively, consider a subscription for the SAP Learning Hub and/or Certification Hub. There is a trial edition available for you to try it out.
Open SAP (Free)
Although there are several courses about SAP HANA development available on the free openSAP platform, these are more targeted towards development and less about modeling. Latest update was for SPS 04 (2019).
The learning journey shows a visualisation of the courses to take. You can logon and mark your progress.
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.
SAP Help Portal (Free) | SAP HANA Platform
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
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.
Note that the focus these days is on SAP HANA Cloud, which in some domains works slightly differently. For more information, visit
SAP Support | Knowledge Base Articles
For those that have access to the SAP ONE Support Launchpad knowledge base articles (KBAs) (S- or P-user account), take note of the many excellent FAQ articles. As with the documentation guides, this will cover more material than you will need to know but it does provide an excellent resource.
This resource is more relevant for the C_HANATEC exam than for C_HANAIMP but if you want to become an SAP HANA expert, digesting an FAQ on memory management or the way caches work is time well spent.
On the exam page, there is a link to a sample exam similar to the real one from.