What is Core Data Services (CDS)? A collection of core features and services that provide data from the ABAP application server layer to the user interface A collection of services for ABAP application programming that provide access to the core features of the SAP HANA database management system A collection of services that provide information about the data volumes of the SAP HANA core tables A collection of domain-specific languages and services for definition and consumption of semantically rich data models .
Which JOIN types can be used in the definition of a Core Data Services (CDS) view? FULL OUTER JOIN LEFT OUTER JOIN RIGHT OUTER JOIN REFERENTIAL JOIN CROSS JOIN .
You want to develop an ABAP application for SAP HANA using the front-end image of your Amazon Web Service (AWS) trial system. Which plug-ins do you need to add to the existing Eclipse installation? SAP HANA Tools ABAP Development Tools for SAP NetWeaver None; everything is preconfigured All plug-ins provided by SAP Development Tools for Eclipse .
You follow the Code-to-Data paradigm in your ABAP coding.
Which of the following scenarios conflicts with the SQL performance guideline "Keep unnecessary load away from the database"? Perform join operations on database tables, then transfer the results to the application layer. Perform business logic and aggregations on database table content, then transfer the results to the application layer. Perform text search operations on database table content, then transfer the results to the application layer. Perform calculations on data transferred to the database layer, then transfer the results back to the application layer. .
Which of the following entries can be found under node CATALOG and not under node CONTENT? Schema Calculation view Package Table.
Which of the following functions are available in both the ADT Debug perspective and the SAP GUI Debugger? Setting breakpoints dynamically during debugging Memory analysis Source code editing in the debugger Displaying the contents of an internal table .
In the source code editor you can navigate quickly from the definition of a method to its implementation. To do so, you select the method name and press which key(s)? Choose the correct answer Ctrl + F2 F3 Ctrl + Shift + F5 F6.
You want to access SAP HANA view CA_BOOKINGS_COUNT in package ha400.primdb via a native SQL query. Which of the following are correct ways of specifying package path and object name in the FROM clause? FROM _SYS_BIC."ha400.primdb::CA_BOOKINGS_COUNT" FROM "ha400.primdb::CA_BOOKINGS_COUNT" FROM _SYS_BIC."ha400.primdb/CA_BOOKINGS_COUNT" FROM "ha400.primdb/CA_BOOKINGS_COUNT".
Which of the following ABAP repository objects can be the data source for ALV with IDA? Transparent table Database view CDS view External view.
Which of the following features are not supported by ALV with IDA? Personalization Editing values Excel export Double-click.
The below CDS view has two fields MARA and MARC. How to fetch fieldA and fieldB from Marc into the view to complete the view.
define view ZMM_I_MAT as select from MARA as m association to MARC as _plant on
m.mara = _plant.mara
{
matnr,
werks, ....
... }</code> .
Which of the following new repository objects belongs to code push down approach? CDS views ABAP managed database procedure Database procedure proxy External view.
What are the basic principles of SAP ALV IDA? The ALV optimization for SAP HANA to display data on the screen To ensure that the user chooses the data on the selection screen in displayed Only retrieve the database data which is to be displayed on screen Data described declaratively instead of passing big internal tables.
Which of the following SAP HANA based scenarios involve ABAP applications? SAP HANA as business accelerator Data mart based on SAP HANA AS ABAP with SAP HANA as primary database Native SAP HANA applications.
Which of the following are View Annotations? Semantics for Amount / Currency Code View Name Authority checking Client Handling.
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? In data preview in ADT In definition of another CDS view In ABAP open SQL In data browser (SE16).
You are programming a report that reads data from a secondary HANA database (DB). What do you need to consider in your SQL statement? All tables and fields you are using must exit in the ABAP dictionary of the Secondary DB. You have to use native SQL when reading data from the secondary DB. You have to specify the DB connection explicitly in your statement. You have to specify the DB schema explicitly in your statement.
You analyze SQL monitor data in transaction SQLMD. You know that program X accesses database table Y. You made sure that program X was executed while the SQL monitor collected its data. But the relevant database access is NOT listed in SQLMD.
What could be the reason? SQL Monitor was activated with a filter that excludes database table Y. SQL Monitor was activated for a specific application server. The data has NOT yet been transferred to the SQL Monitor database tables. Database table Y is a buffered table Program X was executed in the background.
You want to execute a native SQL statement in your program. Why should you use ABAP Database Connectivity(ADBC)? It supports locking and commit ahndling. it supports where-usedlist. It has syntax check at compile time. It supports exception handling.
You want to move some of the logic of an ABAP program into an ABAP-managed database procedure (AMDP). To do so, you need to translate Open SQL statements into SAP HANA Native SQL.
Which of the following are necessary adjustments? Replace UP TO n ROWS additions. Replace CORRESPONDING INTO FIELDS additions. Replace ORDER BY additions. Add explicit client handling. Specify the schema for every table.
You have created a CDS view and used alias name for some of its elements. In which of the following cases is the alias name mandatory? crtdby AS created_by CASE order type WHEN 'A' THEN 1 ELSE 0 END AS order_type CAST('USD' AS abap.cuky) AS currency_key SUM(revenue) AS total_revenue ASSOCIATION TO sflight AS _flights .
You are debugging in ABAP DevelopmentTools in Eclipse. What features are available? Watch points Memory usage analysis Debugger scripting Conditional breakpoints.
When using an SAP HANA full text search, what do you have to keep in mind? SAP HANA has to be the primary database to create a full text search. The full-text index is always updated asynchronously. The LIKE operator is required in your SELECT statement to implement fuzzy logic. The SCORE( ) function is required to ensure the best hits of your search appear on top.
What benefits does SAP HANA Data Compression provide? Optimized data partitioning Increased parallel processing Reduced memory consumption Optimized access to column store tables.
Your development team needs to include SAP HANA objects into an ABAP workbench request. You want to use SAP HANA Transport for ABAP (HTA), and NOT the SAP HANA Transport Container(HTC).
Why would you choose HTA? Because you can manually re-deploy objects after a failed import. Because you always transport entire SAP HANA content packages. Because you use the technique that is recommended by SAP. Because you automatically add changed objects to the transport request.
Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)? Missing ORDER BY or SORT after SELECT. Use of Native SQL and DB Hints. Existence check for Secondary Indexes Direct access to Table Pools/Cluster.
|
