hana

Which of the following SAP HANA-based scenarios involve ABAP applications? 2 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. Determine whether this statement is true or false. True. False.

On SAP HANA, tables are stored in column store by default. Determine whether this statement is true or false. True. False.

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

Which of the following entities can be found under 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. Determine whether this statement is true or false. True. False.

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. 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? Choose the correct answer. 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. Determine whether this statement is true or false. True. False.

Because SAP HANA stores all data in memory, buffering of data on the application server becomes less important. Determine whether this statement is true or false. True. False.

SAP HANA stores all data in memory, but buffering of data on the application server does not become less important. True. False.

Which of the following patterns are known to potentially cause performance issues when accessing an SAP HANA database? Choose the 3 correct answers. 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? Choose the 3 correct answers. 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.

The sequence for a guided performance analysis is: 1) Do static code checks with Code Inspector or ABAP Test Cockpit, 2) Collect runtime data with SQL Monitor, and 3) Combine runtime data and static check result in SQL Performance Tuning Worklist. True. False.

Which part of a guided performance analysis is done with the SQL Monitor tool? Choose the correct answer. 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.

SQL Monitor measurements are not immediately visible. To minimize impact on overall system performance, the writing of measurements to the database is done asynchronously. True. False.

Which of the SQL performance rules become more important with SAP HANA? Choose the 2 correct answers. 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? Choose the 2 correct answers. 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. Determine whether this statement is true or false. True. False.

The Open SQL syntax is a prerequisite for the new Open SQL features. Determine whether this statement is true or false. 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? Choose the correct answers. 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? Choose the correct answers. 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. Determine whether this statement is true or false. True. False.

CDS views that define associations can be extended Determine whether this statement is true or false. True. False.

An import parameter that is annotated with @Environment.systemField: becomes optional 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.

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.

Access restrictions for a given CDS view are implicitly evaluated when the CDS view is accessed in Data Preview in ADT and in ABAP Open SQL. True. False.

Which of the following are common ground between SAP HANA syntax and Open SQL syntax (as of ABAP 7.40 SP05)? Choose the 3 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. Determine whether this statement is true or false. True. False.

In SAP HANA SQL, A schema is not mandatory. If no schema is specified, the user’s default schema is used. True. False.

Which of the following are supported types for parameters of AMDP methods? Choose the 2 correct answers. 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.

Not all AMDP methods shipped by SAP can be extended using the AMDP BAdI technique. True. False.

What can you do in ADT (ABAP in Eclipse) but not in the classical ABAP Workbench? Choose the 2 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.

When executing a native SQL query via ABAP Database Connectivity (ADBC), creating an instance of CL_SQL_CONNECTION is optional. True. False.

What happens if you forget to call method close( ) at the end of your query? Choose the correct answers. 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.

The search function in the toolbar of SAP HANA studio searches in both SAP HANA content and the SAP HANA catalog. 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? Choose the correct answer. 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? Choose the correct answers. Procedure Proxy. Database View. SQL View. External View.

Which of the following are advantages of using proxy objects for SAP HANA artefacts? Choose the correct answers. 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.

An advantage of using proxy objects for SAP HANA artefacts is that no native SQL is required to access the SAP HANA object. True. False.

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.

When creating a proxy object for an SAP HANA view, it is not possible to specify data elements for the view fields. 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.

To include SAP HANA content into an ABAP transport request, SAP recommends using the SAP HANA Transport for ABAP (HTA) technique. 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? Choose the 2 correct answers. 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 perform an SAP HANA full-text search on column COL of database table TAB, table TAB must be located in column store, and a full text index must exist for column COL of table TAB. 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.

ABAP List Viewer with Integrated Data Access (ALV with IDA) is supported for multiple databases. True. False.

Which of the following ABAP repository objects can be the data source for ALV with IDA? Choose the 4 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 answers. Personalization. Editing values. Excel export. Double-click.

Personalization, Microsoft Excel support, and double-click are supported by ALV with IDA. Editing values is not supported. True. False.