EMT Practice Test

1. Question Content...

---

Question1: Which of the following are classes of the ABAP Database Connectivity (ADBC) API? 2 ans

Question2: Which of the following is true? (2 correct answers)

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

Question4: How will you hide the attributes that are not required for client consumption? Choose the correct answer

Question5: Which of the following ABAP transactions can you use to detect SQL performance optimization potential in your ABAP code? 2 ans

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

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

Question8: Which of the below has huge negative impact on performance? (2 answers)

Question9: What are the advantages of column based tables? (3 correct answers)

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

Question11: What are the principles of Using HANA Transport Containers properly? There are 3 correct answers to this question.

Question12: You implement an ABAP-managed database procedure (AMDP). You want to query data from Calculation view CA_BOOKINGS_COUNT in SAP HANA content package ha400.primdb.
How can you address the calculation view?
Note; There are 2 correct answers to this questions.

Question13: You want to develop an ABAP application for SAP HANA using the front-end image of your Amazon Web Service (AWS) trial system. Which plug-ins do you need to add to the existing Eclipse installation?

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

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

Question16: Which components can be a part of a calculation view? (2 answers)

Question17: You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter on the right-hand side of an assignment operator within the procedure. How do you refer to the parameter? Please choose the correct answer.

Question18: How can you exchange SQL Monitor data between two systems?

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

Question20: What is the operating system supported by HANA? (2 correct answers)

Question21: Open SQL largely standardized, three sub-languages. What are these sub-languages? There are 3 correct answers to this question

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

Question23: What views will be most efficient for General Modeling Principles? There are 2 correct answers to this question

Question24: Which of the following feature were added to the ABAP Dictionary to support the SAP HANA database? There are 3 correct answers to this question.

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

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

Question27: Which character is used to escape host variables in the new Open SQL syntax?

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

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

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

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

Question32: 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?

Question33: AM DP can detect 3 types of syntax errors in active or inactive source code. What are these errors ? There are 3 correct answers to this question.

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

Question35: You have created a CDS view as follows: define view zha400 as select from spfli association (*) to sflight as_flights On spfli.carrid =_flights.carrid and spfli.connid=_flights.connid
{
...
}
Given that table sflight also contains the field planetype, how must you address the fields carrid and planetype from table SFLIGHT?

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

Question37: What is the system privilege required to drop analytic privilege?

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

Question39: What are the ABAP development guidelines? There are 2 correct answers to this question.

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

Question41: In ABAP Development Tools for SAP NetWeaver, you execute the ABAP Test Cockpit on an ABAP program to find performance optimization potential.
Where can you find the result of the static code checks?

Question42: What are the Perspectives and Views of SAP HANA Studio? There are 2 correct answers to this question.

Question43: Analytic Privilege can be applied to (3 Answers)

Question44: Which system schema contains the column views of activated objects?

Question45: HANA modeling views can be created under

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

Question47: You plan a database migration to SAP HANA and want to check your ABAP coding for potential functional regressions.
Which Code Inspector check variant can you use?

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

Question49: What are best practices when programming in ABAP for SAP HANA? There are 2 correct answers to this question.

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

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

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

Question53: Which is not a Golden Rule for Open SQL? Please choose the correct answer.

Question54: What is Core Data Services (CDS)?

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

Question56: You are working with ABAP Development Tools (ADT) For Eclipse. Which of the following options belongs to the settings of a specific ABAP project rather than the entire Eclipse workbench?

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

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

Question59: Which of the statements are true for SQLScript? (2 answers)

Question60: Which of the following information is mandatory in the definition of an association in a Core Data Services (CDS) view?