Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

In application development with XS advanced, which of the following entities belong to a specific SPACE? There are 2 correct answers to this question.

A.

Organizations

B.

Users

C.

Applications

D.

Processes

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.

OSET

B.

ARRAY

C.

UNNEST

D.

UNSET

In an SQL Script procedure, which feature do you use to initialize IN/OUT table parameters? Please choose the correct answer.

A.

IS_EMPTY

B.

DEFAULT EMPTY

C.

DEFAULT

D.

SET

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.

A.

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.

B.

Create two entities for the user and address.

Create an association in the user entity to the address entity.

C.

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.

Extend the user entity with address columns.

D.

Create a view named User Details using select on the user entity.

x-s Create two entities for the user and address.

Create a User Details calculation view and join the user and address information.

Which parameters does the APPLY_FILTER function support? There are 2 correct answers to this question.

A.

Filter condition

B.

Join condition

C.

Entity set

D.

Table variable

Which join type is NOT supported by join optimization (pruning)? Please choose the correct answer.

A.

Outer Join

B.

Text Join

C.

Referential Join

D.

Inner Join

Which OData capacity do you use when you need to restrict the number or selection of exposed columns? Please choose the correct answer.

A.

Parameter entity sets

B.

Aggregation

C.

Key specification

D.

Property projection

Which SAP HANA system views contain information about the object ownership? There are 2 correct answers to this question.

A.

SCHEMAS

B.

TABLES

C.

OBJECTS

D.

ROLES

What are the main SAP HANA engines responsible for executing calculation views? There are 3 correct answers to this question.

A.

Java Engine

B.

XS Engine

C.

OLAP Engine

D.

Calculation Engine

E.

Join Engine

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/instance-manager

B.

@sap/xsenv

C.

@sap/hdbext

D.

@sap/node-vsi