Exam Questions and Answers for E_HANAAW_17 Study Guide Questions and Answers!
SAP Certified Development Specialist - ABAP for SAP HANA 2.0 Certification Sample Questions and Practice Exam
NEW QUESTION 90
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 91
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 92
Before migrating to SAP HANA, which Code Inspector check do you have to consider to avoid functional regressions?
- A. Use of the ADBC interface
- B. Standard Web Dynpro checks
- C. Search for DB operations across modularization units
- D. SELECT statements that bypass the table buffer
Answer: A
NEW QUESTION 93
What are the two types of editors available in ADT? There are 2 correct answers to this question.
- A. SAP (GUI)
- B. Client (native)
- C. ABAP (native)
- D. Eclipse (native)
Answer: A,D
NEW QUESTION 94
Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)? There are 3 correct answers to this question.
- A. ABAP test cockpit (transaction ATC)
- B. Data base performance monitor (transaction DB50)
- C. Code inspector (transaction SCI)
- D. SQL monitor (transaction SQLM)
- E. SQL Trace (transaction ST05)
Answer: A,C,D
NEW QUESTION 95
What are the different types of Calculation View? (2 answers)
- A. Graphical Calculation View
- B. Text-Based Calculation
- C. Scripted Calculation View
- D. OLAP Calculation View
Answer: A,C
NEW QUESTION 96
What is the operating system supported by HANA? (2 correct answers)
- A. Both Linux and Window 8
- B. SUSE Linux Enterprise Server
- C. Only Windows 8
- D. Red Hat Enterprise Linux (RHEL)
Answer: B,D
NEW QUESTION 97
When are referential joins executed in analytical views? Choose the correct answer
- A. When fields are optimized
- B. When fields from both the tables are requested
- C. When all the tables are optimized
- D. When fields are selected
Answer: B
NEW QUESTION 98
You use ABAP database connectivity (ADBC) to issue native SQL calls to the database, the native SQL call? Which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call? Please choose the correct answer.
- A. NEXT_PACKAGE
- B. SET_PARAM_TABLE
- C. EXECUTE_QUERY
- D. SET_PARAM
Answer: A
NEW QUESTION 99
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. Changes to Delta Container
- B. Automatic release of units
- C. Take snapshot manually before releasing of the container
- D. You need to refresh the content of the container manually
Answer: C,D
NEW QUESTION 100
What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster? There are 2 correct answers to this question
- A. High availability configuration
- B. Active clusters for all servers
- C. Services-Name and index server on all nodes
- D. Shared file systems for only one server
Answer: A,C
NEW QUESTION 101
What are the Functions of Transaction DBACOCKPIT There are 2 correct answers to this question.
- A. Maintain only HANA specific objects
- B. Used to access local or remote database system
- C. Maintain, Monitor and test secondary database connection
- D. Use Schema for the Connections
Answer: B,C
NEW QUESTION 102
You plan a database migration to SAP HANA and want to check your ABAP coding for performance optimization potential.
Which Code Inspector check variant can you use?
- A. PERFORMANCE_DB
- B. PERFORMANCE_OPT
- C. CHECK_PERFORMANCE
- D. FUNCTIONAL_DB
Answer: A
NEW QUESTION 103
What is the central goal of using SAP HANA? Please choose the correct answer
- A. Positive Impact on Business
- B. To set Priorities for system
- C. Accelerate Performance
- D. Monitor database for record keeping
Answer: C
NEW QUESTION 104
Which of the following ABAP transactions can you use to detect SQL performance optimization potential in your ABAP code? 2 ans
- A. SE09
- B. ST22
- C. SWLT
- D. SQLM
- E. SE3S
Answer: C,D
NEW QUESTION 105
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. Minimize the amount of transferred data
- B. Minimize the number of database accesses
- C. Keep unnecessary load away from the database.
- D. Minimize the search overhead.
Answer: A,B
NEW QUESTION 106
An Analytic Privilege consists of several restrictions. What are they? There 3 correct answers to this question
- A. Activity restrictions
- B. Analytic restrictions
- C. Cube restrictions
- D. Validity restrictions
- E. View restrictions
Answer: A,C,D
NEW QUESTION 107
Which of the following are classes of the ABAP Database Connectivity (ADBC) API? 2 ans
- A. CL_SQL_RESULT_SET
- B. CL_SQL_EXECUTE_QUERY
- C. CL_ADBC_SQL_STATEMENT
- D. CL_EXEC_SQL
- E. CL_SQL_STATEMENT
Answer: A,E
NEW QUESTION 108
What is the language SAP HANA is developed in?
- A. C++
- B. O
- C. Java
- D. Assembly
Answer: A
NEW QUESTION 109
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 110
In addition to closing the result set. what does the CLOSE method of the CL_SQL_RESULT_SET class when using ABAP Database Connectivity (ADBC) do? Please choose the correct answer.
- A. Release resources
- B. Update packages
- C. Update resources
- D. Update resources
Answer: A
NEW QUESTION 111
What are the steps that supported several tools, which in total result in a Guided Performance Optimization? There are 2 correct answers to this question.
- A. The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption
- B. Tools analyzing performance at run-time, to determine if critical constructs
- C. A new tool called SQL Monitor to determine the priority if different programs access the database intensively
- D. A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues.
Answer: B,C
NEW QUESTION 112
You changed an SAP HANA object that you transported using an SAP HANA Transport container. You want to release the transport request with your changes. In which sequence do you perform activities in the ABAP development system immediately before the release? Please choose the correct answer.
- A. Open the ABAP transport request Select take snapshot and Save
Activate the SAP HANA transport container - B. Open the SAP HANA transport containerSelect take snapshot and Save
Activate the SAP HANA Transport Container - C. Open the SAP HANA delivery unit Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container
- D. Open the package Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container
Answer: B
NEW QUESTION 113
Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question.
- A. ABAP Dictionary
- B. Open SQL
- C. Core data services (CDS) data definition
- D. Core data services (CDS) access control
Answer: B,D
NEW QUESTION 114
......
E_HANAAW_17 certification dumps - SAP Certified Development Specialist E_HANAAW_17 guides - 100% valid: https://www.examdumpsvce.com/E_HANAAW_17-valid-exam-dumps.html
