Which activities do you perform on an application in the SAP HANA XS Advanced Cockpit? There are 2 correct answers to this question.
Monitor applications assigned to the current space.
Deploy applications to SAP Cloud Platform.
Display HDI container content.
Start, stop, and restart applications.
The SAP HANA XS Advanced Cockpit is a web-based administration tool that allows you to manage the XS Advanced runtime environment, such as organizations, spaces, applications, services, and users. The XS Advanced Cockpit provides a graphical user interface that is similar to the SAP Cloud Platform Cockpit, to provide a consistent user experience in cloud and on-premise. The XS Advanced Cockpit is available for SAP HANA 2.0 SPS03 and later releases, and it replaces the deprecated XS Advanced Administration Tools.
One of the activities that you can perform on an application in the XS Advanced Cockpit is to monitor the applications assigned to the current space. A space is a logical grouping of applications and services that share a common development and runtime environment. Each space belongs to an organization, which is a collection of users and spaces that share a common quota of resources. You can use the XS Advanced Cockpit to view the list of applications deployed in a particular space, and see their status, instances, memory usage, disk usage, and bound services. You can also filter, sort, and search the applications by name, status, or type. You can also drill down into the details of each application, such as logs, events, environment variables, routes, and service bindings.
Another activity that you can perform on an application in the XS Advanced Cockpit is to start, stop, and restart the applications. You can use the XS Advanced Cockpit to control the lifecycle of the applications deployed in a space, such as starting an application that is stopped, stopping an application that is running, or restarting an application that is experiencing issues. You can also scale the applications by changing the number of instances or the memory and disk quota allocated to each instance. You can also delete the applications that are no longer needed.
The other options are incorrect because they are not activities that you can perform on an application in the XS Advanced Cockpit. You cannot deploy applications to SAP Cloud Platform from the XS Advanced Cockpit, as the XS Advanced Cockpit is only for managing the XS Advanced runtime environment on SAP HANA. To deploy applications to SAP Cloud Platform, you need to use the SAP Cloud Platform Cockpit or the Cloud Foundry Command Line Interface (CF CLI). You also cannot display the HDI container content from the XS Advanced Cockpit, as the HDI container is a database object that is not directly related to the application. To display the HDI container content, you need to use the SAP HANA Database Explorer or the SAP Web IDE for SAP HANA. References:
Which parameters does the APPLY_FILTER function support? There are 2 correct answers to this question.
Filter condition
Join condition
Entity set
Table variable
The APPLY_FILTER function is a SQLScript function that applies a filter condition to a table variable and returns a new table variable with the filtered rows. The APPLY_FILTER function supports the following parameters12:
The other options are not correct because they are not parameters of the APPLY_FILTER function. A join condition is a parameter of the APPLY_FILTER_JOIN function, which applies a filter condition to two table variables and returns a new table variable with the joined and filtered rows. An entity set is a parameter of the APPLY_FILTER_ENTITY function, which applies a filter condition to an entity set and returns a new entity set with the filtered rows. These functions are part of the SAP HANA Predictive Analysis Library (PAL), and they are not part of the SQLScript language3. References:
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.
Index
Import
Storage Type
Association
The Technical Configuration section of a Core Data Services (CDS) entity allows you to define properties that affect the physical storage and performance of the entity in the database. You can define the following properties inside the Technical Configuration section1:
The other two options, Import and Association, are not properties that can be defined inside the Technical Configuration section. Import is a keyword that allows you to import another CDS entity or a database table into the current CDS entity, and use its columns as part of the projection list4. Association is a keyword that allows you to create a relationship between two CDS entities, and use the associated entity’s columns as part of the projection list or the join condition. References: 1: Technical Configuration | SAP Help Portal 2: Index Definition | SAP Help Portal 3: Storage Type | SAP Help Portal 4: Import | SAP Help Portal : [Association | SAP Help Portal]
Your multi-target application will use XSJS. Which module type do you create in your application project? Please choose the correct answer.
Java
SAP HANA database
Node.js
HTML5
To create a multi-target application that will use XSJS, you need to create a Node.js module type in your application project. XSJS is a scripting language that allows you to implement server-side logic and access SAP HANA database features using JavaScript syntax. XSJS is supported by the Node.js runtime of the SAP HANA XS Advanced Model, which provides the necessary libraries and services to execute XSJS code. You can use the SAP Web IDE for SAP HANA to create a Node.js module and add XSJS files to it. The other options are not correct because:
References:
In which of the following objects can you use Commit and Rollback statements? Please choose the correct answer.
Scalar user-defined function
SQL Script procedure
Table user-defined function
Scripted calculation view
You can use Commit and Rollback statements in SQL Script procedures to control the transactional behavior of your code. Commit and Rollback statements allow you to commit or undo the changes made by the SQL statements within the procedure. You can also use them in exception handlers to handle errors and ensure data consistency. You cannot use Commit and Rollback statements in scalar user-defined functions, table user-defined functions, or scripted calculation views, as they are not allowed to have any side effects on the database. References: COMMIT and ROLLBACK, SQLScript Procedures, [SQLScript Functions].
You work on a multi-target application that uses the SAP HANA Deployment Infrastructure (HDI). Which operations can you perform in
the SAP Web IDE for SAP HANA?
There are 2 correct answers to this question.
Create objects in the SAP HANA repository.
Deploy HTML5 modules to the SAP HANA database.
Choose the supported SAP HANA versions.
Configure the artifact namespaces.
The SAP Web IDE for SAP HANA is a web-based development tool that allows you to create and manage multi-target applications (MTAs) that use the SAP HANA Deployment Infrastructure (HDI). HDI is a service layer that enables you to deploy database development artifacts to HDI containers, which are isolated schemas that represent runtime objects. Some of the operations that you can perform in the SAP Web IDE for SAP HANA are:
The following operations are not possible or not recommended in the SAP Web IDE for SAP HANA:
References:
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 defines how data is processed.
It is free of side effects.
lt declares the flow of data.
According to the SAP HANA Developer Guide, declarative logic in SQL Script is a way of expressing complex data transformations by means of classical relational operators, such as selection, projection, join, aggregation, etc. Declarative logic does not specify how data is processed, but rather what the desired result is. The SAP HANA database has the freedom to optimize the data flow and execution plan, which may result in better performance. Declarative logic is free of side effects, meaning that it does not modify any data or state outside the scope of the statement. Declarative logic declares the flow of data, meaning that it binds new variables that are referenced elsewhere in the body of the procedure or function. The other options are incorrect, because:
References: SAP HANA Developer Guide, Chapter 6, Section 6.4.2, page 2111.
What key words are contained in the application descriptor file (xs-app.json)? There are 2 correct answers to this question.
routes
role-templates
tenant-mode
authentication Method
The application descriptor file (xs-app.json) is a JSON file that defines the routing and authentication configuration for an HTML5 module in a multi-target application (MTA) project. It is located in the root folder of the HTML5 module and is used by the managed application router to dispatch requests to the appropriate destinations and to authenticate users. Some of the key words that are contained in the xs-app.json file are:
The following key words are not contained in the xs-app.json file, but in other files related to the MTA project:
References:
You develop an OData service using XSODATA. Which HTTP commands can you use to define the operations on the resources? There are 3 correct answers to this question.
DPUT
READ
INSERT
POST
DGET
According to the SAP HANA Developer Guide, XSODATA supports the following HTTP commands to define the operations on the resources:
The READ and INSERT commands are not valid HTTP commands for XSODATA. They are keywords that can be used in the service definition file (.xsodata) to specify the access mode for each entity set. References: SAP HANA Developer Guide, Chapter 6, Section 6.4.2, page 2111
Which of the following elements can be part of the UI5 application's index.html file? There are 2 correct answers to this question
Framework Reference
Bootstrap
Backend Connection
UI-Area
The index.html file is the entry point of the UI5 application. It contains the following elements:
References:
After reviewing the SQL Analyzer results, which of the following would you consider for optimizing the performance? There are 2 correct answers to this question.
Re-prioritize with Workload Management.
Use CE functions.
Modify SQL hints.
Change the data model.
According to the SAP HANA Performance Guide for Developers1, the SQL Analyzer tool can help you understand and analyze the execution plan of a SQL statement, and identify potential bottlenecks and optimizations. Some of the possible optimizations are:
References: 1: SAP HANA Performance Guide for Developers : SAP HANA SQL and System Views Reference : SAP HANA Modeling Guide
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
Aggregation
Key specification
Property projection
Property projection is an OData capability that allows you to restrict the number or selection of exposed columns in an OData service. Property projection is achieved by using the $select query option, which specifies a subset of properties to be included in the response. The $select query option can be applied to a single entity, a collection of entities, or a complex type. Property projection can be used to reduce the payload size and improve the performance of the OData service.
For example, suppose you have an OData service that exposes a Products entity set with the following properties: ID, Name, Category, Price, and Description. If you want to restrict the number or selection of exposed columns to only ID and Name, you can use the $select query option as follows:
GET /Products?$select=ID,Name
The result is:
{ “@odata.context”: “$metadata#Products(ID,Name)”, “value”: [ { “ID”: 1, “Name”: “Laptop” }, { “ID”: 2, “Name”: “Mouse” }, { “ID”: 3, “Name”: “Keyboard” } ] }
The following OData capabilities are not used to restrict the number or selection of exposed columns, but for other purposes:
References:
You implement a native SAP HANA application using SAP HANA extended application services, advanced model (XS advanced) and SAPUI5. Where is the UI rendering executed? Please choose the correct answer.
On the SAPUI5 HTML5 module
On the SAP Fiori front-end server
On the front-end client device
On the XS advanced application server
The UI rendering is executed on the front-end client device, such as a browser or a mobile device, that accesses the SAP HANA application. SAPUI5 is a JavaScript-based UI framework that enables the development of responsive and user-friendly web applications. SAPUI5 applications run in the browser and communicate with the back-end server via RESTful services, such as OData. The SAPUI5 HTML5 module is a component of the multi-target application (MTA) that contains the UI logic and resources, such as views, controllers, models, and libraries. The SAPUI5 HTML5 module is deployed to the XS advanced application server, which serves the static UI files to the front-end client device. The SAP Fiori front-end server is a separate component that provides the SAP Fiori launchpad, a single entry point for SAP Fiori apps, and the SAP Fiori UI components, such as controls, themes, and icons. The SAP Fiori front-end server is not required for SAP HANA native applications, but it can be used to integrate them with other SAP Fiori apps123. References:
Which parameter do you adapt to change the file that is initially delivered by an HTML5 module? Please choose the correct answer.
Service_url parameter of the mta.xml file
Welcome file parameter of the xs-app.json file
Start parameter of the package.json file
Runners parameter of the projectjson file
An HTML5 module is a module that contains static web content, such as HTML, CSS, JavaScript, or images, that are delivered by a web server. An HTML5 module can be part of a multi-target application (MTA) project, which is a single application that consists of multiple modules that are developed using different technologies and designed to run on different target runtime environments. An HTML5 module can be deployed to the XS Advanced runtime environment, which is a platform that supports the development and execution of cloud-native applications on SAP HANA.
To change the file that is initially delivered by an HTML5 module, you need to adapt the welcome file parameter of the xs-app.json file. The xs-app.json file is a configuration file that defines the routing rules and authentication settings for the HTML5 module. The welcome file parameter specifies the name of the file that is served as the default document when the root path of the HTML5 module is requested. For example, if the welcome file parameter is set to “index.html”, then the file index.html in the HTML5 module will be delivered when the user accesses the URL of the HTML5 module without any additional path. The welcome file parameter can be changed to any valid file name that exists in the HTML5 module.
The other options are incorrect because they are not parameters that can be used to change the file that is initially delivered by an HTML5 module. The service_url parameter of the mta.xml file is a parameter that defines the URL of a service that is required by a module or provided by a resource in an MTA project. The start parameter of the package.json file is a parameter that defines the script that is executed when the npm start command is run in a Node.js module. The runners parameter of the project.json file is a parameter that defines the configuration of the runners that are used to execute the code in a Cloud Foundry module. References:
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
According to the SAP HANA Developer Guide, a multi join is a join that can be defined only with multi-column join in calculation views. A multi join allows you to join multiple data sources using multiple join conditions. You can specify the join type, the join cardinality, and the join columns for each pair of data sources. A multi join is useful when you need to join data sources that have complex relationships or different granularities. The other options are incorrect, because:
References: SAP HANA Developer Guide, Chapter 6, Section 6.4.2, page 2111.
What do you use to set up unit testing for your SQL Script procedure? Please choose the correct answer.
SQL Script logging procedures
A library with language SQLSCRIPT TEST
The SQL Script debugger
The SQL Script Code Analyzer
To set up unit testing for your SQL Script procedure, you use a library with language SQLSCRIPT TEST. A library with language SQLSCRIPT TEST is a special type of library that contains SQL Script test cases for testing the behavior and performance of SQL Script procedures. A SQL Script test case is a SQL Script procedure that has the prefix TEST_ and that uses the ASSERT and EXPECT statements to verify the expected results and outputs of the procedure under test. A library with language SQLSCRIPT TEST can be created in the SAP Web IDE for SAP HANA or in the SAP HANA Studio, and can be executed by using the SQL Script Test Framework, which is a tool that runs the test cases and generates a test report.
The following options are not used to set up unit testing for your SQL Script procedure, but for other purposes:
References:
Which SAP HANA system views contain information about the object ownership? There are 2 correct answers to this question.
SCHEMAS
TABLES
OBJECTS
ROLES
The SAP HANA system views that contain information about the object ownership are SCHEMAS and ROLES. The SCHEMAS view provides information about the schemas in the database, including the owner of each schema1. The ROLES view provides information about the roles in the database, including the owner of each role2. The object ownership indicates who has the right to grant or revoke privileges on the object, or to alter or drop the object3.
The other two options, TABLES and OBJECTS, do not contain information about the object ownership. The TABLES view provides information about the tables in the database, but not the owner of each table4. The OBJECTS view provides information about the objects in the database, such as views, procedures, functions, etc., but not the owner of each object5. References: 1: SCHEMAS System View | SAP Help Portal 2: ROLES System View | SAP Help Portal 3: Object Ownership | SAP Help Portal 4: TABLES System View | SAP Help Portal 5: OBJECTS System View | SAP Help Portal
From which tool can you run the XS command line? Please choose the correct answer.
Local operating system shell
SAP HANA studio
SAP WeblDE for SAP HANA
SAP HANA cockpit
The XS command line is a tool that allows you to administer and manage the XS advanced runtime environment and the applications deployed on it. You can run the XS command line from the local operating system shell of your machine, as long as you have installed the XS CLI client package and added the bin folder to the PATH environment variable1. You can also run the XS command line from the SAP HANA system, where the XS advanced runtime is installed, by logging in as user XSA_ADMIN or
The other options, SAP HANA studio, SAP Web IDE for SAP HANA, and SAP HANA cockpit, are not tools that can run the XS command line. SAP HANA studio is an Eclipse-based tool that allows you to develop, model, and administer SAP HANA databases and applications, but it does not support XS advanced features3. SAP Web IDE for SAP HANA is a web-based tool that allows you to develop, test, and deploy SAP HANA applications using XS advanced features, but it does not provide a command line interface4. SAP HANA cockpit is a web-based tool that allows you to monitor and manage SAP HANA databases and applications, but it does not provide a command line interface either5. References: 1: Installing XS CLI Client | SAP Tutorials 2: XS Advanced Administration: Getting The XS CLI | SAP Blogs 3: SAP HANA Studio | SAP Help Portal 4: SAP Web IDE for SAP HANA | SAP Help Portal 5: SAP HANA Cockpit | SAP Help Portal
Which elements can you specify with the SAP WeblDE for SAP HANA graphical editor for Core Data Services data models? There are 3 correct answers to this question.
Entity
Synonym
Procedure
Context
Association
The SAP Web IDE for SAP HANA graphical editor for Core Data Services (CDS) data models allows you to specify the following elements12:
The other options are not correct because they are not elements that can be specified with the SAP Web IDE for SAP HANA graphical editor for CDS data models. A synonym is a database object that provides an alternative name for another database object, such as a table, view, or procedure. A synonym is not a CDS artifact, and it cannot be created or edited with the graphical editor. A procedure is a database object that contains a set of SQL statements that perform a specific task. A procedure can be created or edited with the SQL editor, but not with the graphical editor. A procedure can also be exposed as a CDS artifact, but it cannot be specified with the graphical editor. References:
You need to consume a Node.js service in an SAPUI5 application. In which section of the mta.xml file do you define the variable for the
exposed service?
Please choose the correct answer.
In the path section of the Node.js module
In the provides section of the Node.js module
In the properties sect on of the MTA resources
In the requires sect on of the HTML5 module
To consume a Node.js service in an SAPUI5 application, you need to define the variable for the exposed service in the requires section of the HTML5 module in the mta.xml file. This way, you can specify the dependency of the SAPUI5 application on the Node.js service and bind them together. The requires section allows you to reference a resource or a module that provides a service or a capability that your module needs. You can also define additional properties and parameters for the required element, such as the name of the variable that holds the service URL. References: The MTA Development Descriptor, The MTA Deployment Descriptor, Developing Multi-Target Applications
Which of the following can be used when implementing transaction management logic in SQLScript using savepoints? Note: There are 3 correct answers to this question.
Release savepoint
Rollback to savepoint
Savepoint
Reverse savepoint
Alter system savepoint
According to the SAP HANA SQLScript Reference, the following statements can be used when implementing transaction management logic in SQLScript using savepoints:
The other options are incorrect, because:
References: SAP HANA SQLScript Reference, Chapter 6, Section 6.4.2, page 2111.
Which SAP HANA extended application services, advanced model (XS advanced) tools can you use to retrieve the URL for the SAP
WeblDE for SAP HANA?
There are 2 correct answers to this question.
Runtime tool
XS advanced Controller Start Screen
XS Advanced command-line client tool
Organization and Space Management tool
The SAP Web IDE for SAP HANA is a web-based development tool that allows you to create and manage multi-target applications (MTAs) that use the SAP HANA Deployment Infrastructure (HDI). The SAP Web IDE for SAP HANA is itself an XS advanced application that runs on the XS advanced runtime and can be accessed via a URL. To retrieve the URL for the SAP Web IDE for SAP HANA, you can use the following XS advanced tools:
The following tools are not used to retrieve the URL for the SAP Web IDE for SAP HANA, but for other purposes:
References:
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";)
Aggregation
Association
Key specification
Join condition
To complete the navigation definition from the customer entity set to the corresponding sales orders, you need to insert an association statement between the two entity sets. An association defines a relationship between two entity sets based on a referential constraint, which specifies the foreign key and the principal key properties that link the entity sets. An association also defines the cardinality and the role names of the entity sets involved in the relationship1. In this case, the association statement should look something like this:
association Customer_Orders with referential constraint principal customer key CustomerID dependent Orders key CustomerID multiplicity “1” to “*”;
This statement defines an association named Customer_Orders that relates the customer entity set with the Orders entity set based on the CustomerID property. The principal role is assigned to the customer entity set, which means that each customer entity can have zero or more related Orders entities. The dependent role is assigned to the Orders entity set, which means that each Orders entity must have exactly one related customer entity2.
The other options are not correct because:
References: 1: OData Service Definition Language Syntax (XS Advanced) 2: OData Service-Definition Examples 3: Creating Calculation Views 4: SQL Reference Manual
You need to initially load data from a .csv file into a Core Data Services table in SAP HANA extended application services, advanced model (XS advanced). Which file type do you create? Please choose the correct answer.
A file with extension .hdbtable data
A fie with extension .hdbtable
A file with extension .hdbdd
A file with extension .hdbti
To initially load data from a .csv file into a Core Data Services (CDS) table in SAP HANA extended application services, advanced model (XS advanced), you need to create a file with extension .hdbti, which stands for HDB Table Import. This file defines the configuration and mapping for importing data from a local or remote file into a table in the HDI container. You can specify the source file name, location, format, delimiter, header, encoding, etc., as well as the target table name, schema, and column mapping. You can also specify whether to truncate the target table before importing, or to append the data to the existing table. You can use the SAP Web IDE for SAP HANA to create and deploy the .hdbti file, or use the HDI deployer CLI tool. The other options are incorrect because they are not the correct file types for importing data into a CDS table. A file with extension .hdbtabledata is a file that contains the data for a table in a JSON format, but it is not used for importing data from a .csv file. A file with extension .hdbtable is a file that defines the structure and properties of a table, but it does not contain any data. A file with extension .hdbdd is a file that defines the CDS entities, such as contexts, types, views, associations, etc., but it does not import any data. References:
Which Git commands are available with the SAP Web IDE for SAP HANA? There are 3 correct answers to this question.
Test changes
Push code
Clone a repository
Redeploy the code
Merge changes
When you create a new project in SAP Web IDE for SAP HANA, you must specify the project name and the template. The project name is a unique identifier for your project that is used to create the folder structure and the deployment descriptor file (mta.yaml) for your project. The template is a predefined set of files and configurations that provide the basic structure and functionality for your project. You can choose from various templates, such as SAP HANA Database Project, SAP Cloud Platform Business Application, SAP Fiori Freestyle Project, and more, depending on your development scenario and requirements.
The following information is not required or not applicable when you create a new project in SAP Web IDE for SAP HANA:
References:
TESTED 20 Apr 2024