In an SQL Script procedure, which feature do you use to initialize IN/OUT table parameters?
Please choose the correct answer. SET DEFAULT EMPTY DEFAULT IS_EMPTY. Which rules apply to declarative logic in SQL Script?
There are 2 correct answers to this question. It supports the full set of SQL Script. It is free of side effects. It declares the flow of data. It defines how data is processed. You need to synchronize all unsynchronized changes of the remote Git branch with a local Git
branch.
Which operation do you use?
Please choose the correct answer. Reset Push Pull Rebase. Which of the following activities are part of the development lifecycle using SAP HANA
extended application services, advanced model (XS advanced)?
There are 2 correct answers to this question. Store the source in the SAP HANA repository. Activate artifacts via _SYS_REPO. Create an MTA project. Export the project as an MTA archive. You implement an asynchronous Node.js service that sends requests to the database. How do
you handle the database responses?
There are 2 correct answers to this question. Register a callback method for every sent request. Process the callback methods in the order in which the requests are returned from the database. Call a method directly after every send request. Process the callback methods in the order in which the requests are sent by the service. What are the nodes where filter expressions can be used in a calculation view?
There are 2 correct answers to this question. Union Aggregation Star join Rank. Which functionality is provided by SAP WebIDE for SAP HANA?
There are 2 correct answers to this question. Build and deploy applications Organization and space management User management Syntax-aware editors for code. What do you use to set up unit testing for your SQL Script procedure?
Please choose the correct answer. SQL Script logging procedures The SQL Script debugger The SQL Script Code Analyzer A library with language SQLSCRIPT TEST. Which elements can you specify with the SAP WebIDE for SAP HANA graphical editor for Core
Data Services data models?
There are 3 correct answers to this question. Synonym Entity Association Context Procedure. You use APPLY_FILTER to add a dynamic WHERE clause on SELECT statements. On which objects can you apply the filter?
There are 2 correct answers to this question. Database tables Intermediate table variables Scalar variables Virtual tables. You developed a multi-target application that contains only a database module. Which
environment are the runtime objects created in?
Please choose the correct answer. HANA Deployment Infrastructure Container SAP Web IDE for SAP HANA SAP HANA Runtime Tools (HRTT) Java Runtime Environment (JRE). Which tool do you use to create a calculation view in a multi-target application?
Please choose the correct answer. SAP HANA Web-based Development Workbench SAP HANA studio SAP HANA database explorer SAP Web IDE for SAP HANA. Which Node.js module do you use to run an SQL statement against the SAP HANA database?
Please choose the correct answer. @sap/hdbext @sap/hdi @sap/xsenv @sap/xssec. What do you reference in a role template?
Please choose the correct answer. Role Collections Routes Scopes Roles. You develop a Node.js application for the SAP HANA platform that executes a SQL statement
in the SAP HANA database. Which modules do you use?
There are 2 correct answers to this question. @sap/instance-manager @sap/node-vsi @sap/xsenv @sap/hdbext. How do you debug a Node.js module in SAP Web IDE for SAP HANA?
Please choose the correct answer. Add the sap.hana .xs.debugger::Debugger role to the HDI Container's #RT User. Attach the debugger to the application in the SAP Web IDE for SAP HANA. Set the enabled parameter to true in the section debugger of the xsengine.ini file. Start the debugger from the XS command line interface and run the program in SAP Web IDE for
SAP HANA. Which of the following joins can be defined only with multi-column join in calculation views?
Please choose the correct answer. Dynamic join Text join Temporal join Multi join. Which join type is NOT supported by join optimization (pruning)?
Please choose the correct answer. Referential Join Text Join Outer Join Inner Join. Which SAP HANA system views contain information about the object ownership?
There are 2 correct answers to this question. ROLES TABLES OBJECTS SCHEMAS. Which keywords do you use to define an OData association?
There are 3 correct answers to this question. MULTIPLICITY UNION DEPENDENT PRINCIPAL JOIN. You want to exclusively use declarative logic in an SQL Script procedure. Which of the
following operators can you use?
There are 2 correct answers to this question. IF condition MAP_REDUCE function COMM IT statement TABLE variable. Which activities do you perform on an application in the SAP HANA XS Advanced Cockpit?
There are 2 correct answers to this question. Display HDI container content. Deploy applications to SAP Cloud Platform. Start, stop, and restart applications. Monitor applications assigned to the current space. You are working on an entity using Core Data Services. Which properties can you define
inside the Technical Configuration section?
There are 2 correct answers to this question. Association Import Index Storage Type. Which of the following SQL Script elements do you use to transform a set of arrays into an
intermediate table variable?
Please choose the correct answer. ARRAY UNNEST UNSET SET. Which services can you use in SAP HANA, express edition?
There are 3 correct answers to this question. Dynamic tiering Columnar OLTP and OLAP Text analytics System replication Multi-core and parallelization. What are the different types of graphical calculation views that can handle measures?
There are 2 correct answers to this question. SQL Access Only Cube with star join Dimension Cube. What are the key characteristics of the calculation view's Input Parameter?
There are 3 correct answers to this question. It can NOT be used to filter measure values. It is passed via reserved word PLACEHOLDER. It can be used in a conditional expression. It can be used to pass values to table functions. It is passed using a WHERE clause. Which of the following information must you specify when you create a new project in SAP
Web IDE for SAP HANA?
There are 2 correct answers to this question. Project name SAP HANA database version Template Namespace. Which configuration file indicates the program that is executed upon start up when you run
the Node.js module?
Please choose the correct answer. server.js package.json mta.yaml project.json. You need to manage an exception in a SQLScript. Which SQLScript features can you use?
There are 2 correct answers to this question. SIGNAL DEFINE RESIGNAL CREATE EXIT HANDLER DECLARE EXIT HANDLER. You are asked to produce sales value for the month using sales order line items (sales price
per item x quantity sold) what do you use to achieve this in a calculated column of a calculation view
?
There are 2 correct answers to this question. Keep flag Transparent filter Dynamic join Non-equijoin. To perform a specific task of an XS advanced application, what does a user need?
Please choose the correct answer. To be assigned to a Space To have directly assigned a Scope To have directly assigned a Role Collection To be assigned to an Organization. Which OData capacity do you use when you need to restrict the number or selection of
exposed columns?
Please choose the correct answer. Parameter entity sets Key specification Property projection Aggregation. A user is dropped with the "cascade" option. The user schema also contains objects owned by
other users, or on which other users have privileges. What happens to the objects?
There are 2 correct answers to this question.
Note: Answers to this question are not verified by our experts, please study yourself and select the
appropriate answers. The objects owned by other users are dropped. The objects owned by other users are NOT dropped. The objects on which other users have privileges are NOT dropped. The objects on which other users have privileges are dropped. You create a simple data model to store user information. The model contains two tables:
one for the user information, and the other for user address details.
The user can only have one address. You also need a view to show the complete information of the
user including the address.
Which actions do you perform if you use CDS artifacts only?
Please choose the correct answer. Create two entities for the user and address.
Create a User Details calculation view and join the user and address information. Create two entities for the user and address.
Create an association in the user entity to the address entity.
Define a User Details view using select on the address entity and using the association to read the
user information. Create two entities for the user and address.
Create an association in the user entity to the address entity.
Define a User Details view using select on the user entity and using the association to read the
address information. Create two entities for the user and address.
Extend the user entity with address columns.
Create a view named User Details using select on the user entity. You need to install SAP HANA 2.0, express edition to develop a native SAP HANA application.
Which of the following deployment options do you have?
There are 2 correct answers to this question. Installation on Mac OS Installation on Windows Server Installation on Linux OS Usage of virtual machine on Microsoft Windows. Which of the following are characteristics of SAPUI5?
There are 3 correct answers to this question. Provides a device-specific user experience Enables responsive application design Supports customer-specific theming Renders the UI on the server side Provides an extensibility concept. You need to access a remote database table object within your HDB module in an MTA
project. In SAP HANA extended application services, advanced model (XS advanced) a user-provided
service was created to access the external schema. The service is already declared in the MTA project
YAML file.
Which activities do you perform?
There are 3 correct answers to this question. Create a view that refers to the table. Create a synonym for the remote table object. Create a synonym that refers to the view. Create a view that refers to a synonym. Create/update the .hdbgrants file providing authorizations for the remote schema. What are the characteristics of the calculation view of type "SQL Access Only"?
There are 2 correct answers to this question. Can be directly used as modelled data source for another view Can be directly used for multidimensional analysis Can be directly exposed to all client tools Can be direct y accessed via SQL. What happens if you define a database object in the persistence model and deploying using
the SAP HANA Deployment Infrastructure (HDI)?
Please choose the correct answer. The corresponding runtime object is created in the database module of the multi-target
application during runtime. A descriptive representation of the object is created in Hot during runtime. The corresponding runtime object is created in the HDI container on deployment The HDI container is created when the design-time object is saved. Who owns the database objects created in an SAP HANA Deployment Infrastructure (HDI)
container?
Please choose the correct answer. The generated, container-specific technical user The SAP HANA extended application services, advanced model (XS advanced) user who deployed
the CDS model The database user with the generated database role, suffix '::access_role' The database user with the generated database role, suffix '::external_privileges_role'. Which SAP HANA extended application services, advanced model (XS advanced) tools can you
use to retrieve the URL for the SAP WebIDE for SAP HANA?
There are 2 correct answers to this question. XS advanced Controller Start Screen Runtime tool Organization and Space Management tool XS Advanced command-line client tool. You create a multi-target application in SAP Web IDE for SAP HANA. Which source code
management option do you use?
Please choose the correct answer. SAP HANA repository workspace SVC-based repository Git-based repository SAP HANA repository. A Node.js module is executed for the first time in SAP HANA extended application services,
advanced model (XS advanced). Which of the following activities are performed automatically?
There are 2 correct answers to this question. A new service is executed on the application server. The required modules are downloaded based on module dependencies. The source code is compiled to create an executable binary file. A new SAP HANA Deployment Infrastructure (HDI) container is created. Which of the following elements can be part of the UI5 application's index.html file?
There are 2 correct answers to this question Backend Connection Bootstrap UI-Area Framework Reference. What are the disadvantages when deploying Dynamic SQL?
There are 2 correct answers to this question. No possibility to bind the result to a SQL Script variable Limited opportunities for optimization Additional SQL execution privileges are required No possibility to use SQL Script variables. What are the main SA P HANA engines responsible for executing calculation views?
There are 3 correct answers to this question. XS Engine Join Engine OLAP Engine Calculation Engine Java Engine. What statement must you insert to the following OData service to complete the navigation
definition from the customer entity set to the corresponding sales orders?
Please choose the correct answer.
service{ "sample.odata::customer" as customer" navigates ("Customer_Orders* as "toOrders);
"sample.odata::salesorder" as "Orders";) Association Join condition Aggregation Key specification. What is the package descriptor package.json used for?
There are 2 correct answers to this question. To set the router version To list the package dependencies To define back-end destinations To define the routes. Your multi-target application will use XSJS. Which module type do you create in your
application project?
Please choose the correct answer. Node.js Java HTML5 SAP HANA database. What are some of the advantages of SQLScript compared to plain SQL queries?
There are 2 correct answers to this question. It enables modular parameterized programing. It contains a well-defined ANSI standard. It retrieves a high data volume from a database. It increases performance by parallel execution of complex SQL statements. You configure an OData service for a transactional SAPUI5 application. What is the default
data access behaviour of the OData service?
Please choose the correct answer. Read: Yes
Create: No
Update: Yes
Delete: No Read: Yes
Create: Yes
Update: Yes
Delete: No Read: Yes
Create: Yes
Update: Yes
Delete: Yes Read: Yes
Create: No
Update: No
Delete: No. What key words are contained in the application descriptor file (xs-app.json)?
There are 2 correct answers to this question. tenant-mode authentication Method role-templates routes. In which of the following objects can you use Commit and Rollback statements?
Please choose the correct answer. Scalar user-defined function Table user-defined function SQL Script procedure Scripted calculation view. What characterizes the Node.js environment?
There are 2 correct answers to this question. It uses a synchronous programming model. It is built on Google's V8 JavaScript engine. It is a client-side design-time environment for JavaScript. It is single-threaded.
