Tavasz Vizsga OT
Tavasz Vizsga OT
Test your skills and knowledge with the Tavasz Vizsga OT quiz, specifically designed for those working with SAP ADT. This comprehensive quiz contains 50 challenging questions to help assess your understanding and proficiency in ABAP and SAP Gateway.
Prepare yourself for success with:
- Multiple choice questions covering a range of SAP topics
- Insightful questions designed for developers, students, and professionals
- A chance to gauge your readiness for real-world challenges
Which of the following details must you supply to log onto an SAP system using ADT? Choose the correct answers.
Client
User
Password
Package
Which of the following data types are incomplete (and therefore support the LENGTH addition to the DATA statement)? Choose the correct answers.
STRING
P
I
C
You are using TRY..ENDTRY to handle errors. If you want to handle any error in a single CATCH statement, which statement would you use? Choose the correct answer.
CATCH OTHERS.
CATCH cx_root.
CATCH cx_static_check.
CATCH cx*.
Which of the following are modularization techniques in ABAP? Choose the correct answers
Stored procedures.
Function modules
Include programs.
Methods of global or local classes
You want to copy data between two structures. The structures have different types, but some of the components have identical names. The target structure already contains data, which you do not want to lose during the copy operation. Which of the following fun
VALUE with BASE
VALUE without BASE
CORRESPONDING with BASE.
CORRESPONDING without BASE.
Which of the following attributes are essential parts of the deיִnition of an internal table type? Choose the correct answers.
Storage type
Line type
Access type
Key components
Which of the following statements regarding the key of a database table are correct? Choose the correct answers.
The key determines the order in which entries in the table will be stored.
The combination of key יִelds identiיִes each row uniquely.
The key must not have more than יִve יִelds.
The key is mandatory.
Which of the following elements may an instance constructor have? Choose the correct answers.
Importing parameters
Exporting parameters
Changing parameters
Exceptions
You have an instance of a subclass and want to assign it to a reference variable that has the type of the superclass. Which of the following statements is true? Choose the correct answer.
You cannot do this because the types are incompatible.
You can always assign an instance of a subclass to superclass reference.
You can only assign an instance of a subclass to a superclass reference after you have checked that the types are compatible.
You can only do this if the superclass provides a suitable method that performs the assignment.
Which of the following statements are true of interfaces? Choose the correct answers.
They may contain method deיִnitions.
They may contain method implementations.
They may contain private attributes.
They may contain type deיִnitions.
What is the name of the protocol that is supported by SAP Gateway and that allows simple access to data from SAP Business Suite? Choose the correct answer.
TCP/IP
OData
RFC
SOAP
Match the following commands with their operation:
PUT: update the whole entity
PUT: partially update the entity
PUT: create an entity
PATCH: update the whole entity
PATCH: partially update the entity
PATCH: create an entity
POST: update the whole entity
POST: partially update the entity
POST: create an entity
Which of the following query options can be used to limit the size of the result set? Choose the correct answers.
$select
$יִlter
$orderby
What is the name of the tool that is used to implement OData services for SAP Gateway in the SAP Business Suite back end? Choose the correct answer.
SAP Gateway Editor
SAP Gateway Monitor
SAP Gateway Client
SAP Gateway Service Builder
When performing CUD operations, a client יִrst needs to request a CSRF token and then has to send this along with the HTTP PUT or POST request. Which actions have to be taken? Choose the correct answers.
When using the SAP Gateway client to test a service, the developer does not have to do anything because the handling of the CSRF token is performed automatically by the SAP Gateway client.
When developing an OData client application, the application developer has to take care of the correct handling of CSRF tokens.
CSRF tokens are not needed when performing updates with OData services in SAP Gateway.
When generating a service by using redeיִnition, which of the following options are available? Choose the correct answers.
Redeיִne a BW query service
Redeיִne an existing SAP Gateway service
Redeיִne an RFC function module
How can you create a Gateway service based on a CDS view? Choose the correct answers.
Code mapping
SAPUI5 template
@OData.publish
Project redeיִnition
Data reference
Which development tool is needed when using the odata.publish : true annotation? Choose the correct answer.
SEGW
SE80
Eclipse
ABAP CDS views can be developed if the SAP back end runs on top of which of the following releases? Choose the correct answers.
SAP NetWeaver 7.40
SAP NetWeaver 7.51
SAP NetWeaver 7.0 with SAP Gateway 2.0 SP8
SAP NetWeaver 7.50
$expand is used to retrieve several entities that are connected via: Choose the correct answer.
Connectors
Navigation properties
Function imports
Identical property names
Which are true statements relating to calculation views of the type SQL access only? Choose the correct answers.
They do not expose their meta data to reporting tools
They are mainly used for reusing inside other calculation views
They must include at least one measure
They include a star join node
Why do you use a Referential Join? Choose the correct answer.
To improve performance of joins that do not need to check integrity if no column from the right table is selected by a query.
When you need to display only facts that have associated master data attributes.
When you want to display facts even when the associated master data attributes are missing.
When is the design time יִlter expression applied in a calculation view? Choose the correct answers.
Before a query on the calculation view begins to execute
On the יִnal result of a query, similar to a ‘where’ clause
Before any joins are executed within the calculation view
What types of user-deיִned SQL fun
Table Functions
Column Engine Functions
Scalar Functions
Which type of node is used to end the parallelization of a data flow? Choose the correct answer.
Projection
Union
Aggregation
Which of the following entries are required when creating a system in the SAP HANA Studio? Choose the correct answers.
Host name
Instance number
Client ID
User name
Logon Language
Which of the following are potential fun
Use of native SQL or DB Hints
Use of secondary database connections
Coding that assumes that a SELECT result is always sorted
The existence of customer-speciיִc cluster tables
The existence of table appends
Which of the following are steps in the recommended sequence for a guided performance analysis? Choose the correct answers.
Do static code checks with Code Inspector or ABAP Test Cockpit
Collect runtime data with SQL Monitor
Collect runtime data with Runtime Analysis
Combine runtime data and static check result in SQL Performance Tuning Worklist
Which of the following are tasks of the database interface (DBI) and database-speciיִc library (DBSL)? Choose the correct answers.
Translate Open SQL syntax into native SQL syntax
Add client handling to the statement
Check user authorizations
Handle SAP table buffering
Transaction handling
Which of the following entities can be found in the object list of the ABAP Workbench or the Project Explorer of ADT? Choose the correct answers.
Data deיִnition (also known as DDL source)
CDS view
SQL view
Which of the following entities corresponds to an object that is created on the database? Choose the correct answer.
Data deיִnition (aka DDL source)
CDS view
SQL view
Which of the following are prerequisites for exposing an association? Choose the correct answer.
The association points to a table, not to another CDS View.
The association has cardinality “to-N.”
All יִelds mentioned in the ON condition are part of the יִeld list.
The association is the only association in this view deיִnition.
Which of the following are common ground between SAP HANA syntax and Open SQL syntax (as of ABAP 7 .40 SP05)? Choose the correct answers.
Key words are not case-sensitive
Table names have to be upper-case
Identical client handling
Comma-separated יִeld lists
Field list after FROM clause is supported
Which of the following are supported types for parameters of AMDP methods? Choose the correct answers.
Numeric or character-like scalar types
Structure types with only scalar components
Table types with only scalar columns
Nested table types without secondary keys
What can you do in ADT (ABAP in Eclipse) but not in the classical ABAP Workbench? Choose the correct answers.
Display an AMDP method implementation
Edit an AMDP method implementation
Test an AMDP method implementation
Debug an AMDP method implementation
You want to access SAP HANA view CA_BOOKINGS_COUNT in package ha400.primdb via a native SQL query. Which of the following are correct ways of specifying package path and object name in the FROM clause? Choose the correct answers.
FROM _SYS_BIC.“ha400.primdb.::CA_BOOKINGS_COUNT”
FROM “ha400.primdb::CA_BOOKINGS_COUNT”
FROM _SYS_BIC.“ha400.primdb/CA_BOOKINGS_COUNT”
FROM “ha400.primdb/CA_BOOKINGS_COUNT”
You execute the following native SQL query on SAP HANA: CALL "ha400.primdb::SP_PROCEDURE"( '10', null, null ) WITH OVERVIEWWhich of the following results do you expect? Choose the correct answer.
Two table-like results
Two scalar results
One scalar result
One table-like result
Which of the following are advantages of using proxy objects for SAP HANA artefacts? Choose the correct answer.
No native SQL required to access the SAP HANA object
Automatic synchronization of proxy object deיִnition
Automatic transport of SAP HANA artefacts in ABAP transport request
No need for SAP HANA database to deיִne the proxy objects
You want to perform an SAP HANA full-text search on column COL of database table TAB. Which of the following conditions have to be fulיִlled? Choose the correct answers.
Table TAB is located in column store.
Column COL is of type TEXT or SHORTTEXT.
A full text index exists for column COL of table TAB.
The application server release is 7 .40 SP05 or higher.
Which of the following features are NOT supported by ALV with IDA? Choose the correct answer
Personalization
Editing values
Excel export
Double-click
Which of the following statements are true about the SAP Web IDE for SAP HANA? Choose the correct answers.
It is a browser-based IDE.
It provides wizards and code templates to help you get started more quickly and easily.
It does not provide debugging facilities to test your applications.
You can package modules into a multi-target application.
What is Node.js? Choose the correct answer
It is a scripting language specialized in the execution of data intensive calculations.
It is a client-side JavaScript library, providing components to design the user interface.
It is a server-side runtime environment for JavaScript.
In the SAP Web IDE for SAP HANA, when you create a new SAP HANA database module, what is added to the mta.yaml יִle? Choose the correct answers.
A module of type HDB
A route to the SAP HANA database
A service of type com.sap.xs.hdi-container
A service of type OData
In the SAP Web IDE for SAP HANA, when you create a SAP HANA database module, a SAP HANA database module and a com.sap.xs.hdi-container service are added to the mta.yaml יִle.What do you use calculation views for? Choose the correct answer.
To code using the R programming language.
To provision data from remote sources.
To resolve complex mathematical equations.
To read data in real time for analytical reporting.
In SAP HANA, you create a stored procedure. What can you set in the header properties? Choose the correct answers.
Global variables
Read/write access
Storage type
Programming language
Security
Waldemar creates a plain database schema and grants Constanze the CREATE ANY privilege on that schema. Who can access the table DUMMY which Constanze creates in Waldemars schema? Choose the correct answers.
Waldemar, because he own the schema
Constanze, because she owns the table
Every user having theCREATE ANY privilege
Every user owning an object in Waldemars schema
You are developing the persistency layer for a multi-target application. You want to create a database view that reads data from a table in a remote SAP HANA schema. What do you need to use? Choose the correct answer.
A remote desktop connection
A user-deיִned service
An OData service
A schema synonym
Which Node.js module provides a database connection? Choose the correct answer.
@sap/xsenv
Express
Jest
@sap/hdbext
{"name":"Tavasz Vizsga OT", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your skills and knowledge with the Tavasz Vizsga OT quiz, specifically designed for those working with SAP ADT. This comprehensive quiz contains 50 challenging questions to help assess your understanding and proficiency in ABAP and SAP Gateway.Prepare yourself for success with:Multiple choice questions covering a range of SAP topicsInsightful questions designed for developers, students, and professionalsA chance to gauge your readiness for real-world challenges","img":"https:/images/course5.png"}