Which SQL syntax is used to create a read only procedure?
A. READS SQL DATA
B. READS PROCEDURE
C. NO-SIDE-EFFECT
D. READ-ONLY
Which functional problem can you detect when using the Runtime Check Monitor (SRTCM )?
A. Existence check for secondary indexes
B. Use of Native SQL and DB Hints
C. Missing ORDER BY or SORT after SELECT
D. Direct access to table pools/cluster
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 procedure
B. Two result sets
C. One result set
D. As many result sets as there are table output parameters in the procedure
Open SQL largely standardized, three sub-languages. What are these sub-languages? There are 3 correct answers to this question
A. 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)
What you must do when you define and implement an ABAP Managed Database Procedure AMDP? There are 3 correct answers to this question.
A. Define all the method parameters to pass by value
B. List all the ABAP dictionary tables used in the procedure body in the USING clause
C. Use Scalar types for all the AMDP method parameters
D. Specify the database system and language
E. Mark the AMDP method as read-only
Which option in SAP NetWeaver Gateway Service Builder (transaction SEGW) can be used to implement the consumption of a Core Data Services view?
A. "Map to Data source"
B. "Consume CDS view"
C. "Relate to Business Entity"
D. "Read from DDL source"
An Analytic Privilege consists of several restrictions. What are they? There 3 correct answers to this question
A. View restrictions
B. Analytic restrictions
C. Validity restrictions
D. Activity restrictions
E. Cube restrictions
Which system schema contains the list of Activated and inactive Objects? 2 answers
A. Used to access local or remote database system
B. Maintain, Monitor and test secondary database connection
C. Use Schema for the Connections
D. Maintain only HANA specific objects
What are the two types of editors available in ADT? There are 2 correct answers to this question.
A. Eclipse (native)
B. Client (native)
C. SAP (GUI)
D. ABAP (native)
What is the operating system supported by HANA? (2 answers)
A. Only Windows 8
B. Red Hat Enterprise Linux (RHEL)
C. SUSE Linux Enterprise Server
D. Both Linux and Window 8
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only SAP exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your E_HANAAW_17 exam preparations and SAP certification application, do not hesitate to visit our Vcedump.com to find your solutions here.