E-HANAAW-18 Dumps with Practice Exam Questions Answers
E-HANAAW-18 by SAP Certified Development Specialist Actual Free Exam Practice Test
SAP E-HANAAW-18 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
NEW QUESTION # 20
When using an SAP HANA full text search, what do you have to keep in mind?
- A. The SCORE( ) function is required to ensure the best hits of your search appear on top.
- B. The LIKE operator is required in your SELECT statement to implement fuzzy logic.
- C. The full-text index is always updated asynchronously.
- D. SAP HANA has to be the primary database to create a full text search.
Answer: A
NEW QUESTION # 21
Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)?
- A. Direct access to Table Pools/Cluster
- B. Use of Native SQL and DB Hints
- C. Missing ORDER BY or SORT after SELECT
- D. Existence check for Secondary Indexes
Answer: C
NEW QUESTION # 22
You developed an ABAP Managed Database Procedure (AMDP). You want to allow the enhancement of this AMDP using a Business Add-In (BAdI). Which of the following objects must you create? Note: There are 3 correct answers to this question.
- A. A BAdI definition
- B. A BAdI fallback implementation
- C. An enhancement spot
- D. A database procedure
- E. A BAdI sample implementation
Answer: A,B,C
NEW QUESTION # 23
You created and activated a database procedure. From where can you call this procedure? Note: There are 2 correct answers to this question.
- A. From a Script-based calculation view
- B. From another database procedure
- C. From a graphical calculation view
- D. From a Core Data Services view
Answer: A,B
NEW QUESTION # 24
You implement an ABAP-managed database procedure (AMDP). Within this AMDP, you want to query data from calculation view CA_BOOKINGS_COUNT in SAP HANA content package ha400.primdb. How can you address the calculation view? Note There are 2 correct answers to this question.
- A. "ha400.primdb: :CA_BOOKINGS_COUNT"
- B. "ha400.primdb/CA_BOOKINGS_COUNT"
- C. _SYS_BIC."ha400.primdb/CA_BOOKINGS_COUNT"
- D. _SYS_BIC."ha400.primdb::CA_BOOKINGS_COUNT"
Answer: C,D
NEW QUESTION # 25
You have created a CDS view as follows: define view zha400 as
select from spfli association^] to sflight as_flights on
spfli.carrid = _flights.carrid and spfli.connid = _flights.connid { ... } Given that table sflight also contains the field planetype, how must you address the fields carrid and planetype from table SFLIGHT?
- A. _flights.carrid and planetype
- B. carrid and _flights.planetype
- C. _flights.carrid and_flights.planetype
- D. carrid and planetype
Answer: C
NEW QUESTION # 26
Which task does the ABAP Managed Database Procedure (AMDP) framework perform?
- A. Deploy a new version of the database procedure when the AMDP is first called.
- B. Deploy the database procedure whenever the AMDP is activated.
- C. Deploy the database procedure whenever the AMDP is called.
- D. Deploy the database procedure when the AMDP is first activated.
Answer: A
NEW QUESTION # 27
Which rules does SAP recommend to improve the performance of ABAP reports on SAP HANA? Note: There are 2 correct answers to this question.
- A. Ensure the WHERE clause contains at least one index field.
- B. Ensure the access to buffered tables uses the SAP table U buffer.
- C. Perform all calculations and aggregations in the ABAP U layer.
- D. Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement.
Answer: A,D
NEW QUESTION # 28
You import an ABAP workbench request into an SAP system P81. The ABAP workbench request contains a single SAP HANA view CA_CUSTOMER that belongs to SAP HANA content package ZHA400_00. Which prerequisites are mandatory for an implicit deployment of the SAP HANA view onto the database? Note: There are 2 correct answers to this question.
- A. View CA_CUSTOMER has deployment mode A.
- B. Package ZHA400_00 is listed in table SNHI DUP PREWORK.
- C. System P81 has SAP HANA as primary database.
- D. Package ZHA400_00 has deployment mode A.
Answer: B,C
NEW QUESTION # 29
You are using a calculated column COUNTS within your Dimension Calculation View and an aggregation node. This is the data that goes into the aggregation node:
- A. Image 2
- B. N/A
- C. Image 1
- D. Image 3
Answer: D
NEW QUESTION # 30
What is the purpose of an ABAP project in ABAP Development Tools for Eclipse? Note: There are 2 correct answers to this question.
- A. It is used to transport ABAP repository objects.
- B. It represents the connection to an ABAP system.
- C. It represents the connection to the SAP HANA server.
- D. It provides access to all ABAP repository objects in an ABAP system.
Answer: B,D
NEW QUESTION # 31
Which of the following features were added to the ABAP dictionary to support the SAP HANA database? Note: There are 3 correct answers to this question.
- A. Storage type for tables
- B. De-pooling and de-clustering
- C. Definition of full-text indexes
- D. Change of data class
- E. Definition of enhancement category
Answer: A,B,C
NEW QUESTION # 32
How many result sets are returned when an SAP HANA database procedure is called using the CALL...WITH OVERVIEW statement?
- A. As many result sets as there are table output parameters in the procedure
- B. One result set
- C. Two result sets
- D. As many result sets as there are input parameters in the procedure
Answer: B
NEW QUESTION # 33
You want to move some of the logic of an ABAP program into an ABAP-managed database procedure (AMDP). To do so, you need to translate Open SQL statements into SAP HANA Native SQL. Which of the following are necessary adjustments? Note: There are 3 correct answers to this question.
- A. Add explicit client handling.
- B. Replace UP TO n ROWS additions.
- C. Specify the schema for every table.
- D. Replace CORRESPONDING FIELDS additions.
- E. Replace ORDER BY additions.
Answer: A,B,C
NEW QUESTION # 34
You analyze SQL Monitor data in transaction SQLMD. You know that program X accesses database table Y. You made sure that program X was executed while the SQL Monitor collected its dat a. But the relevant database access is NOT listed in SQLMD. What could be the reason? Note: There are 3 correct answers to this question.
- A. Database table Y is a buffered table.
- B. Program X was executed in the background.
- C. SQL Monitor was activated for a specific application server.
- D. The data has NOT yet been transferred to the SQL Monitor database tables.
- E. SQL Monitor was activated with a filter that excludes database table Y.
Answer: C,D,E
NEW QUESTION # 35
Which of the following tools and programming techniques use the SQL Data Definition Language? Note: There are 2 correct answers to this question.
- A. Core Data Services (CDS) data definition
- B. Core Data Services (CDS) access control
- C. Open SQL
- D. ABAP Dictionary
Answer: A,C
NEW QUESTION # 36
......
Free SAP Certified Development Specialist E-HANAAW-18 Exam Question: https://examcollection.actualcollection.com/E-HANAAW-18-exam-questions.html