E_HANAAW_17 Online Practice Questions and Answers

You use ABAP database connectivity (ADBC) to issue native SQL calls to the database, the native SQL

call.

Which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native

SQL call? Please choose the correct answer.

A. SET_PARAM_TABLE

B. SET_PARAM

C. EXECUTE_QUERY

D. NEXT_PACKAGE

What do you understand by the SAP HANA Software Optimization? Please choose the correct answer.

A. Speed up the processing within the database

B. Bring logic to where the data is calculated first then only move to results

C. Provide combinations of objects and partitioning

D. Huge potential for hybrid database

Which system schema/user is the owner of all the activated objects?

A. _SYS_XS

B. _SYS_BI

C. _SYS_REP0

D. _SYS_BIC

List down the elements involved in User Management and Security in SAP Hana? There are 3 correct answers to this question

A. Manage users

B. Assign Job security

C. Assign security

D. Work Management

E. Create users

You plan a database migration to SAP HANA and want to check your ABAP coding for potential functional

regressions.

Which Code Inspector check variant can you use?

A. PREV_FUNC_REG

B. FUNCTIONAL_DB

C. FUNCTIONAL_CHECK

D. PERFORMANCE DB

What all are the Types of Applications based on SAP HANA? There are 2 correct answers to this question.

A. Server based on SAP HANA

B. Innovation based on SAP HANA

C. New or Native SAP HANA

D. Data Mart based on SAP HANA

Which of the following is a limitation when you create an external view? Please choose the correct answer.

A. You must include the name of the SAP HANA view in the name of the external view.

B. You can only use native SQL to consume the external view

C. You must know the underlying tables and join conditions of the SAP HANA view.

D. You must use the ABAP Development tools (ADT) TO CREATE the external view

Which components can be a part of a calculation view? (2 answers)

A. BAPIs

B. Analytic View

C. Tables

D. Attribute View

You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias?

There are 3 correct answers to this question.

A. CASTE Expression

B. CASE expression

C. Currency Conversion

D. Nested CASE expression

E. Unit conversion

Which character is used to escape host variables in the new Open SQL syntax?

A. * (asterisk)

B. @ (at)

C. : (colon)

D. ~ (tilde)