In an Open SQL query, you select the sum of sales order gross amounts and a CASE statement to flag sa order gross amounts below a certain value. What information has to be provided in the GROUP BY list?
One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any functional issues after the migration. What should you search for and if necessary replace in the existing custom ABAP code? There are 3 correct answers to this question.
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.
You want to implement business logic on the database layer.
Which approach do you follow when implementing an ABAP Managed Database Procedure?
What are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container? (2 right answers)
You created and activated database procedure. How can you call this procedure? There are 2 correct answers to this question.
What are the steps that supported several tools, which in total result in a Guided Performance Optimization? There are 2 correct answers to this question.
What are the features of New Open SQL? There are 2 correct answers to this question.
Why is a security concept in SAP HANA required? There are 2 correct answers to this question
How will you hide the attributes that are not required for client consumption? Choose the correct answer
Which JOIN types can be used in the definition of a Core Data Services (CDS) view? 2 ans
How can you check if Core Data Services (CDS) views with scalar input parameters can be used in Open SQL queries in your system?
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.
What are the Functions of Transaction DBACOCKPIT There are 2 correct answers to this question.
Which form of services is responsible for defining and consuming semantically rich data models. Please choose the correct answer.
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.
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.
What are the two different kinds of Identifiers used to represent names used in SQL statement? There are 2 correct answers to this question