Hana 17

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 toABAP 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. 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.2answers 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. Specify the database schema if it is not the user’s default schema D. Use the UP TO n ROWS addition. Use the tilde symbol (~) to separate qualifier from column name. 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 resultthat 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.

Whichcan 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?. EXECUTE_QUERY. SET_PARAM_TABLE. NEXT_PACKAGE. SET_PARAM.

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.

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 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 2 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).

Which of the following options belongs to the settings of a specific ABAP project rather than the entire Eclipse workbench?. Statementtemplate 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 acore 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. Analyze data with the design pane. Sort data by characteristics. Convert crosstab cells to formula. Suggests style sets for crosstabs.

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.

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.

What are the Performance Rules and Guidelines for ABAP on SAP HANA? 2 ans. to keep all the load away from the DB. It is beneficial to move data-intensive calculation into the database. It is beneficial to maximizing your search into data base. To reduce main memory consumption and improve insert performance.