Quiz
E_HANAAW_14 ABAP for SAP HANA
Questions in this quiz (174)
1Which of the following SAP HANA-Based scenarios involve ABAP Applications? - HA400 - Unit 1/Less_1. Pg. 5,6.
- AData Smart Based on SAP HANA.
- BAS ABAP with SAP HANA as primary database.
- CNative SAP HANA Applications.
- DSAP HANA as Business Acelerators.
2On SAP HANA, tables are stored in row store by default. - HA400 - Unit 1.
- ATrue
- BFalse
3Which of the following entries are required when creating a system in the SAP HANA Studio?.- HA400 - Unit 1/Less_2. Pg. 14,15.
- AHost Name
- BInstance Number
- CCliente ID
- DUser Name
- ELogon Language
4Which of the followin entities can be found under node Catalog and not under node Content?- HA400 - Unit 1/Less_1. Pg. 15,16.
- APackage
- BSchema
- CTable
- DCalculation View
5It is not posible to create secondary index on SAP HANA. - HA400 - Unit 1/Less_3. Pg. 21,24.
- ATrue
- BFalse
6Which 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.
- AExternal Views
- BCDS Views
- CDatabase Procedure Proxy
- DABAP-Manage Database Procedure
7When 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.
- ATrue
- BFalse
8Which of the following are potential issues when migrating ABAP code to SAP HANA?. - HA400 - Unit 2/Less_2. Pg. 49,50.
- AUse of native QSL or DB Hints.
- BUse of secondary database connection.
- CCoding that assumes that a SELECT result is always sorted.
- DThe existence of customer-specific cluster tables.
- EThe existence of table appends.
9Where 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.- AIn a Code Inspector object list.
- BIn a Code Inspector object check variant.
- CIn a Code Inspector inspection.
10When migrating to SAP HANA, every SELECT statement immediately become faster. - HA400 - Unit 2/Less_3. Pg. 54.
- ATrue
- BFalse
11Because SAP HANA stores all data in memory, buffering of data on the application server becomes less important. UNIT 2.
- ATrue
- BFalse
12Which of the following patterns are known to potentially cause performance issues when accessing SAP HANA database? - Unit 2/Less_5. Pg. 67.
- AUse of SELECT.. FOR ALL ENTRIES..
- BUse of JOINS with more than 3 tables.
- CUse of SELECT statements in LOOPS.
- DUse of SELECT * for tables with many fields.
13Which of the following are steps in the recommended sequence for a guide performance analysis? -Unit 2/Less_4. Pg. 60,61.
- ADo static code checks with Code Inspector or ABAP Test Cockpit.
- BCollect runtime data with SQL Monitor.
- CCollect runtime data with Runtime Analysis.
- DCombine runtime data and static check result in SQL Performance Tuning Worklist.
14Which part of a guided performance analysis is done with th SQL Monitor tool? -Unit 2/Less_4. Pg. 62.
- ACollect runtime data in the productive system.
- BDo static SQL checks in the productive system.
- CDo static SQL check in the development system.
- DCombine runtime data and static check result.
15SQL 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.
- ATrue
- BFalse
16Wich of the SQL performance rules become more important with SAP HANA? -Unit 2/Less_5. Pg. 66,67.
- AKeep the result set small.
- BMinimize amount of transferred data.
- CMinimize number of database accesses.
- DMinimize search overhead.
- EKeep unnecessary load away from the DB.
17Which of the SQL performance rules become less important with SAP HANA? -Unit 2/Less_5. Pg. 67.
- AKeep the result set small.
- BMinimize amount of transferred data.
- CMinimize number of database accesses.
- DMinimize search overhead.
- EKeep unnecessary load away from the DB.
18Which of the following are task of the database interface (DBI) and the Database Specific Library (DBSL)?. - HA400 UNIT3. Less_1. Pg.77,78.
- ATranslate Open SQL syntax into Native Sql Syntax.
- BAdd client handling to the statement.
- CCheck User Authorizations
- DHandle SAP table buffering
- ETransaction handling
19New Open SQL Syntax is mandatory as of SAP Netweaver AS ABAP 7.40 SP05. - HA400 UNIT3. Less_1. Pg.81,82.
- ATrue
- BFalse
20The Open SQL Syntax is a prerequisite for the new Open SQL features. - HA400 UNIT3. Less_1. Pg.81,82.
- ATrue
- BFalse
21Classical 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.
- ATrue
- BFalse
22Which 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.
- AData definition (aka DDL source)
- BCDS view
- CSQL view
23Which of the following entities corresponds to an object that is created on the database?- HA400 UNIT3. Less_3. Pg.87,88.
- AData Definition ( aka DDL source ).
- BCDS view.
- CSQL View.
24If 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.
- ATrue
- BFalse
25ASSOCIATION TO is just another way of saying LEFT OUTER JOIN TO. - HA400 UNIT3. Less_3.
- ATrue
- BFalse
26Which of the following are prerequisites for exposing an association? - HA400 UNIT3. Less_3.
- AThe Association points to a table, not to another CDS View.
- BThe Association has cardinality 'to N'.
- CAll fields mentioned in the ON condition are part of the field list.
- DThe Association is the only Association in this view definition.
27Where can you evaluate an exposed Association? - HA400 UNIT3. Less_3.
- AIn the Data Preview of ADT.
- BIn the Data Browser ( transaction SE16 ).
- CIn another CDS view
- DIn an Open SQL SELECT statement
28CDS views that define associations cannot be extended. - HA400 UNIT3. Less_3.
- ATrue
- BFalse
29An import parameter that is annotated with @Enviroment.systemField: becomes optional in the following places: - HA400 UNIT3. Less_3.
- AIn Data preview in ADT.
- BIn the Data Browser ( SE16 ).
- CIn ABAP Open SQL.
- DIn the definition of another CDS view.
30An 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.
- AIn Data preview in ADT.
- BIn the Data Browser ( SE16 ).
- CIn ABAP Open SQL.
- DIn the definition of another CDS view.
31Which of the following are common ground between SAP HANA syntax and Open SQL
syntax (as of ABAP 7.40 SP05)? -HA400. Unit4- AKey words are not case-sensitive.
- BIdentical client handling.
- CTable names have to be upper-case.
- DComma-separated field lists.
- EField list after FROM clause is supported.
32In SAP HANA SQL, it is mandatory to specify a schema before the table name. -HA400. Unit4
- ATrue
- BFalse
33Which of the following are supported types for parameters of AMDP methods?. -HA400. Unit4
- ANumeric or character-like scalar types.
- BStructure types with only scalar components.
- CTable types with only scalar columns.
- DNested table types without secondary keys.
34All ABAP objects used within the body of an AMDP method have to be listed after the
USING addition. -HA400. Unit4- ATrue
- BFalse
35Any AMDP method shipped by SAP can be extended using the AMDP BAdI technique. -HA400. Unit4
- ATrue
- BFalse
36What can you do in ADT (ABAP in Eclipse) but not in the classical ABAP Workbench?. -HA400. Unit4
- ADisplay an AMDP method implementation.
- BEdit an AMDP method implementation.
- CTest an AMDP method implementation.
- DDebug an AMDP method implementation.
37When executing a native SQL query via ABAP Database Connectivity (ADBC), which of the
following steps is optional? -HA400. Unit4- ACreate an instance of CL_SQL_CONNECTION.
- BCreate an instance of CL_SQL_STATEMENT.
- CCreate an instance of CL_SQL_RESULT_SET.
- DNone, all three are mandatory.
38What happens if you forget to call method close( ) at the end of your query?. -HA400. Unit4
- AYou don’t forget a result.
- BAn exception is raised.
- CDB resources remain blocked.
- DNothing.
39The search function in the toolbar of SAP HANA studio searches in SAP HANA content
and in the SAP HANA catalog. -HA400. Unit5- ATrue
- BFalse
40You can use Data Preview in SAP HANA studio to test SAP HANA views and SAP HANA
stored procedures. -HA400. Unit5- ATrue
- BFalse
41You 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- AFROM _SYS_BIC.“ha400.primdb.::CA_BOOKINGS_COUNT”
- BFROM “ha400.primdb::CA_BOOKINGS_COUNT”
- CFROM _SYS_BIC.“ha400.primdb/CA_BOOKINGS_COUNT”
- DFROM “ha400.primdb/CA_BOOKINGS_COUNT”
42You 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- ATwo table-like results.
- BTwo scalar results.
- COne scalar result.
- DOne table-like result.
43Which of the following object types in ABAP repository are proxy objects for SAP HANA
artefacts?. -HA400. Unit5- AProcedure Proxy.
- BDatabase View.
- CSQL View.
- DExternal View.
44Which of the following are advantages of using proxy objects for SAP HANA artefacts?. -HA400. Unit5
- ANo native SQL required to access the SAP HANA object.
- BAutomatic synchronization of proxy object definition
- CAutomatic transport of SAP HANA artefacts in ABAP transport request.
- DNo need for SAP HANA database to define the proxy objects.
45When creating a proxy object for an SAP HANA view, it is possible to specify data
elements for the view fields. -HA400. Unit5- ATrue
- BFalse
46In 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- ATrue
- BFalse
47You 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- ATable TAB is located in column store.
- BColumn COL is of type TEXT or SHORTTEXT.
- CA full text index exists for column COL of table TAB.
- DThe application server release is 7.40 SP05 or higher.
48Proposal search (= type ahead search) is supported on all database systems. -HA400. Unit6
- ATrue
- BFalse
49ABAP List Viewer with Integrated Data Access (ALV with IDA) is only supported for SAP
HANA database. -HA400. Unit6- ATrue
- BFalse
50Which of the following ABAP repository objects can be the data source for ALV with IDA? -HA400. Unit6
- ATransparent table
- BDatabase view
- CCDS view
- DExternal view
51Which of the following features are NOT supported by ALV with IDA? -HA400. Unit6
- APersonalization
- BEditing values
- CExcel export
- DDouble-click
52Which recent trends have triggered the need for a next generation data processing platform? -HA100. Unit1.
- AIncreasing connectivity of people and devices
- BMove transactional processing and analysis to separate servers for better
scalability - CIncrease in use of mobile devices
- DMassive growth in data volume
53Which recent technology innovations have triggered the opportunity to build a next generation data processing platform?
-HA100. Unit1.- AFaster disk access.
- BMulti-core processing.
- CLarger memory availability.
54What are the key features of SAP HANA? -HA100. Unit1.
- AIn-memory database
- BAutomatic compression of data
- CRemoves the need for cache
- DCombined OLTP and OLAP processing on one platform
55Which are true statements? -HA100. Unit1.
- ASAP HANA runs on Intel x86 and SPARC hardware platforms.
- BSAP HANA runs on Unix.
- CSAP HANA can be installed only by certified engineers for production purposes.
- DCustomers can re-use their own certified hardware components in an SAP HANA system.
- ESAP HANA is available in the cloud or on premise, or a combination of both.
56SAP 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.
- ATrue
- BFalse
57Where is SDI used? -HA100. Unit2.
- AData cleansing
- BData transformation
- CData streaming
- DFor data loading
58How many processing tiers do you usually find in a native SAP HANA application stack? -HA100. Unit2.
- A1
- B2
- C3
59What is XS? -HA100. Unit2.
- AA native, lightweight application server
- BAn optional engine to handle excessive data loads
- CA data cleansing engine
- DA user interface
60Why did SAP move from XS to XSA? -HA100. Unit2.
- ATo move to Cloud Foundry architecture to allow flexible application deployment options
- BTo include ABAP as a key development language for native SAP HANA applications
- CTo implement micro-services architecture
- DTo provide better source code management tools inside SAP HANA
61What are the two views in the Web IDE for SAP HANA? -HA100. Unit2.
- ADatabase Explorer
- BDevelopment
- CCatalog
62In SAP HANA Studio, what would you find in a Package? -HA100. Unit2.
- ACalculation Views
- BAnalytic Privileges
- CProcedures
- DTables
63In Web IDE for SAP HANA, what can I create in a HDB module? -HA100. Unit2.
- ACalculation View
- BAnalytic Privilege
- CHTML file
- DFlowgraph
64What is a role of the SAP HANA Cockpit? -HA100. Unit2.
- ATo provide KPIs to help focus on business performance
- BTo provide key system performance information for one or more HANA instances
- CTo provide an application developer collaboration hub
65What are advantages of column store tables? -HA100. Unit2.
- AData footprint is automatically reduced through compression
- BOnly the columns required are actually loaded to memory
- CColumns can be partitioned
- DThey are optimized for high-volume read/write transactional processing
66Row store tables are more efficient when there is a lot of repeating data values in columns. -HA100. Unit2.
- ATrue
- BFalse
67Why do we still need a persistent layer? -HA100. Unit2.
- ATo store data that has been unloaded from memory
- BTo hold the delta store for newly-arrived records
- CTo enable full database recovery if we have a power failure
- DTo store data that is frequently used
68What is a multistore table? -HA100. Unit2.
- AA table that can hold data in row and column orientation
- BA table that can distribute its partitions across memory and extended storage tiers
- CA table that can be shared across multiple instances of HANA
69Active/active-read enabled mode allows applications to redirect read-intense workloads to a secondary HANA?
-HA100. Unit2.- ATrue
- BFalse
70What is a multi-target application (MTA)? -HA100. Unit2.
- AAn application built with SAP HANA XS Classic (XS) that supports on-premise and
cloud deployments - BAn application built with SAP HANA XS Advanced (XSA) that supports on-premise
and cloud deployments
- AAn application built with SAP HANA XS Classic (XS) that supports on-premise and
71What are the two storage components used to restore the database in case of power failure? -HA100. Unit2.
- ALog area
- BData volume
- CMemory
- DDelta store
72What is the role of core modeling in SAP HANA? -HA100. Unit3.
- ATo push data-intensive processing up to the application to obtain the best performance
- BTo develop reuseable data processing logic in the database
- CTo simplify applications
73What are valid types of calculation view? -HA100. Unit3.
- ADimension
- BCube
- CCube with star schema
- DDimension with star schema
74If I need to create multiple, tabular output structures from an SQLscript, which HANA modeling object do I use?
-HA100. Unit3.- AProcedure
- BFunction
75What do we implement to restrict access to specific data rows of a calculation view? -HA100. Unit3.
- ASQL permission
- BAuthorisation object
- CAnalytic privilege
76Which SAP solution is used with SAP HANA Live? -HA100. Unit3.
- ASAP S/4HANA
- BSAP Business Suite
- CSAP Ariba
77Which of these is used to build the virtual data model for SAP S/4HANA? -HA100. Unit3.
- AABAP CDS
- BSAP HANA Live
- CUniverse
- DSAP HANA CDS
78What SAP HANA spatial type would you most likely use to represent the State of Colorado on a visual application?
-HA100. Unit3.- APolygon
- BLine
- CPoint
79In SAP HANA Text Analysis, why would you use the ‘Voice of Customer’ dictionary? -HA100. Unit3.
- ATo extract the sentiment from customer feedback on social media
- BTo extract common entities such as company, country, currencies, and so on, found in documents
- CTo identify close matches in words and expressions, to catch misspellings
80What must I create to develop a predictive model? -HA100. Unit3.
- ACalculation View
- BPredictive Analysis Library
- CFlowgraph
- DProcedure
81SAP HANA Graph Processing powers real-time, high-performance business charts and dashboards. -HA100. Unit3.
- ATrue
- BFalse
82In data temperature management, cool data is stored in HANA Extended Storage. -HA100. Unit4.
- ATrue
- BFalse
83What is SAP Enterprise Architecture Designer? -HA100. Unit4.
- AA tool to support sizing of an SAP HANA solution
- BA tool used to define a data loading job
- CA tool to support the build of a logical data model
- DA tool used to simulate a work load on different HANA hardware configurations
84What are typical characteristics of SAP HANA data replication? -HA100. Unit4.
- AVirtualization
- BDuplicate data
- CReal-time
- DStreaming
85SAP SLT can be used for real-time replication from SAP and non-SAP sources. -HA100. Unit4.
- ATrue
- BFalse
86What are components of SAP HANA EIM? -HA100. Unit4.
- ASDI
- BSDA
- CSDS
- DSDQ
87What are features of SDA? -HA100. Unit4.
- AAutomatic data type translation
- BData cleansing
- CEvaluation and execution of push-down possibilities to remote sources
- DMerging data from multiple sources
88Which of the following are correct statements relating to the flat file import function of SAP HANA Studio? -HA100. Unit4.
- AThe new table always has a 1:1 mapping between the file and table columns.
- BThe supported file types for upload are .csv, and .txt.
- CWhen loading new data in a table that already contains data, the new data is appended to the existing data.
- DRenaming of columns and changing data types is allowed when loading data to new HANA tables.
89What are the database query languages used by SAP HANA? -HA100. Unit5.
- AODBC
- BJDBC
- CMDX
- DSQL
- EABAP
90What are features of Business Suite on SAP HANA? -HA100. Unit5.
- AEmbedded Analytics for operational analytics
- BABAP is replaced with JAVA
- CCombine operational analytics and transaction processing
- DMassive performance improvement
91What are features of SAP S/4HANA? -HA100. Unit5.
- AOptimized for SAP HANA but maintains compatibility with other platforms
- BEmbedded Analytics
- CRewritten ABAP code optimized for SAP HANA
- DSAP HANA Live provides real time operational analytics
92To connect SAP Analysis Edition for Excel, you need to create a secure connection in SAP BusinessObjects Enterprise.
-HA100. Unit5.- ATrue
- BFalse
93Which of these does SAP HANA use to connect to BI tools? -HA100. Unit5.
- AIDOC
- BODBC
- CJDBC
- DODBO
94In which key areas can we expect there to be improvements when running SAP BW on SAP HANA? -HA100. Unit5.
- ATighter security
- BData loading performance
- CSuperior data quality
- DReporting performance
95In SAP BW, when we refer to mixed modeling, what do we mean? -HA100. Unit5.
- AIntegration of classic BW models such as InfoSets or InfoCubes with SAP HANA Calculation views
- BIntegration of SAP HANA optimized BW models such as ADSOs or OpenODS views with SAP HANA Calculation views
- CIntegration of models from BW on non-HANA databases combined with SAP HANA
optimized BW models
96Where will you find the Data Distribution Optimizer? -HA100. Unit5.
- ASAP HANA Studio
- BSAP BW/4HANA
- CSAP HANA Data Warehousing foundation
97Which interface client is used for XSA application development? -HA100. Unit5.
- ASAP HANA Web-based Workbench
- BSAP Web IDE for SAP HANA
- CSAP HANA Studio
- DSAP Web IDE
98Applications developed with XS must be migrated to XSA before they can run in SAP HANA 2.0. -HA100. Unit5.
- ATrue
- BFalse
99Eclipse is a proprietary tool developed by SAP. -BC404. Unit1.
- ATrue
- BFalse
100Which of the following statements best describes SAP’s approach to Eclipse? -BC404. Unit1.
- AThe Eclipse platform is an important part of SAP’s strategy for development tools
- BThe Eclipse IDE is an interesting but non-essential addition
- CABAP tools in Eclipse is just a proof of concept for the moment
101Development in ABAP Development Tools is performed using the same online development model used in the ABAP Workbench. -BC404. Unit1.
- ATrue
- BFalse
102When you work with ADT, you log onto the ABAP backend system and remain logged on for your entire session. -BC404. Unit1.
- ATrue
- BFalse
103Where can you set your preferences for working with ADT? -BC404. Unit1.
- AIn the project properties dialog box
- BUnder Window→ Preferences
- CIn both the project properties dialog box and under Window→ Preferences
104Which of the following are perspectives in ADT? -BC404. Unit1.
- AABAP
- BTransport Organizer
- CDebug
- DPackage
105ADT contains native Eclipse editors for which kinds of repository objects? -BC404. Unit2.
- AABAP programs
- BData elements
- CABAP classes
- DPackages
- EText elements
106Which 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.
- AShift + Enter
- BCtrl + Enter
- CAlt + Enter
- DCtrl + Shift + Enter
107Which of the following functions are available in both the ADT Debug perspective and the SAP GUI Debugger? -BC404. Unit2.
- ASetting breakpoints dynamically during debugging
- BMemory analysis
- CSource code editing in the debugger
- DDisplaying the contents of an internal table
108You are creating a function module in ADT. How can you define its interface without leaving the function module editor?
-BC404. Unit3- AUse the IMPORTING, EXPORTING, CHANGING, EXCEPTIONS, and RAISING additions in the FUNCTION statement
- BYou can’t - the interface must be edited using the Function Builder in the SAP GUI
109A Core Data Services View can only implement an inner join. -BC404. Unit4.
- ATrue
- BFalse
110You 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.
- AChoose the Code Wizard icon from the application toolbar
- BChoose F2 then choose the required action
- CChoose Ctrl + Space then choose the required action
111You 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.
- AAdd the implementation of the method
- BMove the method definition to the protected or private section
- CDelete the method
112In 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.
- ACtrl + F2
- BF3
- CCtrl + Shift + F5
- DF6
113Which keyboard shortcut displays the Open ABAP Development Object wizard? -BC404. Unit7.
- ACtrl + Shift + H
- BCtrl + H
- CCtrl + A
- DCtrl + Shift + A
114Feeds are updated automatically for both open and closed ABAP projects. -BC404. Unit7.
- ATrue
- BFalse
115Which symbol do ABAP Doc comments start with? -BC404. Unit7.
- A“&
- B*
- C“!
- D!”
116The ABAP Test Cockpit allows you to re-use check variants from which other analysis tool? -BC404. Unit8.
- AThe Code Inspector
- BThe Extended Program Check
- CThe ABAP Trace
117In ABAP Unit, the SETUP method is called before each individual test method. -BC404. Unit8.
- ATrue
- BFalse
118Which of the following statements about ABAP Unit tests are true? -BC404. Unit8.
- ATest classes are not generated in a production system
- BTest methods can access the private components of the class under test
- CThe class under test can access the methods of the test class
- DEach test method is executed independently of all of the others
119External 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.
- ATrue
- BFalse
120Which of the following SAP HANA objects can be assigned to a HANA Transport Container? -BC404. Unit9.
- APackages.
- BDelivery Units.
- CCalculation Views.
- DProcedures.
121Which of the following are types of calculation views? -HA300. Unit1.
- ACube
- BComposite
- CCube with star join
- DDimension
122A dimension can have attributes and measures. -HA300. Unit1.
- ATrue
- BFalse
123Which are true statements relating to calculation views of the type DEFAULT? -HA300. Unit1.
- AThey do not expose their meta data to reporting tools
- BThey are mainly used for reusing inside other calculation views
- CThey must include at least one measure
- DThey include a star join node
124Which are supported data source types for calculation view consumption? -HA300. Unit1.
- ACalculation views
- BFlat files
- CVirtual tables
- DColumn tables
- ERow tables
125What is a time-based dimension calculation view? -HA300. Unit1.
- AA view that is only accessible by users for a limited time
- BA view that stores the values of attributes across time
126What does SAP recommend you use to check your calculation view produces correct result? -HA300. Unit1.
- AExcel pivot tables
- BCustom SQL queries
- CData preview function in Web IDE
127What is the purpose of the projection node? -HA300. Unit2.
- ATo apply filters on the data
- BTo extract only the required columns from a data source
- CTo aggregate measures
- DTo join data sources
128Why do you use a referential join? -HA300. Unit2.
- ATo improve performance of joins that do not need to check integrity if no column from the right table is selected by a query.
- BWhen you need to display only facts that have associated master data attributes
- CWhen you want to display facts even when the associated master data attributes are missing.
129A 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.- ATrue
- BFalse
130Identify the type of join that ensures records are only selected if they fit a specified data range. -HA300. Unit2.
- ALeft Outer Join
- BRight Outer Join
- CTemporal Join
- DFull Outer Join
131In 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.- ATrue
- BFalse
132I 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.
- AIntersect
- BMinus
- CUnion
133In an aggregation node, a calculated column is always computed before the aggregate function. -HA300. Unit2.
- ATrue
- BFalse
134Which flags are relevant to the control of the aggregation behavior? -HA300. Unit2.
- AKeep Flag
- BTransparent filter
- CDynamic join
135In a star join node, what do you join to the central entity (fact table)? -HA300. Unit2.
- ACube calculation views
- BColumn tables
- CDimensions calculation views
136In a rank node, you can choose whether to assign the generated rank column as an attribute or a measure. -HA300. Unit2.
- ATrue
- BFalse
137A restricted columns provide a subset of the original column filtered by attribute values. -HA300. Unit3.
- ATrue
- BFalse
138When is the design time filter expression applied in a calculation view? -HA300. Unit3.
- ABefore a query on the calculation view begin to execute
- BOn the final result of a query, similar to a ‘where’ clause
- CBefore any joins are executed within the calculation view
139When 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.
- ATrue
- BFalse
140Identify the object that adds a WHERE clause to the query. -HA300. Unit3.
- AModeler
- BAttributes
- CInput parameter
- DVariable
141In a calculated column which do you use as a placeholder for a dynamic value in an expression? -HA300. Unit3.
- AVariable
- BInput parameter
142What are the features of a parent-child hierarchy? -HA300. Unit3.
- AA parent can be formed by combining attributes.
- BParent and child columns have the same data type.
- CRecursive data structure defines the hierarchy.
- DThe hierarchy always generates two levels.
143A hierarchy navigation function must be preceded by a hierarchy generator function inside a calculation view. -HA300. Unit3.
- ATrue
- BFalse
144While converting currencies, in addition to source and target currencies, which value is also needed? -HA300. Unit3.
- ATime
- BCountry
- CVAT rate
145When might you use SAP HANA Studio? -HA300. Unit4.
- ATo migrate deprecated object types to the supported types
- BTo access the latest features of calculation view modeling
- CTo maintain attribute and analytic views
- DTo work with a tool you are familiar with when modeling XSA based development objects
146Why is knowledge of SQL important to an SAP HANA modeler? -HA300. Unit5.
- ASo that they can avoid creating calculation views and use SQL
- BSo that they can understand how to implement a function or procedure
- CSo that they can extend the capabilities of a calculation view using SQL
expressions
147You 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.
- AWhen writing SQL against a database connection of the type HDI Container
- BWhen writing SQL against a database connection of the type SAP HANA Database.
148What types of user defined function can you include in a calculation view? -HA300. Unit5.
- ATable
- BColumn
- CScalar
149When would you use an SQL function? -HA300. Unit5.
- AAs a replacement for a graphical calculation view when you need more flexibility
- BWhen you need to write results back to a table
- CWhen you need to define custom data processing logic that the graphical
calculation view cannot provide
150How should you create a procedure? -HA300. Unit5.
- AWrite your code in a source file in the SAP Web IDE with the
extension .hdbprocedure - BUse the CREATE PROCEDURE statement in SQL Console
- AWrite your code in a source file in the SAP Web IDE with the
151Procedures can be used in the FROM clause of a SELECT statement. -HA300. Unit5.
- ATrue
- BFalse
152Why should I define my SAP HANA tables using CDS and not SQL ‘Create table’ syntax? -HA300. Unit6.
- AThe syntax is much simpler than the standard SQL Create Table expression.
- BA table that is created with CDS performs better than one created with the
standard SQL ‘Create Table’ expression. - CThe table definition is easily transported as part of the overall application to ensure
all artifacts are kept together.
153The relational model of SAP HANA Live is built using which type of views? -HA300. Unit7.
- ACalculation views of data category cube without star join
- BCalculation views of data category cube with star join
- CCalculation views of data category ‘blank’
- DCalculation views of data category dimension
154Why is an integrated deployment approach preferred over the side-car approach to SAP HANA Live? -HA300. Unit7.
- AIt provides a quick start to use SAP HANA Live for customers using SAP Business Suite on non-SAP HANA databases.
- BThere is no requirement to copy data from SAP Business Suite to SAP HANA.
- CIt offers a simplified landscape where SAP Business Suite and SAP HANA Live share the same in-memory tables.
155Which version of CDS is used by SAP S/4HANA embedded analytics? -HA300. Unit7.
- AABAP CDS
- BSAP HANA CDS
156What are two reasons why SAP recommends developing data models using calculation views versus CDS? -HA300. Unit7.
- AMore use cases are available with calculation views than CDS
- BNot all features and settings relevant to BI are available with CDS.
- CMore optimization possibilities are available with calculation views
- DCalculation views can define the persistence layer as well as data modeling layer
157To work with calculation view debug query, you first need to build the calculation view? -HA300. Unit8.
- ATrue
- BFalse
158What is the purpose of the SQL Analyzer? -HA300. Unit8.
- ATo identify the longest running SQL statements.
- BTo investigate the generated SQL for each node in my calculation view.
- CTo highlight syntax errors in my SQL code.
159Where possible, in your SQL code, always use calculation engine (CE) functions to ensure best performance. -HA300. Unit8.
- ATrue
- BFalse
160Where do I define a pruning configuration table? -HA300. Unit8.
- AJoin nodes.
- BUnion nodes.
- CProjection nodes.
161Which of the following tools is used to analyze dependencies between models? -HA300. Unit9.
- AData lineage
- BColumn lineage
- CImpact analysis
162Which of the following development layers of an XS Advanced application are provided by an HDB module? -HA300. Unit9.
- APersistence layer
- BUser interface
- CBusiness logic
- DData modeling
163An XS Advanced project can contain multiple HDB modules. -HA300. Unit9.
- ATrue
- BFalse
164The database objects defined in design-time files located in the same project folder can have different namespaces.
-HA300. Unit9.- ATrue
- BFalse
165A HDB module always corresponds to a database schema. -HA300. Unit9.
- ATrue
- BFalse
166You 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.
- AThe project is not assigned to a Space.
- BBuilding a project does not generate the database objects defined in its HDB modules.
- CYou do not have the Developer role in the assigned Space.
167A 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.
- ATrue
- BFalse
168Which database artifact do you use to access external data from an XS Advanced project? -HA300. Unit9.
- ACalculation view
- BSynonym
- CLogical schema
- DUser-provided service
169The 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.
- ATrue
- BFalse
170Which phase of a project does SAP Enterprise Architecture Designer support? -HA300. Unit9.
- ADevelopment
- BDesign
- CPlanning
- DRunning
171SAP Enterprise Architecture Designer can be used as an alternative to develop calculation views in SAP Web IDE.
-HA300. Unit9.- ATrue
- BFalse
172What is a dynamic analytic privilege? -HA300. Unit10.
- AA reusable analytic privilege that can be used for several users who need to access
different data. - BAn analytic privilege that takes its filter values from variables defined in the calculation view
- CA temporary analytic privilege that has a defined time validity set for its use
- AA reusable analytic privilege that can be used for several users who need to access
173What is data masking? -HA300. Unit10.
- AObscuring column values by hiding some or all characters with replacement characters
- BReplacing column values with a higher level group such as replacing a person id with team name
- CRemoving complete rows of data that should not be seen by users
174Why do you implement data anonymization? -HA300. Unit10.
- ATo hide sensitive data using alternative characters such as ‘XXXXX’.
- BTo hide sensitive data by adding noise at the record level so that aggregated values
still make sense but individual records are not exposed. - CTo remove complete records so that they cannot be seen by unauthorized users
Information
- Description
- E_HANAAW_14 - SAP Certified Development Specialist - ABAP for SAP HANA 2.0
- Author
- ERNESTO L MARQUEZ F
- Language
- Español
- Views
- 5,545
- Tags
- Rating
- No ratings yet Rate this quiz