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? Note: There are 3 correct answers to this question.
- A . A BAdI fallback implementation
- B . A BAdI definition
- C . A database procedure
- D . An enhancement spot
- E . A BAdI sample implementation
When using an SAP HANA full text search, what do you have to keep in mind?
- A . The LIKE operator is required in your SELECT statement to implement fuzzy logic.
- B . SAP HANA has to be the primary database to create a full text search.
- C . The SCORE () function is required to ensure the best hits of your search appear on top.
- D . The full-text index is always updated asynchronously.
Which task can you perform with the SQL Monitor (transaction SQLM)?
- A . Capture the SQL profile of an application.
- B . Search for problematic SELECT * statements.
- C . Combine static and dynamic performance analysis results.
- D . Display the execution plan of an SQL statement.
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.
- A . Replace UP TO n ROWS additions.
- B . Replace ORDER BY additions.
- C . Specify the schema for every table.
- D . Replace CORRESPONDING FIELDS additions.
- E . Add explicit client handling.
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 database? Note: There are 2 correct answers to this question.
- A . View CA_CUSTOMER has deployment mode A.
- B . Package ZHA400_00 has deployment mode A.
- C . System P81 has SAP HANA as primary database.
- D . Package ZHA400_00 is listed in table SNHI DUP PREWORK.
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?
- A . HISTORY COLUMN
- B . GLOBAL TEMPORARY
- C . LOCAL TEMPORARY
- D . ROW
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.
- A . All classical open SQL statements in your program will become invalid.
- B . All ABAP variables must be escaped with a preceding @ sign.
- C . All fields in the GROUP BY clause must be separated by commas.
- D . All arithmetic expressions can be used for all types of variables.
Which step of the Guided Performance Analysis should you perform in the production system?
- A . Executing a check run with ABAP Test Cockpit (ATC)
- B . Collecting data with SQL Monitor (SQLM)
- C . Performing an inspection with Code Inspector (SCI)
- D . Building a work list with SQL Performance Tuning Worklist (SWLT)
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.
- A . Data Definition
- B . ABAP class with new Open SQL Syntax
- C . Full-text index
- D . Database Procedure Proxy
- E . ABAP class with SQL script coding
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.
- A . Because you use the technique that is recommended by SAP.
- B . Because you automatically add changed objects to the transport request.
- C . Because you can manually re-deploy objects after a failed import.
- D . Because you always transport entire SAP HANA content packages.