Prueba ERS 1

Which of the following features are NOT supported by ALV with IDA?. Personalization. Editing values. Excel export. Double-click.

Which of the following ABAP repository objects can be the data source for ALV with IDA?. Transparent table. Database view. CDS view. External view.

ABAP List Viewer with Integrated Data Access (ALV with IDA) is only supported for SAP HANA database. True. False.

Proposal search (= type ahead search) is supported on all database systems. 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.

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. True. False.

When creating a proxy object for an SAP HANA view, it is possible to specify data elements for the view fields. True. False.

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.

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

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.

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?. 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 can use Data Preview in SAP HANA studio to test SAP HANA views and SAP HANA stored procedures. True. False.

The search function in the toolbar of SAP HANA studio searches in SAP HANA content and in the SAP HANA catalog. True. False.

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.

When executing a native SQL query via ABAP Database Connectivity (ADBC), which of the following steps is optional?. 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 can you do in ADT (ABAP in Eclipse) but not in the classical ABAP Workbench?. Display an AMDP method implementation. Edit an AMDP method implementation. Test an AMDP method implementation. Debug an AMDP method implementation.

Any AMDP method shipped by SAP can be extended using the AMDP BAdI technique. True. False.

All ABAP objects used within the body of an AMDP method have to be listed after the USING addition. 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.

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

Which of the following are common ground between SAP HANA syntax and Open SQL syntax (as of ABAP 7.40 SP05)?. 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.

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

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.

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

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

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.

ASSOCIATION TO is just another way of saying LEFT OUTER JOIN TO. True. False.

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

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

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.

Classical Open SQL syntax and new Open SQL syntax must not be used in the same ABAP processing block. True. False.

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

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

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

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

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

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

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.

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.

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

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

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

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.

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

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