File Info
| Exam | SAP Certified Development Specialist - ABAP for SAP HANA 2.0 |
| Number | E_HANAAW_16 |
| File Name | SAP.E_HANAAW_16.Pass4Test.2020-11-23.195q.vcex |
| Size | 95 KB |
| Posted | Nov 23, 2020 |
| Download | SAP.E_HANAAW_16.Pass4Test.2020-11-23.195q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
Which JOIN types can be used in the definition of a Core Data Services (CDS) view? 2 ans
- LEFT OUTER JOIN
- CROSS JOIN
- FULL OUTER JOIN
- RIGHT OUTER JOIN
- REFERENTIAL JOIN
Correct answer: AD
Question 2
Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)? Please choose the correct answer.
- Combine information from static ABAP code scans with runtime data from the SQL Monitor.
- Create a graph comparing the runtimes of ABAP code before and after optimization.
- Estimate the new total runtime of optimized code.
- Combine information from static ABAP code scans with runtime data from the SQL Trace tool.
Correct answer: A
Question 3
What is the main purpose of SAML for SAP HANA Studio? Choose the correct answer
- The SAP HANA database supports login of Owners only
- To support scenarios where clients are not directly connected to the SAP HANA Database
- The assertion is issued by a user after the client was successfully authenticated
- SAML may be selected as an Owner's authentication method when creating users in the SAP HANA Studio
Correct answer: B
Question 4
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.
- CASTE Expression
- CASE expression
- Currency Conversion
- Nested CASE expression
- Unit conversion
Correct answer: BCE
Question 5
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.
- Documented checks
- Enhanced distribution of results
- Configuration of check variants
- Flexible schedule of check runs
Correct answer: BD
Question 6
Discuss the conditions required to ensure the Referential Integrity? There are 2 correct answers to this question
- There are three joins in the table
- Referential integrity holds true in both the directions
- There is at least one join in the other table
- There are two joins in the table
Correct answer: BC
Question 7
You execute a Native SQL query statement to retrieve a list of information using the corresponding ABAP Database Connectivity (ADBC) API method.
Which additional steps are necessary to retrieve the result set into an internal table? 2 ans
- Close the CL_SQL_STATEMENT object to release the resources.
- Use an Open SQL query that uses the JOIN between the result set and the internal table as a data source.
- Bind a reference to the internal table as an output parameter to the CL_SQL_RESULT_SET instance.
- Fetch the result using the next_package method of class CL_SQL_RESULT_SET.
- Fetch the result using the fetch method of class CL_SQL_EXECUTE.
Correct answer: CD
Question 8
What all are the Types of Applications based on SAP HANA? There are 2 correct answers to this question.
- Server based on SAP HANA
- Innovation based on SAP HANA
- New or Native SAP HANA
- Data Mart based on SAP HANA
Correct answer: CD
Question 9
What are the basic principles of ALV SAP HANA? There are 2 correct answers to this question.
- Data described declaratively instead of passing big internal tables
- The ALV Optimization for SAP HANA to display data on the screen
- Only retrieve the database data which is to be displayed on screen
- To ensure that the user chooses the data on the selection screen is displayed
Correct answer: AC
Question 10
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.
- Include all fields used in the ON condition in projection list
- Specify an alias for the target entity
- Define the cardinality for the target entity
- Specify the other views in which the association can be used
Correct answer: A
