E_HANAAW_14 ABAP for SAP HANA

ERNESTO L MARQUEZ F
Quiz by ERNESTO L MARQUEZ F, updated more than 1 year ago
ERNESTO L MARQUEZ F
Created by ERNESTO L MARQUEZ F over 1 year ago
965
1

Description

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

Resource summary

Question 1

Question
Which of the following SAP HANA-Based scenarios involve ABAP Applications? - HA400 - Unit 1/Less_1. Pg. 5,6.
Answer
  • Data Smart Based on SAP HANA.
  • AS ABAP with SAP HANA as primary database.
  • Native SAP HANA Applications.
  • SAP HANA as Business Acelerators.

Question 2

Question
On SAP HANA, tables are stored in row store by default. - HA400 - Unit 1.
Answer
  • True
  • False

Question 3

Question
Which of the following entries are required when creating a system in the SAP HANA Studio?.- HA400 - Unit 1/Less_2. Pg. 14,15.
Answer
  • Host Name
  • Instance Number
  • Cliente ID
  • User Name
  • Logon Language

Question 4

Question
Which of the followin entities can be found under node Catalog and not under node Content?- HA400 - Unit 1/Less_1. Pg. 15,16.
Answer
  • Package
  • Schema
  • Table
  • Calculation View

Question 5

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

Question 6

Question
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.
Answer
  • External Views
  • CDS Views
  • Database Procedure Proxy
  • ABAP-Manage Database Procedure

Question 7

Question
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.
Answer
  • True
  • False

Question 8

Question
Which of the following are potential issues when migrating ABAP code to SAP HANA?. - HA400 - Unit 2/Less_2. Pg. 49,50.
Answer
  • 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.

Question 9

Question
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.
Answer
  • In a Code Inspector object list.
  • In a Code Inspector object check variant.
  • In a Code Inspector inspection.

Question 10

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

Question 11

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

Question 12

Question
Which of the following patterns are known to potentially cause performance issues when accessing SAP HANA database? - Unit 2/Less_5. Pg. 67.
Answer
  • 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.

Question 13

Question
Which of the following are steps in the recommended sequence for a guide performance analysis? -Unit 2/Less_4. Pg. 60,61.
Answer
  • 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.

Question 14

Question
Which part of a guided performance analysis is done with th SQL Monitor tool? -Unit 2/Less_4. Pg. 62.
Answer
  • 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.

Question 15

Question
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.
Answer
  • True
  • False

Question 16

Question
Wich of the SQL performance rules become more important with SAP HANA? -Unit 2/Less_5. Pg. 66,67.
Answer
  • 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.

Question 17

Question
Which of the SQL performance rules become less important with SAP HANA? -Unit 2/Less_5. Pg. 67.
Answer
  • 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.

Question 18

Question
Which of the following are task of the database interface (DBI) and the Database Specific Library (DBSL)?. - HA400 UNIT3. Less_1. Pg.77,78.
Answer
  • Translate Open SQL syntax into Native Sql Syntax.
  • Add client handling to the statement.
  • Check User Authorizations
  • Handle SAP table buffering
  • Transaction handling

Question 19

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

Question 20

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

Question 21

Question
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.
Answer
  • True
  • False

Question 22

Question
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.
Answer
  • Data definition (aka DDL source)
  • CDS view
  • SQL view

Question 23

Question
Which of the following entities corresponds to an object that is created on the database?- HA400 UNIT3. Less_3. Pg.87,88.
Answer
  • Data Definition ( aka DDL source ).
  • CDS view.
  • SQL View.

Question 24

Question
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.
Answer
  • True
  • False

Question 25

Question
ASSOCIATION TO is just another way of saying LEFT OUTER JOIN TO. - HA400 UNIT3. Less_3.
Answer
  • True
  • False

Question 26

Question
Which of the following are prerequisites for exposing an association? - HA400 UNIT3. Less_3.
Answer
  • 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.

Question 27

Question
Where can you evaluate an exposed Association? - HA400 UNIT3. Less_3.
Answer
  • In the Data Preview of ADT.
  • In the Data Browser ( transaction SE16 ).
  • In another CDS view
  • In an Open SQL SELECT statement

Question 28

Question
CDS views that define associations cannot be extended. - HA400 UNIT3. Less_3.
Answer
  • True
  • False

Question 29

Question
An import parameter that is annotated with @Enviroment.systemField: becomes optional in the following places: - HA400 UNIT3. Less_3.
Answer
  • In Data preview in ADT.
  • In the Data Browser ( SE16 ).
  • In ABAP Open SQL.
  • In the definition of another CDS view.

Question 30

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

Question 31

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

Question 32

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

Question 33

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

Question 34

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

Question 35

Question
Any AMDP method shipped by SAP can be extended using the AMDP BAdI technique. -HA400. Unit4
Answer
  • True
  • False

Question 36

Question
What can you do in ADT (ABAP in Eclipse) but not in the classical ABAP Workbench?. -HA400. Unit4
Answer
  • Display an AMDP method implementation.
  • Edit an AMDP method implementation.
  • Test an AMDP method implementation.
  • Debug an AMDP method implementation.

Question 37

Question
When executing a native SQL query via ABAP Database Connectivity (ADBC), which of the following steps is optional? -HA400. Unit4
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.

Question 38

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

Question 39

Question
The search function in the toolbar of SAP HANA studio searches in SAP HANA content and in the SAP HANA catalog. -HA400. Unit5
Answer
  • True
  • False

Question 40

Question
You can use Data Preview in SAP HANA studio to test SAP HANA views and SAP HANA stored procedures. -HA400. Unit5
Answer
  • True
  • False

Question 41

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

Question 42

Question
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
Answer
  • Two table-like results.
  • Two scalar results.
  • One scalar result.
  • One table-like result.

Question 43

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

Question 44

Question
Which of the following are advantages of using proxy objects for SAP HANA artefacts?. -HA400. Unit5
Answer
  • 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.

Question 45

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

Question 46

Question
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
Answer
  • True
  • False

Question 47

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

Question 48

Question
Proposal search (= type ahead search) is supported on all database systems. -HA400. Unit6
Answer
  • True
  • False

Question 49

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

Question 50

Question
Which of the following ABAP repository objects can be the data source for ALV with IDA? -HA400. Unit6
Answer
  • Transparent table
  • Database view
  • CDS view
  • External view

Question 51

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

Question 52

Question
Which recent trends have triggered the need for a next generation data processing platform? -HA100. Unit1.
Answer
  • 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

Question 53

Question
Which recent technology innovations have triggered the opportunity to build a next generation data processing platform? -HA100. Unit1.
Answer
  • Faster disk access.
  • Multi-core processing.
  • Larger memory availability.

Question 54

Question
What are the key features of SAP HANA? -HA100. Unit1.
Answer
  • In-memory database
  • Automatic compression of data
  • Removes the need for cache
  • Combined OLTP and OLAP processing on one platform

Question 55

Question
Which are true statements? -HA100. Unit1.
Answer
  • 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.

Question 56

Question
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.
Answer
  • True
  • False

Question 57

Question
Where is SDI used? -HA100. Unit2.
Answer
  • Data cleansing
  • Data transformation
  • Data streaming
  • For data loading

Question 58

Question
How many processing tiers do you usually find in a native SAP HANA application stack? -HA100. Unit2.
Answer
  • 1
  • 2
  • 3

Question 59

Question
What is XS? -HA100. Unit2.
Answer
  • A native, lightweight application server
  • An optional engine to handle excessive data loads
  • A data cleansing engine
  • A user interface

Question 60

Question
Why did SAP move from XS to XSA? -HA100. Unit2.
Answer
  • 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

Question 61

Question
What are the two views in the Web IDE for SAP HANA? -HA100. Unit2.
Answer
  • Database Explorer
  • Development
  • Catalog

Question 62

Question
In SAP HANA Studio, what would you find in a Package? -HA100. Unit2.
Answer
  • Calculation Views
  • Analytic Privileges
  • Procedures
  • Tables

Question 63

Question
In Web IDE for SAP HANA, what can I create in a HDB module? -HA100. Unit2.
Answer
  • Calculation View
  • Analytic Privilege
  • HTML file
  • Flowgraph

Question 64

Question
What is a role of the SAP HANA Cockpit? -HA100. Unit2.
Answer
  • 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

Question 65

Question
What are advantages of column store tables? -HA100. Unit2.
Answer
  • 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

Question 66

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

Question 67

Question
Why do we still need a persistent layer? -HA100. Unit2.
Answer
  • 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

Question 68

Question
What is a multistore table? -HA100. Unit2.
Answer
  • 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

Question 69

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

Question 70

Question
What is a multi-target application (MTA)? -HA100. Unit2.
Answer
  • 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

Question 71

Question
What are the two storage components used to restore the database in case of power failure? -HA100. Unit2.
Answer
  • Log area
  • Data volume
  • Memory
  • Delta store

Question 72

Question
What is the role of core modeling in SAP HANA? -HA100. Unit3.
Answer
  • 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

Question 73

Question
What are valid types of calculation view? -HA100. Unit3.
Answer
  • Dimension
  • Cube
  • Cube with star schema
  • Dimension with star schema

Question 74

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

Question 75

Question
What do we implement to restrict access to specific data rows of a calculation view? -HA100. Unit3.
Answer
  • SQL permission
  • Authorisation object
  • Analytic privilege

Question 76

Question
Which SAP solution is used with SAP HANA Live? -HA100. Unit3.
Answer
  • SAP S/4HANA
  • SAP Business Suite
  • SAP Ariba

Question 77

Question
Which of these is used to build the virtual data model for SAP S/4HANA? -HA100. Unit3.
Answer
  • ABAP CDS
  • SAP HANA Live
  • Universe
  • SAP HANA CDS

Question 78

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

Question 79

Question
In SAP HANA Text Analysis, why would you use the ‘Voice of Customer’ dictionary? -HA100. Unit3.
Answer
  • 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

Question 80

Question
What must I create to develop a predictive model? -HA100. Unit3.
Answer
  • Calculation View
  • Predictive Analysis Library
  • Flowgraph
  • Procedure

Question 81

Question
SAP HANA Graph Processing powers real-time, high-performance business charts and dashboards. -HA100. Unit3.
Answer
  • True
  • False

Question 82

Question
In data temperature management, cool data is stored in HANA Extended Storage. -HA100. Unit4.
Answer
  • True
  • False

Question 83

Question
What is SAP Enterprise Architecture Designer? -HA100. Unit4.
Answer
  • 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

Question 84

Question
What are typical characteristics of SAP HANA data replication? -HA100. Unit4.
Answer
  • Virtualization
  • Duplicate data
  • Real-time
  • Streaming

Question 85

Question
SAP SLT can be used for real-time replication from SAP and non-SAP sources. -HA100. Unit4.
Answer
  • True
  • False

Question 86

Question
What are components of SAP HANA EIM? -HA100. Unit4.
Answer
  • SDI
  • SDA
  • SDS
  • SDQ

Question 87

Question
What are features of SDA? -HA100. Unit4.
Answer
  • Automatic data type translation
  • Data cleansing
  • Evaluation and execution of push-down possibilities to remote sources
  • Merging data from multiple sources

Question 88

Question
Which of the following are correct statements relating to the flat file import function of SAP HANA Studio? -HA100. Unit4.
Answer
  • 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.

Question 89

Question
What are the database query languages used by SAP HANA? -HA100. Unit5.
Answer
  • ODBC
  • JDBC
  • MDX
  • SQL
  • ABAP

Question 90

Question
What are features of Business Suite on SAP HANA? -HA100. Unit5.
Answer
  • Embedded Analytics for operational analytics
  • ABAP is replaced with JAVA
  • Combine operational analytics and transaction processing
  • Massive performance improvement

Question 91

Question
What are features of SAP S/4HANA? -HA100. Unit5.
Answer
  • 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

Question 92

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

Question 93

Question
Which of these does SAP HANA use to connect to BI tools? -HA100. Unit5.
Answer
  • IDOC
  • ODBC
  • JDBC
  • ODBO

Question 94

Question
In which key areas can we expect there to be improvements when running SAP BW on SAP HANA? -HA100. Unit5.
Answer
  • Tighter security
  • Data loading performance
  • Superior data quality
  • Reporting performance

Question 95

Question
In SAP BW, when we refer to mixed modeling, what do we mean? -HA100. Unit5.
Answer
  • 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

Question 96

Question
Where will you find the Data Distribution Optimizer? -HA100. Unit5.
Answer
  • SAP HANA Studio
  • SAP BW/4HANA
  • SAP HANA Data Warehousing foundation

Question 97

Question
Which interface client is used for XSA application development? -HA100. Unit5.
Answer
  • SAP HANA Web-based Workbench
  • SAP Web IDE for SAP HANA
  • SAP HANA Studio
  • SAP Web IDE

Question 98

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

Question 99

Question
Eclipse is a proprietary tool developed by SAP. -BC404. Unit1.
Answer
  • True
  • False

Question 100

Question
Which of the following statements best describes SAP’s approach to Eclipse? -BC404. Unit1.
Answer
  • 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

Question 101

Question
Development in ABAP Development Tools is performed using the same online development model used in the ABAP Workbench. -BC404. Unit1.
Answer
  • True
  • False

Question 102

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

Question 103

Question
Where can you set your preferences for working with ADT? -BC404. Unit1.
Answer
  • In the project properties dialog box
  • Under Window→ Preferences
  • In both the project properties dialog box and under Window→ Preferences

Question 104

Question
Which of the following are perspectives in ADT? -BC404. Unit1.
Answer
  • ABAP
  • Transport Organizer
  • Debug
  • Package

Question 105

Question
ADT contains native Eclipse editors for which kinds of repository objects? -BC404. Unit2.
Answer
  • ABAP programs
  • Data elements
  • ABAP classes
  • Packages
  • Text elements

Question 106

Question
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.
Answer
  • Shift + Enter
  • Ctrl + Enter
  • Alt + Enter
  • Ctrl + Shift + Enter

Question 107

Question
Which of the following functions are available in both the ADT Debug perspective and the SAP GUI Debugger? -BC404. Unit2.
Answer
  • Setting breakpoints dynamically during debugging
  • Memory analysis
  • Source code editing in the debugger
  • Displaying the contents of an internal table

Question 108

Question
You are creating a function module in ADT. How can you define its interface without leaving the function module editor? -BC404. Unit3
Answer
  • 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

Question 109

Question
A Core Data Services View can only implement an inner join. -BC404. Unit4.
Answer
  • True
  • False

Question 110

Question
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.
Answer
  • Choose the Code Wizard icon from the application toolbar
  • Choose F2 then choose the required action
  • Choose Ctrl + Space then choose the required action

Question 111

Question
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.
Answer
  • Add the implementation of the method
  • Move the method definition to the protected or private section
  • Delete the method

Question 112

Question
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.
Answer
  • Ctrl + F2
  • F3
  • Ctrl + Shift + F5
  • F6

Question 113

Question
Which keyboard shortcut displays the Open ABAP Development Object wizard? -BC404. Unit7.
Answer
  • Ctrl + Shift + H
  • Ctrl + H
  • Ctrl + A
  • Ctrl + Shift + A

Question 114

Question
Feeds are updated automatically for both open and closed ABAP projects. -BC404. Unit7.
Answer
  • True
  • False

Question 115

Question
Which symbol do ABAP Doc comments start with? -BC404. Unit7.
Answer
  • “&
  • *
  • “!
  • !”

Question 116

Question
The ABAP Test Cockpit allows you to re-use check variants from which other analysis tool? -BC404. Unit8.
Answer
  • The Code Inspector
  • The Extended Program Check
  • The ABAP Trace

Question 117

Question
In ABAP Unit, the SETUP method is called before each individual test method. -BC404. Unit8.
Answer
  • True
  • False

Question 118

Question
Which of the following statements about ABAP Unit tests are true? -BC404. Unit8.
Answer
  • 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

Question 119

Question
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.
Answer
  • True
  • False

Question 120

Question
Which of the following SAP HANA objects can be assigned to a HANA Transport Container? -BC404. Unit9.
Answer
  • Packages.
  • Delivery Units.
  • Calculation Views.
  • Procedures.

Question 121

Question
Which of the following are types of calculation views? -HA300. Unit1.
Answer
  • Cube
  • Composite
  • Cube with star join
  • Dimension

Question 122

Question
A dimension can have attributes and measures. -HA300. Unit1.
Answer
  • True
  • False

Question 123

Question
Which are true statements relating to calculation views of the type DEFAULT? -HA300. Unit1.
Answer
  • 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

Question 124

Question
Which are supported data source types for calculation view consumption? -HA300. Unit1.
Answer
  • Calculation views
  • Flat files
  • Virtual tables
  • Column tables
  • Row tables

Question 125

Question
What is a time-based dimension calculation view? -HA300. Unit1.
Answer
  • A view that is only accessible by users for a limited time
  • A view that stores the values of attributes across time

Question 126

Question
What does SAP recommend you use to check your calculation view produces correct result? -HA300. Unit1.
Answer
  • Excel pivot tables
  • Custom SQL queries
  • Data preview function in Web IDE

Question 127

Question
What is the purpose of the projection node? -HA300. Unit2.
Answer
  • To apply filters on the data
  • To extract only the required columns from a data source
  • To aggregate measures
  • To join data sources

Question 128

Question
Why do you use a referential join? -HA300. Unit2.
Answer
  • 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.

Question 129

Question
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.
Answer
  • True
  • False

Question 130

Question
Identify the type of join that ensures records are only selected if they fit a specified data range. -HA300. Unit2.
Answer
  • Left Outer Join
  • Right Outer Join
  • Temporal Join
  • Full Outer Join

Question 131

Question
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.
Answer
  • True
  • False

Question 132

Question
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.
Answer
  • Intersect
  • Minus
  • Union

Question 133

Question
In an aggregation node, a calculated column is always computed before the aggregate function. -HA300. Unit2.
Answer
  • True
  • False

Question 134

Question
Which flags are relevant to the control of the aggregation behavior? -HA300. Unit2.
Answer
  • Keep Flag
  • Transparent filter
  • Dynamic join

Question 135

Question
In a star join node, what do you join to the central entity (fact table)? -HA300. Unit2.
Answer
  • Cube calculation views
  • Column tables
  • Dimensions calculation views

Question 136

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

Question 137

Question
A restricted columns provide a subset of the original column filtered by attribute values. -HA300. Unit3.
Answer
  • True
  • False

Question 138

Question
When is the design time filter expression applied in a calculation view? -HA300. Unit3.
Answer
  • 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

Question 139

Question
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.
Answer
  • True
  • False

Question 140

Question
Identify the object that adds a WHERE clause to the query. -HA300. Unit3.
Answer
  • Modeler
  • Attributes
  • Input parameter
  • Variable

Question 141

Question
In a calculated column which do you use as a placeholder for a dynamic value in an expression? -HA300. Unit3.
Answer
  • Variable
  • Input parameter

Question 142

Question
What are the features of a parent-child hierarchy? -HA300. Unit3.
Answer
  • 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.

Question 143

Question
A hierarchy navigation function must be preceded by a hierarchy generator function inside a calculation view. -HA300. Unit3.
Answer
  • True
  • False

Question 144

Question
While converting currencies, in addition to source and target currencies, which value is also needed? -HA300. Unit3.
Answer
  • Time
  • Country
  • VAT rate

Question 145

Question
When might you use SAP HANA Studio? -HA300. Unit4.
Answer
  • 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

Question 146

Question
Why is knowledge of SQL important to an SAP HANA modeler? -HA300. Unit5.
Answer
  • 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

Question 147

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

Question 148

Question
What types of user defined function can you include in a calculation view? -HA300. Unit5.
Answer
  • Table
  • Column
  • Scalar

Question 149

Question
When would you use an SQL function? -HA300. Unit5.
Answer
  • 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

Question 150

Question
How should you create a procedure? -HA300. Unit5.
Answer
  • Write your code in a source file in the SAP Web IDE with the extension .hdbprocedure
  • Use the CREATE PROCEDURE statement in SQL Console

Question 151

Question
Procedures can be used in the FROM clause of a SELECT statement. -HA300. Unit5.
Answer
  • True
  • False

Question 152

Question
Why should I define my SAP HANA tables using CDS and not SQL ‘Create table’ syntax? -HA300. Unit6.
Answer
  • 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.

Question 153

Question
The relational model of SAP HANA Live is built using which type of views? -HA300. Unit7.
Answer
  • 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

Question 154

Question
Why is an integrated deployment approach preferred over the side-car approach to SAP HANA Live? -HA300. Unit7.
Answer
  • 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.

Question 155

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

Question 156

Question
What are two reasons why SAP recommends developing data models using calculation views versus CDS? -HA300. Unit7.
Answer
  • 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

Question 157

Question
To work with calculation view debug query, you first need to build the calculation view? -HA300. Unit8.
Answer
  • True
  • False

Question 158

Question
What is the purpose of the SQL Analyzer? -HA300. Unit8.
Answer
  • 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.

Question 159

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

Question 160

Question
Where do I define a pruning configuration table? -HA300. Unit8.
Answer
  • Join nodes.
  • Union nodes.
  • Projection nodes.

Question 161

Question
Which of the following tools is used to analyze dependencies between models? -HA300. Unit9.
Answer
  • Data lineage
  • Column lineage
  • Impact analysis

Question 162

Question
Which of the following development layers of an XS Advanced application are provided by an HDB module? -HA300. Unit9.
Answer
  • Persistence layer
  • User interface
  • Business logic
  • Data modeling

Question 163

Question
An XS Advanced project can contain multiple HDB modules. -HA300. Unit9.
Answer
  • True
  • False

Question 164

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

Question 165

Question
A HDB module always corresponds to a database schema. -HA300. Unit9.
Answer
  • True
  • False

Question 166

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

Question 167

Question
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.
Answer
  • True
  • False

Question 168

Question
Which database artifact do you use to access external data from an XS Advanced project? -HA300. Unit9.
Answer
  • Calculation view
  • Synonym
  • Logical schema
  • User-provided service

Question 169

Question
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.
Answer
  • True
  • False

Question 170

Question
Which phase of a project does SAP Enterprise Architecture Designer support? -HA300. Unit9.
Answer
  • Development
  • Design
  • Planning
  • Running

Question 171

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

Question 172

Question
What is a dynamic analytic privilege? -HA300. Unit10.
Answer
  • 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

Question 173

Question
What is data masking? -HA300. Unit10.
Answer
  • 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

Question 174

Question
Why do you implement data anonymization? -HA300. Unit10.
Answer
  • 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
Show full summary Hide full summary

Similar

THR10 y THR12
Fabiola Montes-Baquier
Modelo de Prueba de Certificación SAP FI
ERNESTO L MARQUEZ F
THR10
marcos1976
EVALUCIÓN DEL MODULO DE TRANSPORTE
yovany ramirez
HA100: Introduction to SAP HANA
Antonio de Ancos Cid
1. INTRODUCCIÓN A SAP
Carlos Andres Al
1. INTRODUCCIÓN A SAP
dulce maria jimenez esquivez
SAP SD
mey.245
Proceso de compra de Bavaria (cerveza)
Andrés Pérez
Proceso de compra de Bavaria (cerveza)
Luis Barragan
departamentos y capitales
Hana Luisa Davila Correa