|You are debugging in ABAP Development Tools in Eclipse. Whatfeatures are available?
There are 2 correct answers to this question. Watch points Debugger scripting Memory usage analysis Conditional breakpoints.
You define and implement an ABAP Managed database procedure(AMDP). What do you have to list after the USING clause?
There are 3 correct answers to this question. ABAP Dictionary table used in the procedure body ABAP Dictionary views used in the procedure body CE function used in the procedure body SAP HANA views used in the procedure body AMDP used in the procedure body.
Which task can you perform with the SQL Monitor (transactionSQLM)?
Please choose the correct answer. Display the execution plan of an SQL statement. Combine stat c and dynamic performance analysis results. Search for problematic SELECT • statements. Capture the SQL profile of an application.
You perform a static code check using the Code Inspector (SCI). Inyour SCI variant, you select the Search problematic SELECT * statementscheck.
What does this check report?
Please choose the correct answer. SELECT * statements on tables with more than a specified number of fields SELECT * statements where fewer than a specified percentage of all fields areeffectively used SELECT * statements on tables with the Column Store storage type SELECT * statements on tables with more than 100,000 records.
Which tools can you use to provide input data for the SQLperformance tuning work list (Transaction SWLT)?
There are 3 correct answers to this question. SQL Trace (transaction ST05) ABAP test cockpit (transaction ATC) Code inspector (transaction SCI) Data base performance monitor (transaction DB50) SQL monitor (transaction SQLM).
You use ABAP database connectivity (ADBC) to issue native SQLcalls to the database. Which of the following methods of classCL_SQL_RESULT_SET retrieves the result set of the native SQL call?
Please choose the correct answer. SET_PARAM EXECUTE_QUERY SET_PARAM_TABLE NEXT_PACKAGE.
You are programming a report that reads data from a secondaryHANA database (DB). What do you need to consider in your SQL statement?
There are 2 correct answers to this question. You have to specify the DB schema explicity in your statement. All tables and fields you are using must exist in the ABAP Dictionary of theSecondary 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.
What are the Guidelines for optimizing ABAP code running onHANA?
There are 3 correct answers to this question. Open SQL settings Technical settings DB specific properties Column store High-speed data analysis.
User STUDENT_A creates and activates a design-time object. In which schema is the runtime object generated? _SYS_ BI SYSTEM _SYS_ BIC STUDENT_A.
AMDP can detect 3 types of syntax errors in active or inactivesource code. What are these errors ?
There are 3 correct answers to this question. UNION specific syntax errors Database platform syntax errors Database independent syntax errors HANA specific syntax errors SQLScript errors.
Your development team needs to include SAP HANA objects into anABAP 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?
There are 2 correct answers to this question. Because you automatically add changed objects to the transport request. Because you always transport entire SAP HANA content packages. Because you can manually re-deploy objects after a failed import. Because you use the technique that is recommended by SAP.
When are referential joins executed in analytical views?
Choose the correct answer When fields are selected When fields from both the tables are requested When fields are optimized When all the tables are optimized.
You are using ABAP Development Tools, and you have placed yourcursor on a method name in a class. What key do you use to navigate between amethod definition and its implementation?
Please choose the correct answer. F2 F3 F1 F4.
SAP HANA: Delivers Across 5 Dimensions. These five dimensionslead to certain goals HANA has to meet. What are these goals?
There are 2 correct answers to this question. High Performance and Scalability Hybrid data and management system Support for system tables Analytical DBMS features.
Explain Transitioning ABAP Code to SAP HANA – PerformanceConsiderations?
There are 3 correct answers to this question. Some codes impacted positively and should be priorities Some codes immediately run faster Classical performances recommendations for open SQL remain valid Some shifts in priorities, examples, nested selects(higher) indices(lower) Some codes transferred to other systems.
Which of the following is not an element of Analytical view?
Please choose the correct answer. Join fact tables Read Data from the joined database tables Currency conversion is not applicable Used to Joined table.
Open SQL largely standardized, three sub-languages. What arethese sub-languages?
There are 3 correct answers to this question Data Evaluation Language(DEL) Data Transferring Language(DTL) Data Manipulation Language (DML) The Data Definition Language (DDL) The Data Control Language (DCL).
What are the supported joins in CDS view?
There are 2 correct answers to this question. Operators joint Upper join Inner join Left outer join.
What are the two different kinds of Identifiers used to representnames used in SQL statement?
There are 2 correct answers to this question Undelimited Identifiers Delimited identifiers Numeric identifiers Limited identifiers.
What are the uses of SQL Trace (ST05)?
There are 3 correct answers to this question. Applying Code inspector Display record of all database access Detect redundant or identical select statements Locate database performance issues Locate work base issues.