Hana 7.0

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

What are the ABAP development guidelines?. Improved hybrid components for SAP HANA. Extensions to ABAP Language. Improved tools for performance analysis. Consuming Only ABAP contents for SAP HANA.

Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP?. Swap axes. Insert filter components. Create data by members and tables. Create Presentations.

Which of the following objects can you use in the ABAP layer when using the top-down approach to bring code to data?. ABAP managed database procedures. Calculation views. Stored procedure. Core data services views.

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

The new bottlenecks avoided by addressing two challenges, what are they?. Avoid single network. Avoid CPU cache misses. Avoid optimizing data. Avoid idling CPU cores.

What is an attribute view and what are its practices?. May contains flow charts. Used in diagrammatic Projections. Used to join tables. May contain filters. May use in calculation views.

Which of the following tool is introduced as a holistic quality assurance tool?. DBA Cockpit. DBMS Cockpit. ABAP Test Cockpit (ATC). BW system.

What is the main purpose of SAML for SAP HANA Studio?. The SAP HANA database supports login of Owners only. SAML may be selected as an Owner’s authentication method when creating users in the SAP HANA Studio. To support scenarios where clients are not directly connected to the SAP HANA Database. The assertion is issued by a user after the client was successfully authenticated.

What are some of the features available SAP List Viewer with integrated data access (SALV IDA)?. Edit cells. Search in content. Display diagrams. Group rows. Double-click on rows.

What are best practices when programming in ABAP for SAP HANA?. Eliminate nested SELECT statements to reduce the overall number of database accesses. Calculate aggregations using ABAP code on the application server to limit database load. Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required. Use a column list in the SELECT clause to ensure that you only read a column if it is really required.

You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAP HANA is used as the database. In the check parameters, which value would you use for the percentage of fields that are effectively used?. A lower value than on a traditional, row-store only based database. A value that you calculate based on the number of tables. A higher value than on a traditional, row-store only based database. The same value as on a traditional, row-store only based database.

Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)?. Combine information from static ABAP code scans with runtime data from the SQL Monitor. Combine information from static ABAP code scans with runtime data from the SQL Trace tool. Estimate the new total runtime of optimized code. Create a graph comparing the runtimes of ABAP code before and after optimization.

What all are the advantages provides by ABAP Development Tools?. A set of Eclipse data pool and Client- Open platform. 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. An open platform for developing powerful database view.

In an ABAP Core Data services (CDS) view, what must you do expose an association for use in another CDS view?. SPECIFY THE OTHER VIEWS IN WHICH THE ASSOCIATION CAN BE USED. Define the cardinality for the target entity. Include all fields used in the ON condition in projection list. Specify an alias for the target entity.

In which of the following situations could a row store table be more suitable than a column store table?. The table contains mainly distinct values per column across rows. The table contains only a small number of records. The table contains text that you want to search. The table contains data that you want to aggregate.

Which of the following is a limitation when you create an external view?. You must use the ABAP Development tools (ADT) TO CREATE the external view. You can only use native SQL to consume the external view. You must include the name of the SAP HANA view in the name of the external view. You must know the underlying tables and join conditions of the SAP HANA view.

The SAP HANA state-of-the-art search experience includes full-text search with advanced features like... Fuzzy search. ACID search. Isolation search. freestyle search. linguistic search.

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

What all are the steps to perform -To enable type-ahead for an input field on a screen?. Switch on proposal search for input fields. Process on all the input fields. Identify Elementary Search Help. Automatic updates of all the input fields. Check Pre-Requisites.