E_HANAAW_17_1(CER001)

You are using ABAP Development Tools, 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 its implementation?. F2. F4. F3. F1.

Which of the Golden Rules for Open SQL Performance have become more important with SAP HANA? Note: There are 2 correct answers to this question. Keep unnecessary load away from the database. Minimize the search overhead. Minimize the amount of transferred data. Minimize the number of database accesses.

You import an ABAP workbench request into an SAP system P81. The ABAP workbench request contains a 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 data base? Note: There are 2 correct answers to this question. View CA_CUSTOMER has deployment mode A. Package ZHA400_00 has deployment mode A. Package ZHA400_00 is listed in table SNHI_DUP_PREWORK. System P81 has SAP HANA as primary database.

What is the purpose of an ABAP project in ABAP Development Tools for Eclipse? Note: There are 2 correct answers to this question. It represents the connection to an ABAP system. It provides access to all ABAP repository objects in an ABAP system. It represents the connection to the SAP HANA server. It is used to transport ABAP repository objects.

You are debugging in ABAP Development Tools in Eclipse. What features are available? Note: There are 2 correct answers to this question. Memory usage analysis. Conditional breakpoints. Debugger scripting. Watchpoints.

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

What are some of the features available for SAP List Viewer with Integrated Data Access (ALV IDA)? Note: There are 3 correct answers to this question. Search in content. Double-click on rows. Group rows. Display diagrams. Edit cells.

User STUDENT_A creates and activates a design-time object. In which schema is the runtime object generated?. _SYS BI. SYSTEM. STUDENT_A. _SYS_BIC.

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 sflight also contains the field planetype, how must you address the fields carrid and planetype from table SFLIGHT?. _flights.carrid and planetype. _flights.carrid and _flights.planetype. carrid and planetype. carrid and _flights.planetype.

You analyze SQL Monitor data in transaction SQLMD. You know that program X accesses database table Y. You made sure that 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? Note: There are 3 correct answers to this question. The data has NOT yet been transferred to the SQL Monitor database tables. SQL Monitor was activated with a filter that excludes database table Y. Program X was executed in the background. Database table Y is a buffered table. SQL Monitor was activated for a specific application server.

Which of the following features were added to the ABAP dictionary to support the SAP HANA database? Note: There are 3 correct answers to this question. Storage type for tables. Definition of full-text indexes. De-pooling and de-clustering. Change of data class. Definition of enhancement category.

Which data provisioning methods can you use when you need real-time replication? Note: There are 2 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.

In an ABAP Core Data Services (CDS) view, what must you do to expose an association for use in another CDS view?. 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. Define the cardinality for the target entity.

You are programming a report that reads data from a secondary HANA database (DB) What do you need to consider in your SQL statement? Note: There are 2 correct answers to this question. You have to specify the DB connection explicitly in your statement. You have to specify the DB schema explicitly in your statement. All tables and fields you are using must exist in the ABAP Dictionary of the secondary DB. You have to use native SQL when reading data from the secondary DB.

Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)?. Direct access to Table Pools/Cluster. Use of Native SQL and DB Hints. Existence check for Secondary Indexes. Missing ORDER BY or SORT after SELECT.

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? Note: There are 2 correct answers to this question. Create a restricted column for the ADDRESS field. Exclude the ADDRESS field from the union. Map the ADDRESS field to a constant value. Create an input parameter for the ADDRESS field.

Which tools can you use to provide input data for the SQL Performance Tuning Worklist (transaction SWLT)? Note: There are 3 correct answers to this question. SQL Monitor (transaction: SQLM). ABAP Test Cockpit (transaction: ATC). Code Inspector (transaction: SCI). Database Performance Monitor (transaction: DB50). SQL Trace (transaction: ST05).

You are using a calculated column COUNTS within your Dimension Calculation View and an aggregation node. This is the data that goes into the aggregation node: COUNTRY CITY COUNTS AT Vienna 11 AT Vienna 15 DE Berlin 13 DE Berlin 13. COUNTRY CITY COUNTS AT Vienna 11 DE Berlin 13. COUNTRY CITY COUNTS AT Vienna 11 AT Vienna 15 DE Berlin 13 DE Berlin 13. COUNTRY CITY COUNTS AT Vienna 26 DE Berlin 26. COUNTRY CITY COUNTS AT Vienna 11 AT Vienna 15 DE Berlin 13.

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

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

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

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

Which of the following features does the ABAP Test Cockpit offer that the ABAP Code Inspector does NOT offer? Note: There are 2 correct answers to this question. Flexible schedule of check runs. Documented checks. Configuration of check variants. Enhanced distribution of results.

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.primdb. How can you address the calculation view? Note: There are 2 correct answers to this question. "ha400 primdb/CA_BOOKINGS_COUNT". "ha400.primdb::CA_BOOKINGS_COUNT". _SYS_BIC "ha400 primdb::CA_BOOKINGS_COUNT". _SYS_BIC "ha 400 primdb/CA_BOOKINGS_COUNT".

Which of the following repository objects can you edit only in ABAP Development Tools in Eclipse, and NOT in the classical ABAP Workbench? Note: There are 3 correct answers to this question. Data Definition. ABAP class with new Open SQL Syntax. Database Procedure Proxy. ABAP class with SQL script coding. Full-text index.

You want to move some of the 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? Note: There are 3 correct answers to this question. Specify the schema for every table. Replace UP TO n ROWS additions. Replace CORRESPONDING FIELDS additions. Add explicit client handling. Replace ORDER BY additions.

Which rules does SAP recommend to improve the performance of ABAP reports on SAP HANA? Note: There are 2 correct answers to this question. Ensure the access to buffered tables uses the SAP table buffer. Perform all calculations and aggregations in the ABAP layer. Ensure the WHERE clause contains at least one index field. Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement.

You define a Core Data Services (CDS) view to merge the results of queries using the UNION keyword. What must the column lists of these queries contain? Note: There are 2 correct answers to this question. Columns of identical types. All key fields. The same number of columns. Columns of compatible types.

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

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?. EXECUTE_QUERY. SET_PARAM_TABLE. NEXT_PACKAGE. NEXT.

You define and implement an ABAP Managed Database Procedure (AMDP) What do you have to list after the USING clause? Note: There are 3 correct answers to this question. SAP HANA views used in the procedure body. ABAP Dictionary views used in the procedure body. CE functions used in the procedure body. ABAP Dictionary tables used in the procedure body. AMDPs usfed in the procedure body.

What benefits does SAP HANA Data Compression provide? Note: There are 2 correct answers to this question. Reduced memory consumption. Optimized data partitioning. Increased parallel processing. Optimized access to column store tables.

Which of the following tools and programming techniques use the SQL Data Definition Language? Note: There are 2 correct answers to this question. Core Data Services (CDS) access control. ABAP Dictionary. Open SQL. Core Data Services (CDS) data definition.

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? Note: There are 3 correct answers to this question. SUM( revenue ) AS total_revenue. CASE ordertype WHEN 'A' THEN 1 ELSE O END AS order_type. CAST('USD' AS abap.cuky ) AS currency_key. ASSOCIATION TO sflight AS _flights. crtdby AS created_by.

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

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?. GLOBAL TEMPORARY. HISTORY COLUMN. ROW. LOCAL TEMPORARY.

You created and activated a database procedure. From where can you call this procedure? Note: There are 2 correct answers to this question. From a graphical calculation view. From a Script-based calculation view. From a Core Data Services view. From another database procedure.

You developed an ABAP Managed Database Procedure (AMDP). You want to allow the enhancement of this AMDP using a Business Add-In (BAI). Which of the following objects must you create? Note: There are 3 correct answers to this question. A BAdl definition. An enhancement spot. A BAdl sample implementation. A database procedure. A BAdl fallback implementation.

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? Note: There are 2 correct answers to this question. Because you always transport entire SAP HANA content packages. Because you automatically add changed objects to the transport request. Because you can manually re-deploy objects after a failed import. Because you use the technique that is recommended by SAP.

You analyze SQL Monitor data in transaction SQLMD. You know that program X accesses database table Y. You made sure that program X was executed while the SQL Monitor collected its data. But the relevant database access is listed in SQLMD. What could be the reason? Note: There are 2 correct answers to this question. The data has NOT yet been transferred to the SQL Monitor database tables. SQL Monitor was activated with a filter that excludes database table Y. Program X was executed in the background. Database table Y is a buffered table. SQL Monitor was activated for a speci7.4fic application server.

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 the SAP HANA Transport Container (HTC). Why would you choose HTA? Note: There are 2 correct answers to this question. Because you always transport entire SAP HANA content packages. Because you automatically add changed objects to the transport request. Because you can manually re-deploy objects after a failed import. Because you use the technique that is recommended by SAP.

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