Hi - Very thankful for extracting these questions out of the course. I just have a request for changing the text of a question. Which of the following entities can be found under the Catalog node, and not under the Content node? Choose the correct answers. Choose the 3 correct answers
There are only 2 correct answers, not 3 as written in the question
Which of the following SAP HANA-based scenarios involve ABAP applications?
Choose the 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. Which of the following entries are required when creating a system in the SAP HANA
Studio? Choose the 4 correct answers. 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 entities can be found under the Catalog node, and not under the
Content node?
Choose the 3 correct answers. Package Schema Table Calculation View. It is not possible to create secondary indexes on SAP HANA.
Determine whether this statement is true or false. True False. Which of the following new repository objects belong to the so-called “Top-Down
Approach” for Code-to-Data?
Choose the 2correct answers. 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 2 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. 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. 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. 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 3 correct answers. Translate Open SQL syntax into native SQL syntax Add client handling to the statement Handle SAP table buffering Check user authorizations 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. 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 2 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? 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. True False. ASSOCIATION TO is just another way of saying LEFT OUTER JOIN TO. 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 3 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 2 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 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. 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. True False. Any AMDP method 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? 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. True False. You can use Data Preview in SAP HANA studio to test SAP HANA views and SAP HANA
stored procedures. 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 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”. 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 table-like results One table-like results One table-like result. Which of the following object types in ABAP repository are proxy objects for SAP HANA
artefacts?
Choose the 2 correct answers. 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. 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. 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. Proposal search (= type ahead search) is supported on all database systems. True False. ABAP List Viewer with Integrated Data Access (ALV with IDA) is only supported for SAP
HANA database. 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? Editing values Excel export Personalization Double-click.
