Download SAP E-HANAAW-18 Sample Questions [Dec-2023]
Real E-HANAAW-18 Exam Questions and Answers FREE
NEW QUESTION # 13
In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog. Which of the following table types fulfill this requirement?
- A. GLOBAL TEMPORARY
- B. LOCAL TEMPORARY
- C. HISTORY COLUMN
- D. ROW
Answer: B
NEW QUESTION # 14
You use ABAP Database Connectivity (ADBC) to issue native SQL calls to the database. Which method of class CL_SQL_RESULT_SET retrieves the entire result set of the native SQL call?
- A. NEXT
- B. EXECUTE_QUERY
- C. NEXT_PACKAGE
- D. SET_PARAM_TABLE
Answer: C
NEW QUESTION # 15
Which of the following features does the ABAP Test Cockpit offer that the ABAP Code Inspector does NOT offer? Note: There are 2 correct answers to this question.
- A. Flexible schedule of check runs
- B. Configuration of check variants
- C. Enhanced distribution of results
- D. Documented checks
Answer: A,C
NEW QUESTION # 16
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. Replace CORRESPONDING FIELDS additions.
- B. Replace ORDER BY additions.
- C. Add explicit client handling.
- D. Specify the schema for every table.
- E. Replace UP TO n ROWS additions.
Answer: C,D,E
NEW QUESTION # 17
Which of the Golden Rules for Open SQL Performance have become more important with SAP HANA? Note: There are 2 correct answers to this question.
- A. Keep unnecessary load away from the database.
- B. Minimize the amount of transferred data.
- C. Minimize the search overhead.
- D. Minimize the number of database accesses.
Answer: B,D
NEW QUESTION # 18
Which of the following tools and programming techniques use the SQL Data Definition Language? Note: There are 2 correct answers to this question.
- A. Open SQL
- B. Core Data Services (CDS) data definition
- C. Core Data Services (CDS) access control
- D. ABAP Dictionary
Answer: A,B
NEW QUESTION # 19
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. N/A
- B. Image 3
- C. Image 2
- D. Image 1
Answer: B
NEW QUESTION # 20
You define a Core Data Services (CDS) view to merge the results of queries using the UNION keyword. What must the column lists of these queries contain? Note: There are 2 correct answers to this question.
- A. Columns of identical types
- B. All key fields
- C. The same number of columns
- D. Columns of compatible types
Answer: C,D
NEW QUESTION # 21
How many result sets are returned when an SAP HANA database procedure is called using the CALL...WITH OVERVIEW statement?
- A. One result set
- B. As many result sets as there are table output parameters in the procedure
- C. As many result sets as there are input parameters in the procedure
- D. Two result sets
Answer: A
NEW QUESTION # 22
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 full-text index is always updated asynchronously.
- C. The LIKE operator is required in your SELECT statement to implement fuzzy logic.
- D. SAP HANA has to be the primary database to create a full text search.
Answer: A
NEW QUESTION # 23
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. carrid and _flights.planetype
- B. _flights.carrid and planetype
- C. carrid and planetype
- D. _flights.carrid and_flights.planetype
Answer: D
NEW QUESTION # 24
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. The data has NOT yet been transferred to the SQL Monitor database tables.
- B. SQL Monitor was activated with a filter that excludes database table Y.
- C. SQL Monitor was activated for a specific application server.
- D. Database table Y is a buffered table.
- E. Program X was executed in the background.
Answer: A,B,C
NEW QUESTION # 25
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. Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement.
- B. Perform all calculations and aggregations in the ABAP U layer.
- C. Ensure the WHERE clause contains at least one index field.
- D. Ensure the access to buffered tables uses the SAP table U buffer.
Answer: A,C
NEW QUESTION # 26
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 represents the connection to an ABAP system.
- B. It is used to transport ABAP repository objects.
- C. It provides access to all ABAP repository objects in an ABAP system.
- D. It represents the connection to the SAP HANA server.
Answer: A,C
NEW QUESTION # 27
Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)?
- A. Missing ORDER BY or SORT after SELECT
- B. Use of Native SQL and DB Hints
- C. Existence check for Secondary Indexes
- D. Direct access to Table Pools/Cluster
Answer: A
NEW QUESTION # 28
You are programming a report that reads data from a secondary HANA database (DB). What do you need to consider in your SQL statement? Note: There are 2 correct answers to this question.
- A. All tables and fields you are using must exist in the ABAP Dictionary of the secondary DB.
- B. You have to use native SQL when reading data from the secondary DB.
- C. You have to specify the DB connection explicitly in your statement.
- D. You have to specify the DB schema explicitly in your statement.
Answer: C,D
NEW QUESTION # 29
......
Truly Beneficial For Your SAP Exam: https://www.lead2passed.com/SAP/E-HANAAW-18-practice-exam-dumps.html
View All E-HANAAW-18 Actual Exam Questions, Answers and Explanations for Free: https://drive.google.com/open?id=1ouw-XczmNIF5g728iUUdbzdMPtz3jImJ
