|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 Group rows Double-click on rows Search in content Display diagrams Edit cells.
What must to 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 ABAP variables must be escaped with a preceding @ sign All arithmetic expressions can be used for all types of variables All fields in the GROUP BY clause must be separated by commas
FIELDS and ORDER BY too All classic open SQL statements in your program will become invalid.
Which of the following tools and programming techniques use the SQL Data Definition Language? Note: There are 2
correct answers to this question ABAP Directory Core Data Services (CDS) access control Core Data Services (CDS) data definition Open SQL.
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 has syntax check at compile time It supports locking and commit handling It supports exception handling It supports where-used list.
When using an SAP Hana full text search, what do you have to keep in mind? The full-text index is always updated asynchronously The SCORE () function is required to ensure the best hits of your search appear on top The LIKE operator is required in your SELECT statement to implement fuzzy logic SAP HANA has to be the primary database to create a full text search.
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?
Note: There are 3 correct answers to this question Specify the schema for every table Add explicit client handling Replace ORDER BY additions Replace CORRESPONDING FIELDS additions 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? Note: There are 2 correct answers to this question You have to use native SQL when reading data 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 You have to specify the DB schema explicitly in your statement.
You use ABAP Database Connectivity (ADBC) to issue native SQL calls to the database. Which method of the class
CL_SQL_RESULT_SET retrieves the entire result set of the native SQL call? SET_PARAM_TABLE NEXT_PACKAGE EXECUTE_QUERY NEXT.
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 table output parameters in the procedure Two result sets As many result sets as there are input parameters in the procedure One result set.
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 View CA_CUSTOMER has deployment mode A Package ZHA400_00 has deployment mode A System P81 has SAP HANA as primary database Package ZHA400_00 is listed in table SNHI_DUP_PREWORK.
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 SAP HANA Transport Container (HTC). Why would you choose HTA? Note:
There are 2 correct answers to this question Because you use the technique that is recommended by SAP Because you always transport entire SAP HANA content packages Because you always transport entire SAP HANA content packages Because you can manually re-deploy objects after a failed method.
You implemented 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_BOOKING_COUNT” _SYS_BIC.”ha400.primdb/CA_BOOKING_COUNT” “ha400.primdb/CA_BOOKING_COUNT” _SYS_BIC.”ha400.primdb::CA_BOOKING_COUNT”.
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 Documented checks Enhanced distribution results Configuration of check variants Flexible schedule of check runs
General support for quality management processes.
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 WHERE clause contains at least one index field Perform all calculations and aggregations in the ABAP layer Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement Ensure the access to buffered tables uses the SAP table buffer.
Which task can you perform with the SQL Monitor (transaction SQLM)? Capture the SQL profile of an application Combine static and dynamic performance analysis results Search for problematic SELECT * statements
Display the execution plan of an SQL statement.
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? Note: There are 3 correct answers to this question Program X was executed in the background SQL Monitor was activated for specific application server The data has NOT yet been transferred to the SQL Monitor database tables Database table Y is a buffered table SQL Monitor was activated with a filter that excludes database table Y.
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 Minimize the amount of transferred data Keep unnecessary load away from the database Minimize the number of database accesses Minimize the search overhead.
Which step of Guided Performance Analysis should you perform in the production system? Executing a check run with ABAP Test Cockpit (ATC) Collecting data with SQL Monitor (SQLM) Performing an inspection with Code Inspector (SCI) Building a work list with the SQL Performance Tunning Worklist (SWLT).
Which tools can you use to provide input data for the SQL Performance Tunning Worklist (transaction SWLT)? Note:
There are 3 correct answers to this question SQL Trace (Transaction ST05) Code Inspector (Transaction SCI) ABAP Test Cockpit (Transaction ATC) Database Performance Monitor (Transaction DB50) SQL Monitor (Transaction SQLM ).
Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)? Existence check for Secondary Indexes Direct access to Table Pools/Cluster Use of Native SQL and DB Hints Missing ORDER BY or SORT after SELECT
Empty table in FOR ALL ENTRIES clause.
Why would you implement Smart Data Access (SDA)? To define the caching rules based on usage patterns To replicate data between SAP ECC and SAP HANA To generate delta images when sources cannot provide this function To provide real-time access to remote data sources YES
To build new applications on SAP HANA, but access data from
multiple sources without moving data into SAP HANA
To expose Big Data stores such as Hadoop to SAP HANA-based
To combine data from multiple SAP HANA-based data marts.
What benefits does SAP HANA Data Compression provide? Note: There are 2 correct answers Increased parallel processing Reduced memory consumption Optimized access to column store tables Optimized data partitioning.
User STUDENT_A creates and activates a design-time object. In which schema is the runtime object generated? STUDENT_A _SYS_BIC SYSTEM _SYS_BI.
Which of the following takes advantage of the computing power of multiple CPUs used by SAP HANA? Parallel processing Column data storage Dictionary encoding Database table compression.
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 BADI definition An enhancement spot A BADI fallback implementation A BADI simple implementation A database procedure.
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 contains the field planetype, how must you address the fields carrid and planetype from table
SFLIGHT? carrid and planetype carrid and _flights.planetype _flights.carrid and planetype _flights.carrid and _flights.planetype.
In ABAP Core Data Services (CDS) view, what must you do to expose an association for use another CDS view? Include all fields used in the ON condition in the project list Specify the other views in which the association can be used Define the cardinality for the target entity Specify an alias for the target entity.
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 CAST( ‘USD’ AS abap.cuky ) AS currecy_key crtdby AS created_by CASE ordertype WHEN ‘A’ THEN 1 ELSE 0 END AS order_type ASSOCIATION TO sflight AS _flights SUM( revenue ) AS total_revenue.
Which task does the ABAP Managed Database Procedure (AMDP) framework perform? Deploy the database procedure when the AMDP is first activated Deploy the database procedure whenever the AMDP is activated Deploy the database procedure whenever the AMDP is called Deploy a new version of the database procedure when the AMDP is first called.
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 Definition of full-text indexes Storage type for tables De-pooling and De-clustering Change of data class Definition of enhancement category.
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 CE functions used in the procedure body ABAP Dictionary tables used in the procedure body AMDP’s used in the procedure body ABAP Dictionary views used in the procedure body.
You define a Core Data Services (CDS) view to merge the results of the queries using the UNION keyword. What must the
column lists of these queries contain? Note: There are 2 correct answers to this question All key fields Columns of identical types Columns of compatible types The same number of columns.
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? F4 F1 F2 F3.
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 represents the connection to the SAP HANA server It is used to transport ABAP repository objects It provides access to all ABAP repository in the ABAP system.
You are debugging in ABAP Development Tools in Eclipse. What features are available? Note: There are 2 correct
answers to this question Debugger scripting Conditional breakpoints
Direct editing of code in the debugger Watchpoints Memory usage analysis.
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 Database Procedure Proxy Full-text index ABAP class with SQL script coding Data Definition ABAP class with the new Open SQL Syntax.
In a graphical calculation, 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 an input parameter for the ADDRESS field Create a restricted column for the ADDRESS field Map the ADRESS field to a constant value Exclude the ADRESS field from the union.
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? ROW LOCAL TEMPORARY GLOBAL TEMPORARY HISTORY COLUMN.
You created and activated a database procedure. From where can you call this procedure? Note: There are 2 correct
answers to this question From another database procedure From a Core Data Services view From a Script-based calculation view From a graphical calculation view.
You are using a calculated column COUNTS within you Dimension Calculation View and an aggregation node. This is the
data goes into the aggregation node:
CONTRY CITY COUNTS
AT Vienna 11
AT Vienna 15
DE Berlin 13
DE Berlin 13
What does the result of the aggregation look like? CONTRY CITY COUNTS
AT Vienna 11
AT Vienna 15
DE Berlin 13 CONTRY CITY COUNTS
AT Vienna 11
AT Vienna 15
DE Berlin 13
DE Berlin 13 CONTRY CITY COUNTS
AT Vienna 11
DE Berlin 13.