1. What must you do when you define and implement an ABAP Managed Database Procedure (AMDP)? Define all method parameters to be passed by value List all ABAP Dictionary tables used in the procedure body in the USING clause Use scalar types for all AMDP method parameters Mark the AMDP method as a READ-ONLY database procedure Specify the database system and the language.
2. What are some of the features available SAP List Viewer with integrated data access (SALV IDA)? Search in content Display diagrams Group rows Double-click on rows Edit cells.
3. 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? Include the client field in the join condition. Include the client field in the WHERE condition. Include the client field in the field list. Use the CLIENT SPECIFIED addition.
4. You use ABAP database connectivity (ADBC) to issue native SQL calls to the database. Which of the following methods of class CL_SQL_RESULT_SET retrieves the result set of the native SQL call? EXECUTE_QUERY SET_PARAM NEXT_PACKAGE SET_PARAM_TABLE.
5. You use ABAP database connectivity (ADBC) to issue native SQL calls to the database. Which of the following methods of class CL_SQL_RESULT_SET retrieves the result set of the native SQL call? EXECUTE_QUERY SET_PARAM NEXT_PACKAGE SET_PARAM_TABLE.
6. What should you do to follow the code-to-data approach to programming? Aggregate data on the database, and transfer the results to the ABAP layer. Perform expensive calculations on the database. Perform expensive calculations on the ABAP application server. 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.
7. Which data provisioning methods can you use when you need real time replications? SAP Replication server SAP Data services SAP HANA Direct extractor connection (SAP DXC) SAP Landscape transformation Replication server (SAP SLT).
8. How SAP HANA supports SQL? Transferring data Read Manipulate data As a Data Calculator As a means to define.
9. In which of the following situations could a row store table be more suitable than a column store table? The table contains text that you want to search The table contains only a small number of records The table contains mainly distinct values per column across rows The table contains data that you want to aggregate.
10. List down the four main concepts of the SAP HANA database?
There are 3 correct answers to this question Column Store Tools combinations Object store Partitioning Compression.
11. You create a new table definition using the ABAP Dictionary and maintain the database-specific technical settings. Why do you create a row store instead of a column store table? To allow creation of a full-text index To limit the need of indexes To limit the data footprint To limit the unpacking and reconstruction of rows.
12. Which is the new concept that is introduced and improved by using SAP HANA Specific Features? New advanced SQL syntax Procedures Table buffering Programming model ABAP-Managed Database Procedures.
13. What are the two main methods to add a system to the SAP HANA Studio?
There are 2 correct answers to this question By Resource console Manually By Importing a Landscape Automatically.
14. An Analytic Privilege consists of several restrictions. What are they?
There 3 correct answers to this question Activity restrictions Analytic restrictions View restrictions Validity restrictions Cube restrictions.
15. Which of the following tasks can you perform with SQL monitor (transaction SQLM)? Search for problematic SELECT* statements Combine static and dynamic performance analysis results Capture the SQL profile of an application Display the execution plan of an SQL statement.
16. What are the benefits of using the SQL Monitor (transaction SQLM)?
There are 2 correct answers to this question. It collects monitoring data asynchronously without additional database interaction It displays the database execution plan for all SQL statements It can be active in a production system with minimal performance overhead It schedules ABAP programs to monitor and log all database accesses.
17. The SAP HANA state-of-the-art search experience includes full-text search with advanced features like...
There are 3 correct answers to this question. ACID search Freestyle search Isolation search Linguistic search Fuzzy search.
18. What are the two different kinds of Identifiers used to represent names used in SQL statement?
There are 2 correct answers to this question Delimited identifiers Undelimited Identifiers Limited identifiers Numeric identifiers.
19. The new bottlenecks avoided by addressing two challenges, what are they?
There are 2 correct answers to this question. Avoid optimizing data Avoid CPU cache misses Avoid idling CPU cores Avoid single network.
20. You use the ABAP trace (SAT) to measure the run time of a program. In a class, method X checks the validity of its importing parameters and calls method Y.
What pattern of gross and net run time would you expect to see the in the ABAP trace results for method X? The net run time is greater than the gross run time The net run time is equal to Zero The net run time is less than the gross run time The gross and net run times are identical.
20. You use the ABAP trace (SAT) to measure the run time of a program. In a class, method X checks the validity of its importing parameters and calls method Y.
What pattern of gross and net run time would you expect to see the in the ABAP trace results for method X? The net run time is greater than the gross run time The net run time is equal to Zero The net run time is less than the gross run time The gross and net run times are identical.
21. What output does The SAP HANA provide as a unique combination of hardware and software innovations? Huge potential to optimize AMDP application DATA Tables Huge potential to optimize business applications that are running on SAP HANA The ability to create new complex processes with ABAP application cloud Huge potential to maximize the number of disk blocks in the application.
22. What are the Performance Rules and Guidelines for ABAP on SAP HANA?
There are 2 correct answers to this question. To reduce main memory consumption and to improve insert performance To Keep all the loads away from the DB It is beneficial to move data-intensive calculations into the database It is beneficial for maximizing your search into database.
23. What are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container?
There are 2 correct answers to this question. You need to refresh the content of the container manually Take snapshot manually before releasing of the container Changes to Delta Container Automatic release of units.
24. Which of the following are view annotations for a CDS view? There are 3 correct answers to this question. Access control Buffering type Environment Client handling Semantics.
25. Explain the Enterprise Information System of - SAP HANA Implementation Scenarios?
There are 3 correct answers to this question Business Suite on HANA / BW on SAP HANA HANA Accelerators HANA Modeling All SAP applications on one SAP HANA platform All HANA Combinations on one platform.
26. Which steps do you have to perform when defining a view using core data services (CDS)?
There are 3 correct answers to this question. Create a proxy object for the defined view Use the DDL statement DEFINE VIEW and SQL like Syntax Create a data definition in your ABAP package Specify the name of the SQL view in ABAP Dictionary Define the type mapping between ABAP and SAP HANA.
27. Discuss the conditions required to ensure the Referential Integrity? There are 2 correct answers to this question There are two joins in the able There is at least one join in the other table There are three joins in the table Referential integrity holds true in both the directions.
28. You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SO_ID).
Which SELECT statement would you use in the definition? select from snwd_so { so_id, sum(net_amount) as sum_amount } group by net_amount select from snwd_so { so_id, sum(net_amount) as sum_amount } select from snwd_so { so_id, sum(net_amount) as sum_amount } group by so_id select from snwd_so { so_id, sum(net_amount) as sum_amount } order by so_id.
29. What are the components of The Enterprise Procurement Model Demo Scenario?
There are 3 correct answers to this question. Services Stock Product Sales Procurement.
30. Which is not a Golden Rule for Open SQL? Minimize the Number of Database Accesses Reduce the Database Load Keep the result set large Minimize the Amount of Data Transferred.
31. Which of the following are performance recommendations when using SAP HANA?
There are 2 correct answers to this question. Filter data in lower layers. Avoid transferring large result sets between database and client applications. Move data-intensive calculations from the database to an application server. Define indexes on the columns that are used in calculations.
32. Discuss the basic approach of classical ABAP programming?
There are 2 correct answers to this question. Get all the data you need on the application server and do your processing in ABAP Keep load from the database Creating and consuming all the contents from network Collect all the data and perform Parallel processing in ABAP.
33. Which form of services is responsible for defining and consuming semantically rich data models?
Please choose the correct answer. Conditional services ITe services Modell-II services Core Data Services.
34. Open SQL largely standardized, three sub-languages. What are these sublanguages?
There are 3 correct answers to this question Data Evaluation Language(DEL) Data Transferring Language(DTL) Data Manipulation Language (DML) The Data Definition Language (DDL) The Data Control Language (DCL).
35. What is the Limitations of ALV for SAP HANA?
There are 3 correct answers to this question. Restricted to 10,000 records Restricted to 5000 records / unit No unit/ currency split if aggregating amounts/ currency values Without currency /unit consideration All unit/ currency restricted to 10,00,00 records.
36. When would you use a column store table instead of a row store table?
There are 2 correct answers to this question. When there are mainly distinct values in the table When the table has a small number of records When you require aggregation and analysis of values When you want to enable a full-text search of the table.
37. What are functions of the ABAP Managed Database Procedure (AMDP) framework?
There are 2 correct answers to this question. It deletes obsolete versions of the database procedure asynchronously It deletes obsolete versions of the database procedure synchronously It creates the database procedure when the AMDP is first activated It creates the database procedure when the AMDP is first called.
38. You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data?
There are 3 correct answers to this question. Use the tilde symbol (~) to separate qualifier from column name Use the UP TO n ROWS addition Use a Comma-separated column list Specify the database schema if it is not the user's default schema Explicitly handle the client field.
39. What are the steps involved in SAP HANA Evolution?
There are 3 correct answers to this question. ABAP can access SAP HANA ABAP applications on SAP HANA Optimized ABAP on SAP HANA ABAP as accelerator on SAP HANA ABAP can run on SAP HANA.
40. List down the elements involved in User Management and Security in SAP HANA?
There are 3 correct answers to this question Create users Assign security Manage users Work management Assign job security.
|
