SAP C-HANAIMP131 Exam Overview:
| Certification Vendor: | SAP |
|---|---|
| Exam Name: | SAP Certified Application Associate (Edition 2013) - SAP HANA |
| Exam Number: | C-HANAIMP131 |
| Exam Format: | Multiple Choice, Multiple Response, Scenario-based |
| Passing Score: | 61% |
| Real Exam Qty: | 80 |
| Exam Duration: | 180 minutes |
| Certificate Validity Period: | 2 years |
| Related Certifications: | SAP Certified Development Associate - SAP HANA SAP Certified Application Specialist - SAP HANA |
| Exam Price: | USD 500 |
| Available Languages: | English, Japanese |
| Recommended Training: | HA100 - SAP HANA Introduction HA300 - SAP HANA Implementation and Modeling |
| Exam Registration: | SAP Training Shop Pearson VUE |
| Sample Questions: | SAP C-HANAIMP131 Sample Questions |
| Exam Way: | Online proctored or onsite at authorized test centers |
| Pre Condition: | Basic knowledge of database concepts, data modeling, and SAP HANA fundamentals; recommended completion of courses HA100 and HA300 |
| Official Syllabus URL: | https://training.sap.com/v2/certification/c_hanaimp131-sap-certified-application-associate-edition-2013—sap-hana-g/certification-details/ |
SAP C-HANAIMP131 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Deployment Scenarios of SAP HANA | 8% - 12% | |
| Topic 2: Data Provisioning | 8% - 12% | - Data transformation and loading - Replication methods |
| Topic 3: Optimization of Data Models and Reporting | 8% - 12% | - Query optimization - Performance tuning |
| Topic 4: Reporting | 8% - 12% | - Consuming SAP HANA models - Connecting reporting tools |
| Topic 5: Administration of Data Models | 8% - 12% | - Transport and deployment - Version management |
| Topic 6: Data Modeling - Analytic Views | 8% - 12% | - Currency and unit conversion - Measures and dimensions |
| Topic 7: Data Modeling - SQL Script | 8% - 12% | - Stored procedures and logic - SQLScript syntax and functions |
| Topic 8: Security and Authorization | 8% - 12% | - Object-level privileges - Users and roles |
| Topic 9: Data Modeling - Attribute Views | 8% - 12% | - Joins and relationships - Defining attributes and hierarchies |
| Topic 10: SAP HANA Live and Rapid Deployment Solutions | 8% - 12% | - Pre-built content models - RDS implementation |
| Topic 11: Data Modeling - Calculation Views | 8% - 12% | - Complex calculations and logic - Graphical and script-based views |
| Topic 12: Advanced Data Modeling | 8% - 12% | - Input parameters and variables - Derived and restricted measures |
SAP Certified Application Associate (Edition 2013) - SAP HANA Sample Questions:
Question 1
You want to aggregate the grand total sales amount into one currency.
In which of the following cases would you perform the calculation before aggregation?(Choose two)
A. When an aggregate table by country contains sales values in three different currencies.
B. When an aggregate table by country contains sales values in one currency.
C. When a line item table contains sales values in one currency.
D. When a line item table contains sales values of two different currencies.
Question 2
You have been asked to create an SAP HANA attribute view using the tables Employee (left table) and Department (right table) shown in the attached diagram.
Your view should contain the columns NAME and D_Name for all employees.
Which of the following join types do you use?
A. Referential join
B. Text join
C. Left outer join
D. Inner join
Question 3
You want to model customer master data.
Which of the following must you select?(Choose two)
A. Hierarchy
B. Table
C. Key attribute
D. Filter
Question 4
In which engines is an analytic view executed that contains a calculated column?(Choose two)
A. Join engine
B. OLAP engine
C. Calculation engine
D. Row store engine
Question 5
A new user has implemented an SAP HANA data model.
Which technical user requires select rights on the new user's schema?
A. _SYS_REPO
B. _SYS_BI
C. _SYS_BIC
D. _SYS_SECURITY
Solutions:
| Question 1 Answer: A,D | Question 2 Answer: C | Question 3 Answer: B,C | Question 4 Answer: B,C | Question 5 Answer: A |

We're so confident of our products that we provide no hassle product exchange.


By Ben


