1. which of the following SAP HANA-based scenarios insolve ABAP applications?
Choose 2 correct answers. Data marts based on SAP HANA AS ABAP whith SAP HANA as primary database Native SAP HANA applications SAP HANA as Business accelerator.
2. On SAP HANA, tables are stores in row store by default. true false.
3. whitch of the following entries are required when creating a system in the SAP HANA Studio?
Choose 4 correct answers. Host name instance number Client ID User name Logon Language.
4. Which of the following entities can be found under node Catalog and not under node Content?
Choose 2 correct answers. Package Schema Table Calculation View.
5. It is not possible to create secondary indexes on SAP HANA. true false.
6. Which of the following new repository objects belong to the so-called “Top-Down Approach” for Code-to-Data?
Choose 2 correct answers. External view CDS view Database procedure proxy ABAP-managed database procedure.
7. When using a secondary database connection, the default schema is derived from the database user which is stored in the secondary database connection. true false.
8. Which of the following are potential functional issues when migrating ABAP code to SAP HANA?
Choose 2 correct answers. Use of native SQL or DB Hints Use of secondary database connections Coding that assumes that a SELECT result is always sorted The existence of customer-specific cluster tables The existence of table appends.
9. Where do you define a set of Code Inspector checks which you want to perform? In a Code Inspector object list In a Code Inspector object check variant In a Code Inspector inspection.
10. When migrating to SAP HANA, every SELECT statement immediately becomes faster. true false.
11. Because SAP HANA stores all data in memory, buffering of data on the application server becomes less important. true false.
12. Which of the following patterns are known to potentially cause performance issues when accessing SAP HANA database?
Choose 3 correct answers. Use of SELECT ... FOR ALL ENTRIES Use of joins with more than 3 tables Use of SELECT statements in loops Use of SELECT * for tables with many fields.
13. Which of the following are steps in the recommended sequence for a guided performance analysis?
Choose 3 correct answers. Do static code checks with Code Inspector or ABAP Test Cockpit Collect runtime data with SQL Monitor Collect runtime data with Runtime Analysis Combine runtime data and static check result in SQL Performance Tuning Worklist.
14. Which part of a guided performance analysis is done with the SQL Monitor tool? Collect runtime data in the productive system Do static SQL checks in the productive system Do static SQL checks in the development system Combine runtime data and static check results.
15. Which of the SQL performance rules become more important with SAP HANA?
Choose 2 correct answers. Keep the result set small Minimize amount of transferred data Minimize number of database accesses Minimize search overhead Keep unnecessary load away from the DB.
16. Which of the SQL performance rules become less important with SAP HANA?
Choose 2 correct answers. Keep the result set small Minimize amount of transferred data Minimize number of database accesses Minimize search overhead Keep unnecessary load away from the DB.
17. Which of the following are tasks of the database interface (DBI) and database-specific library (DBSL)?
Choose 3 correct answers. Translate Open SQL syntax into native SQL syntax Add client handling to the statement Check user authorizations Handle SAP table buffering Transaction handling.
18. New Open SQL syntax is mandatory as of SAP NetWeaver AS ABAP 7.40 SP05. true false.
19. The Open SQL syntax is a prerequisite for the new Open SQL features. true false.
20. Classical Open SQL syntax and new Open SQL syntax must not be used in the same ABAP processing block. true false.
20. Which of the following entities can be found in the object list of the ABAP Workbench or the Project Explorer of ADT?
Choose 2 correct answers. Data definition (aka DDL source) CDS view SQL view.
21. Which of the following entities corresponds to an object that is created on the database? Data definition (aka DDL source) CDS view SQL view.
22. If you use a CDS view name in the FROM clause of an Open SQL SELECT statement, the new Open SQL syntax is mandatory. true false.
23. ASSOCIATION TO is just another way of saying LEFT OUTER JOIN TO. true false.
24. Which of the following are prerequisites for exposing an association? The association points to a table, not to another CDS View. The association has cardinality “to-N.” All fields mentioned in the ON condition are part of the field list. The association is the only association in this view definition.
26. Where can you evaluate an exposed association?
Choose 3 correct answers. In the Data Preview of ADT In the Data Browser (transaction SE16) In another CDS view In an Open SQL SELECT statement.
27. CDS views that define associations cannot be extended. true false.
28. An import parameter that is annotated with @Environment.systemField: becomes optional in the following places: In Data Preview in ADT In the Data Browser (SE16) In ABAP Open SQL In the definition of another CDS view.
29. An access control (DCL source) defines access restrictions for a given CDS view. These restrictions are implicitly evaluated when the CDS view is accessed in the following places:
Choose 2 correct answers. In Data Preview in ADT In the Data Browser (SE16) In ABAP Open SQL In the definition of another CDS view.
|
