SHAKERHANA_2

You import an ABAP workbench request into a SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package 2HA400_00. Which prerequisites are mandatory for an implicit deployment of the SAP HANA view onto the database? (2 correct answers). View CA_CUSTOMER has deployment mode A. Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK. SYSTEM P81 has SAP HANA has primary database. PACKAGE ZHA400J30 HAS deployment Mode A.

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.

Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does NOT Offer. (2 answers). Documented checks. Enhanced distribution of results. Configuration of check variants. Flexible schedule of check runs.

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. Database table Y is a buffered table. SQL Monitor was activated for a specific application server. SQL Monitor was activated with a filter that excludes database table Y. Program X was executed in the background.

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

Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT). (3 answers). Data base performance monitor (transaction DB50). Code inspector (transaction SCI). SQL Trace (transaction ST05). SQL monitor (transaction SQLM). ABAP test cockpit (transaction ATC).

You use ABAP database connectivity (ADBC) to issue native SQL calls to the database, the native SQL call? Which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call? Please choose the correct answer. SET_PARAM_TABLE. SET_PARAM. EXECUTE_QUERY. NEXT_PACKAGE.

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

What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05). There are 2 correct answers to this question. 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.

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

Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question. ABAP Dictionary. Open SQL. Core data services (CDS) data definition. Core data service (CDS) access control.

You define a core data services (CDS) view to merge the results of queries using the UNION keyword. What must the column list of this queries contain? There are 2 correct answers to this question. The same number of columns. All key fields. Columns of compatible types. Columns of identical types.

You define and implement an AM DP. What do you have to list after the USING clause? (3 answers). ABAP dictionary tables used in procedure body. ABAP dictionary views used in procedure body. CE function used in procedure Body. AMDP Used in Procedure Body. SAP HANA views used in procedure body.

Which tasks does the ABAP managed database (AMDP) framework perform? (2 correct answers). Create a new version of the database when the AMDP is first activated. Delete the obsolete versions of the database procedure synchronously. Delete the obsolete versions of the database procedure asynchronously. Create a new version of the database when the AMDP is first called.

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

Which of the following feature were added to the ABAP Dictionary to support the SAP HANA database? ( 3 answers ). De-pooling and de-clustering. Changes of data class. Definition of full-text indexes. Definition of an enhancement category. Storage type for tables.

You developed an ABAP managed database procedure (AMDP). You want to allow the enhancement of this AMDP using business add-in (BADI). Which of the following objects must you create. (3 answers). A BADI definition. A BADI fallback implementation. An enhancement spot. A database procedure. A BADI simple implementation.

Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not in the Classical ABAP workbench? There are 3 correct answers to this question. Full-text index. Database procedure proxy. ABAP program containing new Open SQL. Core Data service (CDS) view. External view.

What is the purpose of an ABAP project in ABAP Development Tool for eclipse? (2 answers). 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 Layer. It is used to transport the ABAP repository Objects.

Which of the following take advantage of the computing power of multiple CPUs used by SAP HANA? There are 2 correct answers to this question. Partitioning. Database table compression. Column data storage. Parallel processing.

User STUDENT_A create and activates a design-time object. In which schema is the run object generated?. _SYS_BI. STUDENT_A. SYSTEM. _SYS_BIC.

You created and activated database procedure. How can you call this procedure? (2 answers). By another database procedure. By using Sap Analysis for Microsoft office. By a script-based calculation view. By a core data services view.

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? (2 answers). Create an input parameter for the ADDRESS field. Exclude the ADDRESS field from the union. Create a restricted column for the ADDRESS field. Map the ADDRESS field to a constant value.

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

Which rules does SAP recommended to improve the performance of ABAP report on SAP. (2 answers). Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement. Perform all calculations and aggregations in the ABAP layer. Ensure the WHERE clause contains at least one index field. Ensure the access to buffered tables uses the SAP table buffer.

You implement an ABAP-managed database procedure( AMDP). Whitin this AMDP, you want to query data drom calculation view CA_BOOKINGS_COUNT in SAP HANA content package ha400.primdb. How can you address the calculation view? (2 answers). _SYS_BIC."ha400.primdb::CA_BOOKINGS_COUNT". "ha400.primdb::CA_BOOKINGS_COUNT". "ha400.primdb/CA_BOOKINGS_COUNT". _SYS_BIC."ha400.primdb/CA_BOOKINGS_COUNT".

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? (2 answers). Because you always transport entire SAP HANA content packages. Because you automatically add changes 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.

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

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

Which of the Golden Rules for Open SQL Performance have become more importnat with SAP HANA? (2 answers). Minimize the amount of trasferred data. Keep unnecessary load away form the database. Minimize the search overhead. Minimize the number of databse accesses.

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 adjustement? (3 answers). Replace ORDER BY additions. Replace CORRSPONDING FIELDS additions. Specify the schema for every table. Add explicit client handling. Replace UP TO n ROWS additions.

You are programming a report that reads data from a secondary HANA database (DB). WHat do you need to consider in your SQL statement? (2 answers). 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. You have to specify the DB connection explicitly in your statement.

When using an SAP HANA full text search, what do you have to keep mind?. The full-text index is always updated asynchronously. The LIKE operator is reuquired in your SELECT statement to implement fuzzy logic. 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 appear on top.

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 _flights.planetype. carrid and planetype.

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? (3 answers). SUM( revenue ) AS total_revenue. CAST( 'USD' AS abap-cuky ) AS currency_key. CASE ordertype WHEN 'A' THEN 1 ELSE 0 END AS order_type. crtdby AS created_by. ASSOCIATION TO sflight AS _flights.

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?. F3. F2. F4. F1.

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

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

Why would you implement Smart Data Access (SDA)?. To provide real-time access to remote data sources. To define caching rules based on usage patterns. To erplicate data between SAP ECC and SAP HANA. To generate delta images when sources cannot provide this function.