1. 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 By Importing a Landscape Automatically Manually.
2. What is the Limitations of ALV for SAP HANA? There are 3 correct answers to this question. Restricted to 10,000 records All unit/ currency restricted to 10,00,00 records Without currency/unit consideration Restricted to 5000 records / unit No unit/currency split if aggregating amounts/currency values.
3. 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.
4. 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? Please choose the correct answer. select from snwd_so { so_id, sum(net_amount) as sum_amount } select from snwd_so { so_id, sum(net_amount) as sum_amount } order by so_id 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 } group by so_id.
5. What are the benefits of using the SQL Monitor (transaction SQLM)? There are 2 correct answers to this question. It displays the database execution plan for all SQL statements. It schedules ABAP programs to monitor and log all database accesses. It can be active in a production system with minimal performance overhead.
Option 2 It collects monitoring data asynchronously without additional database interaction.
6. Which data provisioning methods can you use when you need real time replications? There are 2 correct answers to this question. SAP Landscape transformation Replication server (SAP SLT) SAP Replication server SAP Data services SAP HANA Direct extractor connection (SAP DXC).
7. 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.
8. Which is the new concept that is introduced and improved by using SAP HANA Specific Features? Please choose the correct answer New advanced SQL syntax Procedures ABAP-Managed Database Procedures Programming model Table buffering.
9. 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? Please choose the correct answer. The gross and net run times are identical The net run time is less than the gross run time The net run time is greater than the gross run time The net run time is equal to Zero.
10. 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? Please choose the correct answer. To limit the need of indexes To limit the data footprint To allow creation of a full-text index To limit the unpacking and reconstruction of rows.
11. ANSI SQL owns features and adds languages these languages divided into three parts. What are they? There are 3 correct answers to this question. Data Manipulation Language The Database Language The Data Definition Language Data Transferred Language The Data Control Language.
12. Which of the following are view annotations for a CDS view? There are 3 correct answers to this question. Environment Buffering type Client handling Semantics Access control.
13. List down the four main concepts of the SAP HANA database? There are 3 correct answers to this question. Partitioning Tools combinations Compression Object store Column Store.
14. 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? Please choose the correct answer. SET_PARAM NEXT_PACKAGE SET_PARAM_TABLE EXECUTE_QUERY.
15. 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.
16. Discuss the basic approach of classical ABAP programming? There are 2 correct answers to this question. Collect all the data and perform Parallel processing in ABAP Keep load from the database Creating and consuming all the contents from network Get all the data you need on the application server and do your processing in ABAP.
17. How SAP HANA supports SQL? There are 3 correct answers to this question. Read Transferring data As a means to define As a Data Calculator Manipulate data .
18. Which steps do you have to perform when defining a view using core data services (CDS).
There are 3 correct answers to this question. Specify the name of the SQL view in ABAP Dictionary Create a proxy object for the defined view Use the DDL statement DEFINE VIEW and SQL like Syntax Define the type mapping between ABAP and SAP HANA Create a data definition in your ABAP package.
19. Discuss the conditions required to ensure the Referential Integrity? There are 2 correct answers to this question There are two joins in the able Referential integrity holds true in both the directions There are three joins in the table There is at least one join in the other table.
20. 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.
21. What are the Performance Rules and Guidelines for ABAP on SAP HANA? There are 2 correct answers to this question. 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 To reduce main memory consumption and to improve insert performance.
22. The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question. Avoid optimizing data Avoid idling CPU cores Avoid single network Avoid CPU cache misses.
23. What are functions of the ABAP Managed Database Procedure (AMDP) framework?
There are 2 correct answers to this question. It creates the database procedure when the AMDP is first activated It creates the database procedure when the AMDP is first called It deletes obsolete versions of the database procedure synchronously It deletes obsolete versions of the database procedure asynchronously.
24. In which of the following situations could a row store table be more suitable than a column store table? There are 2 correct answers to this question. The table contains text that you want to search The table contains mainly distinct values per column across rows The table contains data that you want to aggregate The table contains only a small number of records.
25. What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question. 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. Aggregate data on the database, and transfer the results to the ABAP layer. Use native SQL to access SAP HANA built-in functions.
26. Which of the following tasks can you perform with SQL monitor (transaction SQLM)? Capture the SQL profile of an application Combine static and dynamic performance analysis results Search for problematic SELECT * statements Display the execution plan of an SQL statement.
27. What are some of the features available SAP List Viewer with integrated data access (SALV IDA)? There are 3 correct answers to this question. Group rows Double-click on rows Edit cells Search in content Display diagrams.
28. 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.
29. 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 Numeric identifiers Undelimited Identifiers
Limited identifiers.
30. 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).
31. 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 you want to enable a full-text search of the table When the table has a small number of records When you require aggregation and analysis of values.
32. 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. Freestyle search ACID search Fuzzy search Isolation search Linguistic search.
33. 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.
34. What output does The SAP HANA provide as a unique combination of hardware and software innovations?
Choose the correct answer. Huge potential to maximize the number of disk blocks in the application Huge potential to optimize AMDP application DATA Tables The ability to create new complex processes with ABAP application cloud Huge potential to optimize business applications that are running on SAP HANA.
35. Explain the Enterprise Information System of - SAP HANA Implementation Scenarios?
There are 3 correct answers to this question All HANA Combinations on one platform Business Suite on HANA / BW on SAP HANA HANA Modeling HANA Accelerators All SAP applications on one SAP HANA platform.
36. 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.
37. Which is not a Golden Rule for Open SQL? Please choose the correct answer. Reduce the Database Load Minimize the Number of Database Accesses Minimize the Amount of Data Transferred Keep the result set large.
38. What must you do when you define and implement an ABAP Managed Database Procedure (AMDP)?
There are 3 correct answers to this question. 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. Define all method parameters to be passed by value.
39. 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? There are 2 correct answers to this question. Include the client field in the WHERE condition. Include the client field in the field list. Include the client field in the join condition. Use the CLIENT SPECIFIED addition.
|
