SAP ABAP Specialist for HANA 2.0 Exam questions

What are some of the features available for SAP List Viewer with Integrated Data Access (ALV IDA)? Three answers. - Group rows - Search in content - Double click on rows - Display diagrams - Edit cells

- Group rows - Search in content - Display diagrams

In an ABAP Core Data Service view (CDS view), what must you do to expose an association for use in another CDS view? One answer. - Define the cardinality for the target entity - Specify an alias for the target entity - Include all fields used in the ON condition in the projection list - Specify the other views in which the association can be used

- Include all fields used in the ON condition in the projection list

What is the purpose of an ABAP project in ABAP Development Tools for Eclipse? Two answers. - It provides access to all ABAP repository objects in an ABAP server - It represents the connection to an ABAP system - It represents the connection to the SAP HANA server - It is used to transport ABAP repository objects

- It provides access to all ABAP repository objects in an ABAP server - It represents the connection to an ABAP system

You analyze SQL monitor data in transaction SQLMD. You know that program X accesses database table Y. You made sure that the program X was executed while the SQL Monitor collected its data. But the relevant database access is not listed in SQLMD. What could be the reason? Three answers. - SQL Monitor was activated with a filter that excludes database table Y - The data has not yet been transferred to the SQL Monitor database tables - SQL Monitor was activated for a specific application server - Database table Y is a buffered table - Program X was executed in the background

- SQL Monitor was activated with a filter that excludes database table Y - SQL Monitor was activated for a specific application server - Database table Y is a buffered table

You are programming a report that reads data from a secondary HANA database. What do you need to consider in you SQL statements? Two answers. - You have to specify the DB Schema explicitly in your statement - You have to specify the DB connection explicitly in your statement - You have to use native SQL when reading from the secondary DB - All tables and fields you are using must exist in the ABAP dictionary of the secondary DB.

- You have to specify the DB connection explicitly in your statement - All tables and fields you are using must exist in the BAP dictionary of the secondary DB.

You are using ABAP Development Tools (ADT), and you have placed your cursor on a method name in a class. What key do you use to navigate between a method definition and it's implementation? One answer. - F2 - F3 - F1 - F4

F3

You developed an ABAP Managed Database Procedure (AMDP). You want to allow the enhancement of this AMDP using a Business Add-in (BAdi). Which of the following objects must you create? Three answers. • A database procedure. • A BAdi sample implementation • A BAdi definition. • A BAdi fallback implementation. • An enhancement Spot.

• A BAdi definition. • A BAdi fallback implementation. • An enhancement Spot.

Which of the following repository objects can you edit only in ABAP development tools in Eclipse, and NOT in the classical ABAP workbench? Three answers. • ABAP class with new open SQL syntax • ABAP Class with SQL script coding • Database procedure proxy • Data Definition • Full-text index

• ABAP class with new open SQL syntax • Database procedure proxy • Data Definition

You define and implement an ABAP Managed Database Procedure (AMDP). What do you have to list after the USING clause? Three answers. • AMDPs used in the procedure body • ABAP dictionary tables used in the procedure body • ABAP dictionary views used in the procedure body • CE functions used in the procedure body • SAP HANA views used in the procedure body

• AMDPs used in the procedure body • ABAP dictionary tables used in the procedure body • ABAP dictionary views used in the procedure body

What must you take into consideration when you use the new open SQL syntax (available as of SAP NetWeaver 7.4 SP05)? Two answers. • All classical open SQL statements in your program will become invalid • All ABAP variables must be escaped with a preceding @ sign • All fields in the GROUP BY clause must be separated by commas • All arithmetic expression can be used for all types of variables

• All ABAP variables must be escaped with a preceding @ sign • All fields in the GROUP BY clause must be separated by commas

Your development team needs to include SAP HANA objects into an ABAP workbench request. You want to use SAP HANA Transport for ABAP (HTA), and NOT the SAP HANA Transport Container (HTC). Why would you choose HTA? Two answers. • Because you can manually re-deploy objects after a failed import. • Because you always transport entire SAP HANA content packages. • Because you also use the technique that is recommended by SAP. • Because you automatically add changed objects to the transport request

• Because you can manually re-deploy objects after a failed import. • Because you automatically add changed objects to the transport request

Which tasks can you perform with SQL Monitor (transaction SQLM)? One answer. • Capture the SQL profile of an application • Search the problematic SELECT * statements • Combine static and dynamic performance analysis results • Display the execution plan of an SQL statement

• Capture the SQL profile of an application

You have created a CDS View as follows. ______________________________________________________________________________________ Define view zha400 as select from spfli Association[*] to sflight as _flights On spfli.carrid = _flights.carrid And spfli.connid = _flights.connid { ... } ______________________________________________________________________________________ Given that table flight also contains the field plane type. How must you address the fields carrid and plane type from table SFLIGHT? One answer. • Carrid and planetype • _flights.carrid and planetype • _flights.carrid and _flights.planetype • Carrid and _flights.planetype

• Carrid and _flights.planetype

Which tools can you use to provide input data for the SQL Performance Tuning Worklist (transaction SWLT)? Three answers. • Code inspector (transaction SCI) • SQL Trace (transaction ST05) • Database Performance Monitor (transaction DB50) • SQL monitor (transaction SQLM) • ABAP test Cockpit (transaction ATC)

• Code inspector (transaction SCI) • SQL monitor (transaction SQLM) • ABAP test Cockpit (transaction ATC)

Which step of the Guided Performance Analysis should you perform in the production system? One answer. • Collecting data with SQL Monitor (SQLM). • Performing an inspection with Code Inspector (SCI). • Executing a check run with ABAP Test Cockpit (ATC). • Building a work list with SQL Performance Tuning Worklist (SWLT).

• Collecting data with SQL Monitor (SQLM).

You are debugging in ABAP Development Tools in Eclipse. What features are available? Two answers. • Conditional breakpoints. • Memory usage analysis. • Debugger scripting. • Watchpoints.

• Conditional breakpoints. • Memory usage analysis.

Which of the following features were added to the ABAP dictionary to support the SAP HANA database? Three answers. • De-pooling and de-clustering • Definition of enhancement category • Change of data class • Definition of full-text indexes • Storage type for tables

• De-pooling and de-clustering • Definition of full-text indexes • Storage type for tables

Which task does ABAP Managed Database Procedure (AMDP) framework perform? One answer. • Deploy the database procedure whenever the AMDP is called. • Deploy the database procedure whenever the AMDP is activated. • Deploy the database procedure when the AMDP is first activated. • Deploy a new version of the database procedure when the AMDP is first called.

• Deploy a new version of the database procedure when the AMDP is first called.

Which of the following features does the ABAP test cockpit offer that the ABAP code inspector does not offer? ANS- 2 • Enhanced distribution of results • Documented checks • Flexible schedule of check runs • Configuration of check variants

• Enhanced distribution of results • Flexible schedule of check runs

In a graphical calculation view, you want to implement a union between two result sets that differ only in the fact that one of the two has one additional field named ADDRESS. How can you achieve this in a union node? Two answers. • Exclude the ADDRESS field from the union • Map the address field to a constant value • Create a restricted column for the ADDRESS field • Create an input parameter for the ADDRESS field

• Exclude the ADDRESS field from the union • Map the address field to a constant value

You created and activated a database procedure. From where can you call this procedure? Two answers. • From a Script based calculation view. • From another database procedure. • From a graphical calculation view. • From a Core Data Service

• From a Script based calculation view. • From another database procedure.

You want to execute a native SQL statement in your program. Why should you use ABAP Database Connectivity (ADBC)? Two answers. • It has a syntax check at compile time • It supports where-used list • It supports locking and commit handling • It supports exception handling

• It supports where-used list • It supports exception handling

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 fulfil this requirement? One answer. • GLOBAL TEMPORARY • LOCAL TEMPORARY • HISTORY COLUMN • ROW

• LOCAL TEMPORARY

Which of the golden rules for Open SQL Performance have become more important with SAP HANA? Two answers. • Minimize the amount of transferred data • Keep unnecessary load away from the database • Minimize the number of database accesses • Minimize the search overhead

• Minimize the amount of transferred data • Minimize the number of database accesses

Which functional problems can you detect when using the Runtime Check Monitor (SRTCM)? One Answer. • Use of native SQL and DB hints • Missing ORDER BY or SORT after SELECT • Existence check for Secondary Indexes • Direct access to table pools/cluster

• Missing ORDER BY or SORT after SELECT

You use ABAP database connectivity (ADBC) to issue native SQL calls to the database. Which method of class CL_SQL_RESULT_SET retrieves the entire result set of the native SQL call? One answer. • SET_PARAM_TABLE • EXECUTE_QUERY • NEXT_PACKAGE • NEXT

• NEXT_PACKAGE

How many result sets are returned when an SAP HANA database procedure is called using the 'CALL ...WITH OVERVIEW' statement? One answer. • Two result sets • One result set • 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

Which of the following tools and programming techniques use the SQL Data Definition Language? Two answers. • Core Data Services (CDS) data definition. • Open SQL. • ABAP dictionary • Core Data Services (CDS) access control.

• Open SQL. • Core Data Services (CDS) access control.

What benefits does SAP HANA Data Compression provide? Two answers. • Optimized access to column store tables • Optimized data partitioning • Reduced memory consumption • Increased parallel processing

• Optimized access to column store tables • Reduced memory consumption

Which of the following takes advantage of the computing power of multiple CPUs used by SAP HANA? • Parallel processing • Database table compression • Columnar data storage • Dictionary encoding

• Parallel processing

Which data provisioning methods can you use when you need real time replication? Two answers. • SAP Data Services • SAP Replication Server • SAP Landscape transformation replication Server (SAP SLT) • SAP HANA Direct Extractor Connection (SAP DXC)

• SAP Replication Server • SAP Landscape transformation replication Server (SAP SLT)

You have created a CDS View and used alias names for some of its elements. In which of the following cases is the alias name mandatory? Three answers. • SUM(revenue) AS total_revenue. • Crtdby AS created_by. • CASE ordertype WHEN 'A' THEN 1 ELSE 0 END AS order_type. • ASSOCIATION to sflight AS _flights. • CAST( 'USD' AS abap.cuky) AS currency_key.

• SUM(revenue) AS total_revenue. • CASE ordertype WHEN 'A' THEN 1 ELSE 0 END AS order_type. • CAST( 'USD' AS abap.cuky) AS currency_key.

You want to move some logic of an ABAP program into an ABAP Managed Database Procedure (AMDP). To do so you need to translate open SQL statements into SAP HANA Native SQL. Which of the following are necessary adjustments? Three answers. • Specify the schema for every table. • Replace order by addition. • Add explicit client handling. • Replace UP to n ROWS addition. • Replace corresponding FIELDS addition.

• Specify the schema for every table. • Replace order by addition. • Replace UP to n ROWS addition.

You import an ABAP workbench request into an SAP system P81. The ABAP workbench request contains single SAP HANA view CA_CUSTOMER that belongs to SAP HANA content package ZHA400_00. Which prerequisites are mandatory for an implicit deployment of the SAP HANA view onto the database? Two answers. • System P81 has SAP HANA as primary database • View CA_CUSTOMER has deployment mode A. • Package ZHA400_00 is listed in table SNHI_DUP_ • Package ZHA400_00 has deployment mode A.

• System P81 has SAP HANA as primary database • Package ZHA400_00 is listed in table SNHI_DUP_

When using SAP HANA full texts search. What do you have to keep in mind? One answer. • SAP HANA has to be the primary database to create a full text search. • The SCORE() function is required to ensure the best hits of your search on top. • The LIKE operator is required in your SELECT statement to implement fuzzy logic. • The full-text index is always updated asynchronously.

• The full-text index is always updated asynchronously.

You define a core data service (CDS) view to merge results of queries using the UNION keyword. What must the column lists of these queries contain? Two answers. • All key fields • The same number of columns • Column of compatible type • Columns of identical type

• The same number of columns • Column of compatible type

Which rules does SAP recommend to improve the performance of ABAP reports on SAP HANA? Two answers. • Ensure the WHERE clause contains at least one index field. • Use SELECT FOR ALL ENTRIES instead of a nested select statement • Perform all calculation and aggregations in the ABAP layer • Ensure the access to buffered tables uses the SAP table buffer

• Use SELECT FOR ALL ENTRIES instead of a nested select statement • Ensure the access to buffered tables uses the SAP table buffer

User STUDENT_A creates and activates a design-time object. In which schema the runtime object generated? One answer. • STUDENT_A • _SYS_BI • _SYS_BIC • SYSTEM

• _SYS_BIC

You implement an ABAP Managed Database Procedure (AMDP) within this AMDP you want to query data from calculation view CA_BOOKINGS_COUNT in SAP HANA content package ha400. Two answers. • _SYS_BIC " ha400 primdb::CA_BOOKINGS_COUNT" • _SYS_BIC " ha400 primdb/CA_BOOKINGS_COUNT" • "ha400 primdb::CA_BOOKINGS_COUNT" • "ha400 primdb/CA_BOOKINGS_COUNT"

• _SYS_BIC " ha400 primdb/CA_BOOKINGS_COUNT" • "ha400 primdb::CA_BOOKINGS_COUNT"