option
My Daypo

E_HANAAW_17 v2 - ABAP for SAP Hana 2.0 Example Questions

COMMENTS STADISTICS RECORDS
TAKE THE TEST
Title of test:
E_HANAAW_17 v2 - ABAP for SAP Hana 2.0 Example Questions

Description:
SAP Development Specialist Tests - E_HANAAW_17 v2

Author:
pixiu77
(Other tests from this author)

Creation Date:
22/07/2021

Category:
Others

Number of questions: 63
Share the Test:
Facebook
Twitter
Whatsapp
Share the Test:
Facebook
Twitter
Whatsapp
Last comments
No comments about this test.
Content:
You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter on the right-hand side of an assignment operator within the procedure. How do you refer to the parameter? Please choose the correct answer. :it_books it_books {it.books} @it_books.
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.
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.
ANSI SQL owns features and adds languages. These languages divided into three parts. What are they? There are 3 correct answers to this question. Data Manipulation Language The Data Control Language The Database Language The Data Definition Language Data Transferred Language.
What are the key points that should be kept in mind while performing the Non-automatic update in SAP HANATr.Cont.? There are 2 correct answers to this question. Automatic release of units Changes to Delta Container You need to refresh the content of the container manually Take snapshot manually before releasing of the container.
What are the Functions of Transaction DBACOCKPIT? There are 2 correct answers to this question. Use Schema for the Connections Maintain, Monitor and test secondary database connection Maintain only HANA specific objects Used to access local or remote database system.
You want to execute a native SQL statement in your program. Why should you use ABAP Database Connectivity (ADBC)? (Choose Two) It has syntax check as compile time. It supports exception handling It supports locking and commit handling It supports where-used list.
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 FUNCTIONAL_DB FUNCTIONAL_CHECK PERFORMANCE DB.
Where can you consume associations in a Core Data Services (CDS) view? 3 ans In the projection list In the name list In the input parameter list In the FROM clause In the WHERE and HAVING clauses.
Which option in SAP NetWeaver Gateway Service Builder (transaction SEGW) can be used to implement the consumption of a Core Data Services view? "Map to Data source" "Consume CDS view" "Relate to Business Entity" "Read from DDL source".
Which feature can you use to improve the performance of data transformation in the Extract, Transform and Load (ETL) process? Service Adaptation Description Language (SADL) Process Agent Framework (PAF) ABAP Messaging Channels (AMC) ABAP Managed Database Procedures (AMDP).
You want to implement business logic on the database layer. Which approach do you follow when implementing an ABAP Managed Database Procedure? The Left-Right approach The Near-Far approach The Top-Down approach The Inside-Out approach.
What can you include in the projection list of a Core Data Services (CDS) view? 3 ans ABAP system fields such as sy-langu or sy-mandt / CI String constants and literal values Aggregation functions over fields of ABAP Dictionary tables used in the FROM clause A field from the structural output of an ABAP Managed Database Procedure used in the FROM clause A field from the projection list of another CDS view used in the FROM clause.
Explain the Enterprise Information System of- SAP HANA Implementation Scenarios? There are 3 correct answers to this question HANA Accelerators All HANA Combinations on one platform HANA Modeling All SAP applications on one SAP HANA platform Business Suite on HANA/ BW on SAP HANA.
Discuss the main capabilities of SAP BusinessObjects Analysis for Office? There are 2 correct answers to this question Convert crosstab cells to formula Analyze data with the design pane Suggests style sets for crosstabs Sort data by characteristics.
Open SQL largely standardized, three sub-languages. What are these sub-languages? There are 3 correct answers to this question Data Evaluation Language (DEL) The Data Definition Language (DDL) Data Transferring Language (DTL) The Data Control Language (DCL) Data Manipulation Language (DML).
When would you use a column store table instead of a row store table? There are 2 correct answers to this question. When you require aggregation and analysis of values When the table has a small number of records When there are mainly distinct values in the table When you want to enable a full-text-search of the table.
Which Of the Golden Rules for Open SQL performance have become more important With SAP HANA? There are 2 correct answers to this question. Keep unnecessary load away from the database. Minimize the number of database accesses Minimize the amount of transferred data Minimize the search overhead.
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.
You define and implement an ABAP Managed database procedure (AMDP). What do you have to list after the USING clause? (3 right answers) ABAP Dictionary views used in the procedure body ABAP Dictionary table used in the procedure body AMDP used in the procedure body Function used in the procedure body SAP HANA views used in the procedure body.
Discuss the basic approach of classical ABAP programming. Two answers Collect all the data and perform parallel processing in ABAP Creating and consuming all the contents from network Get all the data you need on the application server and do your processing in ABAP Keep load from the database.
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.
Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)? Existence check for secondary indexes Use of Native SQL and DB Hints Missing ORDER BY or SORT after SELECT Direct access to table pools/cluster.
Analytic Privilege can be applied to ? (3 Answers) Calculation views Attribute views Analytic views Table SQL View.
The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question. Avoid idiling CPU cores Avoid CPU cache misses Avoid optimizing data Avoid single network.
Which of the following ABAP language elements are mandatory for the implementation of a method as an ABAP Managed Database Procedure? 3 ans FOR db (db = HD ..) LANGUAGE dbjang (dbjang = SQLSCRIPT ..) BY DATABASE PROCEDURE CLIENT SPECIFIED AUTHORIZATION db_auth (db_auth = SYSTEM ..).
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.
You changed an SAP HANA object that you transported using an SAP HANA Transport container. You want to release the transport request with your changes. In which sequence do you perform activities in the ABAP development system immediately before the release? Please choose the correct answer. Open the SAP HANA transport container Select take snapshot and Save Activate the SAP HANA Transport Container Open the SAP HANA delivery unit Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container Open the ABAP transport request Select take snapshot and Save Activate the SAP HANA transport container Open the package Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container.
What are the Functions of Transaction DBACOCKPIT There are 2 correct answers to this question. Use Schema for the Connection Maintain, Monitor and test secondary database connection Maintain only HANA specific objects Used to access local or remote database system.
Which system schema contains the list of Activated and inactive Objects? Used to access local or remote database system Maintain, Monitor and test secondary database connection Use Schema for the Connections Maintain only HANA specific objects.
How can you exchange SQL Monitor data between two systems? Create a snapshot of the SQL Monitor data, export it to the file system, and then import it to the target system. Deactivate the SQL Monitor in the source system and activate the SQL Monitor in the target system. Configure a secondary database connection to the target system and query the data in the SQL Monitor. Create and release a transport request containing the SQL Monitor log files.
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.
Which is better from performance point of view? SQLScript Procedure Modeling Views.
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} order by sojd select from snwd_so {so_id( sum(net_amount) as sum_amount} group 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.
You execute a Native SQL query statement to retrieve a list of information using the corresponding ABAP Database Connectivity (ADBC) API method. Which additional steps are necessary to retrieve the result set into an internal table? 2 ans Close the CL_SQL_STATEMENT object to release the resources. Use an Open SQL query that uses the JOIN between the result set and the internal table as a data source. Bind a reference to the internal table as an output parameter to the CL_SQL_RESULT_SET instance. Fetch the result using the next_package method of class CL_SQL_RESULT_SET. Fetch the result using the fetch method of class CL_SQL_EXECUTE.
Which of the statements are true for SQLScript? (2 answers) SQLScript is an open standard. SQLScript is used to push down data intensive logic into the database. SQLScript is a collection of extensions to SQL.
In addition to closing the result set. what does the CLOSE method of the CL_SQL_RESULT_SET class when using ABAP Database Connectivity (ADBC) do? Please choose the correct answer. Release resources Release packages Update resources Update packages.
You have defined the following SQLScript procedure: CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS SQL DATA. Which type of database procedures can be called in this SQLScript procedure? Please choose the correct answer. Read-write Read only Write only Read-update.
You analyse 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 for a specific application server SQL monitor was activated with a filter that excludes database table Y The data has NOT yet been transferred to the SQL monitor database tables Program X was executed in the background. Database table Y is a buffered table.
What all are the steps to perform -To enable type-ahead for an input field on a screen? There are 3 correct answers to this question. Process on all the input fields Automatic updates of all the input fields Check Pre-Requisites Identify Elementary Search Help Switch on proposal search for input fields.
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? 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.
Why is a security concept in SAP HANA required? There are 2 correct answers to this question Need to have selected users in SAP HANA for Information Management Access to ERP tables must be restricted Editing of SAP HANA data models should only be possible for "Users" of the model Database administration should be restricted to skilled.
What is the central goal of using SAP HANA? Please choose the correct answer Positive Impact on Business Accelerate Performance To set Priorities for system Monitor database for record keeping.
Which statement is true for SAP HANA? SAP has partnered with major hardware providers like HP, FUJITSU, CISCO, IBM, HITACHI etc. SAP only provides SAP HANA software which can run on the hardware provided by these partners SAP provides both hardware and software for SAP HANA.
Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question. ABAP Dictionary Open SQL Core data services (CDS) data definition Core data services (CDS) access control.
Which system schema contains the column views of activated objects? _SYS_BI _SYS_BIC _SYS_XS _SYS_REPO.
You developed an ABAP program using ABAP Development Tools for SAP NetWeaver. How can you execute it? 2 ans In the Project Explorer view, right-click the program and choose Run As ― ABAP Application from the context menu. Use the Open Development Object dialog (CTRL+SHIFT+A) and enter <Program_Name>/Execute in the search field. Open the ABAP program in the ABAP Development perspective and execute it using the shortcut F8. Open the ABAP program in the ABAP Development perspective and execute it using the shortcut Fl. Call transaction SRUN_ADT and enter the name of the ABAP program.
Which of the following categories of parameters can you use in the definition of an ABAP manage database procedure (AMDP)? There are 3 correct answers to this question. Returning Receiving Exporting Changing Importing.
Which components can be a part of a calculation view? (2 answers) BAPIs Analytic View Tables Attribute View.
What is the main advantage of SQLScript? (2 answers) SQLScript can be better modularized than traditional SQL SQLScript code can easily be translated into modeling view SQLScript is faster than traditional SQL.
How many result sets are returned when an SAP HANA database procedure is called using the CALL WITH OVERVIEW statement? Please choose the correct answer. As many result sets as there are input parameters in the procedure Two result sets One result set As many result sets as there are table output parameters in the procedure.
What is the scope of the AbapCatalog.Buffering annotation in a Core Data Services (CDS) view? The set of key fields specified in the additional annotation AbapCatalog.buffering.numberOfKeyField The CDS views used in the FROM clause The entire CDS view The elements in the projection list of the CDS view.
What are the two types of editors available in ADT? There are 2 correct answers to this question. Eclipse (native) Client (native) SAP (GUI) ABAP (native).
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.
What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling? There are 2 correct answers to this question Account-based Profitability Costing-based Profitability Product-based Profitability Service-based profitability.
Which of the following is not an element of Analytical view? Please choose the correct answer. Currency conversion is not applicable Join fact tables Read Data from the joined database tables Used to Joined table.
What is the purpose of an ABAP project in ABAP Development tools for eclipse? (2 right answers) It provides access to all ABAP repository objects in an ABAP system. It represents the connection to an ABAP system It represents the connection to the SAP HANA server It is used to transport ABAP repository objects.
You are using a calculated column COUNTS within your Dimension Calculation View and an aggregation node. This is the data that goes into the aggregation node: AT Vienna 11 AT Vienna 15 DE Berlin 13 DE Berlin 13 AT Vienna 11 AT Vienna 15 DE Berlin 13 AT Vienna 26 DE Berlin 26 AT Vienna 11 DE Berlin 13.
When are referential joins executed in analytical views? Choose the correct answer When all the tables are optimized When fields are selected When fields are optimized When fields from both the tables are requested.
Before migrating to SAP HANA, which Code Inspector check do you have to consider to avoid functional regressions? Standard Web Dynpro checks Search for DB operations across modularization units SELECT statements that bypass the table buffer Use of the ADBC interface.
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 Trace (transaction ST05) SQL monitor (transaction SQLM) ABAP test cockpit (transaction ATC).
What are the different views provided by the ABAP Profiling? There are 2 correct answers to this question. Performance Check methods Database accesses Metadata accesses A Hitlist of the most time-consuming programs or methods.
What would you find in a package? There are 3 correct answers to this question. Information Views Analytic Privileges Table Procedures.
Report abuse Terms of use
HOME
CREATE TEST
COMMENTS
STADISTICS
RECORDS
Author's Tests