Skip to Content
Author's profile photo Former Member

SAP HANA Professional Certification ( P_HANAIMP_1)

I have cleared my SAP HANA Professional Certification & would like to share my experiences in this blog  with the sap community

This certification tests your Hands on knowledge on SAP HANA. This is more for Solution Architects & consultants who had practical experience in all different areas of  HANA. This is based on HANA SPS05.

My Experience Background on SAP HANA :

I am a SAP HANA Distingished Engineer . ( Please refer to the link for more details on this program ) . I have been working on SAP HANA for more than 2 years . We are one of the early adopters & have already implemented around 8 Datamart projects & 1 BW on HANA implementation till date . I have also cleared the other two Associate  certifications ( C_HANAIMP_1 & C_HANATEC_1) on HANA  but would rate the HANA Professional certification as the best till date . It  tests your practical experience by going to very granular details

Note : This blog gives you information about the certification & it doesn’t guarantee the questions/topics which I have mentioned below would be part of the certification .

Please find attached link which gives more details on the certification—sap-hana-10-g/

Break up of questions by topics

DataModeling – 17

Optimization & performance – 14

Security & Authorization –  14

System Architecture – 13

Data provisioning – 9

Reporting – 6

Life Cycle Management ( LCM) – 4

Scenario based – 3 

Resources : ( There are lot of documents on data modelling best practices ( Official HANA documentation)

TZH200 (  HA 200 is the new name)

TZH300 (  HA 300  is the new name)

Some pointers on topics :

Data Modeling :

Hana Studio usage , Navigation , Input parameters in Analytical/calc views , Variables , CE functions, Procedures, Text Analytics .

Optimization & Perfomance :

Whats if Scenarios , How do you improve performance , Scenario based questions , Partitioning , SQL script optimizations, RDS implementations

Security & Authorization :

Analytical Privileges , BO Connectivity ,Mobile Connectivity

System Architecture :

Configuration Parameters,XS engine components,Delta merge,Hana  Services

BW Vs Data mart scenarios, Backup & recovery , scale out

Data provisioning :

Advantages / Limitations of using SLT , Data services , DXC

Reporting :

BO  tools connectivity to Hana , BO Olap / Advanced Analysis


Exoprt / Import of content  , Transports

Passing Score :

55% ( this might change )

I hope this blog gives some information to folks who are planning to take this certification 🙂


Kiran .

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj

      Hi Kiran,


      Nice info provided here...

      I just wanted to know were there any questions related to XS, OData and SAPUI5 development?

      Were there any questions related Predicitive Analysis and on transforming data using SLT and Data Services?

      Author's profile photo Former Member
      Former Member

      Thanks Vivek . Yes, we do have questions on the above mentioned topics


      Kiran .

      Author's profile photo Former Member
      Former Member

      Congrats Kiran,

      Thanks for the blog... it's really informative....

      I got a questions for you, I am new to SAP HANA and wish to go for HANA Certification (HANAIMP Associate), just want to know, can we write Certification exam without taking training for HA100 & HA200? because for 5 days training itself they are charging 2 Lac's (+30K for Certification exam) !! can you please help me, is there any way to get HANA certification at less cost?

      Author's profile photo Former Member
      Former Member

      Hi Raghu ,

      I beleive you need to take a Official SAP Training inorder to take the certification  in India . I tried to take the Hanatec_1 exam in banglore when i came to india on vacation ( July 2012) but they told that i need to take a official training in order to take the exam in their prometric center . In USA , It is not mandatory to  take the training if you want to take the certification . May be some one from SAP education can clarify if there is any other way


      Kiran .

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj

      Hi Raghu,

      If you are working and have 6 months of experience in HANA then you can appear for Certification.. you need to contact SAP and get a letter from your Company that you have been working on HANA for so so time

      You can also try to nominate yourself for Certification in SAP Teched through your company

      Other option is to take training and get certified but its very costly

      Author's profile photo Tim Breitwieser
      Tim Breitwieser

      Congratulations Kiran!

      Excellent summary of target profile, exam coverage, and prep options. Other HANA seniors should feel encouraged to get certified when reading this.


      Author's profile photo Former Member
      Former Member

      Thanks Tim

      Author's profile photo Stefan Koehler
      Stefan Koehler

      Hi Kiran,

      congratulations for passing the certification.

      Do you know why there is such a huge passing score gap compared to 80 percent or more several years ago? Is this just HANA specific or the general requirement nowadays?



      Author's profile photo Rodrigo Caparroz
      Rodrigo Caparroz

      Thanks Kiran about all your guide.

      Help me a lot to clear my P_HANAIMP_1 exam certification

      Following you!

      Thanks and Best Regards,

      Rodrigo Caparroz.

      Author's profile photo Former Member
      Former Member

      I am glad my blog helped you in clearing the certification . Congrats 🙂


      Kiran .

      Author's profile photo Manoj Kumar Vaddepally
      Manoj Kumar Vaddepally

      Hi Kiran,

                   I did my SAP HANA Application Associate certification in 2012 and can i go for Professional Certification now and I am not found Certification Code P_HANAIMP_1 in SAP Catalog. Please share some information of you know about and Code and eligibility.

      Author's profile photo MANQOBA THOMO

      Good Day All

      I trust the team is well, could you please assist, i'm trying to run SUSE Linux to run SAP HANA express edition on GCP platform, i have the HXE aka vm files and VMPLAYER assigned 12GB of Ram 120GB of storage and 4vCPU's to the vm but when i start it up, it crashes my GCP windows server, what could be the problem any advise welcomed. thank you in advance