EMT Practice Test

1. Question Content...

---

Question1: Which of the following Open SQL statements are syntactically correct in release 7.50? Note: There are 3 correct Answers to this question.

Question2: There are many syntax differences between SAP HANA SQLScript and Open SQL. Which of the following rules are common ground between the two languages? Note: There are 2 correct Answers to this question.

Question3: You implement the behavior of a CDS-based BOPF Business Object. For which of the following tasks can you reuse the implementation from the BOPF public library?

Question4: You have written the following code: START-OF-SELECTION. LOOP AT itab INTO DATA(line). * ENDLOOP.
The system creates a variable called Line. When is it created and when can you address it?

Question5: Which of the following CDS view definitions is syntactically correct?

Question6: You want to search for custom code that needs to be adjusted. Which of the following tools can you use?

Question7: Which of the following new repository object types were introduced with ABAP CDS? Note: There are 3 correct Answers to this question.

Question8: Which building blocks of the ABAP RESTful Programming Model (RAP) are part of the Core Data Services (CDS)? Note: There are 2 correct Answers to this question.

Question9: You develop an OData V2 service in SAP Gateway.What is listed in the service document?

Question10: Which of the following do you use as a separator between a table and a field name in Open SQL?

Question11: Where do you distinguish between OData V2 or OData V4?

Question12: You edit a behavior implementation class of a draft-enabled BOPF Business Object. You need to distinguish between a new draft instance and an edit draft instance. Which property of the node instance do you evaluate?

Question13: You implement the Behavior of a CDS-based BOPF Business Object. You call method update( ) of the BOPF data modifier to update instance data of node ZMY_NODE. How do you type the actual parameter of import parameter IS_DATA?

Question14: You create a project in the Custom Code Migration app to analyze the readiness of custom code for SAP S/4HANA. How does the app supply the check results?

Question15: Which of the following tasks are typically done in a Projection view of the ABAP RESTful Application Programming Model (RAP)? Note: There are 2 correct Answers to this question.

Question16: What can you use as data source for an SAP Fiori App Launcher - Dynamic?

Question17:

Question18: The root-node of a CDS-based business object is based on CDS View ZMY_VIEW. The persistent data is stored in the database table ZMY_TABLE. At least one key field of ZMY_TABLE has a different name in CDS View ZMY_VIEW. Which kind of repository object is needed to map the fields of ZMY_VIEW to the fields of ZMY_TABLE?

Question19: You implement a SELECT statement in ABAP. When do you use the key word FIELDS?

Question20: Which of the following ways can you use to address input parameter X in the CDS view definition? Note:
There are 2 correct Answers to this question.

Question21: In a Custom Business Object you want to implement a determination for a node with the ID SALESORDER. What kind of parameter is the SALESORDER parameter?

Question22: You are defining a variant in the ABAP Trace tool (SAT). Which of the following trace restrictions can you set? Note: There are 2 correct Answers to this question.

Question23: For performance optimization, you want to combine the results of ABAP Test Cockpit and the SQL Monitor runtime data. Which tool do you use for this?

Question24: You use the following expression to address the internal table gt_flights: gs_flight = gt_flights[ carrid =
'XX' connid = '9999' ]. There is NO table entry with the specified key. What is the result of the statement?

Question25: You maintain a transactional app for sales orders that is built with the ABAP Programming model for SAP Fiori. For which of the following tasks would you implement a determination of the BOPF Business Object? Note: There are 3 correct Answers to this question.

Question26: In SAP S/4HANA, a replacement object is assigned to transparent table ANEA. Which uses of table ANEA do you have to correct when migrating an SAP ERP system to SAP S/4HANA? Note: There are 2 correct Answers to this question.

Question27: You use the following expression to address the internal table gt_flights: gs_flight = gt_flights[ carrid =
'XX' connid = '9999' ]. There is NO table entry with the specified key. What is the result of the statement?

Question28: What can you do with the SQL Trace Tool (ST05)? Note: There are 3 correct Answers to this question.