HANA_14_1

Which is the new concept that is introduced and improved by using SAP HANA Specific Features? Please choose the correct answer. ABAP-Managed Database Procedures. New advanced SQL syntax Procedures. Table buffering. Programming model.

What are the Functions of Transaction DBACOCKPIT There are 2 correct answers to this question. Maintain, Monitor and test secondary database connection. Used to access local or remote database system. Use Schema for the Connections. Maintain only HANA specific objects.

You create a new table definition using the ABAP Dictionary and maintain the database-specific technical settings. Why do you create a row store instead of a column store table? Please choose the correct answer. To limit the need of indexes. To allow creation of a full-text index. To limit the unpacking and reconstruction of rows. To limit the data footprint.

What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling? There are 2 correct answers to this question. Costing-based Profitability. Product-based Profitability. Account-based Profitability. Service-based profitability.

Hybrid Data Management System – Combining different paradigms in one system. Discuss capabilities associated with the Hybrid Data Management system? There are 3 correct answers to this question. Built-in support for planning. Text indexing capabilities. Linguistic search capabilities. Traditional disk-based tables. Text analysis and search.

What are the elements of ABAP Database Integration? There are 3 correct answers to this question. Client database handling. DB For ABAP. Other DB. Application server. DB client-server.

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. The ABAP language and the OpenSQL language have been extended. Re- use components have been extended or optimized for SAP HANA. Performance analysis tools have been improved. The consumption of SAP HANA artifacts was simplified. Do all the data processing in Application server.

You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter on the right-hand side of an assignment operator within the procedure. How do you refer to the parameter? Please choose the correct answer. :it_books. @it_books. {it_books}. it_books.

How will you hide the attributes that are not required for client consumption? Choose the correct answer. By setting the hidden property flag of the attribute in the View. By setting the hidden property flag of the attribute provider. By setting the hidden property flag of the attribute in the Semantics screen. By setting the hidden property flag of the attribute column.

In addition to closing the result set, what does the CLOSE method of the CL_SQL_RESULT_SET class when using ABAP Database Connectivity (ADBC) do? Please choose the correct answer. Release resources. Update packages. Release packages. Update resources.

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. Database user – also different from your ABAP user. By using SQL application. By using Open Catalog look. Password for the database user.

Which data provisioning methods can you use when you need real time replications? There are 3 correct answers to this question. SAP HANA Direct extractor connection (SAP DXC). SAP Landscape transformation Replication server (SAP SLT). SAP Replication server. SAP Data services.

What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster? There are 2 correct answers to this question. Active clusters for all servers. High availability configuration. Services-Name and index server on all nodes. Shared file systems for only one server.

Which data sources can you use for SAP list viewer with integrated data access? There are 3 correct answers to this question. Database Table. CDS View. Internal table. Database Procedure. External view.

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 AMDP. 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 two main factors of SAP HANA Innovations and Challenges? There are 2 correct answers to this question. HW technology and innovations. SAP BW innovations. SAP SW technology and innovations. DBMS technology and innovations.

How to create a core data services view? There are 3 correct answers to this question. Use additional annotations – marked with the @ sign. Use DDL statement DEFINE VIEW and SQL-like syntax to define the view. Use data services tools for updates. Use the ABAP Development Tools for SAP NetWeaver. Use SQL capabilities for Netweaver.

Which of the following is not involved in database table of “The New ABAP SQL Monitor – Architecture”? Choose the correct answer. Critical data table. Runtime monitor data. Performance data table. Selection data table.

What are the two different kinds of Identifiers used to represent names used in SQL statement? There are 2 correct answers to this question. Delimited identifiers. Numeric identifiers. Undelimited Identifiers. Limited identifiers.

Open SQL largely standardized, three sub-languages. What are these sublanguages? There are 3 correct answers to this question. The Data Definition Language (DDL). The Data Control Language (DCL). Data Evaluation Language(DEL). Data Transferring Language(DTL). Data Manipulation Language (DML).

The SAP HANA state-of-the-art search experience includes full-text search with advanced features like... There are 3 correct answers to this question. freestyle search. Fuzzy search. linguistic search. ACID search. Isolation search.

How many result sets are returned when an SAP HANA database procedure is called using the CALL. WITH OVERVIEW statement? Please choose the correct answer. Two result sets. As many result sets as there are table output parameters in the procedure. As many result sets as there are input parameters in the procedure. One result set.

What is the Limitations of ALV for SAP HANA? There are 3 correct answers to this question. No unit/ currency split if aggregating amounts/ currency values. Restricted to 5000 records / unit. All unit/ currency restricted to 10,00,00 records. Without currency /unit consideration. Restricted to 10,000 records.

Which data provisioning methods can you use when you need real time replications? There are 3 correct answers to this question. SAP HANA Direct extractor connection (SAP DXC). SAP Data services. SAP Landscape transformation Replication server (SAP SLT). SAP Replication server.

What are functions of the ABAP Managed Database Procedure (AMDP) framework? There are 2 correct answers to this question. It deletes obsolete versions of the database procedure asynchronously. It deletes obsolete versions of the database procedure synchronously. It creates the database procedure when the AMDP is first activated. It creates the database procedure when the AMDP is first called.

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 Open Catalog look. Password for the database user. By using SQL application. Database user – also different from your ABAP user.

Which is not a key factor of ALV for HANA? Please choose the correct answer. Derived Column headings from the data element. The data display is restricted to a maximum of 2 billion cells. To supply suitable values for any input parameters. To Activate and execute the program in the application.

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

What are the basic principles of ALV SAP HANA? There are 2 correct answers to this question. 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. The ALV Optimization for SAP HANA to display data on the screen. Data described declaratively instead of passing big internal tables.

What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question. Core Data services. Buffer system services. A new and advanced Open SQL. Advanced and specific models.

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

Hybrid Data Management System – Combining different paradigms in one system. Discuss capabilities associated with the Hybrid Data Management system? There are 3 correct answers to this question. Text analysis and search. Built-in support for planning. Traditional disk-based tables. Text indexing capabilities. Linguistic search capabilities.

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

Which of the following are view annotations for a CDS view? There are 3 correct answers to this question. Buffering type. Client handling. Access control. Environment. Semantics.

What are the two main factors of SAP HANA Innovations and Challenges? There are 2 correct answers to this question. SAP BW innovations. SAP SW technology and innovations. HW technology and innovations. DBMS technology and innovations.

What are the Performance Rules and Guidelines for ABAP on SAP HANA? There are 2 correct answers to this question. To Keep all the loads away from the DB. To reduce main memory consumption and to improve insert performance. It is beneficial for maximizing your search into database. It is beneficial to move data-intensive calculations into the database.

What all are the factors involved in Working with ADT There are 3 correct answers to this question. Module interface. Workbench programs. ABAP programs. ABAP interface. ABAP Class.

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

What are the features of New Open SQL? There are 2 correct answers to this question. Supports specific units of database. Supports Code adjustment model. Supports conditional expressions. Supports arithmetic and string expressions.

Which is the new concept that is introduced and improved by using SAP HANA Specific Features? Please choose the correct answer. New advanced SQL syntax Procedures. ABAP-Managed Database Procedures. Programming model. Table buffering.

What are the ABAP development guidelines? There are 2 correct answers to this question. Improved hybrid components for SAP HANA. Improved tools for performance analysis. Extensions to ABAP Language. Consuming Only ABAP contents for SAP HANA.

What are the two types of editors available in ADT? There are 2 correct answers to this question. Client (native). SAP (GUI). Eclipse (native). ABAP (native).

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

What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question. Perform expensive calculations on the ABAP application server. Aggregate data on the database, and transfer the results to the ABAP layer. Use native SQL to access SAP HANA built-in functions. Perform expensive calculations on the database. Transfer all data from the database to the ABAP layer, and then aggregate the results.

In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog? Which of the following table types fulfill this requirement? Please choose the correct answer. ROW. COLUMN. GLOBAL TEMPORARY. LOCAL TEMPORARY.

Name the views that are available to administer and monitor one or several SAP HANA systems? There are 2 correct answers to this question. The Landscape view. The System Monitor view. The Administration view. The Security view.

If the Search Options are enabled, you can set the Search Parameters for an attribute of a view. The following parameters are available? There are 3 correct answers to this question. Weights for ranking. Point base ranking. Index search. Fuzzy search. Freestyle search.

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. 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. The ALV Optimization for SAP HANA to display data on the screen.

How will you hide the attributes that are not required for client consumption? Choose the correct answer. By setting the hidden property flag of the attribute in the View. By setting the hidden property flag of the attribute in the Semantics screen. By setting the hidden property flag of the attribute provider. By setting the hidden property flag of the attribute column.

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. Transparent Optimizations. HANA Specific features. Database Optimization. Buffer system Optimization.

One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any functional issues after the migration. What should you search for and if necessary replace in the existing custom ABAP code? There are 3 correct answers to this question. ORDER BY Clauses in Open SQL statements. Direct access to a cluster on the database. Code that relies on implicit database sorting. Left outer joins in open SQL statements. Native SQL statements.

Which of the following is not involved in database table of “The New ABAP SQL Monitor – Architecture”? Choose the correct answer. Critical data table. Performance data table. Runtime monitor data. Selection data table.