[Oct-2021] E_HANAAW_17 Dumps Full Questions - SAP Certified Development Specialist Exam Study Guide
Exam Questions and Answers for E_HANAAW_17 Study Guide
NEW QUESTION 19
Which data sources can you use for SAP list viewer with integrated data access? There are 3 correct answers to this question.
- A. External view
- B. Internal table
- C. Database Table
- D. Database procedure
- E. CDS View
Answer: A,C,E
NEW QUESTION 20
Which character is used to escape host variables in the new Open SQL syntax?
- A. @ (at)
- B. : (colon)
- C. ~ (tilde)
- D. * (asterisk)
Answer: A
NEW QUESTION 21
One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any functional issues after the migration. What should you search for and if necessary replace in the existing custom ABAP code? There are 3 correct answers to this question.
- A. Direct access to a cluster on the database
- B. Code that relies on implicit database sorting
- C. ORDER BY Clauses in Open SQL statements
- D. Native SQL statements
- E. Left outer joins in open SQL statements
Answer: A,B,D
NEW QUESTION 22
Which system schema/user is the owner of all the activated objects?
- A. _SYS_BI
- B. _SYS_REP0
- C. _SYS_BIC
- D. _SYS_XS
Answer: B
NEW QUESTION 23
What are the advantages of column based tables? (3 correct answers)
- A. Faster Data Access
- B. Better parallel Processing
- C. Better Compression
- D. Bigger Data Set
Answer: A,B,C
NEW QUESTION 24
Which recent software innovations are applied in SAP HANA? 3 ans
- A. Automated de-installation at system shutdown
- B. Improved data compression algorithms
- C. Random Undefined Multi-Memory Swapping (RUMMS)
- D. Columnar data storage
- E. Insert Only approach
Answer: B,D,E
NEW QUESTION 25
What is the scope of the AbapCatalog.Buffering annotation in a Core Data Services (CDS) view?
- A. The elements in the projection list of the CDS view
- B. The entire CDS view
- C. The CDS views used in the FROM clause
- D. The set of key fields specified in the additional annotation AbapCatalog.buffering.numberOfKeyFie
Answer: B
NEW QUESTION 26
Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does NOT Offer? There are 2 correct answers to this question.
- A. Configuration of check variants
- B. Enhanced distribution of results
- C. Documented checks
- D. Flexible schedule of check runs
Answer: B,D
NEW QUESTION 27
For which purpose can you use literal values in an Open SQL statement?
- A. To provide a default value for a database table column
- B. To perform a generic existence check
- C. To alias the result of an arithmetic expression
- D. To comment your development directly in the coding
Answer: B
NEW QUESTION 28
You plan a database migration to SAP HANA and want to check your ABAP coding for potential functional regressions.
Which Code Inspector check variant can you use?
- A. PREV_FUNC_REG
- B. FUNCTIONAL_CHECK
- C. FUNCTIONAL_DB
- D. PERFORMANCE DB
Answer: C
NEW QUESTION 29
Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question.
- A. Perform all calculations and aggregations in the ABAP layer
- B. Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES
- C. Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement
- D. Use array variants of INSERT UPDATE MODIFY and DELETE
Answer: B,D
NEW QUESTION 30
Where can you consume associations in a Core Data Services (CDS) view? 3 ans
- A. In the FROM clause
- B. In the WHERE and HAVING clauses
- C. In the input parameter list
- D. In the projection list
- E. In the name list
Answer: A,B,D
NEW QUESTION 31
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. Identify Elementary Search Help
- B. Process on all the input fields
- C. Check Pre-Requisites
- D. Switch on proposal search for input fields
- E. Automatic updates of all the input fields
Answer: A,C,D
NEW QUESTION 32
Your ABAP program contains an Open SQL join of two client-dependent tables. You want to replace this with a native SQL SELECT statement. Which of the following changes to the SELECT statement can you use to retrieve the same data as before?
There are 2 correct answers to this question
- A. Use the CLIENT SPECIFIED addition.
- B. Include the client field in the join condition.
- C. Include the client field in the field list.
- D. Include the client field in the WHERE condition.
Answer: B,D
NEW QUESTION 33
You follow the Code-to-Data paradigm in your ABAP coding.
Which of the following scenarios conflicts with the SQL performance guideline "Keep unnecessary load away from the database"?
- A. Perform calculations on data transferred to the database layer, then transfer the results back to the application layer.
- B. Perform join operations on database tables, then transfer the results to the application layer.
- C. Perform business logic and aggregations on database table content, then transfer the results to the application layer.
- D. Perform text search operations on database table content, then transfer the results to the application layer.
Answer: A
NEW QUESTION 34
Which components can be a part of a calculation view? (2 answers)
- A. Tables
- B. Analytic View
- C. BAPIs
- D. Attribute View
Answer: A,D
NEW QUESTION 35
Which of the following ABAP language elements are mandatory for the implementation of a method as an ABAP Managed Database Procedure? 3 ans
- A. AUTHORIZATION db_auth (db_auth = SYSTEM ...)
- B. LANGUAGE dbjang (dbjang = SQLSCRIPT...)
- C. FOR db (db = HDB...)
- D. CLIENT SPECIFIED
- E. BY DATABASE PROCEDURE
Answer: B,C,E
NEW QUESTION 36
......
SAP Certified Development Specialist - ABAP for SAP HANA 2.0 Free Update With 100% Exam Passing Guarantee: https://www.itcertmagic.com/SAP/real-E_HANAAW_17-exam-prep-dumps.html
Real Exam Questions & Answers - SAP E_HANAAW_17 Dump is Ready: https://drive.google.com/open?id=1nqYJJ8S9CTKyzByFZnOHNi3pe-CSE1Ua