SAP C-HANADEV-18 Exam Prep Guide: Prep guide for the C-HANADEV-18 Exam
2024 New Preparation Guide of SAP C-HANADEV-18 Exam
SAP C-HANADEV-18 certification exam is designed for professionals who are seeking to obtain an in-depth understanding of SAP HANA 2.0 SPS06. C-HANADEV-18 exam is aimed at individuals who are involved in developing, modeling, and implementing solutions in the SAP HANA environment. Certified Development Associate - SAP HANA 2.0 SPS06 certification exam is a prerequisite for other SAP HANA certifications and is an excellent way to demonstrate expertise in SAP HANA development.
The C_HANADEV_18 exam is administered by SAP, and is available to anyone who is interested in becoming certified as a SAP HANA developer. To take the exam, candidates must register with SAP and pay a fee. Once registered, candidates will have access to study materials and resources, including practice exams and sample questions, to help them prepare for the exam.
SAP C-HANADEV-18 exam is a certification exam that tests a candidate's knowledge and skills in developing applications using the SAP HANA 2.0 platform. C-HANADEV-18 exam is designed to validate the candidate's ability to develop and deploy SAP HANA-based applications, as well as their understanding of the underlying architecture and functionality of the platform.
NEW QUESTION # 21
What is the package descriptor package.json used for? There are 2 correct answers to this question.
- A. To list the package dependencies
- B. To set the router version
- C. To define back-end destinations
- D. To define the routes
Answer: A,B
NEW QUESTION # 22
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.
- A. SAP HANA studio
- B. SAP Web IDE for SAP HANA
- C. Git repository
- D. SAP HANA repository
Answer: B,C
Explanation:
SAP HANA extended application services, advanced model (XS advanced) provides a comprehensive platform for the development and execution of micro-service oriented applications, taking advantage of SAP HANA's in-memory architecture and parallel execution capabilities1. XS advanced supports several programming languages and execution environments, such as Java and Node.js, and also provides compatibility with XS classic model2. To develop native SAP HANA applications in XS advanced, you can use the following new components:
* Git repository: XS advanced integrates with Git, a distributed version control system, to manage the source code of your applications. You can use Git to clone, create, push, pull, merge, and branch your projects, and also to collaborate with other developers3.
* SAP Web IDE for SAP HANA: XS advanced provides a web-based integrated development environment (IDE) that allows you to create, edit, test, debug, and deploy your applications. SAP Web IDE for SAP HANA supports various development tools and features, such as editors, wizards, templates, code completion, syntax highlighting, code analysis, debugging, testing, and deployment3.
The other options are not correct because:
* SAP HANA repository: This is a component of XS classic model, not XS advanced. The SAP HANA repository stores the design-time artifacts of your applications, such as views, procedures, and scripts. In XS advanced, the design-time artifacts are stored in Git repositories instead4.
* SAP HANA studio: This is a desktop-based IDE that can be used to develop applications for XS classic model, but not for XS advanced. SAP HANA studio provides various perspectives and tools to access and manage the SAP HANA database, such as the administration console, the catalog, the content, and the security4.
References: 2: SAP HANA Extended Application Services, Advanced Model 4: SAP HANA Extended Application Services 1: SAP HANA extended application services, advanced model 3: SAP HANA Developer Guide for SAP HANA XS Advanced Model (SAP Web IDE)
NEW QUESTION # 23
Which activities do you perform on an application in the SAP HANA XS Advanced Cockpit? There are 2 correct answers to this question.
- A. Monitor applications assigned to the current space.
- B. Deploy applications to SAP Cloud Platform.
- C. Start, stop, and restart applications.
- D. Display HDI container content.
Answer: A,C
Explanation:
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:
* SAP HANA Platform 2.0 SPS06: SAP HANA XS Advanced Cockpit, Section 1
* SAP HANA Platform 2.0 SPS06: SAP HANA XS Advanced Cockpit, Section 2
* SAP HANA Platform 2.0 SPS06: SAP HANA XS Advanced Cockpit, Section 3
* SAP HANA Platform 2.0 SPS06: SAP HANA XS Advanced Cockpit, Section 4
* SAP HANA Platform 2.0 SPS06: SAP HANA XS Advanced Cockpit, Section 5
NEW QUESTION # 24
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.
- A. Synonyms
- B. Procedures
- C. Imports
- D. Views
Answer: A
Explanation:
To access objects in an external SAP HANA Deployment Infrastructure (HDI) container, you need to define synonyms in the persistence model. Synonyms are design-time artifacts that provide a logical name and a reference to an object in another schema or HDI container. Synonyms allow you to access the data and functionality of the external objects without granting direct privileges or using fully qualified names1. Synonyms can be created for tables, views, procedures, functions, and other database objects2.
The other options, views, imports, and procedures, are not artifacts that can be defined in the persistence model to access objects in an external HDI container. Views are artifacts that define a logical data model based on one or more tables or other views. Views can be used to query data from different sources, but they do not provide a reference to an external object3. Imports are artifacts that allow you to import another CDS entity or a database table into the current CDS entity, and use its columns as part of the projection list. Imports can be used to reuse data definitions, but they do not provide a reference to an external object either4. Procedures are artifacts that define a set of SQL statements that can be executed as a unit. Procedures can be used to implement complex logic and calculations, but they do not provide a reference to an external object either5.
References: 1: Synonyms | SAP Help Portal 2: Synonym Definition | SAP Help Portal 3: Views | SAP Help Portal 4: Import | SAP Help Portal 5: Procedure Definition | SAP Help Portal
NEW QUESTION # 25
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.
- A. On the front-end client device
- B. On the SAPUI5 HTML5 module
- C. On the SAP Fiori front-end server
- D. On the XS advanced application server
Answer: A
Explanation:
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:
* SAP HANA Platform, Developing Applications with SAP HANA Cloud Platform, Developing Multi-Target Applications, Developing HTML5 Modules
* SAP HANA Platform, SAP HANA Extended Application Services, Advanced Model, Developing and
* Deploying Applications, Developing HTML5 Applications
* SAP HANA Platform, SAP HANA Extended Application Services, Advanced Model, Developing and Deploying Applications, Developing SAP Fiori Applications
NEW QUESTION # 26
How do you debug a Node.js module in SAP Web IDE for SAP HANA? Please choose the correct answer.
- A. Attach the debugger to the application in the SAP Web IDE for SAP HANA.
- B. Start the debugger from the XS command line interface and run the program in SAP Web IDE for SAP HANA.
- C. Add the sap.hana .xs.debugger::Debugger role to the HDI Container's #RT User.
- D. Set the enabled parameter to true in the section debugger of the xsengine.ini file.
Answer: A
NEW QUESTION # 27
Which activities do you perform on an application in the SAP HANA XS Advanced Cockpit? There are 2 correct answers to this question.
- A. Monitor applications assigned to the current space.
- B. Deploy applications to SAP Cloud Platform.
- C. Start, stop, and restart applications.
- D. Display HDI container content.
Answer: A,C
NEW QUESTION # 28
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.
- A. Generic SQL conditions
- B. Specific SQL error codes
- C. Specific SQL conditions
- D. Generic SQL exceptions
Answer: B,D
Explanation:
You can use declare exit handlers in a SQL Script procedure to handle generic SQL exceptions or specific SQL error codes. An exit handler is a custom handler that defines a block of code to be executed when an exception occurs in the procedure. You can declare an exit handler for a generic SQL exception, which is any error that is raised by the database system, such as syntax errors, constraint violations, or division by zero. You can also declare an exit handler for a specific SQL error code, which is a numeric code that identifies the type and severity of the error, such as 301 for unique constraint violation, or 1299 for no data found12.
The other two options, generic SQL conditions and specific SQL conditions, are not valid arguments for declare exit handlers. A condition is a named exception that can be declared by using a condition variable and optionally associated with an SQL error code. A condition can be used to signal or resignal an exception in the procedure, or to register a continue handler, which is a custom handler that defines a block of code to be executed when an exception occurs, but does not exit the procedure. However, a condition cannot be used to register an exit handler, as the syntax requires an SQL error code or a generic SQL exception12. References:
1: Exception Handling | SAP Help Portal 2: Exception Handling Examples | SAP Help Portal
NEW QUESTION # 29
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.
- A. Non-equijoin
- B. Transparent filter
- C. Keep flag
- D. Dynamic join
Answer: B,D
NEW QUESTION # 30
You need to check user input data in your OData request. Which exit type do you use? Please choose the correct answer.
- A. Modification
- B. Verification
- C. Consistency
- D. Validation
Answer: D
NEW QUESTION # 31
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 exposed to all client tools
- B. Can be directly used as modelled data source for another view
- C. Can be directly used for multidimensional analysis
- D. Can be direct y accessed via SQL
Answer: B,D
NEW QUESTION # 32
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.
- A. Storage Type
- B. Import
- C. Index
- D. Association
Answer: A,C
Explanation:
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:
* Index: You can create one or more indexes on the entity to improve the query performance. You can specify the index name, the columns to be indexed, and the index type (such as unique, full-text, or spatial)2.
* Storage Type: You can specify the storage type of the entity, such as column store or row store, to optimize the data access and compression. You can also specify the partitioning mode and criteria for the entity, such as hash, range, or round-robin3.
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]
NEW QUESTION # 33
Which parameters does the APPLY_FILTER function support? There are 2 correct answers to this question.
- A. Filter condition
- B. Join condition
- C. Table variable
- D. Entity set
Answer: A,C
Explanation:
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:
* Filter condition: A mandatory parameter that specifies the filter condition as a string literal or a string expression. The filter condition must follow the syntax of the WHERE clause in SQL, and it can use column names, literals, operators, and functions. For example, APPLY_FILTER(:table_var, 'price > 100 and category = ''A''').
* Table variable: A mandatory parameter that specifies the table variable to which the filter condition is applied. The table variable must be a local or input parameter of the SQLScript procedure or function that calls the APPLY_FILTER function. For example, APPLY_FILTER(:table_var, :filter_cond).
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:
* SAP HANA Platform, SAP HANA SQL and System Views Reference, SQLScript Guide, SQLScript Functions, APPLY_FILTER
* SAP HANA Platform, SAP HANA Developer Guide for SAP HANA Web IDE, Developing Database Modules, Developing SQLScript Procedures and Functions, Using APPLY_FILTER
* SAP HANA Platform, SAP HANA Predictive Analysis Library (PAL), Reference Guide, PAL SQLScript Functions, APPLY_FILTER_JOIN, APPLY_FILTER_ENTITY
NEW QUESTION # 34
What characterizes the Node.js environment? There are 2 correct answers to this question.
- A. It is a client-side design-time environment for JavaScript.
- B. It is built on Google's V8 JavaScript engine.
- C. It is single-threaded.
- D. It uses a synchronous programming model.
Answer: B,C
Explanation:
According to the SAP Web IDE for SAP HANA Developer Guide, the Node.js environment is characterized by the following features:
* It is single-threaded: Node.js uses a single thread to handle multiple concurrent requests, instead of creating a new thread for each request. This reduces the memory and CPU overhead, and enables high scalability and performance. However, it also means that any blocking or long-running operation can affect the responsiveness of the entire application. Therefore, Node.js relies on asynchronous and non-blocking I/O operations, callbacks, promises, and events to handle concurrency and avoid blocking the main thread.
* It is built on Google's V8 JavaScript engine: Node.js uses the V8 engine to execute JavaScript code.
The V8 engine is a fast and powerful engine that compiles JavaScript code into native machine code, and supports the latest ECMAScript standards and features. The V8 engine also provides access to low-level system resources, such as files, network, and processes, through the Node.js API.
The other options are incorrect, because:
* Node.js does not use a synchronous programming model, but an asynchronous and event-driven programming model. A synchronous programming model means that each operation blocks the execution until it is completed, and the next operation can only start after the previous one is finished.
An asynchronous programming model means that each operation can start without waiting for the previous one to finish, and the execution can continue with other tasks while the operation is in progress.
An event-driven programming model means that each operation can trigger an event when it is completed, and the event can invoke a callback function that handles the result or the error of the operation.
* Node.js is not a client-side design-time environment for JavaScript, but a server-side run-time environment for JavaScript. A client-side design-time environment for JavaScript means that the JavaScript code is written and executed in the browser, and it can manipulate the HTML document and interact with the user interface. A server-side run-time environment for JavaScript means that the JavaScript code is written and executed on the server, and it can handle HTTP requests and responses, communicate with databases, and perform business logic.
References: SAP Web IDE for SAP HANA Developer Guide, Chapter 6, Section 6.4.2, page 2111.
NEW QUESTION # 35
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.
- A. Storage Type
- B. Import
- C. Index
- D. Association
Answer: A,C
NEW QUESTION # 36
Which parameter do you adapt to change the file that is initially delivered by an HTML5 module? Please choose the correct answer.
- A. Runners parameter of the projectjson file
- B. Service_url parameter of the mta.xml file
- C. Welcome file parameter of the xs-app.json file
- D. Start parameter of the package.json file
Answer: C
Explanation:
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:
* SAP HANA Platform 2.0 SPS06: Developing Multitarget Applications, Section 1.1
* SAP HANA Platform 2.0 SPS06: Developing Multitarget Applications, Section 1.3
* SAP HANA Platform 2.0 SPS06: Developing Multitarget Applications, Section 2.1
* SAP HANA Platform 2.0 SPS06: Developing Multitarget Applications, Section 2.2
* SAP HANA Platform 2.0 SPS06: Developing Multitarget Applications, Section 2.3
* SAP HANA Platform 2.0 SPS06: Developing Multitarget Applications, Section 2.4
* SAP HANA Platform 2.0 SPS06: Developing Multitarget Applications, Section 2.5
* SAP HANA Platform 2.0 SPS06: Developing Multitarget Applications, Section 2.6
* SAP HANA Platform 2.0 SPS06: Developing Multitarget Applications, Section 2.7
* SAP HANA Platform 2.0 SPS06: Developing Multitarget Applications, Section 2.8
* SAP HANA Platform 2.0 SPS06: Developing Multitarget Applications, Section 2.9
NEW QUESTION # 37
From which tool can you run the XS command line? Please choose the correct answer.
- A. Local operating system shell
- B. SAP HANA studio
- C. SAP HANA cockpit
- D. SAP WeblDE for SAP HANA
Answer: A
Explanation:
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 <sid>adm2.
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
NEW QUESTION # 38
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.
- A. $service definition
- B. $format
- C. $schema
- D. $metadata
Answer: D
NEW QUESTION # 39
How do you specify the target currency for currency conversion in calculation views? There are 3 correct answers to this question.
- A. With an input parameter
- B. With a fixed value
- C. In a procedure
- D. In a table function
- E. In a column
Answer: A,B,E
Explanation:
To specify the target currency for currency conversion in calculation views, you can use one of the following methods:
* In a column: You can associate the measure with an attribute column that contains the target currency code. For example, if you have a table that stores the sales amount and the currency code for each transaction, you can use the currency code column as the target currency for the sales amount measure.
* With an input parameter: You can create an input parameter that allows the user to select or enter the target currency code at runtime. For example, if you want to display the sales amount in different currencies based on the user's preference, you can use an input parameter as the target currency for the sales amount measure.
* With a fixed value: You can associate the measure with a fixed currency code that is available in the currency table. For example, if you want to display the sales amount in a single currency, such as USD, you can use a fixed value as the target currency for the sales amount measure. References: Associate Measures with Currency, How to perform Currency Conversion in SAP HANA, Implementing Currency Conversion.
NEW QUESTION # 40
What are the issue categories that SQL Script Code Analyser scans for? There are 3 correct answers to this question.
- A. Security
- B. Business logic
- C. Consistency
- D. Performance
- E. Privileges
Answer: A,C,D
Explanation:
The SQL Script Code Analyser is a tool that scans SQL Script code for potential issues and provides suggestions for improvement. The tool can be accessed from the SAP Web IDE for SAP HANA or from the SAP HANA database explorer. The tool scans for issues in the following categories:
* Performance: This category covers issues that may affect the execution time or resource consumption of the SQL Script code, such as inefficient joins, missing indexes, unnecessary data transfers, etc. The tool provides recommendations for optimizing the code, such as using parallel processing, avoiding nested loops, using table variables, etc.
* Security: This category covers issues that may expose the SQL Script code to security risks, such as SQL injection, privilege escalation, data leakage, etc. The tool provides recommendations for securing the code, such as using parameterized queries, escaping literals, applying proper authorization checks, etc.
* Consistency: This category covers issues that may affect the readability, maintainability, or portability of the SQL Script code, such as coding style, naming conventions, documentation, compatibility, etc.
* The tool provides recommendations for improving the code quality, such as using consistent indentation, avoiding hard-coded values, adding comments, following best practices, etc.
The other options are incorrect because privileges and business logic are not issue categories that the SQL Script Code Analyser scans for. Privileges are handled by the SAP HANA Deployment Infrastructure framework, which automatically grants the necessary privileges to the technical users and roles that access the HDI container objects. Business logic is the domain-specific logic that defines the functionality and behavior of the SQL Script code, and it is not within the scope of the tool to verify or validate it. References:
* SQL Script Code Analyzer - SAP Help Portal
* SQL Script Code Analyzer in SAP Web IDE for SAP HANA - SAP Help Portal
* SQL Script Code Analyzer in SAP HANA Database Explorer - SAP Help Portal
* HA150 - SAP HANA 2.0 SPS06 SQLScript for SAP HANA - SAP Training
NEW QUESTION # 41
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?
There are 2 correct answers to this question.
- A. @sap/xsenv
- B. @sap/hdbext
- C. @sap/instance-manager
- D. @sap/node-vsi
Answer: A,B
Explanation:
To develop a Node.js application for the SAP HANA platform that executes a SQL statement in the SAP HANA database, you need to use the following modules:
* @sap/xsenv: This module provides functions to load service configuration and credentials from the environment variables of the SAP Cloud Platform or the SAP HANA XS Advanced Model. You can use this module to access the SAP HANA database service information, such as host, port, user, password, and schema.
* @sap/hdbext: This module provides a wrapper for the SAP HANA client for Node.js, which enables you to connect to the SAP HANA database and execute SQL statements. You can use this module to create a database connection pool, execute queries, fetch results, and handle errors.
The other options are not correct because:
* A. @sap/instance-manager: This module provides functions to manage the lifecycle of Node.js applications running on the SAP Cloud Platform or the SAP HANA XS Advanced Model. You can use this module to start, stop, restart, scale, and monitor your applications, but not to execute SQL statements in the SAP HANA database.
* D. @sap/node-vsi: This module provides functions to interact with the SAP HANA Virtual Schema Integrator (VSI), which enables you to access data from remote sources using virtual tables. You can use this module to create, update, delete, and query virtual tables, but not to execute SQL statements in the SAP HANA database.
References:
* SAP HANA Developer Guide for SAP HANA Web IDE, Chapter 5, Section 5.2
* SAP HANA Developer Guide for SAP HANA Web IDE, Chapter 5, Section 5.3
* SAP HANA Developer Guide for SAP HANA Web IDE, Chapter 5, Section 5.4
* SAP HANA Developer Guide for SAP HANA Web IDE, Chapter 5, Section 5.5
NEW QUESTION # 42
......
Latest Questions C-HANADEV-18 Guide to Prepare Free Practice Tests: https://www.testpdf.com/C-HANADEV-18-exam-braindumps.html
C-HANADEV-18 Practice Exam - 95 Unique Questions: https://drive.google.com/open?id=1_nN7rzQO6ie4uOsUp5xkSIg9eLUENV-P
