What is the main function of Static Code Analysis? Please choose the correct answer.
A. To detect code that would lead to functional or performance issues When migrating to SAP HANA
B. Integrates with SAP Solution Manager
C. Integrated into ABAP Development Tools and ABAP Workbench
D. ABAP source code with performance optimization potential
Which of the below statements are true for SAP HANA Studio? (3 answers)
A. SAP HANA Studio can be used to manage the SAP HANA database, to create and manage user authorizations, to create new or modify existing models of data etc
B. SAP HANA Studio is an Eclipse-based, integrated development environment (IDE) that is used to develop artifacts in a HANA server.
C. SAP HANA Studio is a client tool, which can be used to access local or remote HANA system.
D. SAP HANA Studio is integrated in SAP GUI > 7.40
How can you consume a Core Data Services (CDS) view? 2 answers
A. Use the Data Preview in ABAP Development Tools for SAP NetWeaver.
B. Use it as a data source in the FROM clause of an Open SQL query.
C. Use the ABAP language statement WRITE and the CDS view name as the argument.
D. Use the CDS maintenance transaction (SCDSV).
You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias? There are 3 correct answers to this question.
A. CASTE Expression
B. CASE expression
C. Currency Conversion
D. Nested CASE expression
E. Unit conversion
You want to move some of the logic of an ABAP program into an ABAP-managed database procedure (AMDP). To do so, you need to translate Open SQL statements into SAP HANA Native SQL. Which of the following are necessary adjustments? Note: There are 3 correct answers to this question.
A. Replace UP TO n ROWS additions
B. Specify the schema for every table
C. Replace ORDER BY additions
D. Replace CORRESPONDING FIELDS additions
E. Add explicit client handling
Which conditional expressions can be used in Core Data Services (CDS) views? 2 answers
A. CASE statements in the projection list
B. IF statements in the projection list
C. WHILE statements in the WHERE clause
D. COALESCE functions in the projection list
E. CASE statements in the HAVING clause
In ADT which setting below to a specific project rather than the entire workbench. Choose the correct answer
A. Code completion option
B. Statement Template options
C. Editor shortcut options
D. Code formatting option
Which of the following ABAP transactions can you use to detect SQL performance optimization potential in your ABAP code? 2 answers
A. SQLM
B. SE09
C. SWLT
D. ST22
E. SE3S
Which SAP HANA engine executes Calculation view? (2 answers)
A. OLAP Engine
B. Calculation Engine
C. SQL Engine
D. JOIN Engine
What are the Perspectives and Views of SAP HANA Studio? There are 2 correct answers to this question.
A. Open system properties
B. Administration console
C. Development properties
D. System Properties
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_18 exam preparations and SAP certification application, do not hesitate to visit our Vcedump.com to find your solutions here.