e-hanaaw-14-worst_2

Explain Transitioning ABAP Code to SAP HANA - Performance Considerations There are 3 correct answers to this question. Some codes immediately run faster. Some shifts in priorities, examples, nested selects(higher) indices(lower). Some codes transferred to other systems. Classical performances recommendations for open SQL remain valid. Some codes impacted positively and should be priorities.

SAP HANA: Delivers Across 5 Dimensions These five dimensions lead to certain goals HANA has to meet What are these goals There are 2 correct answers to this question. Analytical DBMS features. Support for system tables. High Performance and Scalability. Hybrid data and management system.

Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not in the Classical ABAP workbench There are 3 correct answers to this question. Full-text index. Database procedure proxy. ABAP program containing new Open SQL. Core Data service (CDS) view. External view.

Explain the Enterprise Information System of- SAP HANA Implementation Scenarios There are 3 correct answers to this question. HANA Accelerators. All HANA Combinations on one platform. HANA Modeling. All SAP applications on one SAP HANA platform. Business Suite on HANA/ BW on SAP HANA.

SAP HANA DB Migration: you want to avoid any functional issues after the migration There are 3 correct answers to this question. Native sql statement. Direct access to a cluster on the database. Left outer joins in open SQL statements. Order by clause in open SQL statement. Code that relies on implicit database sorting.

What are the Perspectives and Views of SAP HANA Studio There are 2 correct answers to this question. Open system properties. Administration console. Development properties. System Properties.

You created and activated database procedure How can you call this procedure There are 2 correct answers to this question. By another database procedure. By using Sap Analysis for Microsoft office. By a script-based calculation view. By a core data services view.

What are the basic principles of ALV SAP HANA There are 2 correct answers to this question. Data described declaratively instead of passing big internal tables. The ALV Optimization for SAP HANA to display data on the screen. Only retrieve the database data which is to be displayed on screen. To ensure that the user chooses the data on the selection screen is displayed.

AMDP 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. UNION specific syntax errors. Database platform syntax errors. Database independent syntax errors. HANA specific syntax errors. SQLScript errors.

Which code-to-data capability supports- Extended view definitions and Better SQL-92 standard support in open SQL Please choose the correct answer. SAP HANA specific features. Database oriented programming model. New SQL parser used in model. Database for sophisticated analysis.

What are the Parameters for Analytical and Calculation view There are 3 correct answers to this question. Specifying unit of measurement. Passing other values to be used in calculations. Create a copy of a report. To store data for critical analysis. Setting a filter for columns.

What are the benefits of using the SQL Monitor (transaction SQLM) There are 2 correct answers to this question. It collects monitoring data asynchronously without additional database interaction. It schedules ABAP programs to monitor and log all database accesses. It displays the database execution plan for all SQL statements. It can be active in a production system with minimal performance overhead.

What are the Possible Approaches with AS ABAP < 7.4 SP02 There are 2 correct answers to this question. SQL units. Consume using native SQL. Stored Procedures. Interaction with Database.

Which of the following are characteristics of an external view There are 3 correct answers to this question. It can be used as a data type in ABAP programs. It defines the underlying SAP HANA information view. It can be used in Open SQL statements for database updates. It is an ABAP Dictionary object type. It allows access to an SAP HANA information view with Open SQL.

What you must do when you define and implement an ABAP Managed Database Procedure AMDP (3 ans) There are 3 correct answers to this question. Define all the method parameters to pass by value. List all the ABAP dictionary tables used in the procedure body in the USING clause. Use Scalar types for all the AMDP method parameters. Specify the database system and language. Mark the AMDP method as read-only.

You developed an ABAP managed database procedure (AMDP) You want to allow the enhancement of this AMDP using business add-in (BADI) Which of the following objects must you create There are 3 correct answers to this question. A BADI definition. A BADI fallback implementation. An enhancement spot. A database procedure. A BADI simple implementation.

ABAP 7.4 provide support for optimizing ABAP applications running on SAP HANA What are these transparent optimizations (3 ans). Performance analysis tools have been improved. Do all the data processing in Application server. The consumption of SAP HANA artifacts was simplified. Re-use components have been extended or optimized for SAP HANA. The ABAP language and the Open SQL language have been extended.