option
My Daypo

E_HANAAW_17

COMMENTS STADISTICS RECORDS
TAKE THE TEST
Title of test:
E_HANAAW_17

Description:
ABAP on Hana SAP 17

Author:
Vk
(Other tests from this author)

Creation Date:
21/07/2021

Category:
Others

Number of questions: 221
Share the Test:
Facebook
Twitter
Whatsapp
Share the Test:
Facebook
Twitter
Whatsapp
Last comments
No comments about this test.
Content:
You create a new table definition using the ABAP Dictionary and maintain the database-specific technical settings. Why do you create a row store instead of a column store table? To limit the unpacking and reconstruction of rows To allow creation of a full-text index To limit the need of indexes To limit the data footprint.
Which of the following repository object can you edit only in ABAP Development tools in Eclipse and:not in the Classical ABAP workbench? Note: There are 3 correct answers to this question. Full-text index Core Data service (CDS) view Database procedure proxy ABAP program containing new Open SQL External view.
You define and implement an ABAP Managed database procedure (AMDP) What do you have to list after the USING clause? Note: There are 3 correct answers to this question. ABAP Dictionary table used in the procedure body ABAP Dictionary views used in the procedure body CE function used in the procedure body SAP HANA views used in the procedure body AMDP used in the procedure body.
Which tasks does the ABAP managed database (AMDP) framework perform? Note: There are 2 correct answers to this question. Create a new version of the database when the AMDP is first activated Delete the obsolete versions of the database procedure asynchronously Delete the obsolete versions of the:database procedure synchronously Create a new version of the database-when the AMDP is first called.
What is the purpose of an ABAP project in ABAP Development tools for eclipse? Note: There are 2 correct answers to this question. lt represents the connection to the SAP HANA server It represents the connection to an ABAP system It is used to ABAP repository objects. It provides access to all ABAP repository objects in an ABAP system.
You'developed an ABAP managed database procedure (AMDP). You want to allow the enhancement of this AMDP using business add-in (BADI). Which of the following objects must you create? Note: There are 3 correct answers to this question. A BADI definition An enhancement spot A database procedure A BADI simple implementation A BADI fallback implementation.
Which of the following tools and programming techniques use the SQL data definition language? Note: There are 2 correct answers to this question. Core data services (CDS) data definition ABAP Dictionary Core data service (CDS) access control Open SQL.
Which of the following are view annotations for a CDS view? Note: There are 3 correct answers to this question. Access control Environment Client handling Semantics Buffering type.
Which of the following feature were added to the ABAP Dictionary_to support the SAP HANA database? Note: There are 3 correct answers to this question. De-pooling and de-clustering Changes of data class Definition of an enhancement category Definition of full-text indexes Storage type for tables.
What must you take into consideration'when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? Note: There are 2 correct answers to this question. All Keywords are case sensitive All fields in the GROUP BY clause’must be separated by commas. All ABAP variables must be-escaped with a proceeding @ sign. All arithmetic expressions:can be used for all type of variables.
Which of the following objects can you use in the ABAP layer when using the top-down approach to bring code to data? Note: There are 2 answers to this question. Calculation views Core data services views ABAP managed database procedures Stored procedure.
You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data? Note: There are 3 correct answers to this question. Use a Comma-separated column list Use the tilde symbol (~) to separate qualifier from column name Specify the database schema if it is not the user’s default schema Use the UP TO n ROWS addition Explicitly handle the client field.
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? COLUMN ROW GLOBAL TEMPORARY LOCAL TEMPORARY.
In a Graphical calculation view you want to implement a union between two result that differ only in the fact that one of the two has one additional field named ADDRESS. How can you achieve this in a union node? Note: There are 2 correct answers to this question Create a restricted column for the ADDRESS field Map the ADDRESS field to a constant value Exclude the ADDRESS field from the union Create an input parameter for the ADDRESS field.
You use the ABAP trace (SAT) to measure the run time of a program. In a class, method X checks the validity of its importing parameters and calls method _Y: What pattern of gross and net run time would you,expect to see the in the ABAP trace results for method X? The net run time is greater than the gross run time The gross and net run times are identical The net run time is equal to Zero The net run time is less than the gross run time.
Which data sources can you'use for SAP list viewer with integrated data access? Note: There are 3 correct answers to this question Internal table Database Procedure Database Table External view CDS View.
Which can you use to provide input data for the SQL performance tuning work list (Transaction SWLT) Note: There are 3 correct answers to this question SQL Trace (transaction ST05) ABAP test cockpit (transaction ATC) Code inspector (transaction SCl) Data base performance monitor (transaction DB50) SQL monitor (transaction SQLM).
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? SET_PARAM EXECUTE_QUERY SET_PARAM_TABLE NEXT_PACKAGE.
User STUDENT_A create and activates a design-time object In which schema is the run object generated? STUDENT_A SYS BI SYS BIC SYSTEM.
You define a core data services (CDS) View For which of the following expressions and built in functions must you provide alias? Note: There are 3 correct answers to this question Unit conversion CASTE Expression Currency Conversion CASE expression Nested CASE expression.
Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? Note: There are 2 correct answers to this question Use array variants of INSERT UPDATE MODIFY and DELETE Use SELECT FOR ALL ENTRIES instead/of a nested SELECT statement Perform all calculations and aggregations.in the ABAP layer Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES.
You define a core data.services (CDS) view to merge the results of queries using the UNION keyword. What must the column list of this queries contain? Note: There are 2 correct answers to this question Columns of identical types Columns of compatible types The same-number of columns All key fields.
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? Open the SAP HANA transport container Select take snapshot and Save 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 Open the SAP HANA delivery unit Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container.
How many result sets are returned when an SAP HANA database procedure is called using the CALL WITH OVERVIEW statement? As many result sets as there are table output parameters in the procedure Two result sets As many result sets as there are input parameters in the procedure One result set.
Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does NOT Offer? Note: There are 2 correct answers to this question Enhanced distribution of results Documented checks Configuration of check variants Flexible schedule of check runs.
In an ABAP Core Data services.(CDS) view, what must you do expose an association for use in another CDS view? SPECIFY THE OTHER VIEWS.IN WHICH THE ASSOCIATION CAN BE USED Include all fields used in the.ON condition in projection list specify an alias for the.target entity define the cardinality for the target entity.
Which of the following take advantage of the computing power of multiple CPUs used by SAP HANA? Note: There are 2 correct answers to this question Database table compression Parallel processing Columnar data storage Partitioning.
What are some of the features available SAP List Viewer with integrated data access (SALV IDA)? Note: There are 3 correct answers to this question Display diagrams Edit cells Double-click on rows Group rows Search in content.
Which of the following is a limitation when you create an external view? You must include the name of the SAP HANA view in the name of the external view. You must use the ABAP Development tools (ADT) TO CREATE the external view You can only use native SQL to consume the external view You must know the underlying tables and join conditions of the SAP HANA view.
You import an ABAP workbench request into a SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package ZHA400_00. WHICH PREREQISITIES are mandatory for an implicit deployment of the SAP HANA view onto the database? Note: There are 2 correct answers to this question View CA_CUSTOMER has deployment mode A. Package ZHA400_00 Is listed in table SNHI_ DUP_PREWORK SYSTEM P81 has SAP HANA has primary database PACKAGE ZHA400_00 HAS deployment Mode A.
Which of the following tasks can you perform with SQL monitor (transaction SQLM)? Capture the SQL profile of an application Display the execution plan of an SQL statement Combine static and dynamic performance analysis results Search for problematic SELECT* statements.
Which data provisioning methods can you.use when you need real time replications? Note: There are 3 correct answers to this question SAP HANA Direct extractor connection (SAP DXC) SAP Replication server SAP Data services SAP Landscape transformation Replication server (SAP SLT).
You are working with ABAP Development Tools (ADT) For Eclipse. Which of the following options belongs to the settings of a specific ABAP project rather than the entire Eclipse workbench? Statement template options Code completion options Code formatting options Editor shortcut key options.
You created and activated database procedure How can you Call this procedure? Note: There are 2 correct answers to this question By using Sap Analysis for Microsoft office By a script-based calculation view By a core data services view By another database procedure.
You made changes to an object (X) used by an ABAP managed database procedure (AMDP). You did NOT changes the AMDP itself. Now you execute a program that calls this AMDP. In which cases does the call trigger the creation of the database procedure in SAP HANA? Note: There are 2 correct answers to this question X is an SAP HANA view X is an AMDP method X is an ABAP Dictionary table X is a stored procedure.
One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any functional issues after the migration What should you search for and if necessary replace in the existing custom ABAP*code? Note: There are 3 correct answers to this question ORDER BY Clauses in Open SQL statements Direct access to a cluster on the database Code that relies on implicit database sorting Native SQL statements Left outer joins in open SQL statements.
Which steps do you have to perform when defining’a view using core data services (CDS)? Note: There are 3 correct answers to this question Create a proxy object for the defined view: Specify the name of the SQL view in ABAP Dictionary Use the DDL statement DEFINE VIEW_and SQL like Syntax Define the type mapping between ABAP and SAP HANA Create a data definition in your ABAP package.
What are best practices when programming in ABAP for SAP HANA? Note: There are 2 correct answers to this question Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required Eliminate nested SELECT statements to reduce the overall number of database accesses Calculate aggregations using ABAP code on the application server to limit database load Use a column list in the SELECT clause to ensure that you only read a column if it is really required.
You want to debug an ABAP program using ABAP development tools (ADT). How do you launch the debugger? Choose the Run --> Debug options in the menu Create a debug configuration for the ABAP application and run the program Choose the debug as option in the context menu of the ABAP program Set a breakpoint in the ABAP program and execute the program.
Which of the following categories of parameters can you use in the definition of an ABAP manage database procedure (AMDP) Note: There are 3 correct answers to this question Receiving Changing Returning Exporting Importing.
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.
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. Check Pre-Requisites Switch on proposal search for input fields Process on all the input fields Automatic updates of all the input fields Identify Elementary Search Help.
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 ABAP transport request 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 SAP HANA transport container 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.
Which JOIN types can be used in the definition of a Core Data Services (CDS) view? 2 ans FULL OUTER JOIN LEFT OUTER JOIN RIGHT OUTER JOIN REFERENTIAL JOIN CROSS JOIN.
What are the two main factors of SAP HANA Innovations and Challenges? There are 2 correct answers to this question. SAP SW technology and innovations DBMS technology and innovations HW technology and innovations SAP BW innovations.
Which code-to-data capability supports- Extended view definitions and Better SQL-92 standard support in open SQL? Please choose the correct answer. Database for sophisticated analysis SAP HANA specific features Database oriented programming model New SQL parser used in model.
You made changes to an object (X) used by an ABAP managed database procedure (AMDP). You did NOT changes the AMDP itself. Now you execute a program that calls this. In which cases does the call trigger the creation of the database procedure in SAP HANA? There are 2 correct answers to this question. X is a stored procedure. X is an AMDP method X is an ABAP Dictionary table X is an SAP HANA view.
What should you do to follow the code-to-data approach to programming? 2 ans Perform expensive calculations on the database Transfer all data from the database to the ABAP layer, and tehn aggregate the results. Aggregate data on the database, and transfer the results to the ABAP layer. Perform expensive calculations on the ABAP application server.
Discuss the main capabilities of SAP Business Objects Analysis for Office? There are 2 correct answers to this question Analyze data with the design pane Sort data by characteristics Convert crosstab cells to formula Suggests style sets for crosstabs.
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.
User STUDENT_A create and activates a design-time object. In which schema is the run object generated? Please choose the correct answer _SYS_BIC SYSTEM STUDENT_A _SYS_BI.
The SAP HANA state-of-the-art search experience includes full-text search with advanced features like... There are 3 correct answers to this question. Fuzzy search Isolation search Linguistic search Freestyle search ACID search.
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.
You create a new table definition using the ABAP Dictionary and maintain the database- specific technical settings table? Why do you create a row store instead of a column store Please choose the correct answer. To limit the need of indexes To limit the data footprint To allow creation of a full-text index To limit the unpacking and reconstruction of rows.
What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question. Use native SQL to access SAP HANA built-in functions. Transfer all data from the database to the ABAP layer, and then aggregate the results. Aggregate data on the database, and transfer the results to the ABAP layer Perform expensive calculations on the ABAP application server. Perform expensive calculations on the database.
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 if the following are correct ways of specifying packaging path and object name in the FROM clause? Choose the 2 correct answers 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? Choose the correct answers Transparent Table Database view CDS view External view.
Which of the following features are NOT supported by ALV with IDA? Choose the correct answer 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 view to complete 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> _plant.fieldA, _plant.fieldB _plant.fieldA.fieldB, _plant.fieldB.
What are the performance Rules and Guidelines for ABAP on SAP HANA? 2 answers to keep all the loads away from DB It is beneficial to move data intensive calculations into database It is beneficial for maximizing your search into database To reduce main memory consumption and to improve insert performance.
What are the steps that supported several tools, which in total result in a Guided Performance Optimization? 2 ans A new tool called SQL monitor to determine the priority if different programs access the database intensively A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues Tools analyzing performance at run time, to determine if critical constructs The ABAP Trace (SAT) and the ABAP profiling perspective to measure and compare runtime consumption.
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 Hybrid data and management system Support for system tables Analytical DBMS features.
User STUDENT_A creates and activates a design-time Object. In which schema is the runtime object generated? SYS_Bl SYSTEM _SYS_BIC STUDENT_A .
You are programming a report that reads data from a secondary HANA database (DB). What do you need to consider in your SQL statement? Note: There are 2 correct answers to this question. You have to specify the DB schema explicitly in your statement. All tables and fields you are using must exist 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 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? Note: There are 3 correct answers to this question. The data has NOT yet been transferred to the SQL monitor database tables Database table Y is a buffered table SQL Monitor was activated for a specific application server SQL monitor was activated with a filter that excludes database table Y Program X was executed in the background.
You define and implement an ABAP Managed Database Procedure (AMDP). What do you have to list after the USING clause? Note: There are 3 correct answers to this question. ABAP Dictionary tables used in the procedure body AMDPs used in the procedure body ABAP dictionary views used in the procedure body SAP HANA views used in the procedure body CE functions used in the procedure body .
You want to execute a native SQL statement in your program. Why should you use ABAP Database Connectivity (ADBC)? Note: There are 2 correct answers to this question. It supports exception handling It supports where used list It has syntax check at compile time It supports locking and commit handling.
What are the two main factors of SAP HANA Innovations and Challenges? There are 2 correct answers to this question. SAP SW technology and innovations HW technology and innovations DBMS technology and innovations SAP BW innovations.
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? Note: There are 3 correct answers to this question. Replace ORDER BY additions Add explicit client handling Specify the schema for every table Replace CORRESPONDING FIELDS additions Replace UP TO n ROWS additions.
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? Note: There are 2 correct answers to this questions. _SYS_BIC."ha400.primdb::CA_BOOKINGS_COUNT" _SYS_BIC."ha400.primdb/CA_BOOKINGS_COUNT" "ha400.primdb::CA_BOOKINGS_COUNT" "ha400.primdb/CA_BOOKINGS_COUNT".
You are using ABAP Development Tools, and you have placed your cursor on a method name in a class. What key do you use to navigate between a method definition and its implementation ? F2 F3 F1 F4.
You have created a CDS view and used alias names for some of its elements. In which of the following cases is the alias name mandatory? Note: There are 3 correct answers to this question. CASE order type WHEN 'A' THEN 1 ELSE 0 END AS Order_type Crtdby AS created_by SUM( revenue ) AS total_revenue ASSOCIATION TO sflight AS_flights CAST( 'USO' AS abap.cuky) AS currency_key.
When are referential joins executed in analytical views? Please choose the correct answer When fields from both tables are requested When fields are selected When fields are optimized When all the tables are optimized.
You have created a CDS view as follows: define view zha400 as select from spfli association (*) to sflight as_flights On spfli.carrid =_flights.carrid and spfli.connid=_flights.connid { … } Given that table sflight also contains the field planetype, how must you address the fields carrid and planetype from table SFLIGHT? _ flights.carrid and planetype carrid and _flights.planetype _flights.carrid and _flight.s .planetype carrid and planetype.
You are debugging in ABAP Development Tools in Eclipse. What features are available? Note: There are 2 correct answers to this question. Watch points Debugger scripting Memory usage analysis Conditional breakpoints.
When using an SAP HANA full text search, What do you have to keep in mind? The full-text index is always updated asynchronously SAP HANA has to be the primary database to create a full text search The SCORE () function is required to ensure the best hits of your search appear on top The LIKE operator is required in your SELECT statement to implement fuzzy logic.
What benefits does SAP HANA Data Compression provide? Note: There are 2 correct answers to this question Optimized data partitioning Optimized access to column store tables Reduced memory consumption Increased parallel processing.
You are programming a report that reads data from a secondary HANA database (DB). What do you need to consider in your SQL statement? Note: There are 2 correct answers to this question. You have to specify the DB schema explicit y in your statement All tables and fields you are using must exist 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.
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 automatically add changed objects to the transport request Because you always transport entire SAP HANA content packages Because you can manually re-deploy objects after a failed import Because you use the technique that is recommended by SAP.
Which functional problem can you detect when using the Runtime Check Monitor (SRTCM ) ? Use of Native SQL and DB Hints Missing ORDER BY or SORT after SELECT Existence check for secondary indexes Direct access to table pools/cluster.
Which step of the Guided Performance Analysis should you perform in the product on system? Please choose the correct answer. Building a work list with SQL Performance Tuning Work list (SWLT) Executing a check run with ABAP Test Cockpit (ATC) Collecting data with SQL Monitor (SQLM) Performing an inspection with Code Inspector (SCI) .
What are the components of The Enterprise Procurement Model Demo Scenario? There are 3 correct answers to this question Stock Sales Services Procurement Product.
What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA? There are 3 correct answers to this question. Detect Scaling Optimize Tuning Innovate.
What are the two layers of ABAP system interacts with its database? There are 2 correct answers to this question. The Data Storage interface The Database specific library The Client database interface The Database independent interface.
You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAP HANA is used as the database. In the check parameters, which value would you use for the percentage of fields that are effectively used? Please choose the correct answer. A value that you calculate based on the number of tables The same value as on a traditional, row-store only based database The same value as on a traditional, row-store only based database A lower value than on a traditional, row-store only based database.
You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SO_ID). 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 net_amount select from snwd_so { so_id, sum(net_amount) as sum_amount } order by so_id select from snwd_so { so_id, sum(net_amount) as sum_amount } select from snwd_so { so_id, sum(net_amount) as sum_amount } group by so_id.
Which of the following is not involved in database table of “The New ABAP SQL Monitor – Architecture”? Choose the correct answer Runtime monitor data Critical data table Performance data table Selection data table.
How SAP HANA supports SQL? There are 3 correct answers Read As a means to define Manipulate data As a data calculator Transferring data.
For which of the following expressions and built in functions in core data services (CDS) view you must provide alias? There are 3 correct answers Currency Conversion CASE expression Unit conversion CASTE Expression Nested CASE expression.
What do you have to consider if you want to use Native SQL in your ABAP programs to access an SAP HANA database? There are 2 correct answers. Client handling needs to be done explicitly in the Native SQL statement The database independency of your report can be lost Hashed or sorted tables must be used with the INTO CORRESPONDING FIELDS keyword The ABAP system checks the syntax of the Native SQL statements.
Which of the following tasks can you perform with SQL monitor transaction SQLM? Capture the SQL profile of an application Combine static and dynamic performance analysis results Search for problematic SELECT* statements Display the execution plan of an SQL statement.
When using 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 tabular result of the native SQL call? NEXT_PACKAGE GET_METADATA SET_PARAM SET_PARAM_TABLE.
An analytic privilege consists of several restrictions. What are they? There are 3 correct answers Cube restrictions Validity restrictions Activity restrictions Analytic restrictions View restrictions.
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? There are 2 correct answers In data preview in ADT In ABAP open SQL In definition of another CDS view In data browser (SE16).
You use the ABAP trace (SAT) to measure the run time of a program. In a class, method A checks the validity of its importing parameters and calls method B. What pattern of gross and net run time would you expect to see the in the ABAP trace results for method A? The net run time is equal to Zero The net run time is less than the gross run time The net run time is greater than the gross run time The gross and net run times are identical.
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 Run --> Debug options in the menu Create a debug configuration for the ABAP application and run the program Choose the debug as option in the context menu of the ABAP program Set a breakpoint in the ABAP program and execute the program.
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. Configuration of check variants Enhanced distribution of results Flexible schedule of check runs Documented checks.
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. Analytical DBMS features High Performance and Scalability Support for system tables Hybrid data and management system.
Which is not a Golden Rule for Open SQL? Please choose the correct answer. Minimize the Amount of Data Transferred Keep the result set large Reduce the Database Load Minimize the Number of Database Accesses.
What all are the factors involved in Working with ADT? There are 3 correct answers to this question. ABAP interface ABAP programs Workbench programs ABAP Class Module interface.
Hybrid Data Management System combining different paradigms in one system. What are the capabilities associated with the Hybrid Data Management system? There are 3 correct answers to this question. Linguistic search capabilities Traditional disk-based tables Text indexing capabilities Built-in support for planning Text analysis and search.
What are some of the features available SAP List Viewer with integrated data access (SALV IDA)? There are 3 right answers. Search in content Display diagrams Group rows Edit cells Double-click on rows.
What are the uses of SQL Trace (ST05)? There are 3 correct answers to this question. Applying Code inspector Display record of all database access Detect redundant or identical select statements Locate database performance issues Locate work base issues.
What information can you specify using annotations (marked with the @ sign) when you define a Core Data Services (CDS) view in an ABAP system? There are 3 correct answers to this question. The join conditions of the CDS view The logic for aggregations, grouping records, and filtering groups of the CDS view The client dependency of the CDS view The name of the representation of the CDS view in the ABAP dictionary The extent to which records of the CDS view should be buffered on the application server.
How many result sets are returned when an SAP HANA database procedure is called using the CALL WITH OVERVIEW statement? Two result sets As many result sets as there are table output parameters in the procedure One result set As many result sets as there are input parameters in the procedure.
What are the two main factors of SAP HANA Innovations and Challenges? There are 2 correct answers. HW technology and innovations SAP SW technology and innovations SAP BW innovations DBMS technology and innovations.
What are the Guidelines for optimizing ABAP code running on HANA? There are 3 correct answers to this question. Column store High-speed data analysis Technical settings Open SQL settings DB specific properties.
Which of the following option provides access to the views and database procedures that you can consume in the ABAP environment? Please choose the correct answer. System Perspective Catalogue outlook Open Content outlook Modeler Perspective.
Which of the following is a limitation when you create an external view? You can only use native SQL to consume the external view You must use the ABAP Development tools (ADT) to create an external view You must know the underlying tables and join conditions of the SAP HANA view You must include the name of the SAP HANA view in the name of the external view.
The SAP HANA database is a hybrid in-memory database that combines Few technologies within. What are these technologies? There are 3 correct answers to this question Column-based database technology Value-based database technology Row-based database technology Object-based database technology Time-based database technology.
What is an attribute view and what are its practices? There are 3 correct answers to this question. Used in diagrammatic Projections May use in calculation views May contains flow charts May contain filters Used to join tables.
You define a core data services (CDS) view to merge the results of queries using the UNION keyword. What must the column list of this queries contain? There are 2 correct answers to this question. The same number of columns All key fields Columns of compatible types Columns of identical types.
What are the two types of editors available in ADT? There are 2 correct answers to this question. SAP (GUI) Client (native) ABAP (native) Eclipse (native).
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.
Which of the following objects can you use in the ABAP layer when using the topdown approach to bring code to data? There are 2 correct answers to this question. ABAP managed database procedures Calculation views Stored procedures Core data services views.
Which of the following are view annotations for a CDS view? There are 3 correct answers to this question. Buffering type Client handling Semantics Environment for Amount / Currency Code Authority checking / Access control View Name.
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 delivery unit Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container Open the SAP HANA transport container 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 Open the ABAP transport request Select take snapshot and Save Activate the SAP HANA transport container.
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 Buffer system Optimization HANA Specific features Transparent Optimizations.
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 Transferred Language The Database Language The Data Definition Language Data Manipulation Language The Data Control Language.
You made changes to an object (X) used by an ABAP managed database procedure (AMDP). You did NOT changes the AMDP itself. Now you execute a program that calls this AMDP. In which cases does the call trigger the creation of the database procedure in SAP HANA? There are 2 correct answers to this question. X is an SAP HANA view X is a stored procedure X is an ABAP Dictionary table X is an AMDP method.
What are the different views provided by the ABAP Profiling? (2 right answers) Database accesses Metadata accesses A Hit-list of the most time-consuming programs or methods Performance Check methods.
User XYZ creates and activates a design-time object. In which schema is the run object generated? Please choose the correct answer. _SYS_BIC _SYS_BI SYSTEM XYZ.
Which tasks does the ABAP Managed Database Procedure (AMDP) framework perform? Please choose 2 correct answers Create a new version of the database when the AMDP is first activated. Delete the obsolete versions of the database procedure asynchronously Create a new version of the database when the AMDP is first called. Delete the obsolete versions of the database procedure synchronously.
What are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container? There are 2 correct answers to this question. You need to refresh the content of the container manually Changes to Delta Container Take snapshot manually before releasing of the container Automatic release of units.
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 there are mainly distinct values in the table When you want to enable a full-text search of the table When the table has a small number of records.
You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAP HANA is used as the database. In the check parameters, which value would you use for the percentage of fields that are effectively used? A value that you calculate based on the number of tables A higher value than on a traditional, row-store only based database The same value as on a traditional, row-store only based database A lower value than on a traditional, row-store only based database.
You created and activated database procedure. How can you call this procedure? There are 2 correct answers to this question. By a core data services view By a script-based calculation view By using Sap Analysis for Microsoft office By another database procedure.
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 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 The application suggests the column name and data type for the new tables, and it is possible to edit them.
In a Graphical calculation view you want to implement a union between two result sets that differ only in the fact that one of the two has one additional field named ADDRESS. How can you achieve this in a union node? There are 2 correct answers to this question. Exclude the ADDRESS field from the union Create a restricted column for the ADDRESS field Map the ADDRESS field to a constant value Create an input parameter for the ADDRESS field.
What allows you to resolve errors quickly or warnings reported about the code? Please choose the correct answer. Code execution Quick Fix ABAP debugger Debug perspective.
What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? There are 2 correct answers to this question. All Keywords are case sensitive All ABAP variables must be escaped with a proceding @ sign All fields in the GROUP BY clause must be separated by commas All arithmetic expressions can be used for all type of variables.
What are the purposes of tools in SAP HANA system that is an Eclipse-based integrated development environment? There are 3 correct answers to this question. Configure Organizing Administer Monitor Selecting.
Which of the following is a limitation when you create an external view? You can only use native SQL to consume the external view You must use the ABAP Development tools (ADT) TO CREATE the external view You must know the underlying tables and join conditions of the SAP HANA view You must include the name of the SAP HANA view in the name of the external view.
What are the ABAP development guidelines? (2 right answers) Improved hybrid components for SAP HANA Extensions to ABAP Language Consuming Only ABAP contents for SAP HANA Improved tools for performance analysis.
What are the types of privileges associated with Authorization Concept? (3 right answers) Application privileges Analytic privileges Object privileges System privileges Delta privileges.
How to create a core data services view? There are 3 correct answers to this question. Use the ABAP Development Tools for SAP NetWeaver. Use DDL statement DEFINE VIEW and SQL-like syntax to define the view Use SQL capabilities for Netweaver Use additional annotations – marked with the @ sign Use data services tools for updates. Use data services tools for updates.
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. LOCAL TEMPORARY ROW GLOBAL TEMPORARY COLUMN .
What is the main purpose of SAML for SAP HANA Studio? Choose the correct answer SAML may be selected as an Owner’s authentication method when creating users in the SAP HANA Studio To support scenarios where clients are not directly connected to the SAP HANA Database The assertion is issued by a user after the client was successfully authenticated The SAP HANA database supports login of Owners only.
You have an SQLScript procedure with a table input parameter xyz. 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? @xyz {xyz} xyz :xyz.
Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question. Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement Perform all calculations and aggregations in the ABAP layer Use array variants of INSERT UPDATE MODIFY and DELETE.
What views will be most efficient for General Modeling Principles? There are 2 correct answers to this question Attribute view Analytical view Schema view Column view.
Which of the following feature is not supported by ALV with IDA? Editing values Double click Personalization Excel export.
You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data? (3 right answers) Specify the database schema if it is not the user's default schema Explicitly handle the client field Use the UP TO n ROWS addition Use a Comma-separated column list Use the tilde symbol (~) to separate qualifier from column name.
When to use Enhanced Open SQL? There are 2 correct answers to this question. Need the query in one piece of code only To view scalar components To access system fields At the time of Dictionary Views.
AMDP can detect 3 types of syntax errors in active or inactive source code. What are these errors ? (3 right answers) SQLScript errors Database independent syntax errors HANA specific syntax errors Database platform syntax errors UNION specific syntax errors.
What are the benefits of using the SQL Monitor (transaction SQLM)? There are 2 correct answers to this question. It schedules ABAP programs to monitor and log all database accesses. It collects monitoring data asynchronously without additional database interaction. It can be active in a production system with minimal performance overhead. It displays the database execution plan for all SQL statements.
One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any functional issues after the migration. What should you search for and if necessary replace in the existing custom ABAP code? There are 3 correct answers to this question. Code that relies on implicit database sorting Direct access to a cluster on the database Left outer joins in open SQL statements Native SQL statements ORDER BY Clauses in Open SQL statements.
Which code-to-data capability supports- Extended view definitions and Better SQL92 standard support in open SQL? Please choose the correct answer. Database for sophisticated analysis New SQL parser used in model SAP HANA specific features Database oriented programming model.
What is the purpose of an ABAP project in ABAP Development tools for eclipse? There are 2 correct answers to this question. It is used to transport ABAP repository objects. It provides access to all ABAP repository objects in an ABAP system It represents the connection to the SAP HANA server It represents the connection to an ABAP system.
What are the two main methods to add a system to the SAP HANA Studio? There are 2 correct answers to this question By Importing a Landscape Automatically By Resource console Manually.
Name some perspectives that are available in the SAP HANA Studio? There are 3 correct answers to this question The Administration Console perspective The Resources perspective The Information perspective The SAP HANA Modeler perspective The technology & innovation perspective.
What are the supported joins in CDS view? (2 right answers) Operators joint Upper join Inner join Left outer join.
Which is not a key factor of ALV for HANA? Please choose the correct answer. Derived Column headings from the data element The data display is restricted to a maximum of 2 billion cells To Activate and execute the program in the application To supply suitable values for any input parameters.
Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)? (3 right answers) Code inspector (transaction SCI) SQL Trace (transaction ST05) SQL monitor (transaction SQLM) ABAP test cockpit (transaction ATC) Data base performance monitor (transaction DB50).
What are the elements of ABAP Database Integration? There are 3 correct answers to this question. DB client-server Application server Other DB Client database handling DB For ABAP.
Which data sources can you use for SAP list viewer with integrated data access? There are 3 correct answers to this question. External view Database Table Database Procedure CDS View Internal table.
How to call the stored procedures in ABAP code? Please choose the correct answer. Only SQL Open SQL Native SQL CDS View.
What is the central goal of using SAP HANA? Please choose the correct answer. Accelerate Performance Positive Impact on Business Monitor database for record keeping To set Priorities for system.
Which of the following are performance recommendations when using SAP HANA? (2 right answers) Avoid transferring large result sets between database and client applications. Move data-intensive calculations from the database to an application server. Filter data in lower layers. Define indexes on the columns that are used in calculations.
You want to import an ABAP workbench request into an SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package ZHA400_00. WHICH PREREQISITIES are mandatory for an implicit deployment of the SAP HANA view onto the database? There are 2 correct answers to this question. PACKAGE ZHA400_00 HAS deployment Mode A View CA_CUSTOMER has deployment mode A. Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK SYSTEM P81 has SAP HANA as primary database.
Which steps do you have to perform when defining a view using core data services (CDS)? There are 3 correct answers to this question. Use the DDL statement DEFINE VIEW and SQL like Syntax Define the type mapping between ABAP and SAP HANA Specify the name of the SQL view in ABAP Dictionary Create a data definition in your ABAP package Create a proxy object for the defined view.
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. Technology store Re-use component store Development Store ROW store Column store.
What do you understand by The SAP HANA Software Optimization? Choose the correct answer Bring logic to where the data is calculated first, then only move to results Provide combinations of Objects and Partitioning Huge potential for hybrid database Speed up the processing within the database.
The source code editor in ADT provides many helpful features. What are these helpful features? There are 2 correct answers to this question. Creating interface from Method Calls Creating Method Definitions from Implementation Parts Creating Method Implementations from the Method Definition Creating Parts for Interface Methods.
The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question. Avoid idling CPU cores Avoid optimizing data Avoid single network Avoid CPU cache misses.
Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question. Core data service (CDS) access control Open SQL ABAP Dictionary Core data services (CDS) data definition.
Which form of services is responsible for defining and consuming semantically rich data models? Please choose the correct answer. ITe services Core Data Services Conditional services Modell-II services.
What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA? There are 3 correct answers to this question. Tuning Detect Innovate Scaling Optimize.
How will you select a preference for Validation rules? Windows- Preferences-SAP HANA-Modeler-Validation Rules Windows- SAP HANA-Preferences-Modeler-Validation Rules Windows- Modeler – Preferences-SAP HANA-Validation Rules Windows- SAP HANA-Modeler-Preferences-Validation Rules.
Which of the following take advantage of the computing power of multiple CPUs used by SAP HANA? (2 right answers) Partitioning Database table compression Columnar data storage Parallel processing.
What output does The SAP HANA provide as a unique combination of hardware and software innovations? Choose the correct answer Huge potential to maximize the number of disk blocks in the application The ability to create new complex processes with ABAP application cloud Huge potential to optimize AMDP application DATA Tables Huge potential to optimize business applications that are running on SAP HANA.
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. Importing Returning Exporting Receiving Changing.
What are the main concepts of the SAP HANA database? There are 3 correct answers to this question Compression Tools combinations Partitioning Object store Column Store.
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 defines the underlying SAP HANA information view. It can be used in Open SQL statements for database updates. It is an ABAP Dictionary object type. It can be used as a data type in ABAP programs.
What are the main capabilities of SAP BusinessObjects Analysis for Office? There are 2 correct answers to this question Analyze data with the design panel Sort data by characteristics Convert crosstab cells to formula Suggests style sets for crosstabs.
What is the Limitations of ALV for SAP HANA? There are 3 correct answers to this question. Restricted to 5000 records / unit Restricted to 10,000 records No unit/ currency split if aggregating amounts/ currency values Without currency /unit consideration All unit/ currency restricted to 10,00,00 records.
Which views are available to administer and monitor one or several SAP HANA systems? There are 2 correct answers to this question The Security view The Administration view The Landscape view The System Monitor view.
Which of the following are potential functional issues when migrating ABAP code to SAP HANA? There are 2 correct answers coding that assume that SELECT result is always sorted use of native SQL or DB hints existence of table appends existence of customer specific cluster tables use of secondary database connections.
In addition to closing the result set, what else CLOSE method of the CL_SQL_RESULT_SET class in ABAP Database Connectivity (ADBC) do? Please choose the correct answer. Update packages Update resources Release resources Release packages.
You are working with ABAP Development Tools (ADT) For Eclipse. Which of the following options belongs to the settings of a specific ABAP project rather than the entire Eclipse workbench? Please choose the correct answer. Statement template options Code formatting options Editor shortcut key options Code completion options.
What are the basic approach of classical ABAP programming? There are 2 correct answers to this question Keep load from the database 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.
Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP? Create data by members and tables Create Presentations Swap axes Insert filter components.
In an ABAP Core Data services (CDS) view, what must you do expose an association for use in another CDS view? specify the other views in which the association can be used specify an alias for the target entity define the cardinality for the target entity include all fields used in the ON condition in projection list.
Which of the following entries can be found under node CATALOG and not under node CONTENT ? There are 2 correct answers schema table calculation view package.
What are the advanced features of SAP HANA full-text search. There are 3 correct answers to this question. freestyle search Isolation search linguistic search ACID search Fuzzy search.
Which of the following tasks can you perform with SQL monitor (transaction SQLM)? Capture the SQL profile of an application Search for problematic SELECT* statements Combine static and dynamic performance analysis results Display the execution plan of an SQL statement.
What all are the advantages provides by ABAP Development Tools? There are 3 correct answers to this question. A set of open, language- and platform-independent APIs A brand new ABAP development experience on top of the Eclipse platform A set of Eclipse data pool and Client- Open platform An open platform for developing powerful database view An open platform for developing new ABAP-related tools.
What are different types of engines associated with The SAP HANA architecture? There are 2 correct answers to this question Analytic engine OPAX engine Join engine OLAP engine.
Which features does the source code editor provide in ABAP Development Tools for SAP NetWeaver? There are 2 correct answers to this question. Quickfix Content assistance Form-based class builder Screen editing.
You create a new table definition using the ABAP Dictionary and maintain the database-specific technical settings. Why do you create a row store instead of a column store table? Please choose the correct answer. To allow creation of a full-text index To limit the need of indexes To limit the unpacking and reconstruction of rows To limit the data footprint.
Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)? Combine information from static ABAP code scans with runtime data from the SQL Trace tool. Combine information from static ABAP code scans with runtime data from the SQL Monitor. Create a graph comparing the runtimes of ABAP code before and after optimization Estimate the new total runtime of optimized code.
What are the principles of Using HANA Transport Containers properly? (3 right answers) Release of Transport request Takes a ‘snapshot’ of all SAP HANA objects of delivery unit Import of Transport Request Automatic update for all export methods To create Transport container of delivery unit.
Which of the following feature were added to the ABAP Dictionary to support the SAP HANA database? (3 right answers) De-pooling and de-clustering Definition of an enhancement category Definition of full-text indexes Changes of data class Storage types of tables.
What are the Performance Rules and Guidelines for ABAP on SAP HANA? There are 2 correct answers to this question. To Keep all the loads away from the DB It is beneficial for maximizing your search into database It is beneficial to move data-intensive calculations into the database To reduce main memory consumption and to improve insert performance.
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. Write Only Read Only Read-Write Read-update.
When are referential joins executed in analytical views? Choose ONE correct answer When fields are selected When all the tables are optimized When fields from both the tables are requested When fields are optimized.
What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question. Perform expensive calculations on the database. Perform expensive calculations on the ABAP application server. Aggregate data on the database, and transfer the results to the ABAP layer. Use native SQL to access SAP HANA built-in functions. Transfer all data from the database to the ABAP layer, and then aggregate the results.
What are best practices when programming in ABAP for SAP HANA? There are 2 correct answers to this question Calculate aggregations using ABAP code on the application server to limit database load Use a column list in the SELECT clause to ensure that you only read a column if it is really required Eliminate nested SELECT statements to reduce the overall number of database accesses Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required.
What must you do when you define and implement an ABAP Managed Database Procedure (AMDP)? (3 right answers) Define all method parameters to be passed by value. Use scalar types for all AMDP method parameters. Specify the database system and the language. List all ABAP Dictionary tables used in the procedure body in the USING clause. Mark the AMDP method as a READ-ONLY database procedure.
Which of the following SAP HANA based scenarios involve ABAP applications? There are 2 correct answers SAP HANA as business accelerator Data mart based on SAP HANA AS ABAP with SAP HANA as primary database Native SAP HANA applications.
Your customer wants to migrate to SAP HANA and you want to identify which business processes should be optimized. Which of the following steps must you perform to get this information? There are 2 correct answers to this question. Combine the results of the SQL Monitor with the results of a static source code analysis. Combine the results of the SQL Monitor with the results of an ABAP runtime analysis. Activate the new SQL Monitor in a development system. Activate the new SQL Monitor in a productive system.
Which data provisioning methods can you use when you need real time replications? There are 2 correct answers to this question. SAP Landscape transformation Replication server (SAP SLT) SAP Data services SAP Replication server SAP HANA Direct extractor connection (SAP DXC).
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. Core Data service (CDS) view External view Database procedure proxy Full-text index ABAP program containing new Open SQL.
List down the elements involved in User Management and Security in SAP HANA? (3 right answers) Work management Assign job security Assign security Manage users Create users Work management.
What are the benefits associated with The SAP HANA real-time Operational analytics? (2 right answers) Query Speed support Simplification of massive data High modeling flexibility Fast insights into business activity.
Which of the following folder is essential to relate to Smart Data Access and also combines data from remote sources? Security folder Content folder Provisioning folder Administration folder.
What are the two different kinds of Identifiers used to represent names used in SQL statement? (2 right answers) Undelimited Identifiers Delimited identifiers Numeric identifiers Limited identifiers.
What are the conditions required to ensure the Referential Integrity? (2 right answers) There are two joins in the table Referential integrity holds true in both the directions There is at least one join in the other table There are three joins in the table.
ABAP 7.4 provides support for optimizing ABAP applications running on SAP HANA. What are these Transparent Optimizations? There are 3 correct answers to this question. The consumption of SAP HANA artifacts was simplified Performance analysis tools have been improved The ABAP language and the OpenSQL language have been extended Re- use components have been extended or optimized for SAP HANA Do all the data processing in Application server.
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? Please choose the correct answer. SELECT * statements where fewer than a specified percentage of all fields are effectively used SELECT * statements on tables with more than a specified number of fields SELECT * statements on tables with the Column Store storage type SELECT * statements on tables with more than 100,000 records.
Which is the new concept that is introduced and improved by using SAP HANA Specific Features? New advanced SQL syntax Procedures Table buffering ABAP-Managed Database Procedures Programming model.
What are the benefits includes with SAP HANA Full Text Search? (2 right answers) Large number of toolkits are available Exploit structured contents in SQL Easy to use modeling tool Fewer data duplication and movement.
You developed an ABAP managed database procedure (AMDP). You want to allow the enhancement of this AMDP using business add-in (BADI). Which of the following objects must you create? There are 3 correct answers to this question. A BADI fallback implementation A database procedure A BADI definition AN enhancement spot A BADI simple implementation.
You define and implement an ABAP Managed Database Procedure (AMDP). What do you have to list after the USING clause? There are 3 correct answers to this question. CE functions used in the procedure body ABAP Dictionary tables used in the procedure body SAP HANA views used in the procedure body AMDPs used in the procedure body ABAP Dictionary views used in the procedure body.
What are the basic principles of SAP ALV IDA? There are 2 correct answers to this question To ensure that the user chooses the data on the selection screen is displayed Only retrieve the database data which is to be displayed on screen The ALV Optimization for SAP HANA to display data on the screen Data described declaratively instead of passing big internal tables.
Which of the following new repository objects belongs to code push down approach? There are 2 correct answers CDS views ABAP managed database procedure Database procedure proxy external view.
What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question. Core Data services A new and advanced Open SQL Advanced and specific models Buffer system services.
You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SO_ID). 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 } select from snwd_so { so_id, sum(net_amount) as sum_amount } order by so_id select from snwd_so { so_id, sum(net_amount) as sum_amount } group by so_id select from snwd_so { so_id, sum(net_amount) as sum_amount } group by net_amount.
What are the Parameters for Analytical and Calculation view? There are 3 correct answers to this question. To store data for critical analysis Passing other values to be used in calculations Setting a filter for columns Create a copy of a report Specifying unit of measurement.
Report abuse Terms of use
HOME
CREATE TEST
COMMENTS
STADISTICS
RECORDS
Author's Tests