SAP HANA Application Certification Practice Tests

Main Features

• 318 unique questions

• 4 Practice tests

• No repetition of questions

• Scenario based questions

• Guarantee of Passing certification exam

• Specially designed for SAP Certified Application Associate - SAP HANA 2.0 (SPS02)

• Suitable for SAP Certified Application Associate - SAP HANA 2.0 (SPS03)

• Ideal for C_HANAIMP_14, C_HANAIMP_15 certification exams

• Monthly updates

Update: 07-02-2019

                10 new questions added

                19-01-2019

                Few new questions have been added

Covers topics from books

• HA301  SAP HANA 2.0 SPS02 Advanced Modeling

• HA300  SAP HANA 2.0 SPS02 Modeling

• HA100  SAP HANA Introduction

It's very important to study HA100, HA300, and HA301 all these books. but reading books is not sufficient because in the exam you have to face very tricky questions for which you have to correlate multiple topics, only practice of solving question scan help you to answer such questions.

Sample Questions and answers:

1. How does HANA ensure no data is lost during a memory outage?

• • By automatically saving memory to data volumes

• • By automatically saving memory pages to log volumes

• • By saving committed changes between savepoints to data volumes

• • By saving committed changes between savepoints to the log volumes

2. Why do I use the SAP HANA Cockpit?

• • Administration of HANA

• • Modeling in HANA

• • Development native HANA applications

• • Monitoring of multiple HANA appliances

3. What are valid calculation view types?

• ·  Cube with star join

• ·  Cube

• ·  Dimension with star join

• ·  Temporal

• ·  Dimension

4. What type of SQL join is a text join?

• · Inner

• ·  Left Outer

• ·  Right outer

• ·  Cross join

5. Which statements are true regarding Input Parameters?

• ·  They are always bound to a single attribute of a calculation view

• ·  They can be used in expressions

• ·  Value help lists can be assigned to prompt for valid values

• ·  Technically they result in a WHERE clause in the generated SQL

6. Why would I use the Lineage tool in my Calculation View?

• ·   To identify the dependant views

• ·   To drill to the source data of the view

• ·   To follow the path of any specific column inside a Calculation View

• ·   To identify who has worked on the view and when it was activated

7. Which are valid statements regarding Functions?

• ·   Functions can have multiple input parameters

• ·   A function can call another function

• ·   You can create a new persistent table in a function

• ·   Tabular functions can only have one tabular output structure

8. How is vector data stored?

• ·    Using geometries such as polygons, lines etc

• ·    Using bitmaps

• ·    Using graphs

9. How do you call a predictive algorithm from my calculation view?

• ·   Use a scripted calculation view

• ·   Use a table function

• ·   Use a CDS view

• ·   Use a flowgraph

10. What are the three types of full text search?

• ·    Fuzzy

• ·    Linguistic

• ·    Relative

• ·    Exact

SAP Certification Exam Facts:

• 80 questions

• 3 hours

• All question have same weighting ( every question is worth 1 point )

• No partial scoring ( you get one point for the entire question or nothing )

• Questions from same topic stay together, topic sequence is randomized

• Source material is course handbook / e-book

• Same 80 questions for everyone and every time

• Always objective, never opinion based

• No true/false questions

Exam taking strategies:

• Use the elimination method, choose what is left.

• Keep cycling through questions, don't get stuck on one question.

Preparation strategies

• Stick to course book / e-book, use another resource only to clarify

• Look in the course material for keywords ‘always’, ‘must’, ‘never’ etc.

• Look for bullet / tables / lists in course material

• Look for ‘>> Notes’ in course material

• Look for special cases / restrictions

• Look for SAP recommendations

You will be tested on

• Concepts, Functions, Rules, Limits, Prerequisites, Sequence of task, Best practices 

and not  on

• Screen content, Detailed practical knowledge, Past project experiences

Other Courses:

SAP ABAP on HANA Training for Beginners

Trial ABAP system with HANA database on SAP Cloud Platform

SAP ABAP for HANA certification preparation test

SAP ABAP Netweaver 7.50 certification preparation test

SAP Smart Forms for beginners