ABAP HANA

Which of the following are performance recommendations when using SAP HANA?. Move data-intensive calculations from the database to an application server. Define indexes on the columns that are used in calculations. Avoid transferring large result sets between database and client applications. Filter data in lower layers.

What are the principles of Using HANA Transport Containers properly?There are 3 correct answers to this question. To create Transport containerr of delivery unit. Automatic update for all export methods. Takes a ‘snapshot’ of all SAP HANA objects of delivery unit. Import of Transport Request. Release of Transport request.

Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question. Open SQL. ABAP Dictionary. Core data service (CDS) access control. Core data services (CDS) data definition.

What do you understand by The SAP HANA Software Optimization. Huge potential for hybrid database. Provide combinations of Objects and Partitioning. Speed up the processing within the database. Bring logic to where the data is calculated first, then only move to results.

List down the elements involved in User Management and Security in SAP HANA? There are 3 correct answers to this question. Assign job security. Assign security. Manage users. Create users. Work management.

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

ABAP 7.4 provides support for optimizing ABAP applications running on SAP HANA. What are these Transparent Optimizations? There are 3 correct answers to this question. Do all the data processing in Application server. The consumption of SAP HANA artifacts was simplified. The ABAP language and the Open SQL language have been extended. Performance analysis tools have been improved. Re- use components have been extended or optimized for SAP HANA.

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

What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? There are 2 correct answers to this question. All ABAP variables must be escaped with a proceeding @ sign. All arithmetic expressions can be used for all type of variables. All Keywords are case sensitive. All fields in the GROUP BY clause must be separated by commas.

What are the benefits associated with The SAP HANA real-time Operational analytics? There are 2 correct answers to this question. Query Speed support. Simplification of massive data. Fast insights into business activity. High modeling flexibility.

You define and implement an ABAP Managed database procedure (AMDP). What do you have to list after the USING clause? There are 3 correct answers to this question. ABAP Dictionary table used in the procedure body. SAP HANA views used in the procedure body. ABAP Dictionary views used in the procedure body. AMDP used in the procedure body. CE function used in the procedure body.

You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias? There are 3 correct answers to this question. Unit conversion. Currency Conversion. CASTE Expression. Nested CASE expression. CASE expression.

Which of the following objects can you use in the ABAP layer when using the top-down approach to bring code to data? There are 2 correct answers to this question. Calculation views. Stored procedures. ABAP managed database procedures. Core data services views.

To connect with the SAP HANA system and see the corresponding catalog content etc., use the Systems view. How will you add a system to this view? There are 2 correct answers to this question. By using SQL application. Database user – also different from your ABAP user. By using Open Catalog look. Password for the database user.

You are working with ABAP Development Tools (ADT) For Eclipse. Which of the following options belongs to the settings of a specific ABAP project rather than the entire Eclipse workbench.

What all are the advantages provides by ABAP Development Tools? There are 3 correct answers to this question. A set of Eclipse data pool and Client- Open platform. An open platform for developing powerful database view. An open platform for developing new ABAP-related tools. A set of open, language- and platform-independent APIs. A brand new ABAP development experience on top of the Eclipse platform.

You use ABAP database connectivity (ADBC) to issue native SQL calls to the database. Which of the following methods of class CL_SQL_RESULT_SET retrieves the result set of the native SQL call?. EXECUTE_QUERY. NEXT_PACKAGE. SET_PARAM. SET_PARAM_TABLE.

Which tasks does the ABAP managed database (AMDP) framework perform? There are 2 correct answers to this question. Delete the obsolete versions of the database procedure synchronously. Delete the obsolete versions of the database procedure asynchronously. Create a new version of the database when the AMDP is first called. Create a new version of the database when the AMDP is first activated.

List down the four main concepts of the SAP HANA database? There are 3 correct answers to this question. Partitioning. Object store. Tools combinations. Compression. Column Store.

Why is a security concept in SAP HANA required? There are 2 correct answers to this question. Database administration should be restricted to skilled. Editing of SAP HANA data models should only be possible for “Users.” of the model. Need to have selected users in SAP HANA for Information Management. Access to ERP tables must be restricted.

What made SAP HANA possible? There are 2 correct answers to this question. RAM limitation. Technology and innovations. Improved hardware technology. CPU with single core network.