You define and implement an ABAP Managed database procedure (AMDP). What do you have to list after the USING clause? AMDP used in the procedure body function used in the procedure body ABAP Dictionary views used in the procedure body ABAP Dictionary table used in the procedure body SAP HANA views used in the procedure body.
List down the three main concepts of the SAP HANA database There are 3 correct answers to this question Object store Compression Partitioning Tools combinations Column Store.
You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SOJD). 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} group by sojd select from snwd_so {so_id( sum(net_amount) as sum_amount} order by sojd select from snwd_so {sojd, sum(net_amount) as sum_amount} select from snwd_so {so_id( sum(net_amount) as sum_amount} group by net_amount.
Which of the below statements are true for SAP HANA Studio? (3 right answers) SAP HANA Studio is a client tool, which can be used to access local or remote HANA system. SAP HANA Studio is integrated in SAP GUI > 7.40 SAP HANA Studio is an Eclipse-based, integrated development environment (IDE) that is used to develop artifacts in a HANA server. SAP HANA Studio can be used to manage the SAP HANA database, to create and manage user authorizations, to create new or modify existing models of data etc.
What is the purpose of an ABAP project in ABAP Development tools for eclipse? (2 right answers) It represents the connection to the SAP HANA server It provides access to all ABAP repository objects in an ABAP system. It represents the connection to an ABAP system It is used to transport ABAP repository objects.
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?
There are 3 correct answers to this question. Specify the schema for every table Replace ORDER BY additions Replace UP TO n ROWS additions Replace CORRESPONDING FIELDS additions Add explicit client handling.
Which character is used to escape host variables in the new Open SQL syntax? : (colon) ~ (tilde) @ (at) * (asterisk).
List down the elements involved in User Management and Security in SAP Hana?
There are 3 correct answers to this question Create users Assign Job security Manage users Assign security Work Management.
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 GLOBAL TEMPORARY COLUMN LOCAL TEMPORARY.
You plan a database migration to SAP HANA and want to check your ABAP coding for potential functional regressions.
Which Code Inspector check variant can you use? PREV_FUNC_REG PERFORMANCE DB FUNCTIONAL_CHECK FUNCTIONAL_DB.
You implement an ABAP-managed database procedure (AMDP). You want to query data from Calculation view CA_BOOKINGS_COUNT in SAP HANA content package ha400.primdb.
How can you address the calculation view?
There are 2 correct answers to this questions. "ha400.primdb/CA_BOOKINGS_COUNT" _SYS_BIC."ha400.primdb::CA_BOOKINGS_COUNT" "ha400.primdb::CA_BOOKINGS_COUNT" _SYS_BIC."ha400.primdb/CA_BOOKINGS_COUNT".
Which of the following feature were added to the ABAP Dictionary to support the SAP HANA database?
There are 3 correct answers to this question. De-pooling and de-clustering Changes of data class Definition of full-text indexes Definition of an enhancement category Storage type for tables.
What are some of the features available SAP List Viewer with integrated data access (SALV IDA)?
There are 3 correct answers to this question. Display diagrams Double-click on rows Search in content Edit cells Group rows.
In ADT which setting below to a specific project rather than the entire workbench. Choose the correct answer Code completion option Statement Template options Editor shortcut options Code formatting option.
Which of the following is latest release of SAP HANA? SAP HANA 1.0 SP06 SAP HANA 1.0 SAP HANA 1.6 SP03 SAP HANA 2.0 SPS 04.
What are the different types of Variables in HANA? (3 right answers) Range Double Single Value Interval.
For which purpose can you use literal values in an Open SQL statement? To perform a generic existence check To provide a default value for a database table column To alias the result of an arithmetic expression To comment your development directly in the coding.
What are functions of the ABAP Managed Database Procedure (AMDP) framework? (2 right answers) It deletes obsolete versions of the database procedure synchronously It deletes obsolete versions of the database procedure asynchronously It creates the database procedure when the AMDP is first called. It creates the database procedure when the AMDP is first activated.
What are the features of New Open SQL? There are 2 correct answers to this question. Supports arithmetic and string expressions Supports Code adjustment model Supports specific units of database Supports conditional expressions.
What are the benefits includes with SAP HANA Full Text Search? There are 2 correct answers to this question Fewer data duplication and movement Exploit structured contents in SQL Easy to use modeling tool Large number of toolkits are available.
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. Full-text index Database procedure proxy ABAP program containing new Open SQL Core Data service (CDS) view External view.
Which of the following objects can you use in the ABAP layer when using the top-down approach to bring code to data? There are 2 correct answers to this question Calculation views ABAP managed database procedures Stored procedure Core data services views.
What are the Possible Approaches with AS ABAP < 7.4 SP02? There are 2 correct answers to this question SQL units Consume using native SQL Stored Procedures Interaction with Database.
Which form of services is responsible for defining and consuming semantically rich data models.
Please choose the correct answer. Core Data Services ITe services Conditional services Modell-ll services.
According to the performance analysis recommendations; which steps are recommended after doing a database migration to SAP HANA? Perform regular performance scans on your ABAP custom coding as part of the development process. Perform regular performance scans on the ABAP coding delivered by SAP as part of your development process. Activate your ABAP custom coding, which was deactivated before the database migration, using U transaction SFW5 Switch the storage type of you custom database tables to column store and use the database utility (SE14) to perform the database table conversion.
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?
Note: There are 2 correct answers to this question. 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 conditional expressions can be used in Core Data Services (CDS) views? 2 ans CASE statements in the projection list IF statements in the projection list WHILE statements in the WHERE clause COALESCE functions in the projection list CASE statements in the HAVING clause.
You want to debug an ABAP program using ABAP development tools (ADT). How do you launch the debugger? Please choose the correct answer. Choose the debug as option in the context menu of the ABAP program Create a debug configuration for the ABAP application and run the program Set a breakpoint in the ABAP program and execute the program Choose the Run --> Debug options in the menu.
You plan a database migration to SAP HANA and want to check your ABAP coding for performance optimization potential.
Which Code Inspector check variant can you use? PERFORMANCE_OPT CHECK_PERFORMANCE FUNCTIONAL_DB PERFORMANCE_DB.
Which code-to-data capability is responsible for the Optimizations & Translation of "Open SQL SELECT FOR ALL ENTRIES clauses into native SQL?.
Please choose the correct answer. Database Optimization Transparent Optimizations HANA Specific features Buffer system Optimization.
DB-Specific Properties that allows switching between storage types when running on an SAP HANA database. What are these storage types?
There are 2 correct answers to this question. Column store Development Store Row store Technology store Re-use component store.
Which SQL syntax is used to create a read only procedure? READS SQL DATA READS PROCEDURE NO-SIDE-EFFECT READ-ONLY.
Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does NOT Offer? There are 2 correct answers to this question. Documented checks Enhanced distribution of results Configuration of check variants Flexible schedule of check runs.
What is the main function of Static Code Analysis? Please choose the correct answer. To detect code that would lead to functional or performance issues When migrating to SAP HANA Integrates with SAP Solution Manager Integrated into ABAP Development Tools and ABAP Workbench ABAP source code with performance optimization potential.
What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster?
There are 2 correct answers to this question High availability configuration Services-Name and index server on all nodes Shared file systems for only one server Active clusters for all servers.
What is the main function of Static Code Analysis?
Please choose the correct answer. To detect code that would lead to functional or performance issues When migrating to SAP HANA Integrated into ABAP Development Tools and ABAP Workbench Integrates with SAP Solution Manager ABAP source code with performance optimization potential.
What are the features of New Open SQL?
There are 2 correct answers to this question. Supports Code adjustment model Supports arithmetic and string expressions Supports conditional expressions Supports specific units of database.
Which is not a Golden Rule for Open SQL?
Please choose the answer. Reduce the Database Load Keep the result set large Minimize the Number of Database Accesses Minimize the Amount of Data Transferred.
Which features does the source code editor provide in ABAP Development Tools for SAP NetWeaver?
There are 2 correct answers to this question. Quick fix Screen editing Content assistance Form-based class builder.
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. Built-in support for planning Traditional disk-based tables Text analysis and search Text indexing capabilities Linguistic search capabilities.
What are the two layers of ABAP system interacts with its database?
There are 2 correct answers to this question. The Database specific library The Client database interface The Data Storage interface The Database independent interface.
How to call the stored procedures in ABAP code?
Please choose the correct answer. Native SQL Only SQL Open SQL CDS view.
You perform a static code check using the Code Inspector (SCI). In your SCI variant, you select the Search problematic SELECT * statements check.
What does this check report? SELECT * statements on tables with more than a specified number of fields SELECT * statements on tables with the Column Store storage type SELECT * statements where fewer than a specified percentage of all fields are effectively used SELECT * statements on tables with more than 100,000 records.
Which of the following are characteristics of an external view?
There are 3 correct answers to this question It allows access to an SAP HANA information view with Open SQL. It can be used as a data type in ABAP programs. It is an ABAP Dictionary object type. It can be used in Open SQL statements for database updates. It defines the underlying SAP HANA information view.
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 Support for system tables Hybrid data and management system Analytical DBMS features.
You use 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 result set of the native SQL call?
Please choose the correct answer. EXECUTE_QUERY NEXT_PACKAGE SET_PARAM SET_PARAM_TABLE.
How will you select a preference for Validation rules?
Choose the correct answer Windows- Modeler - Preferences-SAP HANA-Validation Rules Windows- SAP HANA-Preferences-Modeler-Validation Rules Windows- SAP HANA-Modeler-Preferences-Validation Rules Windows- Preferences-SAP HANA-Modeler-Validation Rules.
What is a perspective? A collections of views in the SAP HANA Studio that are organized by role A set of security permissions that aligns to a user's view of the data A group of users in a specific SAP HANA role A list if allowed objects in SAP HANA that can be changed by a particular role.
What are advantages of column store tables?
There are 3 correct answers to this question. Data footprint is automatically reduced through compression Only the column required are actually load to memory Columns can be partitioned Aggregates can be created.
SAP HANA security services include which of the following?
There are 4 correct answers to this question. Audit logging Antivirus Protection Authentication Encryption Authorization.
When creating a system connection in SAP HANA Studio. Which of these is essential information?
There are 3 correct answers to this question. Host A valid user and password Instance URL.
Where is SDI (Smart Data Integration) used?
There are 2 correct answers to this question. For data streaming For data cleansing For data transformation For data loading.
What is the SAP HANA Application Function Library (AFL)?
There are 2 correct answers to this question. Repository of connections that can be used by business functions Repository of ready to run applications that are powered by SAP HANA Repository of ready made business functions Repository of ready made predictive algorithms.
An Analytic Privilege consists of several restrictions. What are they?
There 3 correct answers to this question. Activity restrictions Analytic restrictions Validity restrictions View restrictions Cube restrictions.
What are the steps involved in supporting a database oriented programming model?
There are 2 correct answers to this question. Core Data services Buffer system services A new and advanced Open SQL Advanced and specific models.
What are key features of SAP HANA?
There are 3 correct answers to this question. In-memory database Removes the need for cache Automatic compression of data Combined OLTP and OLAP processing on one platform.
To upload data from flat files, SAP HANA offers several features. What are these important features?
There are 2 correct answers to this question The application suggests the column name and data type for the new tables, and it is possible to edit them The new table always has a 2:2 mapping between the file and table columns The supported file types for upload are: .cssv, .xlls, and .xlsxxx When loading new data in the table, it gets appended to the existing data.
You are implementing an ABAP Managed Database Procedures (AMDP) for SAP HANA. What do you have to do in the corresponding ABAP class? Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB. Set the visibility of the corresponding class method in the declaration section to PUBLIC. Implement the ABAP AMDP_HDB Event Handler. Implement the interface IF_AMDP_MARKER_HDB.
Explain Transitioning ABAP Code to SAP HANA - Performance Considerations?
There are 3 correct answers to this question. Some shifts in priorities, examples, nested selects(higher) indices(lower) Some codes transferred to other systems Classical performances recommendations for open SQL remain valid Some codes immediately run faster Some codes impacted positively and should be priorities.
Why do we still need a persistent layer?
There are 2 correct answers to this question. To store data that has been unloaded from memory To hold the delta store for newly arrived records To enable full database recovery if we have a power failure To store data that is frequently used.
Explain The Authorization Concept and the types of privileges associated with it?
There are 3 correct answers to this question. Object privileges Application privileges Analytic privileges System privileges Delta privileges.
To maintain good read performance in a constantly changing database, which two components are used?
There are 2 correct answers to this question. Memory store Column store Main storage Delta storage.
When to use Enhanced Open SQL?
There are 2 correct answers to this question. At the time of Dictionary Views Need the query in one piece of code only To view scalar components To access system fields.
|
