What are these sub-languages?

Open SQL largely standardized, three sub-languages. What are these sub-languages? There are 3 correct answers to this questionA . Data Evaluation Language (DEL)B . The Data Definition Language (DDL)C . Data Transferring Language (DTL)D . The Data Control Language (DCL)E . Data Manipulation Language (DML)View AnswerAnswer: B,D,E

May 11, 2021 No Comments READ MORE +

Why is a security concept in SAP HANA required? There are 2 correct answers to this question

Why is a security concept in SAP HANA required? There are 2 correct answers to this questionA . Need to have selected users in SAP HANA for Information ManagementB . Access to ERP tables must be restrictedC . Editing of SAP HANA data models should only be possible for "Users"...

May 10, 2021 No Comments READ MORE +

What is the scope of the AbapCatalog.Buffering annotation in a Core Data Services (CDS) view?

What is the scope of the AbapCatalog.Buffering annotation in a Core Data Services (CDS) view?A . The set of key fields specified in the additional annotation AbapCatalog.buffering.numberOfKeyFieB . The CDS views used in the FROM clauseC . The entire CDS viewD . The elements in the projection list of the...

May 10, 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

May 10, 2021 No Comments READ MORE +

How can you exchange SQL Monitor data between two systems?

How can you exchange SQL Monitor data between two systems?A . Create a snapshot of the SQL Monitor data, export it to the file system, and then import it to the target system.B . Deactivate the SQL Monitor in the source system and activate the SQL Monitor in the target...

May 9, 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 procedureB . Two result setsC . One result setD . As many result...

May 9, 2021 No Comments READ MORE +

Explain the Enterprise Information System of- SAP HANA Implementation Scenarios? There are 3 correct answers to this question

Explain the Enterprise Information System of- SAP HANA Implementation Scenarios? There are 3 correct answers to this questionA . HANA AcceleratorsB . All HANA Combinations on one platformC . HANA ModelingD . All SAP applications on one SAP HANA platformE . Business Suite on HANA/ BW on SAP HANAView AnswerAnswer:...

May 9, 2021 No Comments READ MORE +

Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)?

Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)?A . Existence check for secondary indexesB . Use of Native SQL and DB HintsC . Missing ORDER BY or SORT after SELECTD . Direct access to table pools/clusterView AnswerAnswer: C

May 8, 2021 No Comments READ MORE +

Which of the following ABAP language elements are mandatory for the implementation of a method as an ABAP Managed Database Procedure? 3 ans

Which of the following ABAP language elements are mandatory for the implementation of a method as an ABAP Managed Database Procedure? 3 ansA . FOR db (db = HDB . ..)C . LANGUAGE dbjang (dbjang = SQLSCRIPD . ..)E . BY DATABASE PROCEDUREF . CLIENT SPECIFIEDG . AUTHORIZATION db_auth (db_auth...

May 8, 2021 No Comments READ MORE +

Which Of the Golden Rules for Open SQL performance have become more important With SAP HANA? Note: There are 2 correct answers to this question.

Which Of the Golden Rules for Open SQL performance have become more important With SAP HANA? Note: There are 2 correct answers to this question.A . Keep unnecessary load away from the database.B . Minimize the number of database accessesC . Minimize the amount of transferred dataD . Minimize the...

May 7, 2021 No Comments READ MORE +