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.
- A . ARRAY
- B . SET
- C . UNSET
- D . UNNEST
Your team develops an application using SAP Web IDE for SAP HANA.
How can you share the application source code with other team users?
- A . Share the project in the application project settings.
- B . Assign a shared workspace to users in XS Advanced Administration.
- C . Store the source code in a shared Git repository.
- D . Store the project in a shared package within the SAP HANA repository.
You develop native SAP HANA applications in SAP HANA extended application services, advanced model (XS advanced).
What are some of the advantages compared to developing in SAP HANA extended application services, classic model (XS classic)? Note: There are 3 correct answers to this question.
- A . No additional SAP HANA components are required.
- B . It supports different runtime containers.
- C . The source code repository is built into the SAP HANA database.
- D . Advanced GIT/GERRIT source code management is available.
- E . The application layer can be separate from the database.
Which services can you use in SAP HANA 2.0, express edition? Note: There are 3 correct answers to this question.
- A . Text analytics
- B . Dynamic tiering
- C . System replication
- D . Columnar OLTP and OLAP
- E . Multi-core and parallelization
In a calculation view, what are the different types of input mapping available in Table Function? There are 2 correct answers to this question.
- A . Formula
- B . Data Source Column
- C . Variable
- D . Constant
What are the characteristics of the calculation view of type "SQL Access Only"? There are 2 correct answers to this question.
- A . Can be directly used for multidimensional analysis
- B . Can be direct y accessed via SQL
- C . Can be directly exposed to all client tools
- D . Can be directly used as modeled data source for another view
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? Note: There are 3 correct answers to this question.
- A . Create a synonym that refers to the view.
- B . Create a view that refers to a synonym.
- C . Create a synonym for the remote table object.
- D . Create/update the .hdbgrants file providing authorizations for the remote schema.
- E . Create a view that refers to the table.
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 . A new SAP HANA Deployment Infrastructure (HDI) container is created.
- B . A new service is executed on the application server.
- C . The required modules are downloaded based on module dependencies.
- D . The source code is compiled to create an executable binary file.
Which of the following models a servet-side model in the SAPUI5 context?
- A . Resource
- B . OData
- C . JSON
- D . XML
What are the nodes where filter expressions can be used in a calculation view? There are 2 correct answers to this question.
- A . Aggregation
- B . Union
- C . Rank
- D . Star join
Which activities do you perform with the Applications tool of SAP HANA XS Advanced Cockpit? Note: There are 2 correct answers to this question.
- A . Monitor applications assigned to the current space.
- B . View system resources used by each instance.
- C . Identify SAP HANA applications which are pinned to spaces.
- D . Start, stop, and restart of applications.
To comply with the SAP Fiori principles, which view type is recommended by SAP?
- A . JSON
- B . XML
- C . HTML
- D . JavaScript
Which of the following activities are part of the development lifecycle using SAP HANA extended application services, advanced model (XS advanced)? Note: There are 3 correct answers to this question.
- A . Synchronize source with GIT repository
- B . Store source in SAP HANA repository
- C . Activate artifacts via _SYS_REPO
- D . Create an MTA project
- E . Export project as MTA archive
Which of the following SQLScript elements do you use to transform a set of arrays into an intermediate table variable?
- A . SET
- B . UNSET
- C . ARRAY
- D . UNNEST
You need to view the data model exposed by an OData V2 service.
What must you append to the service URL?
- A . $servicedefinition
- B . $schema
- C . $metadata
- D . $format
Which GIT commands are available with the SAP Web IDE for SAP HANA? Note: There are 3 correct answers to this question.
- A . Redeploy the code
- B . Clone a repository
- C . Merge changes
- D . Push code
- E . Test changes
For what do you use the RESIGNAL statement in SQLScript?
- A . System exceptions
- B . Specific SQL error codes
- C . Generic SQL exceptions
- D . User-defined exceptions
You need to debug a Node.js application using SAP Web IDE for SAP HANA.
What must you do? Note: There are 3 correct answers to this question.
- A . Open the debugger.
- B . Attach debugger to the node module.
- C . Specify the proper GIT repository in the debug properties.
- D . Set a breakpoint in the application.
- E . Build the application with the debug option.
Your multi-target application will use XSJS.
Which module type do you create in your application project? Please choose the correct answer.
- A . SAP HANA database
- B . HTML5
- C . Java
- D . Node.js
You use APPLY_FILTER to add a dynamic WHERE clause on SELECT statements.
On which objects can you apply the filter? Note: There are 2 correct answers to this question.
- A . Database tables
- B . Intermediate table variables
- C . Virtual tables
- D . Scalar variables
Which new components can you use to develop native SAP HANA applications in SAP HANA extended application services; advanced model (XS advanced)? Note: There are 2 correct answers to this question.
- A . SAP HANA studio
- B . SAP HANA repository
- C . GIT repository
- D . SAP Web IDE for SAP HANA
Please review the JSON model in the screenshot.
Which of the following absolute binding paths are valid? Note: There are 3 correct answers to this question.
{company: {name: "ACME", info: {employees:3}, contacts: [{name: "Barbara", phone: "873"},{name: "Gerry", phone: ‘"734"}]}}
- A . /contacts/0/name
- B . /company/name
- C . /company/contacts/2/phone
- D . /company/info/employees
- E . /company/contacts/1/name
Which elements can you specify with the SAP Web IDE for SAP HANA graphical editor for Core Data Services data models? Note: There are 3 correct answers to this question.
- A . Context
- B . Association
- C . Synonym
- D . Entities
- E . Procedure
Which of the following joins can be defined only with multi-column join in calculation views? Please choose the correct answer.
- A . Temporal join
- B . Dynamic join
- C . Text join
- D . Multi join
To perform a specific task of an XS advanced application, what does a user need? Please choose the correct answer.
- A . To have directly assigned a Scope
- B . To have directly assigned a Role Collection
- C . To be assigned to a Space
- D . To be assigned to an Organization
What are some of the advantages of SQLScript compared to plain SQL queries? Note: There are 2 correct answers to this question.
- A . It retrieves a high data volume from a database.
- B . It increases performance by parallel execution of complex SQL statements.
- C . It contains a well-defined ANSI standard.
- D . It enables modular parameterized programing.
What are the issue categories that SQL Script Code Analyser scans for? There are 3 correct answers to this question.
- A . Performance
- B . Consistency
- C . Security
- D . Business logic
- E . Privileges
You define exception handling in a SQLScript procedure.
What can you use declare exit handlers for? Note: There are 2 correct answers to this question.
- A . Specific SQL error codes
- B . Specific SQL conditions
- C . Generic SQL conditions
- D . Generic SQL exceptions
You implement a native SAP HANA application using SAP HANA extended application services, advanced mode (XS advanced) and SAPUI5.
Where is the UI rendering executed?
- A . On the XS advanced application server
- B . On the SAPUI5 HTML5 module
- C . On the front-end client device
- D . On the SAP Fiori front-end server
Which parameters does the APPLY_FILTER function support? There are 2 correct answers to this question.
- A . Entity set
- B . Join condition
- C . Table variable
- D . Filter condition
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?
- A . A file with extension .hdbti
- B . A file with extension .hdbtabledata
- C . A file with extension .hdbtable
- D . A file with extension .hdbdd
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.
- A . IF condition
- B . MAP_REDUCE function
- C . TABLE variable
- D . COMM IT statement
How do you debug a Node.js module in SAP Web IDE for SAP HANA?
- A . Start the debugger from the XS Command Line interface and run the program in SAP Web IDE for SAP U HANA
- B . Set the enabled parameter to true in the section debugger of the xsengine.ini file
- C . Attach the debugger to the application in the SAP Web IDE for SAP HANA
- D . Add the sap.hana.xs.debugger: :Debugger plugin to the SAP Web IDE for SAP HANA
You configure an OData service for a transactional SAPUI5 application What is the default data access behavior of the OData service?
- A . Read: Yes Create: No Update. Yes Delete No
- B . Read: Yes Create: Yes Update: Yes Delete. No
- C . Read: Yes Create: No Update: No Delete: No
- D . Read: Yes Create: Yes Update: Yes Delete: Yes
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.
- A . INSERT
- B . POST
- C . GET
- D . READ
- E . PUT
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
- A . Re-prioritize with Workload Management.
- B . Change the data model.
- C . Use CE functions.
- D . Modify SQL hints.
Which metadata declarations can you specify in an SQLScript procedure when you use the SAP HANA Deployment Infrastructure? Note: There are 2 correct answers to this question.
- A . Authorization
- B . Default schema
- C . Security
- D . Language
You create an isolated block of code which runs as an independent transaction.
Which of the following SQLScript features do you use?
- A . Autonomous transactions
- B . Blocked transactions
- C . Anonymous transactions
- D . Anonymous transaction block
Which of the following activities are part of the development lifecycle using SAP HANA extended application services, advanced model (XS advanced)? Note: There are 2 correct answers to this question.
- A . Export the project as an MTA archive.
- B . Store the source in the SAP HANA repository.
- C . Create an MTA project.
- D . Activate artifacts via _SYS_REPO.
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?
Service{ "sample.odata;; customer" as "Customer" navigates ("Customer_Orders" as "toOrders");"sample.odata: salesorders" as "Orders";}
- A . Key specification
- B . Aggregation
- C . Join condition
- D . Association