test_dev_luglio

In the calculation view, what are the different types of input mapping available in Table Functions? Note 2 correct answers. Data Source. Constant. Formula. Variable.

You use APPLY_FILTER to add a dynamic WHERE clause on SELECT statements. On which objects ca you apply the filter? Note 2 correct answers. Table variables. Database Tables. Virtuale Tables. Scalar Variables.

What are the issue categories that SQLScript Code Analyzer scan for ? Note 3 correct answers. Security. Performance. Consistency. Business Logic. Privileges.

You want to exclusively use declarative logic in a SQLScript procedure. Which of the following can you use? Note 2 correct answers. TABLE variables. MAP_REDUCE function. IF Condition. COMMIT statement.

What statement must you insert in the following OData service to complete the navigation definition from the customer entity set to the corresponding sales orders?. Key specification. Aggregation. Association. Join condition.

What is the package.json package descriptor user for? Note 2 correct answers. To list the package dependencies. To define the routes. To set the application router version. To define back-end destinations.

What are the disadvantages when deploying dynamic SQL? Note 2 correct answers. Limited opportunities for optimization. No possibility to bind the result to a SQLScript variable. No possibility to use the SQLScript variables. Additional SQL execution privileges and required.

Which SAP HANA extended application services, advanced model (XSA application) tools can you use to retrieve the URL for the SAP Web Ide for SAP HANA. Note 2 correct answers. XSA application command-line client tool. SAP HANA Runtime Tool (HRTT). XSA Controller start screen. Organization and Space MAnagement Tool.

which of the following are characteristics of sap hana calculation views? Note 2 correct answers. Need database tables to execute. Do NOT need an application server to execute. Do NOT need database tables to execute. Need an application server to execute.

You need to synchronize all unsynchronized changes in your local Git branch to a remote Git branch. Which operation do you use ?. Push. Pull. Rebase. Reset.

Which application runtimes are currently supported by the sap cloud application programming model? Note: 2 correct answers. Node.js. Java. Python. Go.

You created several database tables in a multi-target application and need to keep their names as short as possible. Witch parameter of the .hdnamespace file do you set to ignore?. subfolder. name. hdbtable. mixinTypes.

You need to check user input data in your Odata request. Which exit type do you use?. Validation. Consistency. Modification. Verificatin.

A user is dropped with the "Cascade" option. The user schema contains ojects owned by other users, on which other users have privileges. What happens to the objects? Note: 2 correct anwers. The objects on which other users have privileges are dropped. The objects owned by other users are dropped. The objects on which other users have privileges are NOT dropped. The objects owned by other users are NOT dropped.

Which functionality is provided by the SAP Web IDE for SAP HANA? Note 2 correct anwers. Build and deploy applications. Syntax-aware editors for code. User Management. Organization and Space Management.

You need to initially load data from a CSV file into a Core Data Services table in Sap HANA extended application services, advanced model (XSA applicaiton). Which file tipe do you create?. A file with extension .hdbdd. A file with extension .hdbtextbundle. A file with extension .hdbdtable. A file with extension .hdbtabedata.

Which of the following SQLScript elements do you use to transform a set of arrays into an intermediate table variable?. unrest. array. unset. set.

You are a consultant assigend to a project implementing XSA. Your client has identifed who their XSA administrators will be and asks you for clarification on which specific actions their adminstrator will be able to perform using the "User Managemet" application.Which actions will they be able to perform? Note: 3 correct anwers. Create a new role collection. Assign role collection. Create new user. Migrate a Hana user. Delete role collections.

Which keyword do you use to define an OData association ? Note: 3 correct anwers. multiplicity. dependent. principal. join. union.

How do you specify the target currency for currency conversion in calculation views? Note: there are 3 correct answers to this question. In a column. In a table function. With an input parameter. With a fixed value. In a procedure.

You configure an odata service for a transactional SAPUI5 application. What is the default data access behavior of the Odata Service?. Read: YES CREATE: NO UPDATE: NO DELETE: NO. Read: YES CREATE: YES UPDATE: YES DELETE: NO. Read: YES CREATE: NO UPDATE: YES DELETE: NO. Read: YES CREATE: YES UPDATE: YES DELETE: YES.

You have built a Node.js service and need to make it available so that it can be consumed by an SAPUI5 application. In which section of the YAML file do you define the variable for the exposed Node.js service?. In the requires section of the HTML5 module. In the path section of the Node.js module. In the provides section of the Node.js module. In the properties section of the MTA resources.

After reviewing the SQL Analyzer results, which of the following would you consider for optimizing the performance? Note 2 correct Answers. Add SQL hints. Change the data model. Use CE functions. Re-priorize with workload management.

You implement a native SAP HANA application using SAP HANA extended application services, advanced model(XSA application) and SAPUI5. Where is the rendering executed?. On the front-end client device. On the XSA Application Server. On the XSA Application Router. On the SAP Fiori front-end server.

Which rules apply to declarative logic in SQLScript ? Note 2 correct answers. It is free of side effects. It declares the intent of a request. It supports the full set of SQLscript. It defines how data is processed.

Wich configuration file determines the program that is executed upon startup when you run the Node.js module?. server.js. project.json. package.json. mta.yaml.

In a sqlscript procedure, which feature do you use to initialize IN/OUT table parameters?. DEFAULT_EMPTY. SET. IS_EMPTY. DEFAULT.

What are the sTePs to debug a Node.js application using the SAP WEB Ide for SAP HANA ? Note 3 correct Answers. Open the debugger. Attach the debugger to the node module. Set a break point in the application. Specify the proper Git Repository in the debug properties. Built the application with the debug option.

From which tool can you run the XSA command line ?. SAP Web IDE for SAP HANA. SAP HANA Cockpit. SAP HANA Studio. Local Operation system shell.

Which services can you use in SAP HANA, express edition ? Note 3 correct Answers. Text analytics. Columnar OLTP and OLAP. Multi-core and parallelization. Dynamic Tiering. System replication.

What do you use to set up unit testing for your SQLScript procedure ?. A library with language SQLSCRIPT TEST. The SQLscript debugger. The SQLscript Code analyzer. SQLscript logging procedures.

Which of the following can be referenced in a xs-security.json configuration file? Nore 2 Correct answers. Scope. Role templates. Routes. Modules.

You created an HDI database role using the SAP Web IDE for SAP HANA and deployed your project. Afterward, you made some modifications to the runtime role. What happens when you change and rebuild the design-time role?. The runtime modifications are overwritten. The runtime modifications are kept. You need to confirm the runtime modifications. The deployment of roles fails.

How do you debug a Node.js module in SAP Web IDE for SAP HANA?. Attach the debugger to the application in the SAP Web IDE for SAP HANA. Add the sap.hana.xs.debugger::Debugger role to the HDI container's RT user. Set the enabled parameter to true in the section debugger of the xsengine.ini file. Start the debugger from the XSA command-line interface and run the program in the SAP Web IDE for SAP HANA.

Which parameter do you adapt to change the file that functions are an entry point for an HTML5 module?. WelcomeFile parameter of the xs-app.json file. Service_url parameter of the mta.yaml file. Runners parameter of the project.json file. Start parmeter of the xs-app.json file.

You developed a multi-target application that contains only a database module. Which environment are the runtime object created in?. SAP HANA Deployment infrastructure container. SAP HANA Runtime Tool (HRTT). Java Runtime Enviroment (JRE). SAP Web IDE for SAP HANA.

Who owns the database objects created in an SAP HANA Deployment Infrastructure (HDI) container?. The generated, container-specific technical user. The database user with the generated database role, suffix'::access_role. The database user with the generated database role, suffix'::external_privilege_role. The SAP HANA extended application services, advanced model (XSA Application) user who deployed the CDS model.

Which parameters does the APPLY_FILTER function support? Note 2 correct answers. Table variables. Filter Variable. Join condition. Entity set.

A Node.js module is excuted for the first time in SAP HANA extended application services, advanced model (XSA application). Which of the following activities are performed automatically? Note 2 correct answers. The required modules are downloaded based on module dependencies. A new service is executed on the application server. A new SAP HANA Deplyment Infrastructure (HDI) container is created. The module is deployed to the front end.

Which of the following information must you specify when you create a new project in the SAP Web IDE for SAP HANA ? 2 correct answers. The project name. Which template the project is based on. The SAP HANA database version. The project namespace.

Your multi-target application will use XSJS. Which module type do you create in your application project?. Node.js. SAP HANA database. HTML5. JAVA.

Which Odata capabilities are supported in SAP HANA extended application services, advanced Model. Note 3 correct answer. Projection. Union. Join. Aggrecation. Association.

Which new components ca you use to develop native SAP HANA application in SAP HANA extended application services, advanced mode (XSA application)? 2 answer correct. SAP HANA studio. SAP Web IDE for SAP HANA. Git Repository. SAP HANA repository.

Which of following element can be part of the UI5 application's index.html file? 2 correct answers. Bootstrap. Backend connection. framework reference. UI-area.

You need to create a native SAP Hana application that fully leverages the SAP HANA platform. How do you implement data-intensive calculations. Distribuite calculations between application layer and presentation layer. Push as many data-intensive computations as possible to database layer. Push the calculation onto the presentation layer. Push the calculation onto the application layer.

Which Git commands are available with the SAP Web IDE for SAP HANA ? 3 correct Answer. Push Code. Test Changes. Clone a repository. Merge changes. Redeploy the code.

What are the key characteristics of the calculation view's input parameter? 3 answer correct. it can be used to pass values to table function. it is passed using a WHERE clause. it is passed via reserved word PLACEHOLDER. it is can be used in a conditional expression. it CANNOT be used to filler meansure values.

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? 2 answer correct. Deploy HTML5 modules to the SAP HANA database. Deploy node.js modules to the SAP HANA database. Configure the artifact namespaces. Choose the supported SAP HANA Version.

Which element can you specify with the SAP web ide for sap hana graphical editor for data services data model? (3 answer correct). Context. Synonym. Entity. Procedure. Association.

You define exception handling in a sql script procedure? What can you use to declare exit handlers? (2 answer). Specific SQL error code. Generic SQL Error. Specific SQL condition. Generic SQL condiction.

An OData service contain an entity set called Products.Which resource path do you add to the Odata service URL to view all available products?. /product/ALL. /product/$metadata. /products. /products/*.

Which artifacts do you define in the persistence model to access objects in an external SAP HANA Deployment Infrastracture container?. Views. Imports. Procedures. Synonyms.

Which activities do you perform on in application in the XSA cockpit? (2 answer). Monitor applications assigned to current space. Display HDI container content. Deploy application to SAP Cloud platform. Start, Stop and restart application.

What are the main SAP HANA engines responsible for executing calculation views? (3 answer). Java Engine. XS Engine. OLAP Engine. Join Engine. Calculation Engine.

You create a multi-target application in SAP Web IDE for SAP HANA. Which source code management option do you use?. SVC-based repository. SAP HANA repository workspace. SAP HANA repository. GIT-based repository.

What happens if you define a database object in the persistence model and deploy it using the SAP HANA Deployment Infrastructure (HDI)?. The corresponding runtime object is created in the HDI conteiner on deployment. The corrsponding runtime object is created in the database module of the multi-target application during runtime. The HDI containter is created when the desing-time object is saved. A descriptive representetion of the object is created in HDI during runtime.

Which of the following joins can be defined only with multi-column join in calculation views ?. Dynamic Join. Text Join. Multi Join. Temporal join.

You create a simple data model to store user information. The model contains two tables: one for user information, and the other for user address details. The user can have one address. You also need a view to show the user's complete information including the address. Which actions do you perform if you use CDS artifacts only?. - Create two entities for the user and address - Create an association from the user entity to the address entity - Define a UserDetail view using select on the user entity and using association to read the address information. - Create two entities for the user and address - Extended the user entity with address coloums - Create a view named UserDetail using Select on the user entity. - Create two entities for the user and address - Create an association from the user entity to the address entity - Define a UserDetail 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 a UserDetail calculation view and join the user and address information.

What key words are contained in the application descriptor file (xs-app.json)? (2 answer). role-templetes. routes. tenant-mode. authenticationMethod.

Which odata service do you use to prevent change to existing line items of the sap.test::myTable table?. Service{“sap.test::mytable” update forbidden}. Service{“sap.test::mytable” update no-authorization}. Service{“sap.test::mytable” update prohibiten}. Service{“sap.test::mytable” update exclude}.

You create a SAP HANA extended application services, advanced model (XSA application) multi-target application. What does the mta.yaml file contain?. The plugin name and version for every supported file suffix. The node.js package definition with dependencies and initial run configuration. The application router description with the authentication methods and access routes. The application global elements, modules, resources, properties, and parameters.

Which join type is not supported by join optimization?. Inner Join. Text Join. Outer Join. Referential Join.

You need to combine data from different database tables with your OData service.Which capability do you use for this relationshop?. Associations. Aggregations. Projections. Entity sets.

Which Git command do you use to consolidate all changes from one branch with another branch using a single commit ?. Merge. Rebase. Push. Commit.

What are different types of graphical calculation views that can handle measures? (2 answer). Attribute. Cube. SQL access only. Cube with star join.

You are asked to produce sales value for the month using sales order items (sale price per item x quantity sold). What do you use to achieve this in a calculated column of a calculation view? (2 answer). Non-equi join. Temporal Join. Transparent Filter. Keep Flag.

In which of the following objects can you use Commit and Rollback statements?. Scripted calculation View. Table user-defined Function. Scalar user-defined Function. SQLscript procedure.

Of the following SAP HANA System views, which contain fields providing information about the artifact ownership? (2 answer). OBJECT. ROLES. SCHEMAS. SYNONYNS.

In Node.js, which file do you use to define external module dependencies ?. mta.yaml. server.js. pom.xml. package.json.

Which of the following activities are part of the development lifecycle using SAP HANA extended application services, advanced model (XSA application) ? (2 answer). Create a MTA project. Export the project as an MTA archive. Store the source in SAP HANA repository. Activate artifact via _SYS_REPO.

You are working on en entity using Core Data Services. Which properties can you define in the techinical configuration section? 2 correct answers. Import. Association. Index. Storage type.

To perform a specific task of an XSA application, what does the user need?. To have directly assigned a Role Collection. To have directly assigned a Scope. To be assigned to an Organization. To be assigned to a Space.

Which OData capability do you use when you need to restrict the number the number or selection of exposed columns?. Property Projection. Key specification. Aggregation. Parameter entity sets.

You are desinging an OData service in an XSOODATA file. For what reason whould you desing association?. To enforce database-level constraints. To denote a set of properties forming a unique key. to set relationship between multiple contexts. to reference two exposed entities.

You need to install SAP HANA, express edition to develop a native SAP HANA application.Which of the following deployment options do you have? 2 correct answers. Usage of virtual machine on Microsoft Windows. Installation on Linux OS. Installation on Mac OS. Installation on Windows Server.

What are the user-defined functions supported by SAP HANA? 2 correct answers. Table. Scalar. Aggregate. Hierarchy.

Which metadata declarations can you specify in a SQLScript procedure when you use the SAP HANA Deployment Infrastructure? 2 correct answers. Language. Security. Default schema. Authorization.

Which Node.js module do you use to run SQL statement against the SAP HANA database?. @sap/xssec. @sap/hdbext. @sap/hdi. @sap/sapxsenv.

What are the characteristics of a calculation view of type “SQL Access Only”? 2 correct answers. Can be directly accessed via SQL. Can be directly used as modeled data source for another view. Can be directly exposed to all client tools. Can be directly used for multidimension analysis.

You need to view the data model exposed by an OData V2 service. What must you append to the service URL?. $schema. $servicedefinition. $format. $metadata.