|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 .
Name some perspectives that are available in the SAP HANA Studio (3 ans) The technology & innovation perspective The Administration Console perspective The information perspective The SAP HANA Modeler Perspective The Resources perspective .
What are the steps involved in supporting a database oriented programming model There are 2 correct answers to this question A new and advanced Open SQL Core Data services Buffer system services Advanced and specific models .
How to create a core data services view (3 ans) Use SQL capabilities for Netweaver Use data services tools for updates Use DDL statement DEFINE VIEW and SQL like syntax to define the view Use the ABAP Development Tools for SAP Netweaver Use additional annotations - marked with the @sign .
What all are the advantages provides by ABAP Development Tools There are 3 correct answers to this question A set of open, language- and platform-independent APIs A brand new ABAP development experience on top of the Eclipse platform An open platform for developing new ABAP-related tools An open platform for developing powerful database view set of Eclipse data pool and Client- Open platform.
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 .
What should you do to follow the code-to-data approach to programming There are 3 correct answers to this question Use native SQL to access SAP HANA built-in functions Perform expensive calculations on the database Aggregate data on the database, and transfer the results to the ABAP layer Perform expensive calculations on the ABAP application server Transfer all data from the database to the ABAP layer, and then aggregate the results .
What are the ABAP development guidelines There are 2 correct answers to this question Consuming Only ABAP contents for SAP HANA Improved tools for performance analysis Improved hybrid components for SAP HANA Extensions to ABAP Language .
What is a security concept in SAP HANA required There are 2 correct answers to this question Need to have selected users in SAP HANA for Information Management Access to ERP tables must be restricted Editing of SAP HANA data models should only be possible for "Users" of the model Database administration should be restricted to skilled .
What are the steps involved in SAP HANA Evolution There are 3 correct answers to this question ABAP as accelerator on SAP HANA ABAP applications on SAP HANA ABAP can access SAP HANA ABAP can run on SAP HANA Optimized ABAP on SAP HANA .
When are referential joins executed in analytical views Choose the correct answer When all the tables are optimized When fields are selected When fields are optimized When fields from both the tables are requested .
What information can you specify using annotations (marked with the @ sign) when you define a CDS view in an ABAP system There are 3 correct answers to this question The join conditions of the CDS view The logic for aggregations, grouping records, and filtering groups of the CDS view The client dependency of the CDS view The name of the representation of the CDS view in the ABAP dictionary The extent to which records of the CDS view should be buffered on the application server .
You made changes to an object (X) used by an ABAP managed database procedure (AMDP) You did NOT changes the AMDP itself Now you execute a program that calls this In which cases does the call trigger the creation of the database procedure in SAP HANA There are 2 correct answers to this question X is a stored procedure X is an SAP HANA view X is an ABAP Dictionary table X is an AMDP method.
What are the Guidelines for optimizing ABAP code running on HANA There are 3 correct answers to this question Open SQL settings Technical settings High-speed data analysis DB specific properties Column store .
What do you have to consider if you want to use Native SQL in your ABAP programs to access an SAP HANA DB There are 2 correct answer to this question The ABAP system check the syntax of the Native SQL statements Client handling needs to be done explicitely in the Native SQL statement The database independency of your report can be lost Hashed or sorted tables must be used with the INTO CORRESPONDING FIELDS keyword .
Which is the new concept that is introduced and improved by using SAP HANA Specific Features Please choose the correct answer Programming model Table buffering New advanced SQL syntax Procedures ABAP-Managed Database Procedures .
What are the uses of SQL Trace (ST05) There are 3 correct answers to this question Applying Code inspector Locate database performance issues Display record of all database access Detect redundant or identical select statements Locate work base issues .
List down the three main concepts of the SAP HANA database There are 3 correct answers to this question Column Store Tools combinations Object store Partitioning Compression .
In an ABAP Core Data services (CDS) view, what must you do expose an association for use in another CDS view Please choose the correct answer Include all fields used in the ON condition in projection list Specify an alias for the target entity Define the cardinality for the target entity Specify the other views in which the association can be used .