1. When would you use a column store table instead of a row store table? There are 2 correct answers to this question. When you want to enable a full-text search of the table When the table has a small number of records When there are mainly distinct values in the table When you require aggregation and analysis of values.
2. 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 } group by
net_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 so_id .
3. 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.
4. Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not in the Classical ABAP workbench? There are 3 correct answers to this question. Database procedure proxy Full-text index Core Data service (CDS) view External view ABAP program containing new Open SQL.
5. You import an ABAP workbench request into a SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package ZHA400_00. WHICH PREREQISITIES are mandatory for an implicit deployment of the SAP HANA view onto the database? There are 2 correct answers to this question. Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK SYSTEM P81 has SAP HANA has primary database View CA_CUSTOMER has deployment mode A PACKAGE ZHA400_00 HAS deployment Mode A.
6.What are the ABAP development guidelines? Improved hybrid components for SAP HANA Improved tools for performance analysis Extensions to ABAP Language Consuming Only ABAP contents for SAP HANA.
7. Discuss the basic approach of classical ABAP programming? There are 2 correct answers to this question. Keep load from the database Creating and consuming all the contents from network Collect all the data and perform Parallel processing in ABAP Get all the data you need on the application server and do your processing in ABAP.
8. 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 equal to Zero The net run time is greater than the gross run time The net run time is less than the gross run time .
9. Explain the Enterprise Information System of - SAP HANA Implementation Scenarios? There are 3 correct answers to this question HANA Accelerators Business Suite on HANA / BW on SAP HANA HANA Modeling All HANA Combinations on one platform All SAP applications on one SAP HANA platform.
10. What are some of the features available SAP List Viewer with integrated data access (SALV IDA)?
There are 3 correct answers to this question. Edit cells Double-click on rows Search in content Display diagrams Group rows.
11. What are the steps involved in SAP HANA Evolution? There are 3 correct answers to this question. ABAP can run on SAP HANA ABAP applications on SAP HANA ABAP as accelerator on SAP HANA ABAP can access SAP HANA Optimized ABAP on SAP HANA.
12. Which of the following option is not the main capability of SAP Business Objects Analysis for OLAP? Create Presentations Insert filter components Create data by members and tables Swap axes.
13. 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 Define the type mapping between ABAP and SAP HANA Specify the name of the SQL view in ABAP Dictionary Use the DDL statement DEFINE VIEW and SQL like Syntax Create a data definition in your ABAP package.
14. Your customer wants to migrate to SAP HANA and you want to identify which business processes should be optimized.
Which of the following steps must you perform to get this information? There are 2 correct answers to this question. Combine the results of the SQL Monitor with the results of an ABAP runtime analysis. Combine the results of the SQL Monitor with the results of a static source code analysis Activate the new SQL Monitor in a development system Activate the new SQL Monitor in a productive system.
15. What are the Functions of Transaction DBACOCKPIT. There are 2 correct answers to this question. Maintain, Monitor and test secondary database connection Maintain only HANA specific objects Used to access local or remote database system Use Schema for the Connections.
16. The SAP HANA database is a hybrid in-memory database that combines Few technologies within. What are these technologies? There are 3 correct answers to this question Object-based database technology Time-based database technology Column-based database technology Value-based database technology Row-based database technology.
17. What are the purposes of tools in SAP HANA system that is an Eclipse-based integrated development environment?
There are 3 correct answers to this question. Organizing Selecting Configure Administer Monitor.
18. What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA?
There are 3 correct answers to this question. Optimize Innovate Scaling Detect.
19. What do you have to consider if you want to use Native SQL in your ABAP programs to access an SAP HANA database?
There are 2 correct answers to this question. Client handling needs to be done explicitely in the the Native SQL statement. Hashed or sorted tables must be used with the INTO CORESPONDING FIELDS keyword. The database independency of your report can be lost. The ABAP system checks the syntax of the Native SQL statements.
20. Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)?
There are 3 correct answers to this question. Data base performance monitor (transaction DB50) Code inspector (transaction SCI) SQL monitor (transaction SQLM) ABAP test cockpit (transaction ATC) SQL Trace (transaction ST05).
21. 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 join conditions of the CDS view The logic for aggregations, grouping records, and filtering groups of the CDS view The extent to which records of the CDS view should be buffered on the application server The name of the representation of the CDS view in the ABAP dictionary The client dependency of the CDS view.
22. What is an attribute view and what are its practices? There are 3 correct answers to this question. Used in diagrammatic Projections May contain filters Used to join tables May contains flow charts May use in calculation views.
23. What is the central goal of using SAP HANA? Please choose the correct answer. Positive Impact on Business Monitor database for record keeping To set Priorities for system Accelerate Performance.
24. Name some perspectives that are available in the SAP HANA Studio? There are 3 correct answers to this question The technology & innovation perspective The Resources perspective The Administration Console perspective The SAP HANA Modeler perspective.
25. Which features does the source code editor provide in ABAP Development Tools for SAP NetWeaver?
There are 2 correct answers to this question. Quickfix Screen editing Content assistance Form-based class builder.
26. List down the elements involved in User Management and Security in SAP HANA?
There are 3 correct answers to this question Work management Manage users Assign job security Assign security Create users.
27. 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 HANA Direct extractor connection (SAP DXC) SAP Replication server SAP Data services.
28. 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 Access to ERP tables must be restricted Need to have selected users in SAP HANA for Information Management.
29. An Analytic Privilege consists of several restrictions. What are they? There 3 correct answers to this question Validity restrictions View restrictions Analytic restrictions Activity restrictions Cube restrictions.
30. 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 Linguistic search Isolation search ACID search Fuzzy search.
31. 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 Partitioning Parallel processing Columnar data storage.
32. What are the features of New Open SQL? There are 2 correct answers to this question. Supports Code adjustment model Supports conditional expressions Supports specific units of database Supports arithmetic and string expressions.
33. One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any functional issues after the migration. What should you search for and if necessary replace in the existing custom ABAP code?
There are 3 correct answers to this question. Left outer joins in open SQL statements Native SQL statements Direct access to a cluster on the database Code that relies on implicit database sorting ORDER BY Clauses in Open SQL statements.
34. List down the four main concepts of the SAP HANA database? There are 3 correct answers. Partitioning Compression Object store Column Store Tools combinations.
35. What allows you to resolve errors quickly or warnings reported about the code? Please choose the correct answer. ABAP debugger Quick Fix Debug perspective Code execution.
36. What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)?
There are 2 correct answers to this question. All Keywords are case sensitive. All fields in the GROUP BY clause must be separated by commas. All ABAP variables must be escaped with a proceeding @ sign. All arithmetic expressions can be used for all type of variables.
37. 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 Freestyle search Index search Weights for ranking Point base ranking Fuzzy search.
38. Explain The Authorization Concept and the types of privileges associated with it?
There are 3 correct answers to this question Analytic privileges Object privileges Application privileges Delta privileges System privileges.
39. How will you select a preference for Validation rules? Choose the correct answer Windows - SAP HANA - Modeler - Preferences - Validation Rules Windows - SAP HANA - Preferences - Modeler - Validation Rules Windows - Preferences - SAP HANA - Modeler - Validation Rules Windows - Modeler – Preferences - SAP HANA - Validation Rules Option 2.
|
