EMT Practice Test

1. Question Content...

---

Question1: Which of the following JOIN types are supported in Open SQL? 3 ans

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

Question3: Which JOIN types can be used in the definition of a Core Data Services (CDS) view? 2 ans

Question4: Which system schema contains the list of Activated and inactive Objects?

Question5: HANA modeling views can be created under

Question6: You apply static code checks on your ABAP coding to find potential functional regressions and receive a message about an "Unsecure use of FOR ALL ENTRIES'' issue. Which tool can you use to get additional runtime information?

Question7: Which system schema/user is the owner of all the activated objects?

Question8: Which recent software innovations are applied in SAP HANA? 3 ans

Question9: List down the three main concepts of the SAP HANA database There are 3 correct answers to this question

Question10: You import an ABAP workbench request into a SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package 2HA400_00. WHICH PREREQISITIES are mandatory for an implicit deployment of the SAP HANA view onto the database? There are 2 correct answers to this question.

Question11: ANSI SQL owns features and adds languages. These languages divided into three parts. What are they? There are 3 correct answers to this question.

Question12: How can you enhance an existing ABAP Search Help with a type-ahead function?

Question13: 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

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

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

Question16: You define and implement an AM DP. What do you have to list after the USING clause? There are 3 correct answers to this question.

Question17: Which system schema contains the list of Activated and inactive Objects?

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

Question19: What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster? There are 2 correct answers to this question

Question20: 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

Question21: You perform a static code check using the Code Inspector (SCI). In your SCI variant, you select the Search problematic SELECT * statement check. What does this check report? Please choose the correct answer.

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

Question23: What is the main advantage of SQLScript? (2 answers)

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

Question25: In order to get language-specific data, which join is used in SAP HANA?

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

Question27: What are the two different kinds of Identifiers used to represent names used in SQL statement? There are 2 correct answers to this question

Question28: Discuss the basic approach of classical ABAP programming. Two answers

Question29: List down the elements involved in User Management and Security in SAP Hana? There are 3 correct answers to this question

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

Question31: You apply static code checks on your ABAP coding to find performance optimization potential and receive a message about a "Problematic SELECT * statement" issue. How can you improve the performance of your ABAP code?

Question32: What are the features associated with ABAP CDS? (3 Ans) There are 3 correct answers to this question.

Question33: What all are the Types of Applications based on SAP HANA? There are 2 correct answers to this question.

Question34: What is the central goal of using SAP HANA? Please choose the correct answer

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

Question36: You want to implement business logic on the database layer.
Which approach do you follow when implementing an ABAP Managed Database Procedure?

Question37: What is Core Data Services (CDS)?

Question38: You define and implement an ABAP Managed database procedure (AMDP). What do you have to list after the USING clause? (3 right answers)

Question39: In ADT which setting below to a specific project rather than the entire workbench. Choose the correct answer

Question40: What are the benefits of using the SQL Monitor (transaction SQLM)? There are 2 correct answers to this question.

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

Question42: Which tasks does the ABAP managed database (AMDP) framework perform? There are 2 correct answers to this question.

Question43: What is the main function of Static Code Analysis? Please choose the correct answer.

Question44: How can you check if Core Data Services (CDS) views with scalar input parameters can be used in Open SQL queries in your system?

Question45: Which option in SAP NetWeaver Gateway Service Builder (transaction SEGW) can be used to implement the consumption of a Core Data Services view?

Question46: Explain the Authorization Concept and the types of privileges associated with it? There are 3 correct answers to this question

Question47: An Analytic Privilege consists of several restrictions. What are they? There 3 correct answers to this question

Question48: What do you understand by the SAP HANA Software Optimization? Please choose the correct answer.

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

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

Question51: Which conditional expressions can be used in Core Data Services (CDS) views? 2 ans

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

Question53: Which statement is true for SAP HANA?

Question54: What you must do when you define and implement an ABAP Managed Database Procedure AMDP? (3 ans) There are 3 correct answers to this question.

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

Question56: Which SAP HANA engine executes Calculation view? (2 answers)

Question57: Which of the following can be part of an analytic view? (3 answers)

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

Question59: Which system schema contains the information about Time data and Schema Mapping?

Question60: What are the features associated with ABAP CDS? There are 3 correct answers to this question.