You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter on the right-hand side of an assignment operator within the procedure.
How do you refer to the parameter?
Please choose the correct answer. @it_books :it_books {it_books} it_books.
Why is a security concept in SAP HANA required?
There are 2 correct answers to this question. Editing of SAP HANA data models should only be possible for “Users.” of the model Database administration should be restricted to skilled Need to have selected users in SAP HANA for Information Management Access to ERP tables must be restricted.
What should you do to follow the code-to-data approach to programming?
There are 3 correct answers to this question. Transfer all data from the database to the ABAP layer, and then aggregate the results. Use native SQL to access SAP HANA built-in functions. Perform expensive calculations on the database. Aggregate data on the database, and transfer the results to the ABAP layer.
Explain The Authorization Concept and the types of privileges associated with it?
There are 3 correct answers to this question. Application privileges Analytic privileges System privileges Object privileges Delta privileges.
What must you do when you define and implement an ABAP Managed Database Procedure (AMDP)?
There are 3 correct answers to this question. Use scalar types for all AMDP method parameters. Specify the database system and the language. Define all method parameters to be passed by value. Mark the AMDP method as a READ-ONLY database procedure. List all ABAP Dictionary tables used in the procedure body in the USING clause.
You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAP HANA is used as the database.
In the check parameters, which value would you use for the percentage of fields that are effectively used?
Please choose the correct answer. A value that you calculate based on the number of tables A higher value than on a traditional, row-store only based database A lower value than on a traditional, row-store only based database The same value as on a traditional, row-store only based database.
Which of the following are performance recommendations when using SAP HANA?
There are 2 correct answers to this question. Define indexes on the columns that are used in calculations. Move data-intensive calculations from the database to an application server. Avoid transferring large result sets between database and client applications. Filter data in lower layers.
Which features does the source code editor provide in ABAP Development Tools for SAP NetWeaver?
There are 2 correct answers to this question. Screen editing Quickfix Form-based class builder Content assistance.
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. Calculation views Core data services views ABAP managed database procedures Stored procedures.
What information can you specify using annotations (marked with the @ sign) when you define a Core Data Services (CDS) view in an ABAP system?
There are 3 correct answers to this question. The logic for aggregations, grouping records, and filtering groups of the CDS view The join conditions of the CDS view The name of the representation of the CDS view in the ABAP dictionary The client dependency of the CDS view The extent to which records of the CDS view should be buffered on the application server.
|
