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.

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_TABLEB . SET_PARAMC . EXECUTE_QUERYD . NEXT_PACKAGEView AnswerAnswer: D

January 4, 2021 No Comments READ MORE +

What are these transparent optimizations?

ABAP 7.4 provide support for optimizing ABAP applications running on SAP HANA. What are these transparent optimizations? (3 ans) A. Performance analysis tools have been improved B. Do all the data processing in Application server C. The consumption of SAP HANA artifacts was simplified D. Re-use components have been extended...

January 4, 2021 No Comments READ MORE +

SAP HANA DB Migration: you want to avoid any functional issues after the migration? There are 3 correct answers to this question.

SAP HANA DB Migration: you want to avoid any functional issues after the migration? There are 3 correct answers to this question.A . Native sql statementB . Direct access to a cluster on the databaseC . Left outer joins in open SQL statementsD . Order by clause in open SQL...

January 4, 2021 No Comments READ MORE +

The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question.

The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question.A . Avoid idiling CPU coresB . Avoid CPU cache missesC . Avoid optimizing dataD . Avoid single networkView AnswerAnswer: A,B

January 4, 2021 No Comments READ MORE +

Which is the new concept that is introduced and improved by using SAP HANA Specific Features? Please choose the correct answer.

Which is the new concept that is introduced and improved by using SAP HANA Specific Features? Please choose the correct answer.A . Programming modelB . Table bufferingC . New advanced SQL syntax ProceduresD . ABAP-Managed Database ProceduresView AnswerAnswer: D

January 4, 2021 No Comments READ MORE +

If the search options are enabled, you can set the search parameters for an attribute of a view, which parameters will be available?

What all are the factors involved in Working with ADT. If the search options are enabled, you can set the search parameters for an attribute of a view, which parameters will be available? There are 3 correct answers to this question.A . ABAP interfaceB . Module interfaceC . Workbench programsD...

January 3, 2021 No Comments READ MORE +

Which of the following objects must you create?

You developed an ABAP managed database procedure (AMDP). You want to allow the enhancement of this AMDP using business add-in (BADI). Which of the following objects must you create? There are 3 correct answers to this question.A . A BADI definitionB . A BADI fallback implementationC . An enhancement spotD...

January 3, 2021 No Comments READ MORE +

When would you use a column store table instead of a row store table? There are 2 correct answers to this question.

When would you use a column store table instead of a row store table? There are 2 correct answers to this question.A . When you require aggregation and analysis of valuesB . When the table has a small number of recordsC . When there are mainly distinct values in the...

January 3, 2021 No Comments READ MORE +

When to use Enhanced Open SQL? There are 2 correct answers to this question.

When to use Enhanced Open SQL? There are 2 correct answers to this question.A . To view scalar componentsB . At the time of Dictionary ViewsC . Need the query in one piece of code onlyD . To access system fieldsView AnswerAnswer: C,D

January 3, 2021 No Comments READ MORE +

What are these important features?

To upload data from flat files, SAP HANA offers several features. What are these important features? There are 2 correct answers to this questionA . The application suggests the column name and data type for the new tables, and it is possible to edit themB . The supported file types...

January 3, 2021 No Comments READ MORE +