E_HANAAW_17 Online Practice Questions and Answers

Which data sources can you use for SAP list viewer with integrated data access? There are 3 correct answers to this question.

A. CDS View

B. Database procedure

C. External view

D. Database Table

E. Internal table

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

Which Code Inspector check variant can you use?

A. PERFORMANCE_OPT

B. CHECK_PERFORMANCE

C. FUNCTIONAL_DB

D. PERFORMANCE_DB

Which code-to-data capability is responsible for the Optimizations and Translation of "Open SQL SELECT FOR ALL ENTRIES clauses into native SQL?. Please choose the correct answer.

A. Database Optimization

B. Transparent Optimizations

C. HANA Specific features

D. Buffer system Optimization

What are the different types of Calculation View? (2 answers)

A. OLAP Calculation View

B. Graphical Calculation View

C. Scripted Calculation View

D. Text-Based Calculation

In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog? Which of the following table types fulfill this requirement? Please choose the correct answer.

A. ROW

B. GLOBAL TEMPORARY

C. COLUMN

D. LOCAL TEMPORARY

You have defined the following SQLScript procedure: CREATE PROCEDURE LANGUAGE SQLSCRIPT

SQL SECURITY DEFINER READS SQL DATA.

Which type of database procedures can be called in this SQLScript procedure? Please choose the correct

answer.

A. Read-write

B. Read only

C. Write only

D. Read-update

What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? There are 2 correct answers to this question.

A. All arithmetic expressions can be used for all type of variables

B. All ABAP variables must be escaped with a proceeding @ sign.

C. All Keywords are case sensitive.

D. All fields in the GROUP BY clause must be separated by commas.

Which of the following are classes of the ABAP Database Connectivity (ADBC) API? 2 answers

A. CL_SQL_EXECUTE_QUERY

B. CL_SQL_RESULT_SET

C. CL_SQL_STATEMENT

D. CL_EXEC_SQL

E. CL_ADBC_SQL_STATEMENT

Which of the following is latest release of SAP HANA?

A. SAP HANA 1.0 SP06

B. SAP HANA 1.0

C. SAP HANA 1.6 SP03

D. SAP HANA 2.0 SPS 04

AM DP can detect 3 types of syntax errors in active or inactive source code. What are these errors ? There are 3 correct answers to this question.

A. UNION specific syntax errors

B. Database platform syntax errors

C. Database independent syntax errors

D. HANA specific syntax errors

E. SQLScript errors