Before migrating to SAP HANA, which Code Inspector check do you have to consider to avoid functional regressions?
A . Standard Web Dynpro checks
B . Search for DB operations across modularization units
C . SELECT statements that bypass the table buffer
D . Use of the ADBC interface
Answer: D
What is the main advantage of SQLScript? (2 answers)
A . SQLScript can be better modularized than traditional SQL
B . SQLScript code can easily be translated into modeling view
C . SQLScript is faster than traditional SQL
Answer: A,C
You define and implement an ABAP Managed database procedure (AMDP).
What do you have to list after the USING clause? (3 right answers)
A . ABAP Dictionary views used in the procedure body
B . ABAP Dictionary table used in the procedure body
C . AMDP used in the procedure body
D . function used in the procedure body
E . SAP HANA views used in the procedure body
Answer: A,B,C
Discuss the basic approach of classical ABAP programming. Two answers
A . Collect all the data and perform parallel processing in ABAP
B . Creating and consuming all the contents from network
C . Get all the data you need on the application server and do your processing in ABAP
D . Keep load from the database
Answer: C,D
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
A . Calculation views
B . ABAP managed database procedures
C . Stored procedure
D . Core data services views
Answer: B,D
What can you include in the projection list of a Core Data Services (CDS) view? 3 ans
A . ABAP system fields such as sy-langu or sy-mandt / CI String constants and literal values
B . Aggregation functions over fields of ABAP Dictionary tables used in the FROM clause
C . A field from the structural output of an ABAP Managed Database Procedure used in the FROM clause
D . A field from the projection list of another CDS view used in the FROM clause
Answer: B,C,D
You developed an ABAP program using ABAP Development Tools for SAP NetWeaver.
How can you execute it? 2 ans
A . In the Project Explorer view, right-click the program and choose Run As ― ABAP Application from the context menu.
B . Use the Open Development Object dialog (CTRL+SHIFT+A) and enter <Program_Name>/Execute in the search field.
C . Open the ABAP program in the ABAP Development perspective and execute it using the shortcut F8.
D . Open the ABAP program in the ABAP Development perspective and execute it using the shortcut Fl.
E . Call transaction SRUN_ADT and enter the name of the ABAP program.
Answer: A,C
Analytic Privilege can be applied to (3 Answers)
A . Calculation views
B . Attribute views
C . Analytic views
D . Table
E . SQL View
Answer: A,B,C
According to the performance analysis recommendations; which steps are recommended after doing a database migration to SAP HANA?
A . Perform regular performance scans on your ABAP custom coding as part of the development process.
B . Perform regular performance scans on the ABAP coding delivered by SAP as part of your development process.
C . Activate your ABAP custom coding, which was deactivated before the database migration, using U transaction SFW5.
D . Switch the storage type of you custom database tables to column store and use the database utility (SE14) to perform the database table conversion.
Answer: A
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.
A. Read-write
B. Read only
C. Write only
D. Read-update
Answer: B