Interview Questions.

Q1. What Is Hana Cds? What Are The Artifacts We Can Create Using Cds?

Core Data Services (CDS) artifacts are design-time definitions. When CDS document is activated, it generate runtime gadgets.

CDS can be used to create following database artifacts:

Create a desk (entity)

Create an SQL views

Create an affiliation between entities or views

Create a consumer-defined dependent kind

Q2. Can We Call An Xsjslib From Another Xs Project?

Yes. XSJS library (xsjslib) may be known as from some other XS undertaking or another bundle.

Q3. How Can We Create A Job And Schedule It In Hana?

With the help of XSJs report, we will run a provider (for example, an XS JavaScript or a SQLScript) at a scheduled c language.

We first need to define the provider either in XSJS or in SQLScript system. Then we are able to create XSJob report and mention the carrier info at the side of time interval. Finally from HANA Admin tool we can activate the activity.

Q4. What Is The Purpose Of Xsaccess File In Hana Xs Project?

The utility-get right of entry to (.Xsaccess) record enables you to specify who or what's authorized to access the content material exposed through the application package and what content material they're allowed to look.

The application-get right of entry to file does now not have a name before the dot (.); it only has the record extension .Xsaccess. The contents of the .Xsaccess report should be formatted in line with JavaScript Object Notation (JSON) regulations.

Example of .Xsaccess document:

"uncovered" : real,

"authentication" :  "technique" : "Form"

Q5. What Is The File Extension Of Xsjs Library?

File extension of XSJS library is .Xsjslib

Q6. What Is Benefit Of Xodata Compared To Xsjs?

In HANA XSOData, there's a OData framework which provide many functionalities and we best want to offer information like facts source, affiliation and so forth. This may be very beneficial for developers as coding effort is sort of zero. OData framework additionally takes care of security factors like SQL injection, XSRF etc.

While in XSJS, we want to code the entirety our personal. This consequences into more coding effort. We also need to attend to security elements, performance and so on.

Q7. How Can We Create An Xsodata Service Which Only Allows To Read Data But Prevents Any Insert/update/delete Operation?

This may be done with the “forbidden” command. For example:

service 

"mySchema"."myTable" as "MyTable"

create forbidden

replace forbidden

delete forbidden;

Q8. What Are The Different Web-primarily based Tools Available In Hana Xs? How Do We Access Them?

There are in particular 4 XS Web-primarily based tools:

Editor: Inspect, create, change, delete and activate SAP HANA repository gadgets.

Catalog: Create, edit, execute and manipulate SQL catalog artifacts within the SAP HANA database.

Security: Manage users and roles.

Trace: View and down load SAP HANA hint documents and set trace degrees (as an example, info, blunders, debug).

The URL to access these equipment is: http://<WebServerHost>:80<SAPHANAinstance>/sap/hana/xs/ide.

Q9. What Is Sap Hana Xs Engine?

XS Engine is a JavaScript software server based totally at the Mozilla Spider Monkey engine. The predominant idea of SAP HANA XS is to embed a complete featured utility server, web server, and improvement environment within the SAP HANA appliance itself.

Important points approximately SAP HANA XS:

XS is a Small footprint utility server / web server.

It is the idea for an application improvement platform interior SAP HANA.

It simplifies architecture and lowers the TCO (general price of operation).

It affords clean access to SAP HANA database thru HTTP-based intake.

Q10. Is It Possible To Call An External Service From Internet In Xs Application? If Yes, Then How?

Yes, we will name an external service from Internet. This may be performed with HTTP Destination (xshttpdest).

We first need to create an HTTP Destination document and provide the information of external carrier along with other safety and proxy information. Then we are able to name this vacation spot from XSJS the usage of $.Net.Http.ReadDestination API.

Q11. Suppose We Want To Create An Xs Application And Want To Make It Public. User Should Not Need Any Hana Database User To Access This Application. Is It Possible? If Yes, How?

In .Xsaccess file, we are able to set the authentication to null. After this each person can open the utility without consumer identity and password.

Q12. Can We Call An Http Destination From An Xsjs If Http Destination Is In A Different Package?

No. We have to maintain the HTTP vacation spot configuration in the identical package because the utility that uses it. An software can not reference an HTTP vacation spot configuration this is positioned in any other utility bundle.