HA400

Which of the following SAP HANA-based scenarios involve ABAP applications? Choose the correct answers. Data marts based on SAP HANA. AS ABAP with SAP HANA as primary database. Native SAP HANA applications. SAP HANA as Business Accelerator.

On SAP HANA, tables are stored in row store by default. True. False.

Which of the following entries are required when creating a system in the SAP HANA Studio?. Host name. Instance number. Client ID. User name. Logon Language.

Which of the following entities can be found under the Catalog node, and not under the Content node?. Package. Schema. Table. Calculation View.

It is not possible to create secondary indexes on SAP HANA. True. False.

Which of the following new repository objects belong to the so-called “Top-Down Approach” for Code-to-Data ?. External view. CDS view. Database procedure proxy. ABAP-managed database procedure.

When using a secondary database connection, the default schema is derived from the database user, which is stored in the secondary database connection. True. False.

Which of the following are potential functional issues when migrating ABAP code to SAP HANA?. Use of native SQL or DB Hints. Use of secondary database connections. Coding that assumes that a SELECT result is always sorted. The existence of customer-specific cluster tables. The existence of table appends.

Where do you define a set of Code Inspector checks that you want to perform?. In a Code Inspector object list. In a Code Inspector object check variant. In a Code Inspector inspection.

When migrating to SAP HANA, every SELECT statement immediately becomes faster. True. False.

Because SAP HANA stores all data in memory, buffering of data on the application server becomes less important. True. False.

Which of the following patterns are known to potentially cause performance issues when accessing an SAP HANA database?. Use of SELECT ... FOR ALL ENTRIES. Use of joins with more than 3 tables. Use of SELECT statements in loops. Use of SELECT * for tables with many fields.

Which of the following are steps in the recommended sequence for a guided performance analysis?. Do static code checks with Code Inspector or ABAP Test Cockpit. Collect runtime data with SQL Monitor. Collect runtime data with Runtime Analysis. Combine runtime data and static check result in SQL Performance Tuning Worklist.

Which part of a guided performance analysis is done with the SQL Monitor tool?. Collect runtime data in the productive system. Do static SQL checks in the productive system. Do static SQL checks in the development system. Combine runtime data and static check results.

Which of the SQL performance rules become more important with SAP HANA?. Keep the result set small. Minimize amount of transferred data. Minimize number of database accesses. Minimize search overhead. Keep unnecessary load away from the DB.

Which of the SQL performance rules become less important with SAP HANA?. Keep the result set small. Minimize amount of transferred data. Minimize number of database accesses. Minimize search overhead. Keep unnecessary load away from the DB.

Which of the following are tasks of the database interface (DBI) and database-specific library (DBSL)? Choose the correct answers. Translate Open SQL syntax into native SQL syntax. Add client handling to the statement. Check user authorizations. Handle SAP table buffering. Transaction handling.

New Open SQL syntax is mandatory as of SAP NetWeaver AS ABAP 7.40 SP05. True. False.

The Open SQL syntax is a prerequisite for the new Open SQL features. True. False.

Classical Open SQL syntax and new Open SQL syntax must not be used in the same ABAP processing block. Determine whether this statement is true or false. True. False.

Which of the following entities can be found in the object list of the ABAP Workbench or the Project Explorer of ADT?. Data definition (also known as DDL source). CDS view. SQL view.

Which of the following entities corresponds to an object that is created on the database? Choose the correct answer. Data definition (aka DDL source). CDS view. SQL view.

If you use a CDS view name in the FROM clause of an Open SQL SELECT statement, the new Open SQL syntax is mandatory. Determine whether this statement is true or false. True. False.

ASSOCIATION TO is just another way of saying LEFT OUTER JOIN TO. Determine whether this statement is true or false. True. False.

Which of the following are prerequisites for exposing an association?. The association points to a table, not to another CDS View. The association has cardinality “to-N.”. All fields mentioned in the ON condition are part of the field list. The association is the only association in this view definition.

Where can you evaluate an exposed association? Choose the correct answers. In the Data Preview of ADT. In the Data Browser (transaction SE16). In another CDS view. In an Open SQL SELECT statement.

CDS views that define associations cannot be extended. True. False.

An import parameter that is annotated with @Environment.systemField: becomes optional in the following places: In Data Preview in ADT. In the Data Browser (SE16). In ABAP Open SQL. In the definition of another CDS view.

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: Choose the correct answers. In Data Preview in ADT. In the Data Browser (SE16). In ABAP Open SQL. In the definition of another CDS view.

Which of the following are common ground between SAP HANA syntax and Open SQL syntax (as of ABAP 7.40 SP05)? Choose the correct answers. Key words are not case-sensitive. Table names have to be upper-case. Identical client handling. Comma-separated field lists. Field list after FROM clause is supported.

In SAP HANA SQL, it is mandatory to specify a schema before the table name. True. False.

Which of the following are supported types for parameters of AMDP methods?. Numeric or character-like scalar types. Structure types with only scalar components. Table types with only scalar columns. Nested table types without secondary keys.

All ABAP objects used within the body of an AMDP method have to be listed after the USING addition. Determine whether this statement is true or false. True. False.

Any AMDP method shipped by SAP can be extended using the AMDP BAdI technique. Determine whether this statement is true or false. True. False.

What can you do in ADT (ABAP in Eclipse) but not in the classical ABAP Workbench? Choose the correct answers. Display an AMDP method implementation. Edit an AMDP method implementation. Test an AMDP method implementation. Debug an AMDP method implementation.

When executing a native SQL query via ABAP Database Connectivity (ADBC), which of the following steps is optional? Choose the correct answer. Create an instance of CL_SQL_CONNECTION. Create an instance of CL_SQL_STATEMENT. Create an instance of CL_SQL_RESULT_SET. None, all three are mandatory.

What happens if you forget to call method close( ) at the end of your query?. You don’t forget a result. An exception is raised. DB resources remain blocked. Nothing.

The search function in the toolbar of SAP HANA studio searches in SAP HANA content and in the SAP HANA catalog. Determine whether this statement is true or false. True. False.

You can use Data Preview in SAP HANA studio to test SAP HANA views and SAP HANA stored procedures. Determine whether this statement is true or false. True. False.

You want to access SAP HANA view CA_BOOKINGS_COUNT in package ha400.primdb via a native SQL query. Which of the following are correct ways of specifying package path and object name in the FROM clause? Choose the 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”.

You execute the following native SQL query on SAP HANA: CALL "ha400.primdb::SP_PROCEDURE"( '10', null, null ) WITH OVERVIEW Which of the following results do you expect?. Two table-like results. Two scalar results. One scalar result. One table-like result.

Which of the following object types in ABAP repository are proxy objects for SAP HANA artefacts?. Procedure Proxy. Database View. SQL View. External View.

Which of the following are advantages of using proxy objects for SAP HANA artefacts?. No native SQL required to access the SAP HANA object. Automatic synchronization of proxy object definition. Automatic transport of SAP HANA artefacts in ABAP transport request. No need for SAP HANA database to define the proxy objects.

When creating a proxy object for an SAP HANA view, it is possible to specify data elements for the view fields. Determine whether this statement is true or false. True. False.

To include SAP HANA content into an ABAP transport request, SAP recommends using an SAP HANA Transport Container (HTC) instead of the SAP HANA Transport for ABAP (HTA) technique. Determine whether this statement is true or false. True. False.

You want to perform an SAP HANA full-text search on column COL of database table TAB. Which of the following conditions have to be fulfilled?. Table TAB is located in column store. Column COL is of type TEXT or SHORTTEXT. A full text index exists for column COL of table TAB. The application server release is 7.40 SP05 or higher.

Proposal search (= type ahead search) is supported on all database systems. Determine whether this statement is true or false. True. False.

ABAP List Viewer with Integrated Data Access (ALV with IDA) is only supported for SAP HANA database. Determine whether this statement is true or false. True. False.

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?. Personalization. Editing values. Excel export. Double-click.

Which of the following are potential functional issues when migrating ABAP code to SAP HANA? Choose the correct answers. Use of native SQL or DB Hints. Coding that assumes that a SELECT result is always sorted. The existence of customer-specific cluster tables. The existence of table appends.

Your SAP ERP system contains an ABAP Program which calls an SAP function module. This functional module is a blacklist item in SAP S/4HANA. What happens after you migrated the system to SAP S/4HANA?. When a user runs the program, execution terminates with a runtime error. When a user runs the program, execution terminates with an error message. The call of the function module causes a syntax error during the upgrade. It is not possible to upgrade the system to SAP S/4HANA while the program still calls the function module.

If in SAP S/4HANA a former transparent table has been replaced by a view of the same name, which uses of this transparent table will still work fine? Choose the correct answers. Use as data type. Direct read access. Direct write access. Base table of a dictionary view.

Which source of information about SAP S/4HANA simplifications allows you to check whether a given repository object is affected. Simplification Database. Simplification Item Catalog. Simplification List.

Identifying and removing obsolete code is a mandatory step during the conversion of a SAP ERP system to SAP S/4HANA.. Determine whether this statement is true or false. True. False.

Which of the following tools are used to identify unused code? Choose the correct answers. ABAP Call Monitor (SCMON). ABAP Usage data (SUSG). Code Inspector (SCI). ABAP Test Cockpit (ATC).

It is possible to display usage data in the ABAP Call Monitor (transaction SCMON)? Determine whether this statement is true or false. True. False.

Where do you define a set of Code Inspector checks that you want to perform? Choose the correct answer. In a Code Inspector object list. In a Code Inspector object check variant. In a Code Inspector inspection.

Which of the following features are available in ABAP Test Cockpit (ATC) but not in Code Inspector (SCI)?. Distribution of check results. Remote checks. Ad hoc checks in ABAP Workbench ( SE80). Full inspection of freely defined object sets.

Which of the following are prerequisites for performing SAP S/4HANA Readiness Checks? Choose the correct answers. The check system has ABAP release 7.51 or higher. Simplification Database is loaded into the check system. You perform the check with ABAP Test Cockpit (ATC) and not with Code Inspector (SCI). The check system is a SAP S/4HANA system.

You want to set up a central check system for remote ATC checks. Which is the minimum ABAP release for this central check system?. AS ABAP 7.00. AS ABAP 7.40. AS ABAP 7.51.

You want to set up a central check system for remote ATC checks. Which is the minimum ABAP release for the checked system? Choose the correct answer. AS ABAP 7.00. AS ABAP 7.40. AS ABAP 7.51.

Prior to using the Custom Code Migration app you have to perform an S/4HANA readiness check in the ABAP Test Cockpit. Determine whether this statement is true or false. True. False.

Prior to using the Custom Code Migration app you have to configure an Object Provider for the checked system in the ABAP Test Cockpit. True. False.