1. 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 Data Control Language Data Transferred Language The Data Definition Language The Database Language.
2. What is an attribute view and what are its practices?
There are 3 correct answers to this question. May contain filters Used to join tables May contains flow charts May use in calculation views Used in diagrammatic Projections.
3. Which data provisioning methods can you use when you need real time replications?
There are 2 correct answers to this question. SAP Data services SAP Landscape transformation Replication server (SAP SLT) SAP Replication server SAP HANA Direct extractor connection (SAP DXC).
4. The source code editor in ADT provides many helpful features. What are these helpful features?
There are 2 correct answers to this question. Creating interface from Method Calls Creating Method Implementations from the Method Definition Creating Method Definitions from Implementation Parts Creating Parts for Interface Methods.
5. SAP HANA: Delivers Across 5 Dimensions. These five dimensions lead to certain goals HANA has to meet. What are these goals? There are 2 correct answers to this question. High Performance and Scalability Hybrid data and management system Support for system tables Analytical DBMS features.
6. When using 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 tabular result of the native SQL call? SET_PARAM_TABLE NEXT_PACKAGE SET_PARAM GET_METADATA.
7. 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. Fuzzy search Linguistic search Isolation search ACID search Freestyle search.
8. 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 Creating and consuming all the contents from network Get all the data you need on the application server and do your processing in ABAP Keep load from the database.
9. What all are the Types of Applications based on SAP HANA? There are 2 correct answers to this question. Data Mart based on SAP HANA Innovation based on SAP HANA Server based on SAP HANA New or Native SAP HANA.
10. How SAP HANA supports SQL? There are 3 correct answers to this question. Transferring data As a Data Calculator Read Manipulate data As a means to define.
11. 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 Access to ERP tables must be restricted Need to have selected users in SAP HANA for Information Management Database administration should be restricted to skilled.
12. 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 net run time is less than the gross run time The gross and net run times are identical The net run time is greater than the gross run time The net run time is equal to Zero.
13. What are best practices when programming in ABAP for SAP HANA? There are 2 correct answers to this question. Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required Calculate aggregations using ABAP code on the application server to limit database load Use a column list in the SELECT clause to ensure that you only read a column if it is really required Eliminate nested SELECT statements to reduce the overall number of database accesses.
14. An Analytic Privilege consists of several restrictions. What are they? There 3 correct answers to this question Validity restrictions Cube restrictions Activity restrictions Analytic restrictions View restrictions.
15. 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. Use the CLIENT SPECIFIED addition. Include the client field in the field list. Include the client field in the join condition.
16. In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog? Which of the following table types fulfill this requirement? Please choose the correct answer. ROW COLUMN GLOBAL TEMPORARY LOCAL TEMPORARY.
17. Which of the following take advantage of the computing power of multiple CPUs used by SAP HANA?
There are 2 correct answers to this question. Database table compression Columnar data storage Parallel processing Partitioning.
18. Hybrid Data Management System – Combining different paradigms in one system. Discuss capabilities associated with the Hybrid Data Management system? There are 3 correct answers to this question. Linguistic search capabilities Traditional disk-based tables Built-in support for planning Text indexing capabilities Text analysis and search.
19. Which of the following are characteristics of an external view? There are 3 correct answers to this question. It can be used as a data type in ABAP programs. It defines the underlying SAP HANA information view. It allows access to an SAP HANA information view with Open SQL. It is an ABAP Dictionary object type. It can be used in Open SQL statements for database updates.
20. What views will be most efficient for General Modeling Principles?There are 2 correct answers to this question Attribute view Analytical view Schema view Column view.
21. What are the benefits includes with SAP HANA Full Text Search? There are 2 correct answers to this question Exploit structured contents in SQL Fewer data duplication and movement Easy to use modeling tool Large number of toolkits are available.
22. Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA?
There are 2 correct answers to this question. Perform all calculations and aggregations in the ABAP layer Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement Use array variants of INSERT UPDATE MODIFY and DELETE Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES.
23. 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 To reduce main memory consumption and to improve insert performance It is beneficial for maximizing your search into database It is beneficial to move data-intensive calculations into the database.
24. 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? A higher value than on a traditional, row-store only based database The same value as on a traditional, row-store only based database A value that you calculate based on the number of tables A lower value than on a traditional, row-store only based database.
25. What is the central goal of using SAP HANA? Please choose the correct answer. Accelerate Performance Positive Impact on Business To set Priorities for system Monitor database for record keeping.
26. You changed an SAP HANA object that you transported using an SAP HANA Transport container. You want to release the transport request with your changes.
In which sequence do you perform activities in the ABAP development system immediately before the release?
Please choose the correct answer. Open the ABAP transport request
Select take snapshot and Save
Activate the SAP HANA transport container Open the package
Select take snapshot and Save
Activate the SAP HANA Delivery unit
Activate the SAP HANA transport container Open the SAP HANA transport container
Select take snapshot and Save
Activate the SAP HANA Transport Container Open the SAP HANA delivery unit
Select take snapshot and Save
Activate the SAP HANA Delivery unit
Activate the SAP HANA transport container.
27. How to create a core data services view? There are 3 correct answers to this question. Use the ABAP Development Tools for SAP NetWeaver Use SQL capabilities for Netweaver Use data services tools for updates Use additional annotations – marked with the @ sign Use DDL statement DEFINE VIEW and SQL-like syntax to define the view.
28. Which code-to-data capability is responsible for the Optimizations & Translation of “Open SQL SELECT FOR ALL ENTRIES “clauses into native SQL? Database Optimization Transparent Optimizations Buffer system Optimization HANA Specific features.
29. Which of the following tasks can you perform with SQL monitor (transaction SQLM)? Combine static and dynamic performance analysis results Search for problematic SELECT* statements Capture the SQL profile of an application Display the execution plan of an SQL statement.
30. What are the purposes of tools in SAP HANA system that is an Eclipse-based integrated development environment? Configure Selecting Monitor Administer Organizing.
31. You made changes to an object (X) used by an ABAP managed database procedure (AMDP). You did NOT changes the AMDP itself. Now you execute a program that calls this AMDP.
In which cases does the call trigger the creation of the database procedure in SAP HANA?
There are 2 correct answers to this question. X is an AMDP method X is a stored procedure X is an ABAP Dictionary table X is an SAP HANA view.
32. How will you hide the attributes that are not required for client consumption? Choose the correct answer By setting the hidden property flag of the attribute in the Semantics screen By setting the hidden property flag of the attribute column By setting the hidden property flag of the attribute in the View By setting the hidden property flag of the attribute provider.
33. You are working with ABAP Development Tools (ADT) For Eclipse. Which of the following options belongs to the settings of a specific ABAP project rather than the entire Eclipse workbench?
Please choose the correct answer. Editor shortcut key options Statement template options Code completion options Code formatting options.
34. Which code-to-data capability supports- Extended view definitions and Better SQL- 92 standard support in open SQL?
Please choose the correct answer. SAP HANA specific features Database for sophisticated analysis New SQL parser used in model Database oriented programming model.
35. Which is not a key factor of ALV for HANA? Please choose the correct answer. To supply suitable values for any input parameters The data display is restricted to a maximum of 2 billion cells Derived Column headings from the data element To Activate and execute the program in the application.
36. If the Search Options are enabled, you can set the Search Parameters for an attribute of a view. The following parameters are available? There are 3 correct answers to this question Weights for ranking Index search Freestyle search Point base ranking Fuzzy search.
37. What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA?
There are 3 correct answers to this question. Tuning Innovate Scaling Detect Optimize.
38. Which is the new concept that is introduced and improved by using SAP HANA Specific Features?
Please choose the correct answer. Programming model ABAP-Managed Database Procedures New advanced SQL syntax Procedures Table buffering.
39. 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}.
40. What are the supported joins in CDS view?
There are 2 correct answers to this question. Upper join Operators joint Left outer join Inner join.
|
