I would like to share my experience for preparing and clearing for HANA Certification
C_HANAIMP141 Application Associate (Edition 2014) – SAP HANA.
A Brief Background About me : I am an SAP ABAP Consultant for more than 10 years recently involved in a SAP HANA implementation on CRM for a media company which moved my interest towards In Memory database technology and was much more interested towards SAP HANA as a Platform . I had a through preparation about 2-3 months and finally cleared the exam though was lot skeptical in initially finalizing the date of the exam But thorough preparation is needed to be confident to clear the certification.( Please be sure of your exam date because the cost of exam if you are paying by your self.)
Link for certification topics : https://training.sap.com/shop/certification/c_hanaimp141-sap-certified-application-associate-edition-2014—sap-hana-g/
Examination Sections (The number of questions as Approx questions that i have received during my exam it might differ)
|Section||No of Questions approx|
1.Administration of data models : Administer data models in SAP HANA, including setting of information validation rules, managing schemas, the importing/exporting and transporting of data models.
|2.Advanced Data Modelling : Apply advanced data modeling techniques, including currency conversion, variables and input parameters,constraint filters Decision Tables||8|
|3.Data modeling – Analytical view :Implement data models with SAP HANA using analytical views , and best practices optimization scenarios||6|
|4..Data modeling – Attribute views :Implement data models with SAP HANA using attribute views,and best practices optimization scenarios||4|
5.Data modeling – Calculation Views:Implement data models with SAP HANA using calculation views,and best practices optimization scenarios( Both Graphical and as well as Script Calculation View , CE functions that replicate the Graphical Calculation Nodes)
,Calculation View with Union Vs Calculation View with Union as constant
|6.Data modeling – SQL Script : Apply SQL Script to enhance the data models in SAP HANA using AFL, CE functions, and ANSI-SQL.||6|
|7.Data Provisioning : Describe possible scenarios and tools for replicating and loading data into SAP HANA from different data sources (e.g. SAP Landscape Transformation (SLT), SAP Data Services, or Direct Extractor Connection (DXC)).||16|
|8.Deployment scenarios of SAP HANA :Describe the deployment scenarios for SAP HANA and evaluate appropriate system configurations.||4|
|9.Optimization of Data Models and Reporting : Best Practices and Optimization Techniques,General Principles on Performance||8|
|10.SAP HANA Live & Rapid Deployment Solutions for SAP HANA :Describe the value of HANA and identify scenarios for SAP delivered content for SAP HANA, such as SAP HANA Live and Rapid Deployment Solutions.||4|
|11.Reporting : Provide advice on reporting strategies, and perform appropriate reporting solutions with SAP HANA. Build reports using various tools, for example, Microsoft Excel or SAP Business Objects BI tools.||6|
|12.Security and Authorization : Describe the authorization concept of SAP HANA and implement a security model using analytic privileges, SQL privileges, pre-defined roles and schemas. Perform basic security and authorization troubleshooting.||4|
Study Resources : HA100(SP07), HA300(SP07),HA350(SP07) ,Devloper guides in SAP HANA Platform – SAP Help Portal Page
Other Study Resources
1. SAP HANA Academy – YouTube video tutorials which gives your a better understanding of the topics and step by guides to practice.
4. SAP HANA. An Introduction of Bjarne Berg, Penny Silvia – by SAP PRESS ( This contains SP08 topics as well )
Areas of Concentraion : Data Provisioning and Data Modelling and Reporting.
Practical Knowledge : If we don’t have any implementation experience it is advised to practice the exercises and follow the YouTube videos for a basic step by step procedure the You Tube videos are based on version SP05 so there might be slight difference in the screens and options.
Data Modelling Concepts : Create various types of views( Attribute,Analytic,Calculation View),Input Parameters,Variables,Restriction using Filters,Constraint filters,Decision Tables,Currency Conversion,Hierarchies and exposing Views to Excel.
Data Provisioning Concepts : Please practice various methodologies of Data Provisioning ( SLT, Data Services,DXC,Uploading through Flat files etc ) .
SLT ->Configurations,Simple Transformations adding line of and ABAP Includes for transformations , Changing and adding columns during Replication scenarios.
Data Services -> Configurations,creating Data Store,Data Flow,Query Transform,Template table,Complex Transforms, Replication Scenarios,Try to replicate Data into HANA from any extractor as well( Just to be Confident about the process)
Reporting : There are various reporting tools available for various platforms and scenarios
Crystal Reports,WEBI,DASHBOARD,EXPLORER,ANALYSIS EDITION FOR OLAP, ANALYSIS FOR MS OFFICE,SAP Lumira for Visualization do take a look how each scenarios can be created (HA100)
Final Words : There needs to be lots of practice and studying required if we don’t have any implementation experience. In the Study materials each and every slide can be important you never know how the questions might come. Do give a second reading if time permits . 60% of the questions do come from the study materials and developer guides and 40% questions come from your practical and implementation experience .Please do follow the SCN HANA Development center for more detailed understanding of any issues that might encounter.SAP Certification questions are mostly tricky please answer carefully and do read the questions and options twice you can easily spot 2 answers for multiple choice but the third is mostly tricky be careful in those circumstances.Other Topics to be considered as well are Deployment Solutions,Security and Authorizations.
Hope this blog might provide you an insight for the SAP HANA Certification (2014 Edition)
All the best for those preparing and appearing for the certification exam.