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.

• A.Code that relies on implicit database sorting
• B.ORDER BY Clauses in Open SQL statements
• C.Direct access to a cluster on the database
• D.Left outer joins in open SQL statements
• E.Native SQL statements

Comment: *

Name: *

Email: *

Verification: *

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

• A.Open system properties
• B.System Properties
• C.Administration console
• D.Development properties

Comment: *

Name: *

Email: *

Verification: *

In a Graphical calculation view you want to implement a union between two result sets that differ only in the fact that one of the two has one additional field named ADDRESS. How can you achieve this in a union node? There are 2 correct answers to this question.

• A.Map the ADDRESS field to a constant value
• B.Create a restricted column for the ADDRESS field
• C.Create an input parameter for the ADDRESS field
• D.Exclude the ADDRESS field from the union

Comment: *

Name: *

Email: *

Verification: *

Which Of the Golden Rules for Open SQL performance have become more important With SAP HANA?
Note: There are 2 correct answers to this question.

• A.Minimize the amount of transferred data
• B.Minimize the number of database accesses
• C.Minimize the search overhead.
• D.Keep unnecessary load away from the database.

Comment: *

Name: *

Email: *

Verification: *

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.

• A.ROW
• B.GLOBAL TEMPORARY
• C.COLUMN
• D.LOCAL TEMPORARY

Comment: *

Name: *

Email: *

Verification: *