1. What can you include in the projection list of a Core Data Services (CDS) view? 3 ans

2. Explain the Enterprise Information System of- SAP HANA Implementation Scenarios? There are 3 correct answers to this question

3. Discuss the main capabilities of SAP BusinessObjects Analysis for Office? There are 2 correct answers to this question

4. Open SQL largely standardized, three sub-languages.

What are these sub-languages? There are 3 correct answers to this question

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

6. 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.

7. DB-Specific Properties that allows switching between storage types when running on an SAP HANA database.

What are these storage types? There are 2 correct answers to this question.

8. You define and implement an ABAP Managed database procedure (AMDP).

What do you have to list after the USING clause? (3 right answers)

9. Discuss the basic approach of classical ABAP programming. Two answers

10. According to the performance analysis recommendations; which steps are recommended after doing a database migration to SAP HANA?

11. Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)?

12. Analytic Privilege can be applied to (3 Answers)

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

14. Which of the following ABAP language elements are mandatory for the implementation of a method as an ABAP Managed Database Procedure? 3 ans

15. What are some of the features available SAP List Viewer with integrated data access (SALV IDA)? There are 3 correct answers to this question.

16. You changed an SAP HANA object that you transported using an SAP HANA Transport container. You want to release the transport request with your changes.

In which sequence do you perform activities in the ABAP development system immediately before the release? Please choose the correct answer.

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

18. Which system schema contains the list of Activated and inactive Objects?

19. How can you exchange SQL Monitor data between two systems?

20. Which of the following objects can you use in the ABAP layer when using the top-down approach to bring code to data? There are 2 correct answers to this question

21. Which is better from performance point of view?

22. You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SOJD).

Which SELECT statement would you use in the definition? Please choose the correct answer.

23. You execute a Native SQL query statement to retrieve a list of information using the corresponding ABAP Database Connectivity (ADBC) API method.

Which additional steps are necessary to retrieve the result set into an internal table? 2 ans

24. Which of the statements are true for SQLScript? (2 answers)

25. In addition to closing the result set. what does the CLOSE method of the CL_SQL_RESULT_SET class when using ABAP Database Connectivity (ADBC) do? Please choose the correct answer.

26. You have defined the following SQLScript procedure: CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS SQL DATA.

Which type of database procedures can be called in this SQLScript procedure? Please choose the correct answer.

27. You analyse 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 data. But the relevant database access is NOT listed in SQLMD.

What could be the reason?

Note: There are 3 correct answers to this question.

28. 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.

29. Your development team needs to include SAP HANA objects into an ABAP workbench request. You want to use SAP HANA Transport for ABAP (HTA) and NOT the SAP HANA Transport Container (HTC).

Why would you choose HTA? Note: There are 2 correct answers to this question.

30. Why is a security concept in SAP HANA required? There are 2 correct answers to this question

31. What is the central goal of using SAP HANA? Please choose the correct answer

32. Which statement is true for SAP HANA?

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

34. Which system schema contains the column views of activated objects?

35. You developed an ABAP program using ABAP Development Tools for SAP NetWeaver.

How can you execute it? 2 ans

36. 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.

37. Which components can be a part of a calculation view? (2 answers)

38. What is the main advantage of SQLScript? (2 answers)

39. 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.

40. What is the scope of the AbapCatalog.Buffering annotation in a Core Data Services (CDS) view?

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

42. Which form of services is responsible for defining and consuming semantically rich data models. Please choose the correct answer.

43. What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling? There are 2 correct answers to this question

44. Which of the following is not an element of Analytical view? Please choose the correct answer.

45. What is the purpose of an ABAP project in ABAP Development tools for eclipse? (2 right answers)

46. 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:

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

48. Which feature can you use to improve the performance of data transformation in the Extract, Transform and Load (ETL) process?

49. Before migrating to SAP HANA, which Code Inspector check do you have to consider to avoid functional regressions?

50. Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)? There are 3 correct answers to this question.