SAP Certified Application Professional - SAP HANA 1.0

Certification: P_HANAIMP_1


  • Certification ID (Booking code): P_HANAIMP_1
  • Certification duration: 3 hours
  • Number of certification questions: 80
Sample Questions : P_HANAIMP_1 HANA Cert

1. A customer has started stress testing their SAP HANA solution. The actual performance of a calculation view is 100 times slower than the customer requires. The main table accessed contains billions of rows.Join logic in the calculation view is implemented using SQL. The customer explains that this was needed because a required join type is not supported in analytic views or CE functions.
Which of the following do you recommend to overcome the performance issue? 
Note: There are 2 correct answers to this question. 
a)  O  Force query parallelization of the SQL
b)  O  Re-design the data model to use an analytic view
c)  O  Re-design the SQL
d)  O  Persist the result set of the calculation view
2. The values for budget and actuals are in the same fact table identified by value type. You want to move 
budget and actual to the same row to be able to calculate the variance (Key Figure Model).
How could you fulfill the requirement? 
a)  O  Add two instances of the fact table to the data foundation. 
Implement a constant union in the analytic view.
b)  O  Add two instances of the fact table to the data foundation. Join 
them via inner join and design a star schema on the logical view.c)  O 
Implement a constant union by designing two analytic views and 
build a graphical calculation view with a union.
d)  O 
Implement a union by designing two analytic views and build a 
calculation view using CE_UNION_ALL.
3. Which of the following can you use to perform ranking in an SAP HANA data model?
Note: There are 2 correct answers to this question.
a)  O  A CE function
b)  O  A calculated attribute
c)  O  An SQL query
d)  O  A calculated measure
4. A customer is implementing an SAP HANA solution. The major requirements for data sourcing are:
 Extract data from the customer's ECC system using all Business Content extractor types and 
custom extractors.
 Provide job scheduling and monitoring.
Which of the following supports all requirements?
a)  O  SAP BusinessObjects Data Services
b)  O  BW on SAP HANA
c)  O  DXC using embedded BW
d)  O  SAP Landscape Transformation5. You are asked to develop a concept for transporting SAP HANA content from development to 
production.
Which of the following are prerequisites to use CTS+ transports? 
a)  O  SAP HANA content has been copied using „Mass Copy…“ in SAP 
HANA Studio.
b)  O  SAP HANA content has been placed in a built-in package.
c)  O  SAP HANA content is bundled in a delivery unit.
d)  O  SAP HANA content has been exported.
6. Which of the following reduces the amount of data transferred from the OLAP engine to the Calculation 
Engine? 
a)  O  Unions
b)  O  Projections
c)  O  Calculated attributes in an attribute view
d)  O  Calculated attributes in an analytic view
7. A customer complains about the performance of an analytic view. During your analysis you find out 
that there are calculated measures based on multiple restricted measures. 
How can you improve the performance?
a)  O 
1. Create a calculation view
2. Add multiple analytic views
3. Use filters on attributes
4.           Provide the output via an inner join operation in the        
calculation view b)  O 
1. Create a calculation view
2. Add multiple analytic views
3. Create calculated measures on the analytic views
4.           Provide the output via union operation in the calculation
view 
c)  O 
1. Create a calculation view
2. Add multiple analytic views
3. Use filters on attributes
4. Provide the output via a union operation in the 
calculation view 
d)  O 
1. Create multiple analytic views
2. Use filters on the attributes
3. Create calculated measures on the analytic view
4. 
 Use a Universe to join the data 
8. Which of the following SQL statements deletes the user HANADEMO including all dependent objects?
a)  O  REVOKE USER HANADEMO CASCADE
b)  O  DROP USER HANADEMO RESTRICT
c)  O  DROP USER HANADEMO CASCADE
d)  O  REVOKE USER HANADEMO RESTRICT
9. What are the advantages of SAP BW on HANA compared to SAP BW with BWA? 
Note: There are 2 correct answers to this question. 
a)  O  Reduced data latency
b)  O  Modeling flexibility
c)  O  Decreased data load frequencyd)  O  Usage of near line storage (NLS)
10. To support high availability, which of the following are valid index server actual roles for a 5 node 
scale-out SAP HANA system? 
a)  O  Two masters, two slaves, one standby
b)  O  One master, four slaves
c)  O  One master, three slaves, one standby
d)  O  Four masters, one standby
Solutions
1 a) Incorrect 2 a) Incorrect 3 a) Correct 4 a) Incorrect 5 a) Incorrect
1 b) Correct 2 b) Incorrect 3 b) Incorrect 4 b) Correct 5 b) Incorrect
1 c) Incorrect 2 c) Correct 3 c) Correct 4 c) Incorrect 5 c) Incorrect
1 d) Correct 2 d) Incorrect 3 d) Incorrect 4 d) Incorrect 5 d) Correct
6 a) Incorrect 7 a) Incorrect 8 a) Incorrect 9 a) Correct 10 a) Incorrect
6 b) Correct 7 b) Incorrect 8 b) Incorrect 9 b) Correct 10 b) Incorrect
6 c) Incorrect 7 c) Correct 8 c) Correct 9 c) Incorrect 10 c) Correct
6 d) Incorrect 7 d) Incorrect 8 d) Incorrect 9 d) Incorrect 10 d) Incorrect
Share this article :

Post a Comment

 
Copyright © 2011. SAP HANA TUTORIALS FREE - S/4 HANA - All Rights Reserved