ERNESTO L MARQUEZ F
Quiz by , created more than 1 year ago

E_HANAAW_14 - SAP Certified Development Specialist - ABAP for SAP HANA 2.0

5358
1
0
ERNESTO L MARQUEZ F
Created by ERNESTO L MARQUEZ F about 5 years ago
Close

E_HANAAW_14 ABAP for SAP HANA

Question 1 of 174

1

Which of the following SAP HANA-Based scenarios involve ABAP Applications? - HA400 - Unit 1/Less_1. Pg. 5,6.

Select one or more of the following:

  • Data Smart Based on SAP HANA.

  • AS ABAP with SAP HANA as primary database.

  • Native SAP HANA Applications.

  • SAP HANA as Business Acelerators.

Explanation

Question 2 of 174

1

On SAP HANA, tables are stored in row store by default. - HA400 - Unit 1.

Select one of the following:

  • True
  • False

Explanation

Question 3 of 174

1

Which of the following entries are required when creating a system in the SAP HANA Studio?.- HA400 - Unit 1/Less_2. Pg. 14,15.

Select one or more of the following:

  • Host Name

  • Instance Number

  • Cliente ID

  • User Name

  • Logon Language

Explanation

Question 4 of 174

1

Which of the followin entities can be found under node Catalog and not under node Content?- HA400 - Unit 1/Less_1. Pg. 15,16.

Select one or more of the following:

  • Package

  • Schema

  • Table

  • Calculation View

Explanation

Question 5 of 174

1

It is not posible to create secondary index on SAP HANA. - HA400 - Unit 1/Less_3. Pg. 21,24.

Select one of the following:

  • True
  • False

Explanation

Question 6 of 174

1

Which of the following new repository objects belong to the so-called "Top-Down Approach" for Code-to-Data?. - HA400 - Unit 1/Less_3. Pg. 29. Figure 34.1.

Select one or more of the following:

  • External Views

  • CDS Views

  • Database Procedure Proxy

  • ABAP-Manage Database Procedure

Explanation

Question 7 of 174

1

When using a secondary database connection, the default schema is derived from the database user which is stored in the secondary in the secondary database connection. - HA400 - Unit 2/Less_1. Pg. 44,45.

Select one of the following:

  • True
  • False

Explanation

Question 8 of 174

1

Which of the following are potential issues when migrating ABAP code to SAP HANA?. - HA400 - Unit 2/Less_2. Pg. 49,50.

Select one or more of the following:

  • Use of native QSL or DB Hints.

  • Use of secondary database connection.

  • Coding that assumes that a SELECT result is always sorted.

  • The existence of customer-specific cluster tables.

  • The existence of table appends.

Explanation

Question 9 of 174

1

Where do you define a set of Code Inspector checks which you want to perform?. - HA400 - Unit 2/Less_2. Pg. 51,52,53.
- Unit 2/Less_3. Pg. 57.

Select one or more of the following:

  • In a Code Inspector object list.

  • In a Code Inspector object check variant.

  • In a Code Inspector inspection.

Explanation

Question 10 of 174

1

When migrating to SAP HANA, every SELECT statement immediately become faster. - HA400 - Unit 2/Less_3. Pg. 54.

Select one of the following:

  • True
  • False

Explanation

Question 11 of 174

1

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

Select one of the following:

  • True
  • False

Explanation

Question 12 of 174

1

Which of the following patterns are known to potentially cause performance issues when accessing SAP HANA database? - Unit 2/Less_5. Pg. 67.

Select one or more of the following:

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

Explanation

Question 13 of 174

1

Which of the following are steps in the recommended sequence for a guide performance analysis? -Unit 2/Less_4. Pg. 60,61.

Select one or more of the following:

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

Explanation

Question 14 of 174

1

Which part of a guided performance analysis is done with th SQL Monitor tool? -Unit 2/Less_4. Pg. 62.

Select one or more of the following:

  • Collect runtime data in the productive system.

  • Do static SQL checks in the productive system.

  • Do static SQL check in the development system.

  • Combine runtime data and static check result.

Explanation

Question 15 of 174

1

SQL Monitor measurements are not immediately visible to minimize impact on overall system performance, and the writing of measurements to the database is done asynchronously. UNIT 2.

Select one of the following:

  • True
  • False

Explanation

Question 16 of 174

1

Wich of the SQL performance rules become more important with SAP HANA? -Unit 2/Less_5. Pg. 66,67.

Select one or more of the following:

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

Explanation

Question 17 of 174

1

Which of the SQL performance rules become less important with SAP HANA? -Unit 2/Less_5. Pg. 67.

Select one or more of the following:

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

Explanation

Question 18 of 174

1

Which of the following are task of the database interface (DBI) and the Database Specific Library (DBSL)?. - HA400 UNIT3. Less_1. Pg.77,78.

Select one or more of the following:

  • Translate Open SQL syntax into Native Sql Syntax.

  • Add client handling to the statement.

  • Check User Authorizations

  • Handle SAP table buffering

  • Transaction handling

Explanation

Question 19 of 174

1

New Open SQL Syntax is mandatory as of SAP Netweaver AS ABAP 7.40 SP05. - HA400 UNIT3. Less_1. Pg.81,82.

Select one of the following:

  • True
  • False

Explanation

Question 20 of 174

1

The Open SQL Syntax is a prerequisite for the new Open SQL features. - HA400 UNIT3. Less_1. Pg.81,82.

Select one of the following:

  • True
  • False

Explanation

Question 21 of 174

1

Classical Open SQL Syntax and the New Open SQL Syntax must not be used in the same ABAP processing block. - HA400 UNIT3. Less_1. Pg.81,82.

Select one of the following:

  • True
  • False

Explanation

Question 22 of 174

1

Which of the following entities can be found in the object list of the ABAP workbench or the Project Explorer of ADT? - HA400 UNIT3. Less_3. Pg.87,88.

Select one or more of the following:

  • Data definition (aka DDL source)

  • CDS view

  • SQL view

Explanation

Question 23 of 174

1

Which of the following entities corresponds to an object that is created on the database?- HA400 UNIT3. Less_3. Pg.87,88.

Select one or more of the following:

  • Data Definition ( aka DDL source ).

  • CDS view.

  • SQL View.

Explanation

Question 24 of 174

1

If you use a CDS view name in the FROM clause of an Open SQL SELECT statement, the New Open SQL Syntax is mandatory. - HA400 UNIT3. Less_3.

Select one of the following:

  • True
  • False

Explanation

Question 25 of 174

1

ASSOCIATION TO is just another way of saying LEFT OUTER JOIN TO. - HA400 UNIT3. Less_3.

Select one of the following:

  • True
  • False

Explanation

Question 26 of 174

1

Which of the following are prerequisites for exposing an association? - HA400 UNIT3. Less_3.

Select one or more of the following:

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

Explanation

Question 27 of 174

1

Where can you evaluate an exposed Association? - HA400 UNIT3. Less_3.

Select one or more of the following:

  • In the Data Preview of ADT.

  • In the Data Browser ( transaction SE16 ).

  • In another CDS view

  • In an Open SQL SELECT statement

Explanation

Question 28 of 174

1

CDS views that define associations cannot be extended. - HA400 UNIT3. Less_3.

Select one of the following:

  • True
  • False

Explanation

Question 29 of 174

1

An import parameter that is annotated with @Enviroment.systemField: becomes optional in the following places: - HA400 UNIT3. Less_3.

Select one or more of the following:

  • In Data preview in ADT.

  • In the Data Browser ( SE16 ).

  • In ABAP Open SQL.

  • In the definition of another CDS view.

Explanation

Question 30 of 174

1

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 place: - HA400 UNIT3. Less_3.

Select one or more of the following:

  • In Data preview in ADT.

  • In the Data Browser ( SE16 ).

  • In ABAP Open SQL.

  • In the definition of another CDS view.

Explanation

Question 31 of 174

1

Which of the following are common ground between SAP HANA syntax and Open SQL
syntax (as of ABAP 7.40 SP05)? -HA400. Unit4

Select one or more of the following:

  • Key words are not case-sensitive.

  • Identical client handling.

  • Table names have to be upper-case.

  • Comma-separated field lists.

  • Field list after FROM clause is supported.

Explanation

Question 32 of 174

1

In SAP HANA SQL, it is mandatory to specify a schema before the table name. -HA400. Unit4

Select one of the following:

  • True
  • False

Explanation

Question 33 of 174

1

Which of the following are supported types for parameters of AMDP methods?. -HA400. Unit4

Select one or more of the following:

  • Numeric or character-like scalar types.

  • Structure types with only scalar components.

  • Table types with only scalar columns.

  • Nested table types without secondary keys.

Explanation

Question 34 of 174

1

All ABAP objects used within the body of an AMDP method have to be listed after the
USING addition. -HA400. Unit4

Select one of the following:

  • True
  • False

Explanation

Question 35 of 174

1

Any AMDP method shipped by SAP can be extended using the AMDP BAdI technique. -HA400. Unit4

Select one of the following:

  • True
  • False

Explanation

Question 36 of 174

1

What can you do in ADT (ABAP in Eclipse) but not in the classical ABAP Workbench?. -HA400. Unit4

Select one or more of the following:

  • Display an AMDP method implementation.

  • Edit an AMDP method implementation.

  • Test an AMDP method implementation.

  • Debug an AMDP method implementation.

Explanation

Question 37 of 174

1

When executing a native SQL query via ABAP Database Connectivity (ADBC), which of the
following steps is optional? -HA400. Unit4

Select one or more of the following:

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

Explanation

Question 38 of 174

1

What happens if you forget to call method close( ) at the end of your query?. -HA400. Unit4

Select one or more of the following:

  • You don’t forget a result.

  • An exception is raised.

  • DB resources remain blocked.

  • Nothing.

Explanation

Question 39 of 174

1

The search function in the toolbar of SAP HANA studio searches in SAP HANA content
and in the SAP HANA catalog. -HA400. Unit5

Select one of the following:

  • True
  • False

Explanation

Question 40 of 174

1

You can use Data Preview in SAP HANA studio to test SAP HANA views and SAP HANA
stored procedures. -HA400. Unit5

Select one of the following:

  • True
  • False

Explanation

Question 41 of 174

1

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? -HA400. Unit5

Select one or more of the following:

  • 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”

Explanation

Question 42 of 174

1

You execute the following native SQL query on SAP HANA:
CALL "ha400.primdb::SP_PROCEDURE"( '10', null, null ) WITH OVERVIEW
Whichof the following results do you expect?. -HA400. Unit5

Select one or more of the following:

  • Two table-like results.

  • Two scalar results.

  • One scalar result.

  • One table-like result.

Explanation

Question 43 of 174

1

Which of the following object types in ABAP repository are proxy objects for SAP HANA
artefacts?. -HA400. Unit5

Select one or more of the following:

  • Procedure Proxy.

  • Database View.

  • SQL View.

  • External View.

Explanation

Question 44 of 174

1

Which of the following are advantages of using proxy objects for SAP HANA artefacts?. -HA400. Unit5

Select one or more of the following:

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

Explanation

Question 45 of 174

1

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

Select one of the following:

  • True
  • False

Explanation

Question 46 of 174

1

In order to include SAP HANA content into an ABAP transport request, SAP recommends
to use a SAP HANA Transport Container (HTC) instead of the SAP HANA Transport for
ABAP (HTA) technique. -HA400. Unit6

Select one of the following:

  • True
  • False

Explanation

Question 47 of 174

1

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? -HA400. Unit6

Select one or more of the following:

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

Explanation

Question 48 of 174

1

Proposal search (= type ahead search) is supported on all database systems. -HA400. Unit6

Select one of the following:

  • True
  • False

Explanation

Question 49 of 174

1

ABAP List Viewer with Integrated Data Access (ALV with IDA) is only supported for SAP
HANA database. -HA400. Unit6

Select one of the following:

  • True
  • False

Explanation

Question 50 of 174

1

Which of the following ABAP repository objects can be the data source for ALV with IDA? -HA400. Unit6

Select one or more of the following:

  • Transparent table

  • Database view

  • CDS view

  • External view

Explanation

Question 51 of 174

1

Which of the following features are NOT supported by ALV with IDA? -HA400. Unit6

Select one or more of the following:

  • Personalization

  • Editing values

  • Excel export

  • Double-click

Explanation

Question 52 of 174

1

Which recent trends have triggered the need for a next generation data processing platform? -HA100. Unit1.

Select one or more of the following:

  • Increasing connectivity of people and devices

  • Move transactional processing and analysis to separate servers for better
    scalability

  • Increase in use of mobile devices

  • Massive growth in data volume

Explanation

Question 53 of 174

1

Which recent technology innovations have triggered the opportunity to build a next generation data processing platform?
-HA100. Unit1.

Select one or more of the following:

  • Faster disk access.

  • Multi-core processing.

  • Larger memory availability.

Explanation

Question 54 of 174

1

What are the key features of SAP HANA? -HA100. Unit1.

Select one or more of the following:

  • In-memory database

  • Automatic compression of data

  • Removes the need for cache

  • Combined OLTP and OLAP processing on one platform

Explanation

Question 55 of 174

1

Which are true statements? -HA100. Unit1.

Select one or more of the following:

  • SAP HANA runs on Intel x86 and SPARC hardware platforms.

  • SAP HANA runs on Unix.

  • SAP HANA can be installed only by certified engineers for production purposes.

  • Customers can re-use their own certified hardware components in an SAP HANA system.

  • SAP HANA is available in the cloud or on premise, or a combination of both.

Explanation

Question 56 of 174

1

SAP HANA 2.0 is the ‘stability’ release and its use case is to support mission critical applications where frequent upgrades are not desirable. -HA100. Unit1.

Select one of the following:

  • True
  • False

Explanation

Question 57 of 174

1

Where is SDI used? -HA100. Unit2.

Select one or more of the following:

  • Data cleansing

  • Data transformation

  • Data streaming

  • For data loading

Explanation

Question 58 of 174

1

How many processing tiers do you usually find in a native SAP HANA application stack? -HA100. Unit2.

Select one or more of the following:

  • 1

  • 2

  • 3

Explanation

Question 59 of 174

1

What is XS? -HA100. Unit2.

Select one or more of the following:

  • A native, lightweight application server

  • An optional engine to handle excessive data loads

  • A data cleansing engine

  • A user interface

Explanation

Question 60 of 174

1

Why did SAP move from XS to XSA? -HA100. Unit2.

Select one or more of the following:

  • To move to Cloud Foundry architecture to allow flexible application deployment options

  • To include ABAP as a key development language for native SAP HANA applications

  • To implement micro-services architecture

  • To provide better source code management tools inside SAP HANA

Explanation

Question 61 of 174

1

What are the two views in the Web IDE for SAP HANA? -HA100. Unit2.

Select one or more of the following:

  • Database Explorer

  • Development

  • Catalog

Explanation

Question 62 of 174

1

In SAP HANA Studio, what would you find in a Package? -HA100. Unit2.

Select one or more of the following:

  • Calculation Views

  • Analytic Privileges

  • Procedures

  • Tables

Explanation

Question 63 of 174

1

In Web IDE for SAP HANA, what can I create in a HDB module? -HA100. Unit2.

Select one or more of the following:

  • Calculation View

  • Analytic Privilege

  • HTML file

  • Flowgraph

Explanation

Question 64 of 174

1

What is a role of the SAP HANA Cockpit? -HA100. Unit2.

Select one or more of the following:

  • To provide KPIs to help focus on business performance

  • To provide key system performance information for one or more HANA instances

  • To provide an application developer collaboration hub

Explanation

Question 65 of 174

1

What are advantages of column store tables? -HA100. Unit2.

Select one or more of the following:

  • Data footprint is automatically reduced through compression

  • Only the columns required are actually loaded to memory

  • Columns can be partitioned

  • They are optimized for high-volume read/write transactional processing

Explanation

Question 66 of 174

1

Row store tables are more efficient when there is a lot of repeating data values in columns. -HA100. Unit2.

Select one of the following:

  • True
  • False

Explanation

Question 67 of 174

1

Why do we still need a persistent layer? -HA100. Unit2.

Select one or more of the following:

  • To store data that has been unloaded from memory

  • To hold the delta store for newly-arrived records

  • To enable full database recovery if we have a power failure

  • To store data that is frequently used

Explanation

Question 68 of 174

1

What is a multistore table? -HA100. Unit2.

Select one or more of the following:

  • A table that can hold data in row and column orientation

  • A table that can distribute its partitions across memory and extended storage tiers

  • A table that can be shared across multiple instances of HANA

Explanation

Question 69 of 174

1

Active/active-read enabled mode allows applications to redirect read-intense workloads to a secondary HANA?
-HA100. Unit2.

Select one of the following:

  • True
  • False

Explanation

Question 70 of 174

1

What is a multi-target application (MTA)? -HA100. Unit2.

Select one or more of the following:

  • An application built with SAP HANA XS Classic (XS) that supports on-premise and
    cloud deployments

  • An application built with SAP HANA XS Advanced (XSA) that supports on-premise
    and cloud deployments

Explanation

Question 71 of 174

1

What are the two storage components used to restore the database in case of power failure? -HA100. Unit2.

Select one or more of the following:

  • Log area

  • Data volume

  • Memory

  • Delta store

Explanation

Question 72 of 174

1

What is the role of core modeling in SAP HANA? -HA100. Unit3.

Select one or more of the following:

  • To push data-intensive processing up to the application to obtain the best performance

  • To develop reuseable data processing logic in the database

  • To simplify applications

Explanation

Question 73 of 174

1

What are valid types of calculation view? -HA100. Unit3.

Select one or more of the following:

  • Dimension

  • Cube

  • Cube with star schema

  • Dimension with star schema

Explanation

Question 74 of 174

1

If I need to create multiple, tabular output structures from an SQLscript, which HANA modeling object do I use?
-HA100. Unit3.

Select one or more of the following:

  • Procedure

  • Function

Explanation

Question 75 of 174

1

What do we implement to restrict access to specific data rows of a calculation view? -HA100. Unit3.

Select one or more of the following:

  • SQL permission

  • Authorisation object

  • Analytic privilege

Explanation

Question 76 of 174

1

Which SAP solution is used with SAP HANA Live? -HA100. Unit3.

Select one or more of the following:

  • SAP S/4HANA

  • SAP Business Suite

  • SAP Ariba

Explanation

Question 77 of 174

1

Which of these is used to build the virtual data model for SAP S/4HANA? -HA100. Unit3.

Select one or more of the following:

  • ABAP CDS

  • SAP HANA Live

  • Universe

  • SAP HANA CDS

Explanation

Question 78 of 174

1

What SAP HANA spatial type would you most likely use to represent the State of Colorado on a visual application?
-HA100. Unit3.

Select one or more of the following:

  • Polygon

  • Line

  • Point

Explanation

Question 79 of 174

1

In SAP HANA Text Analysis, why would you use the ‘Voice of Customer’ dictionary? -HA100. Unit3.

Select one or more of the following:

  • To extract the sentiment from customer feedback on social media

  • To extract common entities such as company, country, currencies, and so on, found in documents

  • To identify close matches in words and expressions, to catch misspellings

Explanation

Question 80 of 174

1

What must I create to develop a predictive model? -HA100. Unit3.

Select one of the following:

  • Calculation View

  • Predictive Analysis Library

  • Flowgraph

  • Procedure

Explanation

Question 81 of 174

1

SAP HANA Graph Processing powers real-time, high-performance business charts and dashboards. -HA100. Unit3.

Select one of the following:

  • True
  • False

Explanation

Question 82 of 174

1

In data temperature management, cool data is stored in HANA Extended Storage. -HA100. Unit4.

Select one of the following:

  • True
  • False

Explanation

Question 83 of 174

1

What is SAP Enterprise Architecture Designer? -HA100. Unit4.

Select one or more of the following:

  • A tool to support sizing of an SAP HANA solution

  • A tool used to define a data loading job

  • A tool to support the build of a logical data model

  • A tool used to simulate a work load on different HANA hardware configurations

Explanation

Question 84 of 174

1

What are typical characteristics of SAP HANA data replication? -HA100. Unit4.

Select one or more of the following:

  • Virtualization

  • Duplicate data

  • Real-time

  • Streaming

Explanation

Question 85 of 174

1

SAP SLT can be used for real-time replication from SAP and non-SAP sources. -HA100. Unit4.

Select one of the following:

  • True
  • False

Explanation

Question 86 of 174

1

What are components of SAP HANA EIM? -HA100. Unit4.

Select one or more of the following:

  • SDI

  • SDA

  • SDS

  • SDQ

Explanation

Question 87 of 174

1

What are features of SDA? -HA100. Unit4.

Select one or more of the following:

  • Automatic data type translation

  • Data cleansing

  • Evaluation and execution of push-down possibilities to remote sources

  • Merging data from multiple sources

Explanation

Question 88 of 174

1

Which of the following are correct statements relating to the flat file import function of SAP HANA Studio? -HA100. Unit4.

Select one or more of the following:

  • The new table always has a 1:1 mapping between the file and table columns.

  • The supported file types for upload are .csv, and .txt.

  • When loading new data in a table that already contains data, the new data is appended to the existing data.

  • Renaming of columns and changing data types is allowed when loading data to new HANA tables.

Explanation

Question 89 of 174

1

What are the database query languages used by SAP HANA? -HA100. Unit5.

Select one or more of the following:

  • ODBC

  • JDBC

  • MDX

  • SQL

  • ABAP

Explanation

Question 90 of 174

1

What are features of Business Suite on SAP HANA? -HA100. Unit5.

Select one or more of the following:

  • Embedded Analytics for operational analytics

  • ABAP is replaced with JAVA

  • Combine operational analytics and transaction processing

  • Massive performance improvement

Explanation

Question 91 of 174

1

What are features of SAP S/4HANA? -HA100. Unit5.

Select one or more of the following:

  • Optimized for SAP HANA but maintains compatibility with other platforms

  • Embedded Analytics

  • Rewritten ABAP code optimized for SAP HANA

  • SAP HANA Live provides real time operational analytics

Explanation

Question 92 of 174

1

To connect SAP Analysis Edition for Excel, you need to create a secure connection in SAP BusinessObjects Enterprise.
-HA100. Unit5.

Select one of the following:

  • True
  • False

Explanation

Question 93 of 174

1

Which of these does SAP HANA use to connect to BI tools? -HA100. Unit5.

Select one or more of the following:

  • IDOC

  • ODBC

  • JDBC

  • ODBO

Explanation

Question 94 of 174

1

In which key areas can we expect there to be improvements when running SAP BW on SAP HANA? -HA100. Unit5.

Select one or more of the following:

  • Tighter security

  • Data loading performance

  • Superior data quality

  • Reporting performance

Explanation

Question 95 of 174

1

In SAP BW, when we refer to mixed modeling, what do we mean? -HA100. Unit5.

Select one or more of the following:

  • Integration of classic BW models such as InfoSets or InfoCubes with SAP HANA Calculation views

  • Integration of SAP HANA optimized BW models such as ADSOs or OpenODS views with SAP HANA Calculation views

  • Integration of models from BW on non-HANA databases combined with SAP HANA
    optimized BW models

Explanation

Question 96 of 174

1

Where will you find the Data Distribution Optimizer? -HA100. Unit5.

Select one or more of the following:

  • SAP HANA Studio

  • SAP BW/4HANA

  • SAP HANA Data Warehousing foundation

Explanation

Question 97 of 174

1

Which interface client is used for XSA application development? -HA100. Unit5.

Select one or more of the following:

  • SAP HANA Web-based Workbench

  • SAP Web IDE for SAP HANA

  • SAP HANA Studio

  • SAP Web IDE

Explanation

Question 98 of 174

1

Applications developed with XS must be migrated to XSA before they can run in SAP HANA 2.0. -HA100. Unit5.

Select one of the following:

  • True
  • False

Explanation

Question 99 of 174

1

Eclipse is a proprietary tool developed by SAP. -BC404. Unit1.

Select one of the following:

  • True
  • False

Explanation

Question 100 of 174

1

Which of the following statements best describes SAP’s approach to Eclipse? -BC404. Unit1.

Select one or more of the following:

  • The Eclipse platform is an important part of SAP’s strategy for development tools

  • The Eclipse IDE is an interesting but non-essential addition

  • ABAP tools in Eclipse is just a proof of concept for the moment

Explanation

Question 101 of 174

1

Development in ABAP Development Tools is performed using the same online development model used in the ABAP Workbench. -BC404. Unit1.

Select one of the following:

  • True
  • False

Explanation

Question 102 of 174

1

When you work with ADT, you log onto the ABAP backend system and remain logged on for your entire session. -BC404. Unit1.

Select one of the following:

  • True
  • False

Explanation

Question 103 of 174

1

Where can you set your preferences for working with ADT? -BC404. Unit1.

Select one or more of the following:

  • In the project properties dialog box

  • Under Window→ Preferences

  • In both the project properties dialog box and under Window→ Preferences

Explanation

Question 104 of 174

1

Which of the following are perspectives in ADT? -BC404. Unit1.

Select one or more of the following:

  • ABAP

  • Transport Organizer

  • Debug

  • Package

Explanation

Question 105 of 174

1

ADT contains native Eclipse editors for which kinds of repository objects? -BC404. Unit2.

Select one or more of the following:

  • ABAP programs

  • Data elements

  • ABAP classes

  • Packages

  • Text elements

Explanation

Question 106 of 174

1

Which keyboard shortcut do you use to copy a method and its signature into your code after using CTRL+SPACE and choosing the relevant method? -BC404. Unit2.

Select one or more of the following:

  • Shift + Enter

  • Ctrl + Enter

  • Alt + Enter

  • Ctrl + Shift + Enter

Explanation

Question 107 of 174

1

Which of the following functions are available in both the ADT Debug perspective and the SAP GUI Debugger? -BC404. Unit2.

Select one or more of the following:

  • Setting breakpoints dynamically during debugging

  • Memory analysis

  • Source code editing in the debugger

  • Displaying the contents of an internal table

Explanation

Question 108 of 174

1

You are creating a function module in ADT. How can you define its interface without leaving the function module editor?
-BC404. Unit3

Select one or more of the following:

  • Use the IMPORTING, EXPORTING, CHANGING, EXCEPTIONS, and RAISING additions in the FUNCTION statement

  • You can’t - the interface must be edited using the Function Builder in the SAP GUI

Explanation

Question 109 of 174

1

A Core Data Services View can only implement an inner join. -BC404. Unit4.

Select one of the following:

  • True
  • False

Explanation

Question 110 of 174

1

You are creating a controller method in a Web Dynpro component and want to use the code wizard to read the value of a context node. How do you start the code wizard? -BC404. Unit6.

Select one or more of the following:

  • Choose the Code Wizard icon from the application toolbar

  • Choose F2 then choose the required action

  • Choose Ctrl + Space then choose the required action

Explanation

Question 111 of 174

1

You are creating an ABAP class in ADT and have just written the definition of a method in the public section of the class definition. You press Ctrl + 1 to see the available quick fixes. Which fixes are available? -BC404. Unit5.

Select one or more of the following:

  • Add the implementation of the method

  • Move the method definition to the protected or private section

  • Delete the method

Explanation

Question 112 of 174

1

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)? -BC404. Unit7.

Select one or more of the following:

  • Ctrl + F2

  • F3

  • Ctrl + Shift + F5

  • F6

Explanation

Question 113 of 174

1

Which keyboard shortcut displays the Open ABAP Development Object wizard? -BC404. Unit7.

Select one or more of the following:

  • Ctrl + Shift + H

  • Ctrl + H

  • Ctrl + A

  • Ctrl + Shift + A

Explanation

Question 114 of 174

1

Feeds are updated automatically for both open and closed ABAP projects. -BC404. Unit7.

Select one of the following:

  • True
  • False

Explanation

Question 115 of 174

1

Which symbol do ABAP Doc comments start with? -BC404. Unit7.

Select one or more of the following:

  • “&

  • *

  • “!

  • !”

Explanation

Question 116 of 174

1

The ABAP Test Cockpit allows you to re-use check variants from which other analysis tool? -BC404. Unit8.

Select one or more of the following:

  • The Code Inspector

  • The Extended Program Check

  • The ABAP Trace

Explanation

Question 117 of 174

1

In ABAP Unit, the SETUP method is called before each individual test method. -BC404. Unit8.

Select one of the following:

  • True
  • False

Explanation

Question 118 of 174

1

Which of the following statements about ABAP Unit tests are true? -BC404. Unit8.

Select one or more of the following:

  • Test classes are not generated in a production system

  • Test methods can access the private components of the class under test

  • The class under test can access the methods of the test class

  • Each test method is executed independently of all of the others

Explanation

Question 119 of 174

1

External views, which can be created to expose SAP HANA views to the ABAP Dictionary, can only be created in ADT and not in SE80. -BC404. Unit9.

Select one of the following:

  • True
  • False

Explanation

Question 120 of 174

1

Which of the following SAP HANA objects can be assigned to a HANA Transport Container? -BC404. Unit9.

Select one or more of the following:

  • Packages.

  • Delivery Units.

  • Calculation Views.

  • Procedures.

Explanation

Question 121 of 174

1

Which of the following are types of calculation views? -HA300. Unit1.

Select one or more of the following:

  • Cube

  • Composite

  • Cube with star join

  • Dimension

Explanation

Question 122 of 174

1

A dimension can have attributes and measures. -HA300. Unit1.

Select one of the following:

  • True
  • False

Explanation

Question 123 of 174

1

Which are true statements relating to calculation views of the type DEFAULT? -HA300. Unit1.

Select one or more of the following:

  • They do not expose their meta data to reporting tools

  • They are mainly used for reusing inside other calculation views

  • They must include at least one measure

  • They include a star join node

Explanation

Question 124 of 174

1

Which are supported data source types for calculation view consumption? -HA300. Unit1.

Select one or more of the following:

  • Calculation views

  • Flat files

  • Virtual tables

  • Column tables

  • Row tables

Explanation

Question 125 of 174

1

What is a time-based dimension calculation view? -HA300. Unit1.

Select one or more of the following:

  • A view that is only accessible by users for a limited time

  • A view that stores the values of attributes across time

Explanation

Question 126 of 174

1

What does SAP recommend you use to check your calculation view produces correct result? -HA300. Unit1.

Select one or more of the following:

  • Excel pivot tables

  • Custom SQL queries

  • Data preview function in Web IDE

Explanation

Question 127 of 174

1

What is the purpose of the projection node? -HA300. Unit2.

Select one or more of the following:

  • To apply filters on the data

  • To extract only the required columns from a data source

  • To aggregate measures

  • To join data sources

Explanation

Question 128 of 174

1

Why do you use a referential join? -HA300. Unit2.

Select one or more of the following:

  • To improve performance of joins that do not need to check integrity if no column from the right table is selected by a query.

  • When you need to display only facts that have associated master data attributes

  • When you want to display facts even when the associated master data attributes are missing.

Explanation

Question 129 of 174

1

A text join is a right outer join used to join a text table containing multi-language descriptions, to an attribute in a dimension.
-HA300. Unit2.

Select one of the following:

  • True
  • False

Explanation

Question 130 of 174

1

Identify the type of join that ensures records are only selected if they fit a specified data range. -HA300. Unit2.

Select one or more of the following:

  • Left Outer Join

  • Right Outer Join

  • Temporal Join

  • Full Outer Join

Explanation

Question 131 of 174

1

In a union, you do not have to select all source columns and the source columns do not have to have the same name.
-HA300. Unit2.

Select one of the following:

  • True
  • False

Explanation

Question 132 of 174

1

I have customers who appear in table A and sometimes they also appear in table B. I want to select the customers that appear ONLY in table A. Which node type do you use?. -HA300. Unit2.

Select one or more of the following:

  • Intersect

  • Minus

  • Union

Explanation

Question 133 of 174

1

In an aggregation node, a calculated column is always computed before the aggregate function. -HA300. Unit2.

Select one of the following:

  • True
  • False

Explanation

Question 134 of 174

1

Which flags are relevant to the control of the aggregation behavior? -HA300. Unit2.

Select one or more of the following:

  • Keep Flag

  • Transparent filter

  • Dynamic join

Explanation

Question 135 of 174

1

In a star join node, what do you join to the central entity (fact table)? -HA300. Unit2.

Select one or more of the following:

  • Cube calculation views

  • Column tables

  • Dimensions calculation views

Explanation

Question 136 of 174

1

In a rank node, you can choose whether to assign the generated rank column as an attribute or a measure. -HA300. Unit2.

Select one of the following:

  • True
  • False

Explanation

Question 137 of 174

1

A restricted columns provide a subset of the original column filtered by attribute values. -HA300. Unit3.

Select one of the following:

  • True
  • False

Explanation

Question 138 of 174

1

When is the design time filter expression applied in a calculation view? -HA300. Unit3.

Select one or more of the following:

  • Before a query on the calculation view begin to execute

  • On the final result of a query, similar to a ‘where’ clause

  • Before any joins are executed within the calculation view

Explanation

Question 139 of 174

1

When the Default Client property of a calculation view is set to Session Client, the data is filtered dynamically based on the CLIENT assigned to the user. -HA300. Unit3.

Select one of the following:

  • True
  • False

Explanation

Question 140 of 174

1

Identify the object that adds a WHERE clause to the query. -HA300. Unit3.

Select one or more of the following:

  • Modeler

  • Attributes

  • Input parameter

  • Variable

Explanation

Question 141 of 174

1

In a calculated column which do you use as a placeholder for a dynamic value in an expression? -HA300. Unit3.

Select one or more of the following:

  • Variable

  • Input parameter

Explanation

Question 142 of 174

1

What are the features of a parent-child hierarchy? -HA300. Unit3.

Select one or more of the following:

  • A parent can be formed by combining attributes.

  • Parent and child columns have the same data type.

  • Recursive data structure defines the hierarchy.

  • The hierarchy always generates two levels.

Explanation

Question 143 of 174

1

A hierarchy navigation function must be preceded by a hierarchy generator function inside a calculation view. -HA300. Unit3.

Select one of the following:

  • True
  • False

Explanation

Question 144 of 174

1

While converting currencies, in addition to source and target currencies, which value is also needed? -HA300. Unit3.

Select one or more of the following:

  • Time

  • Country

  • VAT rate

Explanation

Question 145 of 174

1

When might you use SAP HANA Studio? -HA300. Unit4.

Select one or more of the following:

  • To migrate deprecated object types to the supported types

  • To access the latest features of calculation view modeling

  • To maintain attribute and analytic views

  • To work with a tool you are familiar with when modeling XSA based development objects

Explanation

Question 146 of 174

1

Why is knowledge of SQL important to an SAP HANA modeler? -HA300. Unit5.

Select one or more of the following:

  • So that they can avoid creating calculation views and use SQL

  • So that they can understand how to implement a function or procedure

  • So that they can extend the capabilities of a calculation view using SQL
    expressions

Explanation

Question 147 of 174

1

You are using the SQL console of the We IDE for SAP HANA Database Explorer. When are schema references not required in your code? -HA300. Unit5.

Select one or more of the following:

  • When writing SQL against a database connection of the type HDI Container

  • When writing SQL against a database connection of the type SAP HANA Database.

Explanation

Question 148 of 174

1

What types of user defined function can you include in a calculation view? -HA300. Unit5.

Select one or more of the following:

  • Table

  • Column

  • Scalar

Explanation

Question 149 of 174

1

When would you use an SQL function? -HA300. Unit5.

Select one or more of the following:

  • As a replacement for a graphical calculation view when you need more flexibility

  • When you need to write results back to a table

  • When you need to define custom data processing logic that the graphical
    calculation view cannot provide

Explanation

Question 150 of 174

1

How should you create a procedure? -HA300. Unit5.

Select one or more of the following:

  • Write your code in a source file in the SAP Web IDE with the
    extension .hdbprocedure

  • Use the CREATE PROCEDURE statement in SQL Console

Explanation

Question 151 of 174

1

Procedures can be used in the FROM clause of a SELECT statement. -HA300. Unit5.

Select one of the following:

  • True
  • False

Explanation

Question 152 of 174

1

Why should I define my SAP HANA tables using CDS and not SQL ‘Create table’ syntax? -HA300. Unit6.

Select one or more of the following:

  • The syntax is much simpler than the standard SQL Create Table expression.

  • A table that is created with CDS performs better than one created with the
    standard SQL ‘Create Table’ expression.

  • The table definition is easily transported as part of the overall application to ensure
    all artifacts are kept together.

Explanation

Question 153 of 174

1

The relational model of SAP HANA Live is built using which type of views? -HA300. Unit7.

Select one or more of the following:

  • Calculation views of data category cube without star join

  • Calculation views of data category cube with star join

  • Calculation views of data category ‘blank’

  • Calculation views of data category dimension

Explanation

Question 154 of 174

1

Why is an integrated deployment approach preferred over the side-car approach to SAP HANA Live? -HA300. Unit7.

Select one or more of the following:

  • It provides a quick start to use SAP HANA Live for customers using SAP Business Suite on non-SAP HANA databases.

  • There is no requirement to copy data from SAP Business Suite to SAP HANA.

  • It offers a simplified landscape where SAP Business Suite and SAP HANA Live share the same in-memory tables.

Explanation

Question 155 of 174

1

Which version of CDS is used by SAP S/4HANA embedded analytics? -HA300. Unit7.

Select one or more of the following:

  • ABAP CDS

  • SAP HANA CDS

Explanation

Question 156 of 174

1

What are two reasons why SAP recommends developing data models using calculation views versus CDS? -HA300. Unit7.

Select one or more of the following:

  • More use cases are available with calculation views than CDS

  • Not all features and settings relevant to BI are available with CDS.

  • More optimization possibilities are available with calculation views

  • Calculation views can define the persistence layer as well as data modeling layer

Explanation

Question 157 of 174

1

To work with calculation view debug query, you first need to build the calculation view? -HA300. Unit8.

Select one of the following:

  • True
  • False

Explanation

Question 158 of 174

1

What is the purpose of the SQL Analyzer? -HA300. Unit8.

Select one or more of the following:

  • To identify the longest running SQL statements.

  • To investigate the generated SQL for each node in my calculation view.

  • To highlight syntax errors in my SQL code.

Explanation

Question 159 of 174

1

Where possible, in your SQL code, always use calculation engine (CE) functions to ensure best performance. -HA300. Unit8.

Select one of the following:

  • True
  • False

Explanation

Question 160 of 174

1

Where do I define a pruning configuration table? -HA300. Unit8.

Select one or more of the following:

  • Join nodes.

  • Union nodes.

  • Projection nodes.

Explanation

Question 161 of 174

1

Which of the following tools is used to analyze dependencies between models? -HA300. Unit9.

Select one or more of the following:

  • Data lineage

  • Column lineage

  • Impact analysis

Explanation

Question 162 of 174

1

Which of the following development layers of an XS Advanced application are provided by an HDB module? -HA300. Unit9.

Select one or more of the following:

  • Persistence layer

  • User interface

  • Business logic

  • Data modeling

Explanation

Question 163 of 174

1

An XS Advanced project can contain multiple HDB modules. -HA300. Unit9.

Select one of the following:

  • True
  • False

Explanation

Question 164 of 174

1

The database objects defined in design-time files located in the same project folder can have different namespaces.
-HA300. Unit9.

Select one of the following:

  • True
  • False

Explanation

Question 165 of 174

1

A HDB module always corresponds to a database schema. -HA300. Unit9.

Select one of the following:

  • True
  • False

Explanation

Question 166 of 174

1

You have successfully built a project that you imported into the SAP Web IDE workspace, but you cannot see the corresponding runtime database objects. What could be the reason? -HA300. Unit9.

Select one or more of the following:

  • The project is not assigned to a Space.

  • Building a project does not generate the database objects defined in its HDB modules.

  • You do not have the Developer role in the assigned Space.

Explanation

Question 167 of 174

1

A calculation view CV1 has been created in your project folder but has never been built. Your perform a build of another calculation view CV2 that consumes CV1. The CV1 file will be included in the build of CV2. -HA300. Unit9.

Select one of the following:

  • True
  • False

Explanation

Question 168 of 174

1

Which database artifact do you use to access external data from an XS Advanced project? -HA300. Unit9.

Select one or more of the following:

  • Calculation view

  • Synonym

  • Logical schema

  • User-provided service

Explanation

Question 169 of 174

1

The Git architecture relies on a central server that stores a unique version of your source code and includes a check-out process that prevents several users from modifying the same source file at the same time. -HA300. Unit9.

Select one of the following:

  • True
  • False

Explanation

Question 170 of 174

1

Which phase of a project does SAP Enterprise Architecture Designer support? -HA300. Unit9.

Select one or more of the following:

  • Development

  • Design

  • Planning

  • Running

Explanation

Question 171 of 174

1

SAP Enterprise Architecture Designer can be used as an alternative to develop calculation views in SAP Web IDE.
-HA300. Unit9.

Select one of the following:

  • True
  • False

Explanation

Question 172 of 174

1

What is a dynamic analytic privilege? -HA300. Unit10.

Select one or more of the following:

  • A reusable analytic privilege that can be used for several users who need to access
    different data.

  • An analytic privilege that takes its filter values from variables defined in the calculation view

  • A temporary analytic privilege that has a defined time validity set for its use

Explanation

Question 173 of 174

1

What is data masking? -HA300. Unit10.

Select one or more of the following:

  • Obscuring column values by hiding some or all characters with replacement characters

  • Replacing column values with a higher level group such as replacing a person id with team name

  • Removing complete rows of data that should not be seen by users

Explanation

Question 174 of 174

1

Why do you implement data anonymization? -HA300. Unit10.

Select one or more of the following:

  • To hide sensitive data using alternative characters such as ‘XXXXX’.

  • To hide sensitive data by adding noise at the record level so that aggregated values
    still make sense but individual records are not exposed.

  • To remove complete records so that they cannot be seen by unauthorized users

Explanation

Previous
Check answer
Next