E_HANAAW_17 exam

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

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"...

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

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

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

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

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:...

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

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

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