To comply with the SAP Fiori principles, which view type is recommended by SAP?

A. JSON

B. XML

C. HTML

D. JavaScript

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.

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

Which development environment does SAP recommend to develop an SAP HANA extended application services; advanced model (XS advanced) multi-target application?

A. SAP HANA studio

B. ASAP development tools

C. SAP web IDE for SAP HANA

D. SAP HANA Web-based Development Workbench

You need to check user input data in your OData request. Which exit type do you use?

A. Consistency

B. Modification

C. Verification

D. Validation

You create a simple data model 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?

A. Create two entities for the user and address. Extend the user entity with address columns. Create a view named User Details using select on the user entity.

B. Create two entities for the user and address. Create a User Details calculation view and join the user and address information.

C. Create two entities for the user and address. Create an association in the user entity to the address O entity. Define a User Details view using select on the address entity and using the association to read the user information.

D. Create two entities for the user and address. Create an association in the user entity to the address O entity. Define a User Details view using select on the user entity and using the association to read the address information.

What are some of the benefits of developing applications on SAP HANA? Note: There are 2 correct answers to this question.

A. Execution of stored procedures is faster due to the in-memory database.

B. Reliable segregation of OLAP and OLTP workloads on different SAP HANA databases.

C. Faster response times by using SAP HANA integrated UI rendering.

D. HTML5-compliant Web-based user interface is supported.

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

What are the key characteristics of the calculation view's Input Parameter? There are 3 correct answers to this question.

A. It can NOT be used to filter measure values.

B. It can be used in a conditional expression.

C. It can be used to pass values to table functions.

D. It is passed via reserved word PLACEHOLDER.

E. It is passed using a WHERE clause.

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 column

D. In a procedure

E. In a table function

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

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. Keep flag

B. Transparent filter

C. Dynamic join

D. Non-equijoin

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

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

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