What are the two different kinds of Identifiers used to represent names used in SQL statement? There are 2 correct answers to this question
A. Numeric identifiers
B. Limited identifiers
C. Delimited identifiers
D. Undelimited Identifiers
正解:C,D
質問 2:
You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data? There are 3 correct answers to this question.
A. Use a Comma-separated column list
B. Use the tilde symbol (-) to separate qualifier from column name
C. Use the UP TO n ROWS addition
D. Specify the database schema if it is not the user's default schema
E. Explicitly handle the client field
正解:A,D,E
質問 3:
Which of the following ABAP transactions can you use to detect SQL performance optimization potential in your ABAP code? 2 ans
A. SWLT
B. ST22
C. SQLM
D. SE09
E. SE3S
正解:A,C
質問 4:
HANA modeling views can be created under
A. File System
B. Catalog
C. Schema
D. Content
正解:D
質問 5:
What are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container? (2 right answers)
A. You need to refresh the content of the container manually
B. Changes to Delta Container
C. Take snapshot manually before releasing of the container
D. Automatic release of units
正解:A,C
質問 6:
How can you check if Core Data Services (CDS) views with scalar input parameters can be used in Open SQL queries in your system?
A. Check the Open SQL statement in the Explain SQL Statement transaction (SDBE).
B. Use the static method use_features of class cl_abap_dbfeatures.
C. Perform a static code check using the FUNCTIONAL_DB variant.
D. Check the value of the ABAP system field sy-cdsfeatures.
正解:B
質問 7:
What all are the steps to perform -To enable type-ahead for an input field on a screen? There are 3 correct answers to this question.
A. Switch on proposal search for input fields
B. Automatic updates of all the input fields
C. Identify Elementary Search Help
D. Check Pre-Requisites
E. Process on all the input fields
正解:A,C,D
質問 8:
Which of the following is latest release of SAP HANA?
A. SAP HANA 2.0 SPS 04
B. SAP HANA 1.0
C. SAP HANA 1.6 SP03
D. SAP HANA 1.0 SP06
正解:A
質問 9:
What are functions of the ABAP Managed Database Procedure (AMDP) framework? (2 right answers)
A. It deletes obsolete versions of the database procedure synchronously
B. It deletes obsolete versions of the database procedure asynchronously
C. It creates the database procedure when the AMDP is first called.
D. It creates the database procedure when the AMDP is first activated.
正解:B,C
Minase -
Pass4Testから提供されたこのE_HANAAW_17問題集一つで習得できました。今回は試験に受かりそうです。