Name the views that are available to administer and monitor one or several SAP HANA systems? There are 2 correct answers to this question
- A . The System Monitor view
- B . The Administration view
- C . The Landscape view
- D . The Security view
The binding between a Ul element and a context attribute is a two-way relationship
- A . True
- B . False
The predefined data types are defined locally in the ABAP program.
- A . True
- B . False
CORRECT TEXT
Which of the following are valid control level changes within a loop over an internal table? There are 2 correct answers to this question.
- A . LAST
- B . SUM
- C . END of <f>
- D . COLLECT
What is the ALV Object Model? Please choose the correct answer.
- A . A group of hierarchal classes that describe the ALV Grid as a whole but do not inherit from a single class
- B . A group of classes that apply Grid as a whole and inherit from a multiple class
- C . A group of classes that describe the ALV Grid as a whole and inherit from a single class
- D . A group of classes that describe the BDC Grid as a whole and inherit from a single class
The source code editor in ADT provides many helpful features.
What are these helpful features? There are 2 correct answers to this question.
- A . Creating Method Implementations from the Method Definition
- B . Creating Method Definitions from Implementation Parts
- C . Creating interface from Method Calls
- D . Creating Parts for Interface Methods
All Open SQL commands allow processing on multiple rows.
- A . False
- B . True
The FIELD statement does not have any effect in the PBO event block, and it should not be used in the PBO event block.
- A . True
- B . False
Which of the following is true? Select all that apply. (S. 105) {2 Richtig}
- A . The repository objects and cross-client customization objects are recorded in a task belonging to a local change request if there is no consolidation route leading from the current system defined in the Transport Management System for the transport layer.
- B . The repository objects and the cross-client customization are recorded in a task belonging to the transportable request if the consolidation route is defined in the Transport Management System.
Which of the following actions can be performed in the Process After Input (PAI) processing block? Please choose the correct answer.
- A . Set the title bar.
- B . Set the GUI status of the screen.
- C . Modify screen attributes dynamically.
- D . Check the function code.
Object or class events can trigger any number of handler methods.
- A . True
- B . False
Private components of the class cannot be addressed directly from outside the class except when the friendship concept applies
- A . False
- B . True
What are the two layers of ABAP system interacts with its database? There are 2 correct answers to this question.
- A . The Client database interface
- B . The Database specific library
- C . The Data Storage interface
- D . The Database independent interface
Each ABAP program that actually contains executable statements… (Select all that apply.)
- A . Assigns every executable statement to a processing block regardless of it ^ ‘―’ being in a processing block.
- B . Only assigns executable statements in a processing block to a processing •―I block
- C . Has declarative statements outside of processing blocks that are considered •―I local
- D . Uses event blocks to trigger events in ABAP.
- E . Has declarative statements inside of processing blocks that are considered •―I local
- F . Is divided into processing blocks.
- G . Can be tested from the ABAP Workbench by pressing (F8)
The data is transferred and displayed on the screen after the processing of the PBO.
- A . True
- B . False
Function modules provide which types of parameters? Select all that apply.
- A . Return values
- B . Output
- C . Exceptions
- D . Input
- E . Input/output (changing)
Which of the following statements are true? Select all that apply.
- A . A conversion routine can be assigned to a domain.
- B . A conversion routine can be assigned to a data element.
- C . You define the value range in the data element.
- D . You can enter documentation for the data element in the ABAP Dictionary.
One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any functional issues after the migration.
What should you search for and if necessary replace in the existing custom ABAP code? There are 3 correct answers to this question.
- A . Direct access to a cluster on the database
- B . Left outer joins in open SQL statements
- C . ORDER BY Clauses in Open SQL statements
- D . Native SQL statements
- E . Code that relies on implicit database sorting
What must you specify in a Unicode system when opening a file in TEXT MODE?
- A . The byte order
- B . The ENCODING addition
- C . The code page
Each ABAP program starts with an introductory statement.
Which statements are correct? Select all that apply.
- A . The introductory statement must be the first line in the program
- B . The introductory statement can be modified.
- C . The introductory statement must be the first statement in the program.
- D . The introductory statement must never be modified.
Customer exits provide program exit, screen exit, and menu exit enhancements.
- A . True
- B . False
When does the lifetime of a component controller begin and end? (S. 530) {1 Richtig}
- A . It begins with the Web Dynpro component and ends with the Web Dynpro application that called it
- B . It lasts from creating data within the controller to cover the whole period’ during which the component is in use.
- C . It begins the first time the Web Dynpro application is called at runtime and ends when the Web Dynpro application that called and instantiated the component ends.
The Object Navigator incorporates a total of 11 browsers.
- A . False
- B . True
Internal tables can also be modified after executing the READ statement with the addition ASSIGNING. (S. 204) {1 Richtig}
- A . False
- B . True
Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does NOT Offer? There are 2 correct answers to this question.
- A . Documented checks
- B . Configuration of check variants
- C . Flexible schedule of check runs
- D . Enhanced distribution of results
The OCCURS statement is required to define an internal table with a header line.
- A . False
- B . True
Enhancement definitions and implementations can be displayed in the Enhancement Information System.
- A . True
- B . False
You can use the APPEND statement to fill a sorted internal table.
- A . False
- B . True
To reserve an area on the screen for an ALV Grid Control, you must do the following:
- A . Use the Screen Painter
- B . Create an object (instantiate the object) of the class CL_GUI_CUSTOM_CONTAINER
- C . Create an object (instantiate the object) of the class CL_GUI_ALV_GRID
- D . Create an object (instantiate the object) of the class CL_SALV_TABLE
Name some perspectives that are available in the SAP HANA Studio? There are 3 correct answers to this question
- A . The technology & innovation perspective
- B . The Information perspective
- C . The Resources perspective
- D . The SAP HANA Modeler perspective
- E . The Administration Console perspective
What is the best order to provide an event handler for an ALV?
- A . Create the ALV, write the handler, register for the event, display the ALV
- B . Write the handler, register for the event, create the ALV, display the ALV
- C . Write the handler, create the ALV, display the ALV, register for the event
- D . Register for the event, write the handler, create the ALV, display the ALV
- E . Write the handler, create the ALV, register for the event, display the ALV
Your ABAP program contains an Open SQL join of two clientdependent tables. You want to replace this with a native SQL SELECT statement.
Which of the following changes to the SELECT statement can you use to retrieve the same data as before?
There are 2 correct answers to this question.
- A . Include the client field in the WHERE condition.
- B . Include the client field in the join condition.
- C . Use the CLIENT SPECIFIED addition.
- D . Include the client field in the field list.
What are the two main methods to add a system to the SAP HANA Studio? There are 2 correct answers to this question
- A . Manually
- B . By Importing a Landscape
- C . By Resource console
- D . Automatically
In which of the following situations could a row store table be more suitable than a column store table? There are 2 correct answers to this question.
- A . The table contains data that you want to aggregate.
- B . The table contains mainly distinct values per column across rows.
- C . The table contains text that you want to search.
- D . The table contains only a small number of records.
The Java stack and the ABAP stack of an SAP NetWeaver Application Server must always be installed together
- A . False
- B . True
A watchpoint stops program execution every time the condition specified is met
- A . False
- B . True
An internal table can have at most 15 secondary keys.
- A . False
- B . True
You can use the logical expression IS SUPPLIED for any formal parameter passed to which modularization unit? Select all that apply.
- A . Instance method
- B . Subroutine (FORM routine)
- C . Function module
- D . Static method
Each ABAP program starts with an introductory statement.
Which statements are correct? Select all that apply.
- A . The introductory statement must be the first statement in the program.
- B . The introductory statement must be the first line in the program
- C . The introductory statement can be modified.
- D . The introductory statement must never be modified.
Is it possible to have multiple active implementations of business add-ins at a time? Select all that apply
- A . It can have multiple active implementations if the Multiple use checkbox is ‘―’ selected.
- B . It cannot have a multiple active implementation.
- C . It can have multiple implementations if the Filter-Depend, checkbox is ‘―’ selected.
What is a plug? Select all that apply.
- A . Can be assigned to multiple views
- B . outbound, or both
- C . Can be defined as default inbound
- D . Can be defined as outbound controlling multiple inbound plugs
- E . Can be defined as an exit
- F . Forms the basis of navigation within a Web Dynpro
- G . Can be defined as inbound and be controlled by multiple outbound plugs
- H . Can be defined as a startup
Which is not a Golden Rule for Open SQL? Please choose the correct answer.
- A . Minimize the Amount of Data Transferred
- B . Keep the result set large
- C . Reduce the Database Load
- D . Minimize the Number of Database Accesses
Which of the following tool is introduced as a holistic quality assurance tool? Choose the correct answer
- A . ABAP Test Cockpit (ATC)
- B . DBA Cockpit
- C . DBMS Cockpit
- D . BW system
Which modularization units are global? Select all that apply
- A . Function modules
- B . Subroutines (FORM routines)
- C . Methods within a local class in the program
- D . Methods within class pools
Which events can exist in all types of programs that actually contain executable statements?
- A . AT USER-COMMAND
- B . AT PF##
- C . INITIALIZATION
- D . LOAD-OF-PROGRAM
- E . AT LINE-SELECTION
- F . START-OF-SELECTION
ABAP Push Channels (APC) can only use the WebSocket protocol.
- A . False
- B . True
You use the addition OBLIGATORY to define the input field of a parameter as a required field.
- A . True
- B . False
CORRECT TEXT
You want to select data from two tables and store the result in as structure.
Table PARTNER contains the fields PARTJD and KIND.
Table CONTRACT contains the fields CONTJD, CONT_TYPE and DIVISION.
The structure is defined as follows
DATA: BEGIN OF wa_result,
Part_id type partner-partjd, cont_id type contract-cont_id, ConMype TYPE contract-cont_type,
END of wa_result,
Lt_result type table of wa_result.
How can you replace the following SELECT statement with an outer join?
SELECT partjd from partner INTO wa_result WHERE kind = ‘Residential’.
SELECT contjd from CONTRACT into wa_result-cont_id WHERE part EQ
wa_partner-part_id And DIVISION eq ‘Water’.
Append wa_result to lt_result.
ENDSELECT.
If sy-subrc<>0. CLEAR wa_result-cont_id
APPEND wa_result TO lt_result. ENDIF.
ENDSELECT.
Please choose the correct answer.
- A . SELECT partjdcontjd from partner AS A LEFT JOIN contract AS b ON a-partjd = b-partjdAND b-division EQ ‘Water’ INTO TABLEIt_result WHERE kind = ‘Residential’
- B . SELECT partjdcontjd from partner LEFT JOIN contract on partner-partjd = contract-partjd
AND partner-kind EQ ‘Residential’ INTO CORRESPONDING FIELDS OF TABLE lt_result
WHERE division eq ‘Water’. - C . SELECT partjdcontjd from partner AS A LEFT JOIN contract AS b ON a-partjd = b-partjd INTO CORRESPONDING FIELDS OF TABLE lt_result WHERE kind = ‘Residential’ and AND division EQ ‘Water’.
- D . SELECT partjdcontjd from partner LEFT JOIN contract on partner-partjd = contract-partjd AND contract-division EQ ‘Water’ INTO TABLE It result WHERE kind EQ ‘Residential’.
What is the allowed length of the ABAP Dictionary data type DF34_RAW?
- A . The allowed length is between 1 and 34 digits.
- B . The allowed length is 34 digits.
- C . The allowed length is between 1 and 31 digits
- D . The allowed length is between 0 and 33 digits.
When analyzing a program, which tasks can you perform using the code inspector? There are 3 correct answers to this question.
- A . Discover unused variables.
- B . Inspect the memory consumption.
- C . Determine used database tables.
- D . Execute the extended program check.
- E . Evaluate the time needed for program execution.
Methods provide which types of parameters? Select all that apply.
- A . Output
- B . Return values
- C . Input
- D . Input/output (changing)
- E . Exceptions
The order of fields for a transparent table in the database…
- A . Is created in the order of the ABAP Dictionary
- B . Needs to match the ABAP Dictionary.
- C . Is allowed to be different than the ABAP Dictionary.
If you enter the value "0" or blank ("") as the next screen, then the system resumes processing from the point at which the screen was initiated, assuming the Next Screen attribute is overridden
dynamically in the program.
- A . True
- B . False
The valid value for a decimal floating point number of type decfloat16 is a number between 1E385 and -1E-383 for a negative number, 0, and 1E-383 to 1E385 for a positive number.
- A . True
- B . False
What does SAP recommend that you use a hashed table? Please choose the correct answer.
- A . When a table must be sorted automatically by key in ascending order
- B . When a table must be accessible by both index and key
- C . When a table is very large and you want to access the table by index only
- D . When a table is very large and you want to access the table by key only
What does SAP recommend that you use a hashed table? Please choose the correct answer.
- A . When a table must be sorted automatically by key in ascending order
- B . When a table must be accessible by both index and key
- C . When a table is very large and you want to access the table by index only
- D . When a table is very large and you want to access the table by key only
What does SAP recommend that you use a hashed table? Please choose the correct answer.
- A . When a table must be sorted automatically by key in ascending order
- B . When a table must be accessible by both index and key
- C . When a table is very large and you want to access the table by index only
- D . When a table is very large and you want to access the table by key only
What does SAP recommend that you use a hashed table? Please choose the correct answer.
- A . When a table must be sorted automatically by key in ascending order
- B . When a table must be accessible by both index and key
- C . When a table is very large and you want to access the table by index only
- D . When a table is very large and you want to access the table by key only
What does SAP recommend that you use a hashed table? Please choose the correct answer.
- A . When a table must be sorted automatically by key in ascending order
- B . When a table must be accessible by both index and key
- C . When a table is very large and you want to access the table by index only
- D . When a table is very large and you want to access the table by key only
Each button on a Dynpro (screen) requires the assignment of a function code. This function code…
- A . Can be used to identify when the button is clicked by looking for the function code in the screen’s OK_CODE •―I field.
- B . Is used to define global variables that receive a value when the button is ‘―’ clicked.
- C . Prevents the function code from be assigned to a menu item.
Which code-to-data capability supports- Extended view definitions and Better SQL- 92 standard support in open SQL?
Please choose the correct answer.
- A . SAP HANA specific features
- B . Database for sophisticated analysis
- C . New SQL parser used in model
- D . Database oriented programming model
Explain the Enterprise Information System of – SAP HANA Implementation Scenarios? There are 3 correct answers to this question
- A . HANA Accelerators
- B . Business Suite on HANA / BW on SAP HANA
- C . All HANA Combinations on one platform
- D . HANA Modeling
- E . All SAP applications on one SAP HANA platform
What do you need to have in your program to respond to the DOUBLE_CLICK event raised by an instance of the CL_GUI_ALV_GRID class? There are 3 correct answers to this question.
- A . A SET HANDLER statement to register the handler to the event
- B . A handler class
- C . A CATCH statement to capture the event
- D . A method to read the registration table
- E . A handler method for the event
Which modularization units can raise an exception? Select all that apply
- A . Methods
- B . Subroutines (FORM routines)
- C . Function modules
The ALV is entirely implemented using ABAP Objects.
- A . False
- B . True
FORM routines (subroutines) can be used in which program types? Select all that apply
- A . Module pools
- B . Executables
- C . Function groups
- D . Class pools
- E . Subroutine pools
- F . Interface pools
- G . Type groups
Which elementary field types are considered a character type? Select all that apply.
- A . N
- B . X
- C . F
- D . C
- E . I
- F . STRING
- G . XSTRING
- H . T
- I . D
The database always uses the primary key when the WHERE clause contains any of the key fields.
- A . False
- B . True
What is the difference between a Unicode and non-Unicode program? Select all that apply
- A . Offset positioning in a Unicode structure is restricted to flat data objects.
- B . Byte-type data objects cannot be assigned to character-type data objects.
- C . Offset positioning in a Unicode structure is restricted to character data ^ •―I objects.
- D . Byte-type data objects cannot be compared to character-type data objects.
Which you should specify in a non-Unicode system when opening a file in TEXT MODE? Select all that apply.
- A . The ENCODING addition
- B . The byte order
- C . The code page
Beginning with SAP NetWeaver 7.40, if SAP HANA (an in-memory database) is being used as a database, then table buffering is no longer effective and is therefore not possible.
- A . True
- B . False
Each work process… (select all that apply.)
- A . Can only make database changes within a single database LUW.
- B . Is independent of other work processes
- C . Uses a pool of database connections established when the SAP NetWeaver AS for ABAP started.
- D . Uses a database connection to a work process established when the SAP NetWeaver AS for ABAP started.
- E . Can make database changes spanning multiple database LUWs
At most, how many menu items (including functions, separators and submenus) can a menu have on the screen?
- A . 10
- B . 20
- C . 15
- D . None of the above
What do you need to consider when creating a secondary index on a table? There are 2 correct answers to this question.
- A . The index can be created for specific database systems only
- B . The most frequently selected fields should be at the first positions in the index
- C . The index must always be unique
- D . The table will be updated more quickly if you create more indexes
Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question.
- A . Core data service (CDS) access control
- B . Open SQL
- C . ABAP Dictionary
- D . Core data services (CDS) data definition
Which statements are true? Select all that apply.
- A . The ALV Object Model requires a table refresh after programmatically changing the ALV
- B . The ALV Grid can define a sort criteria for initial display.
- C . The ALV Object Model uses a reference to the data table for display.
- D . The ALV Object Model can define a sort criteria for initial display.
- E . The ALV Grid uses a reference to the data table for display.
- F . The ALV Grid requires a table refresh after programmatically changing the DALV.
Which selection screen elements allow user input in ABAP Reports? There are 2 correct answers to this question
- A . SELECTION-SCREEN COMMENT
- B . SELECT-OPTIONS
- C . PARAMETERS
- D . SELECTION-SCREEN BLOCK
The Debugger is entirely self-contained and requires no external transactions.
- A . True
- B . False
What is the default selection screen number for the ABAP program?
- A . 1100
- B . None of the above
- C . 1000
- D . 100
What does the enhancement category for a database table or structure do? Select all that apply.
- A . Specifies the types of changes that can be made to the structure
- B . Can produce warnings at incompatible points for the structure
- C . Can identify where program behavior may change
- D . Makes a table Unicode-compliant
Authorizations are handled automatically during access to the database interface to restrict data access of the user.
- A . False
- B . True
Given the code in the exhibit (see Figure 17.9) and the knowledge that both lcl_truck and lcl_car inherit from lcl_vehicle, which statements are true? Select all that apply
- A . The code will produce a runtime error.
- B . The code shows two valid up casts.
- C . The table lt_vehicle contains three vehicles.
- D . The code is not syntactically correct.
- E . The code shows no valid up casts.
- F . The code shows three valid up casts.
The READ statement with the addition BINARY SEARCH for a sorted internal table is better for performance.
- A . False
- B . True