1. Which code-to-data capability is responsible for the Optimizations & Translation of Open SQL "SELECT FOR ALL ENTRIES" clauses into native SQL? (A) Transparent Optimizations (B) HANA Specific features (C) Database Optimization (D) Buffer system Optimization.
2. The SAP HANA database is a hybrid in-memory database that combines Few technologies within. What are these technologies? Value-based database technology Column-based database technology Row-based database technology Time-based database technology Object-based database technology.
3. What are the components of The Enterprise Procurement Model Demo Scenario? (A) Stock (B) Product (C) Procurement (D) Services (E) Sales.
4. Which of the following are characteristics of an external view? (A) It can be used as a data type in ABAP programs. (B) It can be used in Open SQL statements for database updates. (C) It is an ABAP Dictionary object type. (D) It defines the underlying SAP HANA information view. (E) It allows access to an SAP HANA information view with Open SQL.
5. What are the key points that should be kept in mind while performing the Non automatic update in SAP HANA Transport Container? (A) Automatic release of units (B) Changes to Delta Container (C) Take snapshot manually before releasing of the container (D) You need to refresh the content of the container manually.
6. Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does NOT Offer? (A) Enhanced distribution of results (B) Documented checks (C) Flexible schedule of check runs (D) Configuration of check variants.
7. What are the components of The Enterprise Procurement Model Demo Scenario? (A) Stock (B) Product (C) Procurement (D) Services (E) Sales.
8.How SAP HANA support SQL? Manipulate data Read As a Data Calculator As a means to define Transferring data.
9. What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster? High availability configuration Active clusters for all servers Shared file systems for only one server Services-Name and index server on all nodes.
10.What are the benefits of using the SQL Monitor (transaction SQLM)? It schedules ABAP programs to monitor and log all database accesses. It collects monitoring data asynchronously without additional database interaction. It can be active in a production system with minimal performance overhead. It displays the database execution plan for all SQL statements.
11. Discuss different types of engines associated with The SAP HANA architecture? Analytic engine OLAP engine OPAX engine Join engine.
12. You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data? Use the UP TO n ROWS addition Use the tilde symbol (~) to separate qualifier from column name Explicitly handle the client field Use a Comma-separated column list Specify the database schema if it is not the user's default schema.
13. Explain the Enterprise Information System of - SAP HANA Implementation Scenarios? All HANA Combinations on one platform Business Suite on HANA / BW on SAP HANA All SAP applications on one SAP HANA platform HANA Accelerators HANA Modeling.
14. Explain how and when to create calculated columns - Using Graphical Modeling Tools? Time characteristics based calculation columns The calculation will be opened in a read-only mode The calculation could be an arithmetic or character manipulation. It is possible to nest so that one calculated column, in turn, is based on other calculated columns Calculated columns also support non-measure attributes as part of the calculation.
15. Which of the following is not an element of Analytical view? Used to Joined table Join fact tables Read Data from the joined database tables Currency conversion is not applicable.
16. What all are the steps to perform To enable type-ahead for an input field on a screen? Check Pre-Requisites Automatic updates of all the input fields Switch on proposal search for input fields Process on all the input fields Identify Elementary Search Help.
17. When to use Enhanced Open SQL? To view scalar components To access system fields At the time of Dictionary Views Need the query in one piece of code only.
18. Explain Transitioning ABAP Code to SAP HANA – Performance Considerations? Classical performances recommendations for open SQL remain valid Some codes immediately run faster Some codes impacted positively and should be priorities Some shifts in priorities, examples, nested selects(higher) indices(lower) Some codes transferred to other systems.
19. Hybrid Data Management System – Combining different paradigms in one system. Discuss capabilities associated with the Hybrid Data Management system? Linguistic search capabilities Traditional disk-based tables Built-in support for planning Text indexing capabilities Text analysis and search.
20. 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? Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK PACKAGE ZHA400_00 HAS deployment Mode A SYSTEM P81 has SAP HANA has primary database View CA_CUSTOMER has deployment mode A.
21. What are the steps that supported several tools, which in total result in a Guided Performance Optimization? Tools analyzing performance at run-time, to determine if critical constructs A new tool called SQL Monitor to determine the priority if different programs access the database intensively A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues. The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption.
22. What are the benefits of using the SQL Monitor (transaction SQLM)? 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.
23. 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.
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 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.
26. 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.
27. 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.
28. What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling? Product-based Profitability Account-based Profitability Costing-based Profitability Service-based profitability.
29. How many result sets are returned when an SAP HANA database procedure is called using the CALL. WITH OVERVIEW statement? Two result sets As many result sets as there are input parameters in the procedure One result set As many result sets as there are table output parameters in the procedure.
30. Explain The Authorization Concept and the types of privileges associated with it? System privileges Delta privileges Analytic privileges Object privileges Application privileges.
|
