We're so confident of our products that we provide no hassle product exchange.
SAP C_HANAIMP131 Exam Overview:
| Certification Vendor: | SAP |
| Exam Name: | SAP Certified Application Associate (Edition 2013) - SAP HANA |
| Exam Number: | C_HANAIMP131 |
| Certificate Validity Period: | 2 years |
| Exam Format: | Multiple Choice, Multiple Response, Scenario-based |
| Exam Duration: | 180 minutes |
| Real Exam Qty: | 80 |
| Exam Price: | USD 500 |
| Available Languages: | English, Japanese |
| Passing Score: | 61% |
| Related Certifications: | SAP Certified Application Specialist - SAP HANA SAP Certified Development Associate - SAP HANA |
| Recommended Training: | HA300 - SAP HANA Implementation and Modeling HA100 - SAP HANA Introduction |
| Exam Registration: | Pearson VUE SAP Training Shop |
| 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 |
|---|---|---|
| Advanced Data Modeling | 8% - 12% | - Derived and restricted measures - Input parameters and variables |
| Deployment Scenarios of SAP HANA | 8% - 12% | |
| Administration of Data Models | 8% - 12% | - Version management - Transport and deployment |
| Data Modeling - Calculation Views | 8% - 12% | - Graphical and script-based views - Complex calculations and logic |
| Data Modeling - Attribute Views | 8% - 12% | - Joins and relationships - Defining attributes and hierarchies |
| SAP HANA Live and Rapid Deployment Solutions | 8% - 12% | - RDS implementation - Pre-built content models |
| Data Modeling - Analytic Views | 8% - 12% | - Measures and dimensions - Currency and unit conversion |
| Data Modeling - SQL Script | 8% - 12% | - Stored procedures and logic - SQLScript syntax and functions |
| Security and Authorization | 8% - 12% | - Users and roles - Object-level privileges |
| Reporting | 8% - 12% | - Connecting reporting tools - Consuming SAP HANA models |
| Optimization of Data Models and Reporting | 8% - 12% | - Performance tuning - Query optimization |
| Data Provisioning | 8% - 12% | - Replication methods - Data transformation and loading |
SAP Certified Application Associate (Edition 2013) - SAP HANA Sample Questions:
1. What is the functionality of an aggregation node in a calculation view?(Choose two)
A) It calculates the sum, minimum, or maximum values for selected columns
B) It determines the output structure of the calculation view
C) It provides grouping of filter criteria
D) It provides deeper control over which columns are totaled
2. You want to run a report on data with multiple currencies. You want to allow end users to select the target currency at run time.
Which option does SAP recommend for defining the currency conversion?
A) Currency conversion during data load
B) A calculated column in an analytic view
C) Measures enabled for conversion in an analytic view
D) A CE_CONVERSION function in a calculation view
3. You have created two analytic views for actual and planned financial data each. The data covers multiple years. You want to display the actual data, planned data, and their difference in three separate columns in a report. The difference column is a calculated column.
How can you model this?
A) Create restricted columns for each year for the actual and planned columns in each analytic view
Combine the analytic views in a new calculation view using a UNION
B) Create an analytic view
Combine the analytic views in the new analytic view using a referential join
C) Create a calculation view
Combine the analytic views in the calculation view using a UNION
D) Create a calculation view
Combine the analytic views in the calculation view using a UNION WITH CONSTANT VALUES
4. When loading data into SAP HANA, which of the following tasks can you perform using SAP Data Services?(Choose two)
A) Upload data via the SAP HANA studio
B) Data transformations
C) Real-time replication
D) Data filtering
5. In a calculation view you define a calculated column and set the Calculate Before Aggregation flag.
Which of the following activities is mandatory to activate the view?
A) Select the aggregation type
B) Add a new aggregation node
C) Mark the column as hidden
D) Set the column type to Attribute
Solutions:
| Question # 1 Answer: A,D | Question # 2 Answer: C | Question # 3 Answer: D | Question # 4 Answer: B,D | Question # 5 Answer: A |
By Xanthe
