Which of the ff. are characteristics of SAPUI5? Provides an extensibility concept Renders the UI on the server side Enables responsive application design Supports customer-specific theming Provides a device-specific user experience.
You implement an asynchronous Node.js service that sends requests to the database. How do you handle the database responses? Process the callback methods in the order in which the requests are sent by the service Call a method directly after every send request Process the callback methods in the order in which the requests are returned by the database Register a callback method for every sent request.
What are some of the advantages of SQLScript compared to plain SQL Queries It contains a well-defined ANSI standard It enables modular parameterized programming It retrieves a high data volume from a database It increases performance by parallel execution of complex SQL statements.
To which SAP HANA authorisation entities can you grant a role? User Role Privilege Object.
You develop an OData service using XSODATA. Which HTTP commands can you use to define the operations on the resources? READ GET PUT INSERT POST.
Which new components can you use to develop native SAP HANA applications in SAP HANA extended application services, advanced model (XS advanced)? There are 2 correct answers to this question (DOUBLE CHECK) SAP HANA Studio SAP HANA Repository GIT Repository SAP Web IDE for SAP HANA.
You need to access a remote database table object within your HDB module in a Multi-target application 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 Multi-target application project YAML file.
Which activities do you perform?
Note: 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/update the .hdbgrants file providing authorizations for the remote schema. Create a view that refers to a synonym.
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?
Note: There are 2 correct answers to this question. @sap/hdbext @sap/xsenv @sap/instance-manager @sap/node-vsi.
What characterizes the Node.js environment?
Note: There are 2 correct answers to this question. It is a client-side design-time environment for JavaScript. It is built on Google's V8 JavaScript engine. It uses a synchronous programming model. It is single-threaded.
Which tool do you use to create a calculation view in a multi-target application? SAP HANA studio SAP HANA database explorer SAP HANA Web-based Development Workbench SAP Web IDE for SAP HANA.
You need to manage an exception in a SQLScript.
Which SQLScript features can you use?
Note: There are 2 correct answers to this question. DEFINE RESIGNAL CREATE EXIT HANDLER SIGNAL DECLARE EXIT HANDLER.
What do you reference in a role template? Please choose the correct answer Routes Role Role collections Scopes.
You created several database tables in a multi-target application and need to keep their names as short as possible. Which parameter of the .hdinamespace file do you set to ignore?
Please choose the correct answer. mixinTypes name subfolder hdbtable.
You need to check user input data in your OData request. Which exit type do you use? Please choose the correct answer Modification Validation Consistency Verification.
You create an SAP HANA extended application services, advanced model (XS advanced) multi-target application. What does the mta.xml file contain? Please choose the correct answer. The Node.js package definition with dependencies and initial run configurations The application router description with the authentication methods and access routes. The plugin name and version for every supported file suffix The application global elements, modules, resources, properties, and parameters.
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 Choose the supported SAP HANA versions Deploy HTML5 modules to the SAP HANA database Configure the artifact namespaces.
What are the disadvantages when deploying Dynamic SQL? There are 2 correct answers to this question No possibility to use SQL Script variables Limited opportunities for optimization Additional SQL execution privileges are required No possibility to bind the result to a SQL Script variable.
Which Git commands are available with the SAP Web IDE for SAP HANA? There are 3 correct answers to this question. Push code Merge changes Redeploy the code Clone a repository Test changes.
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 .hdbdd A file with extension .hdbti A fie with extension .hdbtable A file with extension .hdbtable data.
How do you debug a Node.js module in SAP Web IDE for SAP HANA? Please choose the correct answer. 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. Start the debugger from the XS command line interface and run the program in SAP Web IDE for SAP HANA. Set the enabled parameter to true in the section debugger of the xsengine.ini file.
Why do you use associations in your persistence model for SAP HANA extended application services, advanced model (XS advanced)? Please choose the correct answer. To define the relationships between contexts and views To enforce database-level constraints To define multiplicity and key of an entity relation To set relationships between multiple contexts.
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. UNNEST SET UNSET ARRAY.
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 Use CE functions Modify SQL hints Change the data model Re-prioritize with Workload Management.
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. Export the project as an MTA archive Store the source in the SAP HANA Repository Activate artifacts via _SYS_REPO Create an MTA project.
Who owns the database objects created in an SAP HANA Deployment Infrastructure (HDI) container? Please choose the correct answer. 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 '::external_privileges_role' The database user with the generated database role, suffix '::access_role' The generated, container-specific technical user.
Which OData service do you use to prevent changes to existing line items of the sap.test :myTable table? Please choose the correct answer. service { "sap.test::myTable" update no-authorization; } service { "sap.test::myTable" update forbidden; ) service { "sap.test::myTable" update prohibited; ) service { "sap.test::myTable" update exclude; ).
How do you specify the target currency for currency conversion in calculation views? There are 3 correct answers to this question. In a table function In a column In a procedure With an input parameter With a fixed value.
What is the package descriptor package.json used for? There are 2 correct answers to this question To define the routes To list the package dependencies To set the router version To define back-end destinations.
Which services can you use in SAP HANA, express edition? There are 3 correct answers to this question Multi-core and parallelization System Replication Columner OLTP and OLAP Text Analytics Dynamic Tiering.
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 Start parameter of the package.json file Welcome file parameter of the xs-app.json file Runners parameter of the project json file.
Which of the following joins can be defined only with multi-column join in calculation views? Please choose the correct answer. Temporal Join Dynamic Join Multi Join Text Join.
In Node.js, which file do you use to define external module dependencies? Please choose the correct answer. package.json mta.yaml server.js pom.xml.
Which elements can you specify with the SAP Web IDE for SAP HANA graphical editor for Core Data Services data models?
There are 3 correct answers to this question. Association Entity Synonym 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 Virtual tables Scalar Variables.
Which Git command do you use to consolidate all changes from one branch with another branch using a single commit? Please choose the correct answer. Rebase Merge Push Commit.
Which OData capacity do you use when you need to restrict the number or selection of exposed columns? Please choose the correct answer. Property Projection Key Specification Aggregation Parameter Entity Sets.
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. A descriptive representation of the object is created in Hot during runtime. The HDI container is created when the design-time object is saved. The corresponding runtime object is created in the database module of the multitarget application during runtime. The corresponding runtime object is created in the HDI container on deployment.
What do you use to set up unit testing for your SQL Script procedure? Please choose the correct answer. A library with language SQLSCRIPT TEST The SQL Script debugger The SQL Script Code Analyzer SQL Script logging procedures.
What are the main SAP HANA engines responsible for executing calculation views? There are 3 correct answers to this question. Java Engine OLAP Engine XS Engine Join Engine Calculation Engine.
You need to create a native SAP HANA application that fully leverages the SAP HANA platform. How do you implement data-intensive calculations? Please choose the correct answer. Push the calculations onto the application layer Push the calculations onto the database layer Distribute calculations between application layer and presentation layer Push the calculations onto the presentation layer.
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 for this question The required modules are downloaded based on module dependencies. A new SAP HANA Deployment Infrastructure (HDI) container is created. The source code is compiled to create an executable binary file. A new service is executed on the application server.
An OData service contains an entity set called Products. Which resource path do you add to the OData service URL to view all available products? /Products /Products/ALL /Products/$metadata /Products/'.
Which SAP HANA system views contain information about the object ownership? There are 2 correct answers to this question. SCHEMAS OBJECTS TABLES ROLES.
Which artifacts do you define in the persistence model to access objects in an external SAP HANA Deployment Infrastructure container? Please choose the correct answer. Synonyms Procedures Imports Views.
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. Rebase Push Reset Pull.
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. Extend the user entity with address columns. Create a view named User Details using select on the user entity. 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. 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.
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 Association Storage Type.
What are the nodes where filter expressions can be used in a calculation view? There are 2 correct answers to this question. STAR Join Aggregation Union Rank.
What are the key characteristics of the calculation view's Input Parameter? There are 3 correct answers to this question. It can be used in a conditional expression. It can NOT be used to filter measure values. It is passed via reserved word PLACEHOLDER. It is passed using a WHERE clause. It can be used to pass values to table functions.
Which join type is NOT supported by join optimization (pruning)? Please choose the correct answer. Referential Join Inner Join Outer Join Text Join.
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. The objects on which other users have privileges are NOT dropped The objects on which other users have privileges are dropped. The objects owned by other users are NOT dropped. The objects owned by other users are dropped.
Which application runtimes are currently supported by the SAP Cloud Application Programming Model? There are 2 correct answers to this question. Node.js Java Go Python.
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: No Delete: No Read: Yes Create: No Update: Yes Delete: No Read: Yes Create: Yes Update: Yes Delete: Yes Read: Yes Create: Yes Update: Yes Delete: No.
To perform a specific task of an XS advanced application, what does a user need? Please choose the correct answer. To be assigned to an Organization To have directly assigned a Scope To be assigned to a Space To have directly assigned a Role Collection.
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 Git-based Repository SVC-based Repository SAP HANA Repository Workspace.
In application development with XS advanced, which of the following entities belong to a specific SPACE? There are 2 correct answers to this question. Applications Organizations Processes Users.
What are the characteristics of SAP HANA calculation views? There are 2 correct answers to this question. Need database tables to execute Need an application server to execute Do NOT need an application server to execute Do NOT need database tables to execute.
You need to view the data model exposed by an OData V2 service. What must you append to the service URL? Please choose the correct answer. $schema $format $metadata $service definition.
You define exception handling in a SQL Script procedure. What can you use declare exit handlers for? There are 2 correct answers to this question. Generic SQL conditions Specific SQL Error codes Generic SQL Exceptions Specific SQL conditions.
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 Java Runtime Environment (JRE) SAP HANA Runtime Tools (HRTT) SAP Web IDE for SAP HANA.
Your multi-target application will use XSJS. Which module type do you create in your application project? Please choose the correct answer. HTML5 SAP HANA Database Node.js Java.
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. Transparent Filter Dynamic Join Keep Flag Non-Equijoin.
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 Aggregation Join condition Key specification.
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. SAP HANA database version Namespace Template Project Name.
|
