Online Access Free E-HANAAW-17 Exam Questions

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.

• A.Buffer system Optimization
• B.HANA Specific features
• C.Transparent Optimizations
• D.Database Optimization

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

• A.The Data Control Language (DCL)
• B.Data Evaluation Language(DEL)
• C.The Data Definition Language (DDL)
• D.Data Transferring Language(DTL)
• E.Data Manipulation Language (DML)

What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question.

• A.Transfer all data from the database to the ABAP layer, and then aggregate the results.
• B.Perform expensive calculations on the database.
• C.Use native SQL to access SAP HANA built-in functions.
• D.Perform expensive calculations on the ABAP application server.
• E.Aggregate data on the database, and transfer the results to the ABAP layer.

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

• A.Aggregation functions over fields of ABAP Dictionary tables used in the FROM clause
• B.ABAP system fields such as sy-langu or sy-mandt \/ CI String constants and literal values
• C.A field from the projection list of another CDS view used in the FROM clause
• D.A field from the structural output of an ABAP Managed Database Procedure used in the FROM clause

When are referential joins executed in analytical views? Choose the correct answer

• A.When fields are selected
• B.When fields from both the tables are requested
• C.When all the tables are optimized
• D.When fields are optimized