Questions C_HANADEV_17 SAP HANA 2.0 SPS05
| Your team develops an application using SAP Web IDEfor SAP HANA. How can you share the application source code with other team users? |
| You need to view the data model exposed by an OData V2 service. What must you append to theservice URL? |
| What are the characteristics of SAP HANA calculation views? There are 2 correct answers to this question. |
| Which functionality is provided by SAP web IDE for SAP HANA? Note: There are 2 correct answers to this question. |
| 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. |
| Which join type is NOT supported by join optimization (pruning)? Please choose the correct answer. |
| In your UI5application, you need to refer to an SAPUI5 core library that is available on your SAP HANA extended application services, advanced model (XS advanced) server. Which files must you adapt? Note: There are 3 correct answers to this question. |
| Which activities doyou perform with the Applications tool of SAP HANA XS Advanced Cockpit? Note: There are 2 correct answers to this question. |
| In an SAPU15 application, where do you find the reference to sap-ui-core.js? |
| What are the nodes where filter expressions can be used in a calculation view? There are 2 correct answers to this question. |
| 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. |
| What are the disadvantages when deploying Dynamic SQL? There are 2 correct answers to this question. |
| 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. |
| What happens if you define a database object in the persistence model and deploy it using the SAP HANA Deployment Infrastructure (HDI)? |
| You want to exclusively use declarative logic in an SQL Script procedure. Which of the following operators canyou use? There are 2 correct answers to this question. |
| Which parameters does the APPLY_FILTER function support? There are 2 correct answers to this question. |
| Which of the following information must you specify when you create a new project in SAP Web IDE for SAP HANA? Note: There are 2 correct answers to this question. |
| Where do you add controls to the user interface? |
| You create an isolated block of code which runs as an independent transaction. Which of the following SQLScript features do you use? |
| Which parameters do you need for the APPLY_FILTER function? Note: There are 2 correct answers to this question. |
| Who owns the database objects created in an SAP HANADeployment Infrastructure container? |
| Your multi-target application shall use XSJS. Which module type do you create in your application project? |
| What do you reference in a role template? Please choose the correct answer |
| You need to consume a Node.js service in an SAPUI5 application. In which section of the mta.yaml file do you define the variable for the exposed service? |
| Which parameter do you adapt to change the file that is initially delivered by an HTML5 module? Please choose the correct answer. |
| In a calculation view, what are the different types of input mapping available in Table Function? There are 2 correct answers to this question. |
| You create a simple datamodel to store user information. The model contains two tables: One for the user information, 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 to you perform if you use CDS artifacts only? |
| Which artifacts do you define in the persistence model to access objects in an external SAP HANA Deployment Infrastructure container? |
| What key words are contained in the applicationdescriptor file (xs-app.json)? There are 2 correct answers to this question. |
| After reviewing the SQL Analyzer results, which of the following would you consider for optimizingthe performance? There are 2 correct answers to this question |
| Which GIT command doyou use to consolidate all changes from one branch with another branch using a single commit? |
| Which content can you include in a Node.js module of the multi-target application? Note: There are 3 correct answersto this question. |
| You are working on an entity using Core Data Services. Which properties can you define inside the Technical Configuration section? Note: There are 2 correct answers to this question. |
| What are the main SAP HANA engines responsible for executing calculation views? There are 3 correct answers to this question. |
| 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. |
| In an SQLScript procedure, which feature do you use to initialize IN/OUT table parameters? |
| Which SAP HANA system views contain information about the object ownership? There are 2 correct answers to this question. |
| You need to manage an exception in a SQLScript. Which SQLScript features can you use? Note: There are 2 correct answers to this question. |
| 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. |
| Which of the following joins can be defined onlywith multi-column join in calculation views? Please choose the correct answer. |
| 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. |
| To perform a specific task of an XSadvanced application, what does a user need? Please choose the correct answer. |
| Which application runtimes are currently supported by the SAP Cloud Application Programming Model? There are 2 correct answers to this question. |
| An OData Service contains an entity set called Products. Which resource path do you add to the OData Service URL to view the available products? |
| You need to synchronize all unsynchronized changes of the remote GIT branch with a local GIT branch. Which operation do youuse? |
| How do you specify the target currency for currency conversion in calculation views? There are 3 correct answers to this question. |
| You configure an OData service for a transactional SAPUI5 application What is the default data access behavior of the OData service? |
| What are some of the advantages of SQLScript compared to plain SQL queries? Note: There are 2 correct answers to this question. |
| You must debug an existing SQLScript procedure in SAP HANA extended application services, advanced model (XS advanced). What is the valid sequence to debug the procedure? |
| What are the characteristics of the calculation view of type “SQL Access Only”? There are 2 correct answers to this question. |
| Which configuration file indicates the program that is executed upon startup when you run the Node.js module? |
| What is the package descriptor package.json used for? There are 2 correct answers to this question. |
| Which programming paradigms are supported by SQLScript? Note: There are 2 correct answers to this question. |
| 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? |
| For what do you use the RESIGNAL statement in SQLScript? |
| Which of the following elements can be part of the UI5 application’s index.html file? There are 2 correct answers to this question |
| You need to restrict the selected columns exposed to the client. Which OData capability do you use? |
| You create triggers using theSQL Console. Where are the triggers stored? |
| You developnative 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. |
| Which tool can you use to perform an in-place upgrade of SAP HANA 2.0, express edition? |
A Node.js module is executed for the first time in SAP HANA extended application services, advanced model (XS advanced). Which of the followingactivities are performed automatically? There are 2 correct answers to this question. |
| What are some of the benefits of developing applications on SAP HANA? Note: There are 2 correct answers to this question. |
| You create a multi-target application in SAP Web IDE for SAP HANA. Which source code management option do you use? |
| A user is dropped with the “cascade” option. The user schema also contains objects owned by other users, or on whichother users have privileges. What happens to the objects? There are 2 correct answers to this question. |
| What are the issue categories that SQL Script Code Analyser scans for? There are 3 correct answers to this question. |
| Which GIT commands are available with the SAP Web IDE for SAP HANA? Note: There are 3 correctanswers to this question. |
| You create an SAP HANA extended application services, advanced model (XS advanced) multi-target application using the SAP Web IDE for SAP HANA. Which files can be generated automatically by the wizard when you create the SAP HANA database (HDB) module? Note: There are 2 correct answers to this question. |
| Which of the following models a servet-side model in the SAPUI5 context? |
| How do you debug a Node.js module in SAP Web IDE for SAP HANA? |
| Which services can you use in SAP HANA 2.0, express edition? Note: There are 3 correct answers to this question. |
| Which tool do you use to create a calculation view in a multi-target application? |
| 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. |
| Which OData capacities are supported in SAP HANAextended application services, advanced model (XSA)? There are 3 correct answers to this question. |
| You need to create a native SAP HANA application that fully leverages the SAP HANA platform. How do you implement data-intensive calculations? |
| Which OData service do you use to prevent changes to existing line items of the sap.test::myTable table? |
| In Node.js, which file do you use to define external module dependencies? |
| You implement an asynchronous Node.js service which sends requests to the database. How do you handle the database responses? Note: There are 2 correct answers to this question. |
| 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 correctanswers to this question. |
| What are the key characteristics of the calculation view’s Input Parameter? There are 3 correct answers to this question. |
| 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″}]}} |
| Which are the artifacts that are contained in an SAP HANA Deployment Infrastructure (HDI) container? Note: There are 2 correct answers to this question. |
| Which of the following are characteristics of an SAP HANA Deployment Infrastructure container? Note: There are 3 correct answers to this question. |
| Which module do you use to run an SQL statement against the SAP HANA database? |
| 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? |
| You develop a Node.js application for theSAP 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. |
| Which keywords do you use to define an OData association? Note: There are 3 correct answers to this question. |
| 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? Note: There are 2 correct answers to this question. |
| Which of the following are characteristics of SAPU15? Note; There are 3 correct answers to this question. |
| 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”;} |
| Which SAP HANA extended application services, advanced model (XS advanced) tools can you use to retrieve the URL for the SAP Web IDE for SAP HANA? Note: There are 2 correct answers tothis question. |
| o which SAP HANA authorization entities can you grant a role? There are 2 correct answers to this question. |
| What characterizes the Node.js environment? Note: There are 2 correct answers to this question. |
| 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. |
| You create an SAP HANA extended application services, advanced model (XS advanced) multi-target application. What does the mta.yaml file contain? |
| In application development with XS advanced, which of the following entities belong to a specific SPACE? There are 2 correct answers to this question. |
| You need to bind UI5 controls to a data source. Between which parts of the SAPUI5 application must you create databinding? |
| 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? |
| You need to combine data from different database tables within your OData service. Which capability do you use for this relationship? |
| To comply with the SAP Fiori principles, which view type is recommended by SAP? |
| Your multi-target application will use XSJS. Which module type do you create in your application project? Please choose the correct answer. |
| 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. |
| In which of the following objects can you use Commit and Rollback statements? |
| You use path expressions (associations) in yourCore Data Services to combine entities instead of using SQL joins. What is a benefit to use these associations? |
| Which of the following SQLScript elements do you use to transform a set of arrays into an intermediate table variable? |
| Which development environment does SAP recommend to develop an SAP HANA extended application services; advanced model (XS advanced) multi-target application? |
| Which of the following activities are part of the development lifecycleusing SAP HANA extended application services, advanced model (XS advanced)? Note: There are 3 correct answers to this question. |
| From which tool can you run the XS Command Line? |
| Which of the following activities are part of the development lifecycle using SAP HANA extendedapplication services, advanced model (XS advanced)? Note: There are 2 correct answers to this question. |
| Why do you use associations in your persistence model for SAP HANA extended application services, advanced model (XS advanced)? |
| 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. |
| You need to check user input data in your OData request. Which exit type do you use? |
| 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? |
| What do you use to set up unit testing for your SQL Script procedure? Please choose the correct answer. |
| You developed a multi-target application that contains only a database module. Which environment are the runtime objects createdin? Please choose the correct answer. |
| Where do you find the design-time objects of an SAP HANA extended application services, classic model (XS classic) application? |
| Which URL query options are available with XSOData v2.0? Note: There are 3 correct answers to this question. |