Question 1
Question
What are the main principles of SAP Fiori?
Choose the correct answers.
There are 2 correct answers to this question.
Question 2
Question
On what basis are the ABAP Development Tools developed?
Choose the correct answer.
Question 3
Question
What are the different types of editors available in ABAP Development Tools?
Choose 2 correct answers.
Question 4
Question
What new repository object types were introduced with ABAP CDS?
Choose 3 correct answers.
Question 5
Question
Which object is created when a Data Definition is activated?
Choose the correct answer.
Answer
-
Role View
-
CDS View
-
Activation View
-
Authorization View
-
Data Definition View
Question 6
Question
What are possible values for the annotation @AccessControl.authorizationCheck?
Choose 3 correct answers.
Answer
-
#CHECK
-
#NOT_REQUIRED
-
#PFCG_AUTH
-
#FULL_ACCESS
-
#NOT_ALLOWED
-
#GRANT_SELECT
Question 7
Question
What tools are available in the ABAP Development Tools to analyze CDS Views?
Choose 3 correct answers.
Answer
-
Dependency Analyzer
-
Active Annotations
-
Annotation Analyzer
-
Authorization Preview
-
Data Preview
-
Active Dependencies
Question 8
Question
What are the repository objects that make up a business service?
Choose 2 correct answers.
Answer
-
Service Model
-
Service Binding
-
Service Type
-
Service Definition
-
Service Protocol
Question 9
Question
Which of the following are service types available when exposing a business service as an
OData service?
Choose 2 correct answers.
Answer
-
UI API
-
Service API
-
Web API
-
Web Service
-
UI Service
-
API Service
Question 10
Question
How is the UI of an SAPUI5 application rendered?
Choose the correct answer
Answer
-
The UI is rendered in the browser using JavaScript.
-
The UI is rendered in the browser using ABAP.
-
The UI is rendered on the ABAP server using JavaScript.
-
The UI is rendered on the ABAP server using ABAP.
Question 11
Question
Which statements about SAP Fiori elements are correct?
Choose 3 correct answers.
Answer
-
SAP Fiori elements are part of the SAPUI5 delivery.
-
SAP Fiori elements provide complete freedom in implementing an application.
-
The effort required for development with SAP Fiori elements is less than for
SAPUI5 freestyle development.
-
SAP Fiori elements ensure a consistent look and feel and UI behavior for the
developed applications.
Question 12
Question
SAP Fiori elements provide a framework for generating UIs at runtime based on OData
services and annotations requiring no JavaScript UI coding. Just like the data provided via
OData services, the metadata annotations must also be made available via the
corresponding back-end.
Determine whether this statement is true or false.
Question 13
Question
What of the following are floorplans currently available with SAP Fiori elements?
Choose 2 correct answers.
Answer
-
Overview Page
-
Create Page
-
Object Page
-
Master-Detail Page
Question 14
Question
For which development environments are the SAP Fiori tools extensions available?
Choose 2 correct answers.
Question 15
Question
Which command do you use to deploy a SAPUI5 application?
Choose the correct answer.
Answer
-
run npm deploy
-
run deploy
-
npm deploy
-
npm run deploy
Question 16
Question
Which SAP Fiori elements can be assigned to user roles?
Choose the correct answers.
Answer
-
SAP Fiori Group
-
SAP Fiori Catalog
-
SAP Fiori Target Mapping
-
SAP Fiori Tile
Question 17
Question
What is needed to define a target mapping for an SAPUI5 application?
Choose 3 correct answers.
Answer
-
Component ID
-
Gateway service
-
ICF path
-
BSP name
-
System alias
-
Application ID
Question 18
Question
In which ABAP repository object is the behavior of a RAP business object specified?
Choose the correct answer.
Answer
-
Behavior Description
-
Behavior Definition
-
Behavior Pool
-
Behavior Implementation
Question 19
Question
Which syntax element includes RAP draft handling in the projection layer of a draftenabled RAP business object?
Choose the correct answer.
Answer
-
with draft
-
reuse draft
-
include draft
-
project draft
-
use draft
Question 20
Question
What are the options for providing additional application-specific business logic to a RAP Business Object?
Choose 3 correct answers.
Answer
-
Determinations
-
Injections
-
Formatters
-
Validations
-
Actions
Question 21
Question
Which annotation is used to define value helps?
Choose the correct answer.
Question 22
Question
ABAP Core Data Services (ABAP CDS) are only available when using a SAP HANA database.
Determine whether this statement is true or false.
Question 23
Question
When working with ABAP Development Tools (ADT), a project represents a certain set of tools.
Determine whether this statement is true or false.
Question 24
Question
In ABAP Development Tools (ADT), you open the context menu for a CDS View entity.
Which of the following tools is not in sub menu Open With?
Choose the correct answer.
Question 25
Question
Which of the followings are correct ways to add a comment in a data definition?
Choose 2 correct answers.
Question 26
Question
When you define a CDS DDIC-based view, the key of the generated DDIC View and the key of the CDS view can be different.
Determine whether this statement is true or false.
Question 27
Question
Which of the following View annotations is mandatory for the definition of a CDS DDIC-based view?
Choose the correct answer.
Question 28
Question
CASE expressions can be nested.
Determine whether this statement is true or false.
Question 29
Question
Type conversions in ABAP CDS are performed with a CONV( ) expression.
Determine whether this statement is true or false.
Question 30
Question
What is the default behavior of built-in function currency_conversion( ) in case of an error?
Choose the correct answer.
Answer
-
The function returns the input value unconverted.
-
The function returns the NULL value.
-
The function triggers an SQL Error.
Question 31
Question
When nesting CDS Views how many views can you built on to of each other (technically)?
Choose the correct answer.
Answer
-
2 Levels
-
3 Levels
-
10 Levels
-
No Limit
Question 32
Question
What is the result type of aggregate function SUM( )?
Choose the correct answer.
Question 33
Question
What is the difference when using UNION instead of using UNION ALL?
Choose the correct answer.
Question 34
Question
Which of the following are syntactically correct ways to address an input parameter
factorof a CDS View?
Choose 2 correct answers.
Answer
-
:factor
-
$factor
-
$parameters.factor
-
:parameters.factor
Question 35
Question
Which of the following is the default cardinality of an association of no cardinality is specified?
Choose the correct answers.
Answer
-
[0..1]
-
[0..*]
-
[1..1]
-
none
Question 36
Question
Which of the following extensions are allowed on a CDS view that does not contain annotation ABAPCatalog.viewEnhancementCategory?
Choose 3 correct answers.
Answer
-
Additional fields in the element list
-
Additional fields in the GROUP BY - clause
-
Additional expressions in the element list
-
Additional associations in the element list
Question 37
Question
All access conditions in CDS roles are based on user authorizations.
Determine whether this statement is true or false.
Question 38
Question
A CDS table function is a CDS object that is implemented by a script coding that is executed on the database.
Determine whether this statement is true or false.
Question 39
Question
SAP S/4HANA runs best with SAP HANA as database but it is available with other
databases, too.
Determine whether this statement is true or false.
Question 40
Question
Which of the following are potential functional issues when migrating ABAP code to SAP
HANA?
Choose 2 correct answers.
Answer
-
Use of native SQL or DB Hints.
-
Coding that assumes that a SELECT result is always sorted.
-
The existence of customer-specific cluster tables.
-
The existence of table appends.
Question 41
Question
Your SAP ERP system contains an ABAP Program which calls an SAP function module.
This functional module is a blacklist item in SAP S/4HANA. What happens after you migrated the system to SAP S/4HANA?
Choose the correct answers.
Answer
-
When a user runs the program, execution terminates with an error message.
-
When a user runs the program, execution terminates with a runtime error.
-
The call of the function module causes a syntax error during the upgrade.
-
It is not possible to upgrade the system to SAP S/4HANA while the program still
calls the function module.
Question 42
Question
If in SAP S/4HANA a former transparent table has been replaced by a view of the same name, which uses of this transparent table will still work fine?
Choose 2 correct answers.
Question 43
Question
Which source of information about SAP S/4HANA simplifications allows you to check whether a given repository object is affected.
Choose the correct answer.
Question 44
Question
Identifying and removing obsolete code is a mandatory step during the conversion of a SAP ERP system to SAP S/4HANA..
Determine whether this statement is true or false.
Question 45
Question
Which of the following tools are used to identify unused code?
Choose 2 correct answers.
Question 46
Question
It is possible to display usage data in the ABAP Call Monitor (transaction SCMON)?
Determine whether this statement is true or false.
Question 47
Question
Where do you define a set of Code Inspector checks that you want to perform?
Choose the correct answer.
Answer
-
In a Code Inspector object list.
-
In a Code Inspector check variant.
-
In a Code Inspector inspection.
Question 48
Question
Which of the following features are available in ABAP Test Cockpit (ATC) but not in Code
Inspector (SCI)?
Choose 2 correct answers.
Answer
-
Ad hoc checks in ABAP Workbench (SE80).
-
Full inspection of freely defined object sets.
-
Distribution of check results.
-
Remote checks.
Question 49
Question
Which of the following are prerequisites for performing SAP S/4HANA Readiness Checks?
Choose 2 correct answers.
Answer
-
The check system has ABAP release 7.51 or higher.
-
You perform the check with ABAP Test Cockpit (ATC) and not with Code Inspector
(SCI).
-
Simplification Database is loaded into the check system.
-
The check system is a SAP S/4HANA system.
Question 50
Question
You want to set up a central check system for remote ATC checks. Which is the minimum
ABAP release for this central check system?
Choose the correct answer.
Answer
-
AS ABAP 7.00
-
AS ABAP 7.40
-
AS ABAP 7.51
Question 51
Question
You want to set up a central check system for remote ATC checks. Which is the minimum ABAP release for the checked system?
Choose the correct answer.
Answer
-
AS ABAP 7.40
-
AS ABAP 7.00
-
AS ABAP 7.51
Question 52
Question
Prior to using the Custom Code Migration app you have to perform an S/4HANA readiness check in the ABAP Test Cockpit.
Determine whether this statement is true or false.
Question 53
Question
Prior to using the Custom Code Migration app you have to configure an Object Provider for the checked system in the ABAP Test Cockpit.
Determine whether this statement is true or false.
Question 54
Question
BTP stands for:
Choose the correct answer.
Question 55
Question
What is correct with regards to in-app extensibility?
Choose 3 correct answers.
Answer
-
The key user can perform simple extensibility tasks in an easy-to-do way.
-
UI adaptations are feasible for fields, groups, and field labels.
-
The key user may adapt the behavior of the kernel functions of the application
server.
-
The key user may reorganize the sequence of the Logical Unit of Work processing.
-
The key user may add custom business logic at predefined enhancement points.
Question 56
Question
What is true concerning the new extensibility concept for SAP S/4HANA?
Choose 2 correct answers.
Answer
-
Only such an extensibility is allowed that does not block updates and permits to
continue to work after an update.
-
No modifications are allowed.
-
Custom side-by-side extensions are tightly coupled with the digital core.
Question 57
Question
An ABAP Environment is a service of SAP BTP. Which of the following are correct?
Choose 2 correct answers.
Answer
-
In a technical sense, the ABAP Service is associated directly with a Global Account;
there is no need for a subaccount and a space.
-
The ABAP Service is instantiated as part of a space. A space in turn can comprise
several ABAP services.
-
To perform administrative tasks for the ABAP Service with ABAP Service
Launchpad (Dashboard), you need to have a Business User.
-
To perform development tasks with ABAP Development Tools (ADT) on ABAP
Environment, you need to have a space user.
-
To perform development tasks with ABAP Development Tools (ADT) on ABAP
Environment, you need to have a Business User.
Question 58
Question
To log on to ABAP Environment coming from ABAP Development Tools (ADT), using the service key is sufficient.
Choose the correct answer.
Answer
-
Yes, you do not need any other credentials.
-
No. Besides this, you need a Business User.
Question 59
Question
For side-by-side extensions, SAP BTP offers several programing languages. Which of the following are supported?
Choose 3 correct answers.
Answer
-
HTML5
-
Cobol
-
ABAP
-
Java
-
Java Script
-
Assembler
Question 60
Question
SAP BTP ABAP environment allows Agile Innovation on the newest technology. What are the characteristics of Agile Innovation?
Choose 2 correct answers.
Answer
-
Developers can work from everywhere.
-
The newest SAP S/4HANA capabilities always can be exploited.
-
The newest ABAP Programming Model is always available.
-
Innovations from SAP must be pulled explicitly by the customer; there is no
automatism that they are available.
Question 61
Question
ABAP Environment is a Platform-as-a-Service (PaaS). Which of the following is correct?
Choose the correct answer.
Answer
-
It cannot be part of SAP BTP because SAP BTP itself is already a PaaS.
-
It is always part of SAP BTP.
-
It can be part of SAP BTP but it is available stand-alone also.
Question 62
Question
ABAP Development Tools (ADT) are the Integrated Development Environment (IDE) for ABAP Environment. Which of the following are correct?
Choose 2 correct answers.
Answer
-
ADT is part of SAP BTP.
-
ADT can be downloaded at eclipse.org and works for ABAP development out-ofthe-box without any further preparations.
-
ADT is a specific Plug-In for the Eclipse IDE from SAP.
-
ADT can be used for on-premise development and for cloud-based development.
Question 63
Question
There is one ABAP but different versions.
Determine whether this statement is true or false.
Question 64
Question
which program is used, to allow developers to check, out the behavior of the different ABAP language versions?
Choose the correct answer.
Answer
-
ABAP_VERSIONS_DEMO
-
COMPARE_ABAP_VERSIONS
-
DEMO_ABAP_VERSIONS
Question 65
Question
External Repository Objects are Development Objects that are not created by the
customer.
Determine whether this statement is true or false.
Question 66
Question
Which of the following entity types implement the ABAP RESTful programming model?
Choose 4 correct answers.
Question 67
Question
All entities of a structure (except the root entity) that represent a node of the business
object structure serve as a:
Choose 3 correct answers.
Answer
-
Leaf entity
-
Parent entity
-
Branch Entity
-
Child entity
Question 68
Question
Which of the following statements are correct?
Choose 2 correct answers.
Answer
-
A service definition describes which CDS entities of a data model are to be
exposed
-
A service binding is used to bind a service definition to a communication protocol
such as OData
-
A service definition implements the behavior of a data model such as create,
update, delete
-
A service binding implements the behavior of a data model such as create, update,
delete
Question 69
Question
A behavior definition is defined by using the ABAP Restful Definition Toolset.
Determine whether this statement is true or false.
Question 70
Question
The draft concept fills the gap between a stateless communication pattern and a stateful
application by applying REST principles.
Determine whether this statement is true or false.
Question 71
Question
The Connectivity service provides the following services:
Choose 4 correct answers.
Answer
-
Allows you to make connections to on-premises systems, using the Cloud
Connector.
-
Allows connections to on-premises systems not using the Cloud Connector
-
Allows subaccount specific configuration of application connections via
destinations.
-
Provides an API that application developers can use to consume remote services.
-
Lets you establish a secure tunnel from your on-premises network to applications
on SAP BTP, while you keep full control and auditability of what is exposed to the
cloud.
Question 72
Question
Which methods are offered in the class: CL_HTTP_DESTINATION_PROVIDER to establish
a connection to an internet-facing API?
Choose 3 correct answers.
Question 73
Question
What are CRUD operations?
Choose the correct answer.
Answer
-
Change, Read, Update and Delete
-
Create, Read, Update, and Delete
-
Create, Read, Update, and Distribute
Question 74
Question
The Cloud Connector provides the connectivity between the SAP BTP and on-premise
systems.
Determine whether this statement is true or false.
Question 75
Question
What is the difference between OData service consumption and RFC execution?
Choose the correct answer.
Answer
-
The difference between OData service consumption and RFC execution is, that
OData always requires an HTTPS connection.
-
The difference between OData service consumption and RFC execution is, that
RFC is transported over an HTTP protocol.
-
The difference between OData service consumption and RFC execution is that
while OData is transported over the HTTP protocol, RFC is not.
Question 76
Question
What is used to simplify and encapsule both, the request and handling of a reusable custom-developed API?
Choose the correct answer.
Answer
-
The cloud connector.
-
A remote client proxy.
-
The remote service
Question 77
Question
Which of the following statements are true for Custom Code Development in SAP
Business Suite?
Choose 2 correct answers.
Answer
-
You can replace an SAP database table with a customer database table.
-
You can reuse SAP development objects.
-
Modification of SAP development objects is possible.
-
You can only access whitelisted APIs so that the digital core is decoupled from
customer access.
Question 78
Question
Which of the following is correct for Custom Code Development in the cloud?
Choose the correct answer.
Question 79
Question
Which adaptations are necessary when transforming ABAP Custom Code to SAP BTP ABAP environment?
Choose 2 correct answers.
Answer
-
Usage of OpenSQL is prohibited.
-
For the user interface, only usage of classical dynpro SAP GUI screens is allowed.
-
Adjustment to ABAP language version 'Cloud Platform' is necessary.
-
Custom code must be SAP cloud ready.
Question 80
Question
Which of the following statements about using abapGit is correct?
Choose 2 correct answer.
Answer
-
Custom source code can be transported in both directions between ABAP systems
– from on-premise to cloud and vice versa.
-
The abapGit Eclipse plug-in must be installed in ABAP Development Tools to
import/export ABAP objects from a Git repository.
-
The program ZABAPGIT must be installed on SAP BTP, ABAP environment.
Question 81
Question
Which of the following statements regarding transporting software components in SAP
BTP ABAP environment is correct?
Choose the correct answer.
Answer
-
Transport of software components is only possible within the same global account.
-
To transport any software components, no actions are necessary in ABAP
Development Tools. All actions are performed from the ABAP Service's dashboard.
-
C There must exist a transport layer – that is – there is a dedicated development
system and a dedicated production system.
Question 82
Question
The main development directions of the SAP BTP, ABAP environment are more options
for dynamic programming and improvements for the ABAP RESTful Programming Model.
Determine whether this statement is true or false.
Question 83
Question
Which of the following SAP HANA-based scenarios involve ABAP applications?
Choose 2 correct answers.
Answer
-
Data marts based on SAP HANA.
-
AS ABAP with SAP HANA as primary database.
-
Native SAP HANA applications.
-
SAP HANA as Business Accelerator.
Question 84
Question
On SAP HANA, tables are stored in row store by default.
Determine whether this statement is true or false.
Question 85
Question
Which of the following entries are required when creating a system in the SAP HANA Studio?
Choose 4 correct answers.
Answer
-
Host name
-
Instance number
-
Client ID
-
User name
-
Logon Language
Question 86
Question
Which of the following entities can be found under the Catalog node, and not under the
Content node?
Choose 2 correct answers.
Answer
-
Package
-
Schema
-
Table
-
Calculation View
Question 87
Question
It is not possible to create secondary indexes on SAP HANA.
Determine whether this statement is true or false.
Question 88
Question
Which of the following new repository objects belong to the so-called “Top-Down
Approach” for Code-to-Data?
Choose 2 correct answers.
Question 89
Question
When using a secondary database connection, the default schema is derived from the database user, which is stored in the secondary database connection.
Determine whether this statement is true or false.
Question 90
Question
Which of the following are potential functional issues when migrating ABAP code to SAP
HANA?
Choose 2 correct answers.
Answer
-
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-specific cluster tables.
-
The existence of table appends.
Question 91
Question
Where do you define a set of Code Inspector checks that you want to perform?
Choose the correct answer.
Answer
-
In a Code Inspector object list.
-
In a Code Inspector object check variant.
-
In a Code Inspector inspection.
Question 92
Question
When migrating to SAP HANA, every SELECT statement immediately becomes faster.
Determine whether this statement is true or false.
Question 93
Question
Because SAP HANA stores all data in memory, buffering of data on the application server becomes less important.
Determine whether this statement is true or false.
Question 94
Question
Which of the following patterns are known to potentially cause performance issues when accessing an SAP HANA database?
Choose 3 correct answers.
Answer
-
Use of SELECT ... FOR ALL ENTRIES
-
Use of joins with more than three tables
-
Use of SELECT statements in loops
-
Use of SELECT * for tables with many fields
Question 95
Question
Which of the following are steps in the recommended sequence for a guided performance analysis?
Choose 3 correct answers.
Answer
-
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
Question 96
Question
Which part of a guided performance analysis is done with the SQL Monitor tool?
Choose the correct answer.
Answer
-
Collect runtime data in the productive system.
-
Do static SQL checks in the productive system.
-
Do static SQL checks in the development system.
-
Combine runtime data and static check results
Question 97
Question
Which of the SQL performance rules become more important with SAP HANA?
Choose 2 correct answers.
Answer
-
Keep the result set small.
-
Minimize amount of transferred data.
-
Minimize number of database accesses.
-
Minimize search overhead.
-
Keep unnecessary load away from the DB.
Question 98
Question
1. Which of the SQL performance rules become less important with SAP HANA?
Choose 2 correct answers.
Answer
-
Keep the result set small.
-
Minimize amount of transferred data.
-
Minimize number of database accesses.
-
Minimize search overhead.
-
Keep unnecessary load away from the DB.
Question 99
Question
Which of the following are tasks of the database interface (DBI) and database-specific library (DBSL)?
Choose 3 correct answers.
Answer
-
Translate Open SQL syntax into native SQL syntax.
-
Add client handling to the statement.
-
Check user authorizations.
-
Handle SAP table buffering.
-
Transaction handling.
Question 100
Question
New Open SQL syntax is mandatory as of SAP NetWeaver AS ABAP 7.40 SP05.
Determine whether this statement is true or false
Question 101
Question
The Open SQL syntax is a prerequisite for the new Open SQL features.
Determine whether this statement is true or false.
Question 102
Question
Classical Open SQL syntax and new Open SQL syntax must not be used in the same ABAP processing block.
Determine whether this statement is true or false.
Question 103
Question
Which of the following entities can be found in the object list of the ABAP Workbench or the Project Explorer of ADT?
Choose 2 correct answers.
Question 104
Question
Which of the following entities corresponds to an object Created on the database?
Choose the correct answer.
Question 105
Question
If you use a CDS view name in the FROM clause of an Open SQL SELECT statement, the new Open SQL syntax is mandatory.
Determine whether this statement is true or false.
Question 106
Question
ASSOCIATION TO is just another way of saying LEFT OUTER JOIN TO.
Determine whether this statement is true or false.
Question 107
Question
Which of the following are prerequisites for exposing an association?
Choose the correct answers.
Answer
-
The association points to a table, not to another CDS View.
-
The association has cardinality “to-N.”
-
All fields mentioned in the ON condition are part of the field list.
-
The association is the only association in this view definition.
Question 108
Question
Where can you evaluate an exposed association?
Choose 3 correct answers.
Answer
-
In the Data Preview of ADT
-
In the Data Browser (transaction SE16) .
-
In another CDS view .
-
In an Open SQL SELECT statement.
Question 109
Question
CDS views that define associations cannot be extended.
Determine whether this statement is true or false.
Question 110
Question
An import parameter that is annotated with @Environment.systemField: becomes optional
in the following places:
Choose the correct answers.
Question 111
Question
An access control (DCL source) defines access restrictions for a given CDS view. These restrictions are implicitly evaluated when the CDS view is accessed in the following places:
Choose 2 correct answers.
Question 112
Question
Which of the following are common ground between SAP HANA syntax and Open SQL syntax (as of ABAP 7.40 SP05)?
Choose 3 correct answers.
Answer
-
Key words are not case-sensitive.
-
Table names have to be upper-case
-
Identical client handling.
-
Comma-separated field lists.
-
Field list after FROM clause is supported.
Question 113
Question
In SAP HANA SQL, it is mandatory to specify a schema before the table name.
Determine whether this statement is true or false.
Question 114
Question
Which of the following are supported types for parameters of AMDP methods?
Choose the correct answers.
Answer
-
Numeric or character-like scalar types.
-
Structure types with only scalar components.
-
Table types with only scalar columns
-
Nested table types without secondary keys.
Question 115
Question
All ABAP objects used within the body of an AMDP method have to be listed after the
USING addition.
Determine whether this statement is true or false.
Question 116
Question
Any AMDP method shipped by SAP can be extended using the AMDP BAdI technique.
Determine whether this statement is true or false.
Question 117
Question
What can you do in ADT (ABAP in Eclipse) but not in the classical ABAP Workbench?
Choose 2 correct answers.
Answer
-
Display an AMDP method implementation.
-
Edit an AMDP method implementation.
-
Test an AMDP method implementation.
-
Debug an AMDP method implementation.
Question 118
Question
When executing a native SQL query via ABAP Database Connectivity (ADBC), which of the following steps is optional?
Choose the correct answer.
Answer
-
Create an instance of CL_SQL_CONNECTION.
-
Create an instance of CL_SQL_STATEMENT.
-
Create an instance of CL_SQL_RESULT_SET.
-
None, all three are mandatory.
Question 119
Question
What happens if you forget to call method close( ) at the end of your query?
Choose the correct answers.
Question 120
Question
The search function in the toolbar of SAP HANA studio searches in SAP HANA content and in the SAP HANA catalog.
Determine whether this statement is true or false.
Question 121
Question
You can use Data Preview in SAP HANA studio to test SAP HANA views and SAP HANA stored procedures.
Determine whether this statement is true or false.
Question 122
Question
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 2 correct answers.
Answer
-
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”
Question 123
Question
Which of the following object types in ABAP repository are proxy objects for SAP HANA objects?
Choose 2 correct answers.
Answer
-
Procedure Proxy
-
Database View
-
SQL View
-
External View
Question 124
Question
When creating a proxy object for an SAP HANA view, it is possible to specify data elements for the view fields.
Determine whether this statement is true or false.
Question 125
Question
To include SAP HANA content into an ABAP transport request, SAP recommends using an
SAP HANA Transport Container (HTC) instead of the SAP HANA Transport for ABAP (HTA) technique.
Determine whether this statement is true or false.
Question 126
Question
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 fulfilled?
Choose 2 correct answers.
Answer
-
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.
Question 127
Question
Proposal search (= type ahead search) is supported on all database systems.
Determine whether this statement is true or false.
Question 128
Question
ABAP List Viewer with Integrated Data Access (ALV with IDA) is only supported for SAP HANA database.
Determine whether this statement is true or false.
Question 129
Question
Which of the following ABAP repository objects can be the data source for ALV with IDA?
Choose 4 correct answers.
Answer
-
Transparent table
-
Database view
-
CDS view
-
SQL view
-
External view
Question 130
Question
Which of the following features are NOT supported by ALV with IDA?
Choose the correct answers.
Answer
-
Personalization
-
Editing values
-
Excel export
-
Double-click
Question 131
Question
What of the following are floorplans currently available with SAP Fiori Elements?
There are two correct answers to this question.
Answer
-
Object Page
-
Create Page
-
Master-Detail Page
-
Overview Page
Question 132
Question
Which data transfer formats are available in SAP Gateway?
There are 2 correct answers to this question
Question 133
Question
You want to use Data Source Extensions. Which of the following restrictions and options apply?
There are 2 correct answers to this question.
Answer
-
You can only read fields of a data source extension.
-
You can use data source extensions to extend the SAP data sources with customer specific fields.
-
You can only create data source extensions for SAP applications that have been enabled by SAP for key user extensibility.
-
You can only create one data source extension per data source.
Question 134
Question
What annotation is required on the root entity to define the root of the compositional hierarchy for the business object to be created?
Choose the correct answer.
Answer
-
@ObjectModel.compositionRoot: true
-
@ObjectModel.compositionParent: true
-
@ObjectModel.topLevel: true
-
@ObjectModel.compositionChild: false
Question 135
Question
You are creating an enhancement implementation using key user extensibility. Which of the following can you do in the web-based ABAP editor?
There are 3 correct answers to this question.
Answer
-
Assign your implementation to a transport
-
Create filter conditions.
-
Directly access SAP database tables.
-
Modularize your code using custom libraries.
-
Test your custom logic.
Question 136
Question
Which of the following are extensibility apps from the Extensibility Business Catalog?
There are 3 correct answers to this question
Question 137
Question
Which programming language does ABAP RESTful Application Programming Model (RAP) support?
Answer
-
Node.js
-
JavaScript
-
ABAP
-
Java
Question 138
Question
Which development environment should you use to develop RAP-based apps?
Question 139
Question
Which RAP service type requires release, versioning, and deprecation management?
Question 140
Question
What do you define in a RAP service definition?
Answer
-
The data model of the business object
-
The entities of the app that are exposed as a service
-
The protocol used by the service
-
The behavior of the implementation
Question 141
Question
What languages do you use to define and implement RAP-based apps?
There are 2 correct answers to this question.
Answer
-
Core Data Services
-
ABAP
-
TypeScript
-
Unity
Question 142
Question
Which database is used in SAP Cloud Platform, ABAP Environment?
Question 143
Question
Which tool do you use to manage SAP Cloud Platform?
Question 144
Question
What does an SAP Cloud Platform, ABAP Environment trial account cost?
Question 145
Question
What is the ABAP flight reference scenario?
Answer
-
An application suite for regression tests.
-
A data model for ABAP system demos that is simple to use and understand.
-
An application for checking live flight data from various air carriers.
-
A productive application for managing bookings in a travel agency delivered by SAP.
Question 146
Question
Which editor should you use to create database tables in the SAP Cloud Platform, ABAP Environment?
Answer
-
Data dictionary editor in SE11 embedded in ADT
-
Table editor in SAP Fiori Tools
-
Source-based table editor in ABAP Development Tools
-
SAP HANA table editor
Question 147
Question
How do you add domain-specific semantics to a CDS data model?
Question 148
Question
How do you define your travel entity as root node of the RAP Business Object?
Question 149
Question
What is the purpose of projecting a CDS data model?
Answer
-
To define access control.
-
To document the CDS data model.
-
To define the specific use case and enrich the business object (BO) data model.
-
To define new business objects.
Question 150
Question
How do you enable CDS views and specific view elements for a full-text/freestyle search?
Answer
-
Using the appropriate @Search annotations in the respective database table.
-
By implementing the appropriate logic in an ABAP class.
-
By manually specifying the CDS view in the search engine.
-
Using the appropriate @Search annotations in the CDS data definition.
Question 151
Question
What can you define with UI annotations in an SAP Fiori Elements app?
There are 2 correct answers to this question.
Answer
-
Element position on list and on the object page.
-
List report header information and UI facets on the object page.
-
Standard CRUD (Create, Read, Update and Delete) operations.
-
Calculated fields.
Question 152
Question
How can you suppress an element from the personalization dialog of an SAP Fiori Elements app on the web browser?
Answer
-
Using the annotation "@UI.hidden: true".
-
By removing it from the CDS metadata extension.
-
Using the annotation "@UI.readonly: true".
-
Elements cannot be suppressed.
Question 153
Question
Which artifacts do you use to create a business service on top of a data model?
Answer
-
CDS metadata and business object projection
-
Business object data model projection and behavior projection
-
Service definition and service binding
-
Database tables and data elements
Question 154
Question
What advantages does a managed runtime implementation offer?
There are 2 correct answers to this question.
Answer
-
Enables existing code to be easily integrated using adapters.
-
Business Object Processing Framework (BOPF) framework is used to manage transactional handling.
-
Standard CRUD operations are available out-of-the-box.
-
Does not allow changes to the implementation.
-
Technical implementation tasks are performed by the business object infrastructure.
Question 155
Question
What does the managed scenario provide so you can implement your own business logic?
Answer
-
Screen exits
-
Call-back function modules
-
Business Add-Ins
-
Determinations, validations, and actions
Question 156
Question
How do you define the Business Object (BO) behavior?
Answer
-
By modelling a BOPF business object with the required behavior.
-
By creating a behavior definition for the root BO and defining the behavior of each BO node.
-
By creating a behavior implementation for the root BO.
-
By adding the appropriate @ObjectModel annotations in the CDS data model.
Question 157
Question
Which standard operations are performed by the managed runtime implementation?
Answer
-
Archiving and data aging.
-
Basic CRUD operations, Create, Read, Update, and Delete.
-
No standard operations are provided out-of-the-box meaning that an implementation is always required.
-
Writing of change documents for all performed operations.
Question 158
Question
What is the purpose of the Business Object (BO) behavior projection?
Answer
-
To project the relevant BO behavior to be exposed for a given consumption scenario.
-
To project the relevant CDS data model and metadata extensions.
-
To redefine the BO behavior and exposure for a given business service.
-
To project actions, validations, and metadata extension for a specific scenario.
Question 159
Question
Which keyword is used to project a given Business Object (BO) behavior in the BO projection layer?
Question 160
Question
What does EML stand for in the context of the RESTful Application Programming Model?
Answer
-
Entity Manipulation Layer
-
Extension Manipulation Language
-
Entity Manipulation Language
-
Entity Modification Language
Question 161
Question
Which statements about the Entity Manipulation Language (EML) are correct?
There are 2 correct answers to this question.
Answer
-
It is a mix of ABAP and SQLScript.
-
It offers a direct API-based access to RAP business objects.
-
It offers a standard API for type safe access to RAP business objects.
-
It is defined in the IEEE9767/1 standard.
-
EML was invented by Linus Torvalds.
Question 162
Question
How do you define instance-based feature control for fields and operations?
Answer
-
By referring to the UUID of the respective entities.
-
By using the keyword 'features : instance' in the business object behavior definition.
-
By using the annotation '@Instance.feature: True'.
-
By implementing the unmanaged lock.
Question 163
Question
Where do you define new validations and determinations for your business object behavior?
Answer
-
In the Business Object Behavior Projection.
-
In the metadata extension.
-
In the root CDS view.
-
In the base Business Object Behavior Definition.
Question 164
Question
How is a class containing a RAP business object implementation identified?
Answer
-
By using the keyword 'FOR BEHAVIOR IMPLEMENTATION OF' in the global class definition.
-
By selecting the respective flag in the class properties.
-
By using the keyword 'FOR BEHAVIOR OF' in the global class definition.
-
By using the keyword 'FOR BEHAVIOR OF' in the local types section.
Question 165
Question
How are validations taken care of in an unmanaged scenario?
Answer
-
Validations are implemented by the function modules of the existing business logic.
-
Validations are implemented by the RAP framework.
-
Validations are defined in the business object behavior projection.
-
Validations are run by an external AI service.
Question 166
Question
How many root nodes can be defined in a CDS business object?
Answer
-
None because root nodes are defined for business services, not for business objects.
-
It depends on the artifact the business object represents.
-
As many as you need to define the business object.
-
Only one because the root node defines the top node in a business object's structure and serves as a representation of the business object.
Question 167
Question
Which default function key executes the data preview of your CDS view?
Question 168
Question
Which statements about behavior projections are correct?
There are 2 correct answers to this question.
Answer
-
They allow you to define new cardinalities between the entities of our business object.
-
They specify the service type that is used for the business service.
-
They specify whether a create-enabled association is used.
-
They define that all associations are deprecated.
-
They specify which standard operations are used (create, update, delete).
Question 169
Question
For what purpose can you use CDS metadata extensions?
Answer
-
You can define authorization for CDS views.
-
You can define which entities are published in a Web API.
-
You can define metadata information that can be used in the user interface.
-
You can define metadata information that can be used for automated testing.
Question 170
Question
How can you start the SAP Fiori Elements preview?
There are 2 correct answers to this question.
Answer
-
By clicking on the preview button.
-
By double-clicking on an entity in the Entity and Association window.
-
By starting the preview wizard from the view menu.
-
By clicking on the link 'service URL'.
-
By pressing F1.
Question 171
Question
Which entities from the data model are referenced in the service definition?
Answer
-
Metadata extensions
-
Behavior definitions
-
Database tables
-
Projection views
Question 172
Question
For which methods does the service consumption model provide sample code?
Question 173
Question
Which protocols can you use today for service consumption models?
There are 2 correct answers to this question.
Question 174
Question
How do you implement a custom entity query?
Question 175
Question
Which interface has to be implemented by the custom query?
Answer
-
IF_RAP_CST_QUERY
-
IF_RAP_QUERY_ACCESS
-
IF_RAP_QUERY_PROVIDER
-
IF_OO_ADT_CLASS_RUN
Question 176
Question
Which method is part of the interface if_rap_query_provider?
Answer
-
READ_SINGLE
-
CREATE
-
SELECT
-
UPDATE
Question 177
Question
What happens if the filter statement cannot be converted into a range statement and the method io_request->get_filter()->get_as_ranges() is called?"
Answer
-
An empty dataset is returned.
-
An exception is thrown that can be caught.
-
The filtering is ignored.
-
A dump occurs.
Question 178
Question
How do you create aliases for a field, in a custom entity?
Answer
-
By annotating the field with @CustomEntity.alias:<your_name>.
-
By using the keyword as.
-
By using the keyword alias names in our custom entity.
-
You cannot create aliases for field names in custom entities.
Question 179
Question
What is the name of the public method you use from the implementation of your custom query?
Answer
-
get_agency
-
get_public_data-agencies
-
get_agencies
-
get_agencies_data
Question 180
Question
How do you define an alias for the technical name of a custom entity?
Answer
-
By running refactoring on the service definition.
-
Aliases cannot be set for a custom entity in the service definition.
-
Right-click on the custom entity and choose Add Alias.
-
By adding an alias for the custom entity in the service definition.
Question 181
Question
Which binding type should you choose when you create a Web API?
Answer
-
OData V2 – UI
-
OData V2 - Web Service
-
SOAP - Web API
-
OData V2 - Web API
Question 182
Question
Which tool do you use to create the communication scenario in SAP Cloud Platform, ABAP Environment?
Question 183
Question
When do you need the dictionary log?
Answer
-
To analyze errors that occurred during the processing of OData calls.
-
If you want to analyze the annotations used in your application.
-
To understand the OData network calls and their responses.
-
Whenever an activation of one or more CDS views fails and an investigation is required.
Question 184
Question
What can you use in the ABAP Development Tools for CDS troubleshooting?
There are 2 correct answers to this question.
Question 185
Question
How do you enable draft handling for a business object?
Answer
-
By using the keyword 'use draft' in the CDS view.
-
By using the keyword 'enable draft' in the CDS behavior projection.
-
By using the keyword 'draft enabled' in the CDS behavior projection.
-
By using the keyword 'with draft' in the CDS behavior definition.