SAP E_HANAAW_18 Cert Guide PDF 100% Cover Real Exam Questions
Pass E_HANAAW_18 Exam - Real Questions and Answers
NEW QUESTION # 11
In an ABAP Core Data Services (CDS) view, what must you do to expose an association for use in another CDS view?
- A. Specify an alias for the target entity.
- B. Include all fields used in the ON condition in the projection
- C. Specify the other views in which the association can be used.
- D. Define the cardinality for the target entity.
Answer: B
NEW QUESTION # 12
What are some of the features available for SAP List Viewer with Integrated Data Access (ALV IDA)? Note: There are 3 correct answers to this question.
- A. Edit cells
- B. Double-click on rows
- C. Display diagrams
- D. Group rows
- E. Search in content
Answer: B,D,E
NEW QUESTION # 13
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. All key fields
- B. Columns of identical types
- C. Columns of compatible types
- D. The same number of columns
Answer: C,D
NEW QUESTION # 14
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. SAP HANA has to be the primary database to create a full text search.
- C. The LIKE operator is required in your SELECT statement to implement fuzzy logic.
- D. The full-text index is always updated asynchronously.
Answer: A
NEW QUESTION # 15
In a graphical calculation view, you want to implement a union between two result sets that differ only in the fact that one of the two has one additional field named ADDRESS. How can you achieve this in a union node? Note: There are 2 correct answers to this question.
- A. Exclude the ADDRESS field from the union.
- B. Map the ADDRESS field to a constant value.
- C. Create an input parameter for the ADDRESS field.
- D. Create a restricted column for the ADDRESS field.
Answer: A,B
NEW QUESTION # 16
Which step of the Guided Performance Analysis should you perform in the production system?
- A. Collecting data with SQL Monitor (SQLM)
- B. Executing a check run with ABAP Test Cockpit (ATC)
- C. Performing an inspection with Code Inspector (SCI)
- D. Building a work list with SQL Performance Tuning Worklist (SWLT)
Answer: A
NEW QUESTION # 17
You have created a CDS view and used alias names for some of its elements. In which of the following cases is the alias name mandatory? Note: There are 3 correct answers to this question.
- A. SUM( revenue ) AS total_revenue
- B. CAST( 'USD' AS abap.cuky ) AS currency_key
- C. crtdby AS created_by
- D. ASSOCIATION TO sflight AS .flights
- E. CASE ordertype WHEN 'A' THEN 1 ELSE 0 END AS order_type
Answer: A,B,E
NEW QUESTION # 18
You define and implement an ABAP Managed Database Procedure (AMDP). What do you have to list after the USING clause? Note: There are 3 correct answers to this question.
- A. AMDPs used in the procedure body
- B. ABAP Dictionary tables used in the procedure body
- C. ABAP Dictionary views used in the procedure body
- D. SAP HANA views used in the procedure body
- E. functions used in the procedure body
Answer: A,B,C
NEW QUESTION # 19
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. SQL Monitor was activated for a specific application server.
- C. The data has NOT yet been transferred to the SQL Monitor database tables.
- D. SQL Monitor was activated with a filter that excludes database table Y.
- E. Program X was executed in the background.
Answer: B,C,D
NEW QUESTION # 20
Which task does the ABAP Managed Database Procedure (AMDP) framework perform?
- A. Deploy the database procedure whenever the AMDP is activated.
- B. Deploy the database procedure when the AMDP is first activated.
- C. Deploy a new version of the database procedure when the AMDP is first called.
- D. Deploy the database procedure whenever the AMDP is called.
Answer: C
NEW QUESTION # 21
You are using ABAP Development Tools, and you have placed your cursor on a method name in a class. What key do you use to navigate between a method definition and its implementation?
- A. F3
- B. F1
- C. F4
- D. F2
Answer: A
NEW QUESTION # 22
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. Perform all calculations and aggregations in the ABAP U layer.
- C. Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement.
- D. Ensure the access to buffered tables uses the SAP table U buffer.
Answer: A,C
NEW QUESTION # 23
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. Minimize the number of database accesses.
- B. Keep unnecessary load away from the database.
- C. Minimize the search overhead.
- D. Minimize the amount of transferred data.
Answer: A,D
NEW QUESTION # 24
You are debugging in ABAP Development Tools in Eclipse.
What features are available? Note: There are 2 correct answers to
this question.
- A. Memory usage analysis
- B. Debugger scripting
- C. Conditional breakpoints
- D. Watch points
Answer: C,D
NEW QUESTION # 25
Which of the following repository objects can you edit only in ABAP Development Tools in Eclipse, and NOT in the classical ABAP Workbench? Note: There are 3 correct answers to this question.
- A. ABAP class with new Open SQL Syntax
- B. Data Definition
- C. Database Procedure Proxy
- D. ABAP class with SQL script coding
- E. Full-text index
Answer: A,C,D
NEW QUESTION # 26
......
100% Free E_HANAAW_18 Daily Practice Exam With 42 Questions: https://validexam.pass4cram.com/E_HANAAW_18-dumps-torrent.html