ABAP for SAP HANA 2.0 Exam E_HANAAW_14 Dumps Questions

1. What are the Functions of Transaction DBACOCKPIT There are 2 correct answers to this question.

2. The source code editor in ADT provides many helpful features.

What are these helpful features? There are 2 correct answers to this question.

3. What are the purposes of tools in SAP HANA system that is an Eclipse-based integrated development environment? There are 3 correct answers to this question.

4. One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any functional issues after the migration.

What should you search for and if necessary replace in the existing custom ABAP code? There are 3 correct answers to this question.

5. You want to debug an ABAP program using ABAP development tools (ADT).

How do you launch the debugger? Please choose the correct answer.

6. When would you use a column store table instead of a row store table? There are 2 correct answers to this question.

7. To upload data from flat files, SAP HANA offers several features.

What are these important features? There are 2 correct answers to this question

8. Which features does the source code editor provide in ABAP Development Tools (ADT)? There are 2 correct answers to this question.

9. You created and activated database procedure.

How can you call this procedure? There are 2 correct answers to this question.

10. What all are the advantages provides by ABAP Development Tools? There are 3 correct answers to this question.

11. When are referential joins executed in analytical views? Choose the correct answer

12. Which of the following take advantage of the computing power of multiple CPUs used by SAP HANA? There are 2 correct answers to this question.

13. Which is the new concept that is introduced and improved by using SAP HANA Specific Features? Please choose the correct answer.

14. What made SAP HANA possible?

15. When to use Enhanced Open SQL? There are 2 correct answers to this question.

16. Name the views that are available to administer and monitor one or several SAP HANA systems? There are 2 correct answers to this question

17. You use the ABAP trace (SAT) to measure the run time of a program. In a class, method X checks the validity of its importing parameters and calls method Y.

What pattern of gross and net run time would you expect to see the in the ABAP trace results for method X? Please choose the correct answer.

18. Which of the following are view annotations for a CDS view? There are 3 correct answers to this question.

19. What are the Parameters for Analytical and Calculation view? There are 3 correct answers to this question.

20. What is the purpose of an ABAP project in ABAP Development Tool for eclipse? There are 2 correct answers to this question

21. Which of the following is not involved in database table of "The NewABAP SQL Monitor-Architecture? Choose the correct answer

22. Which of the following categories of parameters can you use in the definition of an ABAP manage database procedure (AMDP)? There are 3 correct answers to this question.

23. Discuss the basic approach of classical ABAP programming? There are 2 correct answers to this question.

24. Which code-to-data capability is responsible for the Optimizations & Translation of "Open SQL SELECT FOR ALL ENTRIES clauses into native SQL? Please choose the correct answer.

25. What are the two types of editors available in ADT? There are 2 correct answers to this question.

26. Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question.

27. The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question.

28. Discuss the conditions required to ensure the Referential Integrity? There are 2 correct answers to this question

29. What all are the steps to perform -To enable type-ahead for an input field on a screen? There are 3 correct answers to this question.

30. Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)? Please choose the correct answer.

31. The SAP HANA state-of-the-art search experience includes full-text search with advanced features like... There are 3 correct answers to this question.

32. 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? Please choose the correct answer.

33. ABAP 7.4 provide support for optimizing ABAP applications running on SAP HANA.

What are these transparent optimizations? (3 ans)

34. Which of the following is a limitation when you create an external view? Please choose the correct answer.

35. What are the benefits includes with SAP HANA Full Text Search? There are 2 correct answers to this question

36. You use ABAP database connectivity (ADBC) to issue native SQL calls to the database, the native SQL call? Which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call? Please choose the correct answer.

37. You made changes to an object (X) used by an ABAP managed database procedure (AMDP). You did NOT changes the AMDP itself. Now you execute a program that calls this.

In which cases does the call trigger the creation of the database procedure in SAP HANA? There are 2 correct answers to this question.

38. How to create a core data services view? (3 ans)

39. What are the elements of ABAP Database Integration? There are 3 correct answers to this question.

40. You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias? There are 3 correct answers to this question.

41. You create a new table definition using the ABAP Dictionary and maintain the database-specific technical settings table?

Why do you create a row store instead of a column store Please choose the correct answer?

42. In an ABAP Core Data services (CDS) view, what must you do expose an association for use in another CDS view? Please choose the correct answer.

43. You developed an ABAP managed database procedure (AMDP). You want to allow the enhancement of this AMDP using business add-in (BADI).

Which of the following objects must you create? There are 3 correct answers to this question.

44. SAP HANA DB Migration: you want to avoid any functional issues after the migration? There are 3 correct answers to this question.

45. What all are the factors involved in Working with ADT.

If the search options are enabled, you can set the search parameters for an attribute of a view, which parameters will be available? There are 3 correct answers to this question.

46. The SAP HANA database is a hybrid in-memory database that combines Few technologies within.

What are these technologies? There are 3 correct answers to this question

47. You are implementing an ABAP Managed Database Procedures (AMDP) for SAP HANA.

What do you have to do in the corresponding ABAP class? Please choose the correct answer.

48. How many result sets are returned when an SAP HANA database procedure is called using the CALL WITH OVERVIEW statement? Please choose the correct answer.

49. What are the key points that should be kept in mind while performing the Non-automatic update in SAP HANATr.Cont.? There are 2 correct answers to this question.

50. Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question.