Updated Oct-2021 Test Engine to Practice Test for E_HANAAW_16 Exam Questions and Answers!
SAP Certified Development Specialist - ABAP for SAP HANA 2.0 Certification Sample Questions and Practice Exam
NEW QUESTION 70
Explain Transitioning ABAP Code to SAP HANA - Performance Considerations? There are
3 correct answers to this question.
- A. Classical performances recommendations for open SQL remain valid
- B. Some codes transferred to other systems
- C. Some codes immediately run faster
- D. Some codes impacted positively and should be priorities
- E. Some shifts in priorities, examples, nested selects(higher) indices(lower)
Answer: A,C,E
NEW QUESTION 71
What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question.
- A. A new and advanced Open SQL
- B. Buffer system services
- C. Advanced and specific models
- D. Core Data services
Answer: A,D
NEW QUESTION 72
You perform a static code check using the Code Inspector (SCI). In your SCI variant, you select the Search problematic SELECT * statement check. What does this check report? Please choose the correct answer.
- A. SELECT * statements on tables with more than 100,000 records
- B. SELECT * statements on tables with the Column Store storage type
- C. SELECT * statements on tables with more than a specified number of fields
- D. SELECT * statements where fewer than a specified percentage of all fields are effectively used
Answer: D
NEW QUESTION 73
Which of the following objects can you use in the ABAP layer when using the top-down approach to bring code to data? There are 2 correct answers to this question
- A. ABAP managed database procedures
- B. Stored procedure
- C. Core data services views
- D. Calculation views
Answer: A,C
NEW QUESTION 74
Name some perspectives that are available in the SAP HANA Studio? (3 ans)
- A. The Resources perspective
- B.
- C. The technology & innovation perspective
- D.
- E. The SAP HANA Modeler Perspective
Answer: A,D,E
NEW QUESTION 75
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 76
What is the main purpose of Analytic Privilege?
- A. Restrict row level access so that user will be able to see only certain portion of the data
- B. Restrict users to access database tables
- C. Restrict user to access modeling view
Answer: A
NEW QUESTION 77
In an ABAP Core Data services (CDS) view, what must you do expose an association for use in another CDS view? Please choose the correct answer.
- A. Include all fields used in the ON condition in projection list
- B. Specify an alias for the target entity
- C. Specify the other views in which the association can be used
- D. Define the cardinality for the target entity
Answer: A
NEW QUESTION 78
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 79
What are the benefits associated with The SAP HANA real-time Operational analytics?
There are 2 correct answers to this question
- A. Query Speed support
- B. Fast insights into business activity
- C. Simplification of massive data
- D. High modeling flexibility
Answer: B,D
NEW QUESTION 80
You import an ABAP workbench request into a SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package 2HA400_00. WHICH PREREQISITIES are mandatory for an implicit deployment of the SAP HANA view onto the database? There are 2 correct answers to this question.
- A. PACKAGE ZHA400J30 HAS deployment Mode A
- B. View CA_CUSTOMER has deployment mode A.
- C. Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK
- D. SYSTEM P81 has SAP HANA has primary database
Answer: C,D
NEW QUESTION 81
What are the supported joins in CDS view? There are 2 correct answers to this question.
- A. Injection
- B. Operators join
- C. Upper join
- D. Left outer join
Answer: A,D
NEW QUESTION 82
What are the features associated with ABAP CDS? (3 Ans) There are 3 correct answers to this question.
- A. Read
- B. Create
- C. Delete/Edit Table
- D. Update
Answer: A,B,D
NEW QUESTION 83
Discuss different types of engines associated with The SAP HANA architecture? There are 2 correct answers to this question
- A. Join engine
- B. OPAX engine
- C. OLAP engine
- D. Analytic engine
Answer: A,C
NEW QUESTION 84
What are the different types of Variables in HANA? (3 right answers)
- A. Interval
- B. Single Value
- C. Double
- D. Range
Answer: A,B,D
NEW QUESTION 85
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 86
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 87
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 88
You are implementing an ABAP Managed Database Procedures (AMDP) for SAP HANA. What do you have to do in the corresponding ABAP class? Please choose the correct answer.
- A. Set the visibility of the corresponding class method in the declaration section to PUBLIC.
- B. Implement the interface IF_AMDP_MARKER_HDB.
- C. Implement the ABAP AMDPJHDB Event Handler.
- D. Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB.
Answer: B
NEW QUESTION 89
What is the main purpose of SAML for SAP HANA Studio? Choose the correct answer
- A. The SAP HANA database supports login of Owners only
- B. The assertion is issued by a user after the client was successfully authenticated
- C. To support scenarios where clients are not directly connected to the SAP HANA Database
- D. SAML may be selected as an Owner's authentication method when creating users in the SAP HANA Studio
Answer: C
NEW QUESTION 90
How will you select a preference for Validation rules? Choose the correct answer
- A. Windows- Modeler- Preferences-SAP HANA-Validation Rules
- B. Windows- Preferences-SAP HANA-Modeler-Validation Rules
- C. Windows- SAP HANA-Modeler-Preferences-Validation Rules
- D. Windows- SAP HANA-Preferences-Modeler-Validation Rules
Answer: B
NEW QUESTION 91
How can you exchange SQL Monitor data between two systems?
- A. Deactivate the SQL Monitor in the source system and activate the SQL Monitor in the target system.
- B. Create a snapshot of the SQL Monitor data, export it to the file system, and then import it to the target system.
- C. Create and release a transport request containing the SQL Monitor log files.
- D. Configure a secondary database connection to the target system and query the data in the SQL Monitor.
Answer: B
NEW QUESTION 92
......
Certification dumps SAP Certified Development Specialist E_HANAAW_16 guides - 100% valid: https://www.realvalidexam.com/E_HANAAW_16-real-exam-dumps.html
