option
My Daypo

E_HANAAW_17 v1 - ABAP for SAP Hana 2.0 Example Questions

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

Description:
SAP Development Specialist Tests - E_HANAAW_17 v1

Author:
pixiu77
(Other tests from this author)

Creation Date:
21/07/2021

Category:
Others

Number of questions: 60
Share the Test:
Facebook
Twitter
Whatsapp
Share the Test:
Facebook
Twitter
Whatsapp
Last comments
No comments about this test.
Content:
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.
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).
An Analytic Privilege consists of several restrictions. What are they? There 3 correct answers to this question View restrictions Analytic restrictions Validity restrictions Activity restrictions Cube restrictions.
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.
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 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.
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 = HDB...) LANGUAGE dbjang (dbjang = SQLSCRIPT...) BY DATABASE PROCEDURE CLIENT SPECIFIED AUTHORIZATION db_auth (db_auth = SYSTEM ...).
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.
Explain the Enterprise Information System of- SAP HANA Implementation Scenarios? There are 3 correct answers to this question HANA Accelerators All SAP applications on one SAP HANA platform Business Suite on HANA/ BW on SAP HANA All HANA Combinations on one platform HANA Modeling.
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.
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.
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.
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.
Why is a security concept in SAP HANA required? There are 2 correct answers to this question Access to ERP tables must be restricted Database administration should be restricted to skilled Editing of SAP HANA data models should only be possible for "Users" of the model Need to have selected users in SAP HANA for Information Management.
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) The Data Control Language (DCL) Data Manipulation Language (DML) Data Transferring Language (DTL).
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 two types of editors available in ADT? There are 2 correct answers to this question. Eclipse (native) SAP (GUI) Client (native) ABAP (native).
What is the purpose of an ABAP project in ABAP Development tools for eclipse? 2 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.
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.
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 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. Database Performance Monitor (transaction DB50) Code Inspector (transaction SCI) SQL Monitor (transaction SQLM) ABAP Test Cockpit (transaction ATC) SQL Trace (transaction ST05).
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 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.
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? There are 3 correct answers to this question. 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.
Which system schema contains the column views of activated objects? _SYS_BI _SYS_REPO _SYS_XS _SYS_BIC.
Which is better from performance point of view? SQLScript Procedure Modeling Views.
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.
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.
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.
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.
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).
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.
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.
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 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 Check Pre-Requisites Identify Elementary Search Help Switch on proposal search for input fields Automatic updates of all the input fields.
Which components can be a part of a calculation view? (2 answers) BAPIs Analytic View Tables Attribute View.
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.
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.
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 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.
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.
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 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.
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 Used to access local or remote database system Maintain only HANA specific objects.
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.
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.
Analytic Privilege can be applied to (3 Answers) Calculation views Attribute views Analytic views Table SQL View.
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.
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.
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 Core Data Services views Stored procedure.
Discuss the basic approach of classical ABAP programming. 2 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.
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.
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.
Before migrating to SAP HANA, which Code Inspector check do you have to consider to avoid functional regressions? Choose the correct answer Use of the ADBC interface Standard Web Dynpro checks Search for DB operations across modularization units SELECT statements that bypass the table buffer.
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 of the following are classes of the ABAP Database Connectivity (ADBC) API? 2 ans CL_SQL_EXECUTE_QUERY CL_SQL_RESULT_SET CL_SQL_STATEMENT CL_EXEC_SQL CL_ADBC_SQL_STATEMENT.
What you must do when you define and implement an ABAP Managed Database Procedure (AMDP) ? There are 3 correct answers to this question. Define all the method parameters to pass by value List all the ABAP dictionary tables used in the procedure body in the USING clause Use Scalar types for all the AMDP method parameters Specify the database system and language Mark the AMDP method as read-only.
AMDP can detect 3 types of syntax errors in active or inactive source code. What are these errors ? There are 3 correct answers to this question. UNION specific syntax errors Database platform syntax errors Database independent syntax errors HANA specific syntax errors SQLScript errors.
Which recent software innovations are applied in SAP HANA? 3 ans Columnar data storage Automated de-installation at system shutdown Improved data compression algorithms Insert Only approach Random Undefined Multi-Memory Swapping (RUMMS).
What all are the Types of Applications based on SAP HANA? There are 2 correct answers to this question. Server based on SAP HANA Innovation based on SAP HANA New or Native SAP HANA Data Mart based on SAP HANA.
Report abuse Terms of use
HOME
CREATE TEST
COMMENTS
STADISTICS
RECORDS
Author's Tests