Why do you create a row store instead of a column store Please choose the correct answer?

You create a new table definition using the ABAP Dictionary and maintain the database-specific technical settings table? Why do you create a row store instead of a column store Please choose the correct answer?A . To allow creation of a full-text indexB . To limit the unpacking and reconstruction of...

January 7, 2021 No Comments READ MORE +

What are the key points that should be kept in mind while performing the Non-automatic update in SAP HANATr.Cont.? There are 2 correct answers to this question.

What are the key points that should be kept in mind while performing the Non-automatic update in SAP HANATr.Cont.? There are 2 correct answers to this question.A . Automatic release of unitsB . Changes to Delta ContainerC . You need to refresh the content of the container manuallyD . Take...

January 7, 2021 No Comments READ MORE +

What are the Parameters for Analytical and Calculation view? There are 3 correct answers to this question.

What are the Parameters for Analytical and Calculation view? There are 3 correct answers to this question.A . Specifying unit of measurementB . Passing other values to be used in calculationsC . Create a copy of a reportD . To store data for critical analysisE . Setting a filter for...

January 6, 2021 No Comments READ MORE +

Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question.

Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question.A . ABAP DictionaryB . Open SQLC . Core data services (CDS) data definitionD . Core data service (CDS) access controlView AnswerAnswer: B,D

January 6, 2021 No Comments READ MORE +

What are the elements of ABAP Database Integration? There are 3 correct answers to this question.

What are the elements of ABAP Database Integration? There are 3 correct answers to this question.A . Client database handlingB . Application serverC . DB client-serverD . Other DBE . DB For ABAPView AnswerAnswer: B,D,E

January 6, 2021 No Comments READ MORE +

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

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 viewC . You...

January 5, 2021 No Comments READ MORE +

What are these technologies?

The SAP HANA database is a hybrid in-memory database that combines Few technologies within. What are these technologies? There are 3 correct answers to this questionA . Row-based database technologyB . Time-based database technologyC . Column-based database technologyD . Object-based database technologyE . Value-based database technologyView AnswerAnswer: A,D,E

January 5, 2021 No Comments READ MORE +

Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question.

Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question.A . Use SELECT FOR ALL ENTRIES instead of a nested SELECT statementB . Use array variants of INSERT UPDATE MODIFY and DELETEC . Use a nested SELECT...

January 5, 2021 No Comments READ MORE +

When are referential joins executed in analytical views? Choose the correct answer

When are referential joins executed in analytical views? Choose the correct answerA . When all the tables are optimizedB . When fields are selectedC . When fields are optimizedD . When fields from both the tables are requestedView AnswerAnswer: D

January 5, 2021 No Comments READ MORE +

How many result sets are returned when an SAP HANA database procedure is called using the CALL WITH OVERVIEW statement? Please choose the correct answer.

How many result sets are returned when an SAP HANA database procedure is called using the CALL WITH OVERVIEW statement? Please choose the correct answer.A . As many result sets as there are input parameters in the procedurB . Two result setsC . One result setD . As many result...

January 5, 2021 No Comments READ MORE +