17752420
Descripción
Test por ERNESTO L MARQUEZ F, actualizado hace más de 1 año
|
|
Creado por ERNESTO L MARQUEZ F
hace más de 5 años
|
|
Pregunta 1
Pregunta
Which of the following SAP HANA-Based scenarios involve ABAP Applications? - HA400 - Unit 1/Less_1. Pg. 5,6.
Respuesta
-
Data Smart Based on SAP HANA.
-
AS ABAP with SAP HANA as primary database.
-
Native SAP HANA Applications.
-
SAP HANA as Business Acelerators.
Pregunta 2
Pregunta
On SAP HANA, tables are stored in row store by default. - HA400 - Unit 1.
Respuesta
- True
- False
Pregunta 3
Pregunta
Which of the following entries are required when creating a system in the SAP HANA Studio?.- HA400 - Unit 1/Less_2. Pg. 14,15.
Respuesta
-
Host Name
-
Instance Number
-
Cliente ID
-
User Name
-
Logon Language
Pregunta 4
Pregunta
Which of the followin entities can be found under node Catalog and not under node Content?- HA400 - Unit 1/Less_1. Pg. 15,16.
Respuesta
-
Package
-
Schema
-
Table
-
Calculation View
Pregunta 5
Pregunta
It is not posible to create secondary index on SAP HANA. - HA400 - Unit 1/Less_3. Pg. 21,24.
Respuesta
- True
- False
Pregunta 6
Pregunta
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.
Respuesta
-
External Views
-
CDS Views
-
Database Procedure Proxy
-
ABAP-Manage Database Procedure
Pregunta 7
Pregunta
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.
Respuesta
- True
- False
Pregunta 8
Pregunta
Which of the following are potential issues when migrating ABAP code to SAP HANA?. - HA400 - Unit 2/Less_2. Pg. 49,50.
Respuesta
-
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.
Pregunta 9
Pregunta
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.
Respuesta
-
In a Code Inspector object list.
-
In a Code Inspector object check variant.
-
In a Code Inspector inspection.
Pregunta 10
Pregunta
When migrating to SAP HANA, every SELECT statement immediately become faster. - HA400 - Unit 2/Less_3. Pg. 54.
Respuesta
- True
- False
Pregunta 11
Pregunta
Because SAP HANA stores all data in memory, buffering of data on the application server becomes less important. UNIT 2.
Respuesta
- True
- False
Pregunta 12
Pregunta
Which of the following patterns are known to potentially cause performance issues when accessing SAP HANA database? - Unit 2/Less_5. Pg. 67.
Respuesta
-
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.
Pregunta 13
Pregunta
Which of the following are steps in the recommended sequence for a guide performance analysis? -Unit 2/Less_4. Pg. 60,61.
Respuesta
-
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.
Pregunta 14
Pregunta
Which part of a guided performance analysis is done with th SQL Monitor tool? -Unit 2/Less_4. Pg. 62.
Respuesta
-
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.
Pregunta 15
Pregunta
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.
Respuesta
- True
- False
Pregunta 16
Pregunta
Wich of the SQL performance rules become more important with SAP HANA? -Unit 2/Less_5. Pg. 66,67.
Respuesta
-
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.
Pregunta 17
Pregunta
Which of the SQL performance rules become less important with SAP HANA? -Unit 2/Less_5. Pg. 67.
Respuesta
-
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.
Pregunta 18
Pregunta
Which of the following are task of the database interface (DBI) and the Database Specific Library (DBSL)?. - HA400 UNIT3. Less_1. Pg.77,78.
Respuesta
-
Translate Open SQL syntax into Native Sql Syntax.
-
Add client handling to the statement.
-
Check User Authorizations
-
Handle SAP table buffering
-
Transaction handling
Pregunta 19
Pregunta
New Open SQL Syntax is mandatory as of SAP Netweaver AS ABAP 7.40 SP05. - HA400 UNIT3. Less_1. Pg.81,82.
Respuesta
- True
- False
Pregunta 20
Pregunta
The Open SQL Syntax is a prerequisite for the new Open SQL features. - HA400 UNIT3. Less_1. Pg.81,82.
Respuesta
- True
- False
Pregunta 21
Pregunta
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.
Respuesta
- True
- False
Pregunta 22
Pregunta
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.
Respuesta
-
Data definition (aka DDL source)
-
CDS view
-
SQL view
Pregunta 23
Pregunta
Which of the following entities corresponds to an object that is created on the database?- HA400 UNIT3. Less_3. Pg.87,88.
Respuesta
-
Data Definition ( aka DDL source ).
-
CDS view.
-
SQL View.
Pregunta 24
Pregunta
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.
Respuesta
- True
- False
Pregunta 25
Pregunta
ASSOCIATION TO is just another way of saying LEFT OUTER JOIN TO. - HA400 UNIT3. Less_3.
Respuesta
- True
- False
Pregunta 26
Pregunta
Which of the following are prerequisites for exposing an association? - HA400 UNIT3. Less_3.
Respuesta
-
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.
Pregunta 27
Pregunta
Where can you evaluate an exposed Association? - HA400 UNIT3. Less_3.
Respuesta
-
In the Data Preview of ADT.
-
In the Data Browser ( transaction SE16 ).
-
In another CDS view
-
In an Open SQL SELECT statement
Pregunta 28
Pregunta
CDS views that define associations cannot be extended. - HA400 UNIT3. Less_3.
Respuesta
- True
- False
Pregunta 29
Pregunta
An import parameter that is annotated with @Enviroment.systemField: becomes optional in the following places: - HA400 UNIT3. Less_3.
Respuesta
-
In Data preview in ADT.
-
In the Data Browser ( SE16 ).
-
In ABAP Open SQL.
-
In the definition of another CDS view.
Pregunta 30
Pregunta
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.
Respuesta
-
In Data preview in ADT.
-
In the Data Browser ( SE16 ).
-
In ABAP Open SQL.
-
In the definition of another CDS view.
Pregunta 31
Pregunta
Which of the following are common ground between SAP HANA syntax and Open SQL
syntax (as of ABAP 7.40 SP05)? -HA400. Unit4
Respuesta
-
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.
Pregunta 32
Pregunta
In SAP HANA SQL, it is mandatory to specify a schema before the table name. -HA400. Unit4
Respuesta
- True
- False
Pregunta 33
Pregunta
Which of the following are supported types for parameters of AMDP methods?. -HA400. Unit4
Respuesta
-
Numeric or character-like scalar types.
-
Structure types with only scalar components.
-
Table types with only scalar columns.
-
Nested table types without secondary keys.
Pregunta 34
Pregunta
All ABAP objects used within the body of an AMDP method have to be listed after the
USING addition. -HA400. Unit4
Respuesta
- True
- False
Pregunta 35
Pregunta
Any AMDP method shipped by SAP can be extended using the AMDP BAdI technique. -HA400. Unit4
Respuesta
- True
- False
Pregunta 36
Pregunta
What can you do in ADT (ABAP in Eclipse) but not in the classical ABAP Workbench?. -HA400. Unit4
Respuesta
-
Display an AMDP method implementation.
-
Edit an AMDP method implementation.
-
Test an AMDP method implementation.
-
Debug an AMDP method implementation.
Pregunta 37
Pregunta
When executing a native SQL query via ABAP Database Connectivity (ADBC), which of the
following steps is optional? -HA400. Unit4
Respuesta
-
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.
Pregunta 38
Pregunta
What happens if you forget to call method close( ) at the end of your query?. -HA400. Unit4
Respuesta
-
You don’t forget a result.
-
An exception is raised.
-
DB resources remain blocked.
-
Nothing.
Pregunta 39
Pregunta
The search function in the toolbar of SAP HANA studio searches in SAP HANA content
and in the SAP HANA catalog. -HA400. Unit5
Respuesta
- True
- False
Pregunta 40
Pregunta
You can use Data Preview in SAP HANA studio to test SAP HANA views and SAP HANA
stored procedures. -HA400. Unit5
Respuesta
- True
- False
Pregunta 41
Pregunta
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
Respuesta
-
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”
Pregunta 42
Pregunta
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
Respuesta
-
Two table-like results.
-
Two scalar results.
-
One scalar result.
-
One table-like result.
Pregunta 43
Pregunta
Which of the following object types in ABAP repository are proxy objects for SAP HANA
artefacts?. -HA400. Unit5
Respuesta
-
Procedure Proxy.
-
Database View.
-
SQL View.
-
External View.
Pregunta 44
Pregunta
Which of the following are advantages of using proxy objects for SAP HANA artefacts?. -HA400. Unit5
Respuesta
-
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.
Pregunta 45
Pregunta
When creating a proxy object for an SAP HANA view, it is possible to specify data
elements for the view fields. -HA400. Unit5
Respuesta
- True
- False
Pregunta 46
Pregunta
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
Respuesta
- True
- False
Pregunta 47
Pregunta
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
Respuesta
-
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.
Pregunta 48
Pregunta
Proposal search (= type ahead search) is supported on all database systems. -HA400. Unit6
Respuesta
- True
- False
Pregunta 49
Pregunta
ABAP List Viewer with Integrated Data Access (ALV with IDA) is only supported for SAP
HANA database. -HA400. Unit6
Respuesta
- True
- False
Pregunta 50
Pregunta
Which of the following ABAP repository objects can be the data source for ALV with IDA? -HA400. Unit6
Respuesta
-
Transparent table
-
Database view
-
CDS view
-
External view
Pregunta 51
Pregunta
Which of the following features are NOT supported by ALV with IDA? -HA400. Unit6
Respuesta
-
Personalization
-
Editing values
-
Excel export
-
Double-click
Pregunta 52
Pregunta
Which recent trends have triggered the need for a next generation data processing platform? -HA100. Unit1.
Respuesta
-
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
Pregunta 53
Pregunta
Which recent technology innovations have triggered the opportunity to build a next generation data processing platform?
-HA100. Unit1.
Respuesta
-
Faster disk access.
-
Multi-core processing.
-
Larger memory availability.
Pregunta 54
Pregunta
What are the key features of SAP HANA? -HA100. Unit1.
Respuesta
-
In-memory database
-
Automatic compression of data
-
Removes the need for cache
-
Combined OLTP and OLAP processing on one platform
Pregunta 55
Pregunta
Which are true statements? -HA100. Unit1.
Respuesta
-
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.
Pregunta 56
Pregunta
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.
Respuesta
- True
- False
Pregunta 57
Pregunta
Where is SDI used? -HA100. Unit2.
Respuesta
-
Data cleansing
-
Data transformation
-
Data streaming
-
For data loading
Pregunta 58
Pregunta
How many processing tiers do you usually find in a native SAP HANA application stack? -HA100. Unit2.
Respuesta
-
1
-
2
-
3
Pregunta 59
Pregunta
What is XS? -HA100. Unit2.
Respuesta
-
A native, lightweight application server
-
An optional engine to handle excessive data loads
-
A data cleansing engine
-
A user interface
Pregunta 60
Pregunta
Why did SAP move from XS to XSA? -HA100. Unit2.
Respuesta
-
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
Pregunta 61
Pregunta
What are the two views in the Web IDE for SAP HANA? -HA100. Unit2.
Respuesta
-
Database Explorer
-
Development
-
Catalog
Pregunta 62
Pregunta
In SAP HANA Studio, what would you find in a Package? -HA100. Unit2.
Respuesta
-
Calculation Views
-
Analytic Privileges
-
Procedures
-
Tables
Pregunta 63
Pregunta
In Web IDE for SAP HANA, what can I create in a HDB module? -HA100. Unit2.
Respuesta
-
Calculation View
-
Analytic Privilege
-
HTML file
-
Flowgraph
Pregunta 64
Pregunta
What is a role of the SAP HANA Cockpit? -HA100. Unit2.
Respuesta
-
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
Pregunta 65
Pregunta
What are advantages of column store tables? -HA100. Unit2.
Respuesta
-
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
Pregunta 66
Pregunta
Row store tables are more efficient when there is a lot of repeating data values in columns. -HA100. Unit2.
Respuesta
- True
- False
Pregunta 67
Pregunta
Why do we still need a persistent layer? -HA100. Unit2.
Respuesta
-
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
Pregunta 68
Pregunta
What is a multistore table? -HA100. Unit2.
Respuesta
-
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
Pregunta 69
Pregunta
Active/active-read enabled mode allows applications to redirect read-intense workloads to a secondary HANA?
-HA100. Unit2.
Respuesta
- True
- False
Pregunta 70
Pregunta
What is a multi-target application (MTA)? -HA100. Unit2.
Respuesta
-
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
Pregunta 71
Pregunta
What are the two storage components used to restore the database in case of power failure? -HA100. Unit2.
Respuesta
-
Log area
-
Data volume
-
Memory
-
Delta store
Pregunta 72
Pregunta
What is the role of core modeling in SAP HANA? -HA100. Unit3.
Respuesta
-
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
Pregunta 73
Pregunta
What are valid types of calculation view? -HA100. Unit3.
Respuesta
-
Dimension
-
Cube
-
Cube with star schema
-
Dimension with star schema
Pregunta 74
Pregunta
If I need to create multiple, tabular output structures from an SQLscript, which HANA modeling object do I use?
-HA100. Unit3.
Respuesta
-
Procedure
-
Function
Pregunta 75
Pregunta
What do we implement to restrict access to specific data rows of a calculation view? -HA100. Unit3.
Respuesta
-
SQL permission
-
Authorisation object
-
Analytic privilege
Pregunta 76
Pregunta
Which SAP solution is used with SAP HANA Live? -HA100. Unit3.
Respuesta
-
SAP S/4HANA
-
SAP Business Suite
-
SAP Ariba
Pregunta 77
Pregunta
Which of these is used to build the virtual data model for SAP S/4HANA? -HA100. Unit3.
Respuesta
-
ABAP CDS
-
SAP HANA Live
-
Universe
-
SAP HANA CDS
Pregunta 78
Pregunta
What SAP HANA spatial type would you most likely use to represent the State of Colorado on a visual application?
-HA100. Unit3.
Respuesta
-
Polygon
-
Line
-
Point
Pregunta 79
Pregunta
In SAP HANA Text Analysis, why would you use the ‘Voice of Customer’ dictionary? -HA100. Unit3.
Respuesta
-
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
Pregunta 80
Pregunta
What must I create to develop a predictive model? -HA100. Unit3.
Respuesta
-
Calculation View
-
Predictive Analysis Library
-
Flowgraph
-
Procedure
Pregunta 81
Pregunta
SAP HANA Graph Processing powers real-time, high-performance business charts and dashboards. -HA100. Unit3.
Respuesta
- True
- False
Pregunta 82
Pregunta
In data temperature management, cool data is stored in HANA Extended Storage. -HA100. Unit4.
Respuesta
- True
- False
Pregunta 83
Pregunta
What is SAP Enterprise Architecture Designer? -HA100. Unit4.
Respuesta
-
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
Pregunta 84
Pregunta
What are typical characteristics of SAP HANA data replication? -HA100. Unit4.
Respuesta
-
Virtualization
-
Duplicate data
-
Real-time
-
Streaming
Pregunta 85
Pregunta
SAP SLT can be used for real-time replication from SAP and non-SAP sources. -HA100. Unit4.
Respuesta
- True
- False
Pregunta 86
Pregunta
What are components of SAP HANA EIM? -HA100. Unit4.
Respuesta
-
SDI
-
SDA
-
SDS
-
SDQ
Pregunta 87
Pregunta
What are features of SDA? -HA100. Unit4.
Respuesta
-
Automatic data type translation
-
Data cleansing
-
Evaluation and execution of push-down possibilities to remote sources
-
Merging data from multiple sources
Pregunta 88
Pregunta
Which of the following are correct statements relating to the flat file import function of SAP HANA Studio? -HA100. Unit4.
Respuesta
-
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.
Pregunta 89
Pregunta
What are the database query languages used by SAP HANA? -HA100. Unit5.
Respuesta
-
ODBC
-
JDBC
-
MDX
-
SQL
-
ABAP
Pregunta 90
Pregunta
What are features of Business Suite on SAP HANA? -HA100. Unit5.
Respuesta
-
Embedded Analytics for operational analytics
-
ABAP is replaced with JAVA
-
Combine operational analytics and transaction processing
-
Massive performance improvement
Pregunta 91
Pregunta
What are features of SAP S/4HANA? -HA100. Unit5.
Respuesta
-
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
Pregunta 92
Pregunta
To connect SAP Analysis Edition for Excel, you need to create a secure connection in SAP BusinessObjects Enterprise.
-HA100. Unit5.
Respuesta
- True
- False
Pregunta 93
Pregunta
Which of these does SAP HANA use to connect to BI tools? -HA100. Unit5.
Respuesta
-
IDOC
-
ODBC
-
JDBC
-
ODBO
Pregunta 94
Pregunta
In which key areas can we expect there to be improvements when running SAP BW on SAP HANA? -HA100. Unit5.
Respuesta
-
Tighter security
-
Data loading performance
-
Superior data quality
-
Reporting performance
Pregunta 95
Pregunta
In SAP BW, when we refer to mixed modeling, what do we mean? -HA100. Unit5.
Respuesta
-
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
Pregunta 96
Pregunta
Where will you find the Data Distribution Optimizer? -HA100. Unit5.
Respuesta
-
SAP HANA Studio
-
SAP BW/4HANA
-
SAP HANA Data Warehousing foundation
Pregunta 97
Pregunta
Which interface client is used for XSA application development? -HA100. Unit5.
Respuesta
-
SAP HANA Web-based Workbench
-
SAP Web IDE for SAP HANA
-
SAP HANA Studio
-
SAP Web IDE
Pregunta 98
Pregunta
Applications developed with XS must be migrated to XSA before they can run in SAP HANA 2.0. -HA100. Unit5.
Respuesta
- True
- False
Pregunta 99
Pregunta
Eclipse is a proprietary tool developed by SAP. -BC404. Unit1.
Respuesta
- True
- False
Pregunta 100
Pregunta
Which of the following statements best describes SAP’s approach to Eclipse? -BC404. Unit1.
Respuesta
-
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
Pregunta 101
Pregunta
Development in ABAP Development Tools is performed using the same online development model used in the ABAP Workbench. -BC404. Unit1.
Respuesta
- True
- False
Pregunta 102
Pregunta
When you work with ADT, you log onto the ABAP backend system and remain logged on for your entire session. -BC404. Unit1.
Respuesta
- True
- False
Pregunta 103
Pregunta
Where can you set your preferences for working with ADT? -BC404. Unit1.
Respuesta
-
In the project properties dialog box
-
Under Window→ Preferences
-
In both the project properties dialog box and under Window→ Preferences
Pregunta 104
Pregunta
Which of the following are perspectives in ADT? -BC404. Unit1.
Respuesta
-
ABAP
-
Transport Organizer
-
Debug
-
Package
Pregunta 105
Pregunta
ADT contains native Eclipse editors for which kinds of repository objects? -BC404. Unit2.
Respuesta
-
ABAP programs
-
Data elements
-
ABAP classes
-
Packages
-
Text elements
Pregunta 106
Pregunta
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.
Respuesta
-
Shift + Enter
-
Ctrl + Enter
-
Alt + Enter
-
Ctrl + Shift + Enter
Pregunta 107
Pregunta
Which of the following functions are available in both the ADT Debug perspective and the SAP GUI Debugger? -BC404. Unit2.
Respuesta
-
Setting breakpoints dynamically during debugging
-
Memory analysis
-
Source code editing in the debugger
-
Displaying the contents of an internal table
Pregunta 108
Pregunta
You are creating a function module in ADT. How can you define its interface without leaving the function module editor?
-BC404. Unit3
Respuesta
-
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
Pregunta 109
Pregunta
A Core Data Services View can only implement an inner join. -BC404. Unit4.
Respuesta
- True
- False
Pregunta 110
Pregunta
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.
Respuesta
-
Choose the Code Wizard icon from the application toolbar
-
Choose F2 then choose the required action
-
Choose Ctrl + Space then choose the required action
Pregunta 111
Pregunta
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.
Respuesta
-
Add the implementation of the method
-
Move the method definition to the protected or private section
-
Delete the method
Pregunta 112
Pregunta
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.
Respuesta
-
Ctrl + F2
-
F3
-
Ctrl + Shift + F5
-
F6
Pregunta 113
Pregunta
Which keyboard shortcut displays the Open ABAP Development Object wizard? -BC404. Unit7.
Respuesta
-
Ctrl + Shift + H
-
Ctrl + H
-
Ctrl + A
-
Ctrl + Shift + A
Pregunta 114
Pregunta
Feeds are updated automatically for both open and closed ABAP projects. -BC404. Unit7.
Respuesta
- True
- False
Pregunta 115
Pregunta
Which symbol do ABAP Doc comments start with? -BC404. Unit7.
Respuesta
-
“&
-
*
-
“!
-
!”
Pregunta 116
Pregunta
The ABAP Test Cockpit allows you to re-use check variants from which other analysis tool? -BC404. Unit8.
Respuesta
-
The Code Inspector
-
The Extended Program Check
-
The ABAP Trace
Pregunta 117
Pregunta
In ABAP Unit, the SETUP method is called before each individual test method. -BC404. Unit8.
Respuesta
- True
- False
Pregunta 118
Pregunta
Which of the following statements about ABAP Unit tests are true? -BC404. Unit8.
Respuesta
-
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
Pregunta 119
Pregunta
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.
Respuesta
- True
- False
Pregunta 120
Pregunta
Which of the following SAP HANA objects can be assigned to a HANA Transport Container? -BC404. Unit9.
Respuesta
-
Packages.
-
Delivery Units.
-
Calculation Views.
-
Procedures.
Pregunta 121
Pregunta
Which of the following are types of calculation views? -HA300. Unit1.
Respuesta
-
Cube
-
Composite
-
Cube with star join
-
Dimension
Pregunta 122
Pregunta
A dimension can have attributes and measures. -HA300. Unit1.
Respuesta
- True
- False
Pregunta 123
Pregunta
Which are true statements relating to calculation views of the type DEFAULT? -HA300. Unit1.
Respuesta
-
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
Pregunta 124
Pregunta
Which are supported data source types for calculation view consumption? -HA300. Unit1.
Respuesta
-
Calculation views
-
Flat files
-
Virtual tables
-
Column tables
-
Row tables
Pregunta 125
Pregunta
What is a time-based dimension calculation view? -HA300. Unit1.
Respuesta
-
A view that is only accessible by users for a limited time
-
A view that stores the values of attributes across time
Pregunta 126
Pregunta
What does SAP recommend you use to check your calculation view produces correct result? -HA300. Unit1.
Respuesta
-
Excel pivot tables
-
Custom SQL queries
-
Data preview function in Web IDE
Pregunta 127
Pregunta
What is the purpose of the projection node? -HA300. Unit2.
Respuesta
-
To apply filters on the data
-
To extract only the required columns from a data source
-
To aggregate measures
-
To join data sources
Pregunta 128
Pregunta
Why do you use a referential join? -HA300. Unit2.
Respuesta
-
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.
Pregunta 129
Pregunta
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.
Respuesta
- True
- False
Pregunta 130
Pregunta
Identify the type of join that ensures records are only selected if they fit a specified data range. -HA300. Unit2.
Respuesta
-
Left Outer Join
-
Right Outer Join
-
Temporal Join
-
Full Outer Join
Pregunta 131
Pregunta
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.
Respuesta
- True
- False
Pregunta 132
Pregunta
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.
Respuesta
-
Intersect
-
Minus
-
Union
Pregunta 133
Pregunta
In an aggregation node, a calculated column is always computed before the aggregate function. -HA300. Unit2.
Respuesta
- True
- False
Pregunta 134
Pregunta
Which flags are relevant to the control of the aggregation behavior? -HA300. Unit2.
Respuesta
-
Keep Flag
-
Transparent filter
-
Dynamic join
Pregunta 135
Pregunta
In a star join node, what do you join to the central entity (fact table)? -HA300. Unit2.
Respuesta
-
Cube calculation views
-
Column tables
-
Dimensions calculation views
Pregunta 136
Pregunta
In a rank node, you can choose whether to assign the generated rank column as an attribute or a measure. -HA300. Unit2.
Respuesta
- True
- False
Pregunta 137
Pregunta
A restricted columns provide a subset of the original column filtered by attribute values. -HA300. Unit3.
Respuesta
- True
- False
Pregunta 138
Pregunta
When is the design time filter expression applied in a calculation view? -HA300. Unit3.
Respuesta
-
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
Pregunta 139
Pregunta
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.
Respuesta
- True
- False
Pregunta 140
Pregunta
Identify the object that adds a WHERE clause to the query. -HA300. Unit3.
Respuesta
-
Modeler
-
Attributes
-
Input parameter
-
Variable
Pregunta 141
Pregunta
In a calculated column which do you use as a placeholder for a dynamic value in an expression? -HA300. Unit3.
Respuesta
-
Variable
-
Input parameter
Pregunta 142
Pregunta
What are the features of a parent-child hierarchy? -HA300. Unit3.
Respuesta
-
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.
Pregunta 143
Pregunta
A hierarchy navigation function must be preceded by a hierarchy generator function inside a calculation view. -HA300. Unit3.
Respuesta
- True
- False
Pregunta 144
Pregunta
While converting currencies, in addition to source and target currencies, which value is also needed? -HA300. Unit3.
Respuesta
-
Time
-
Country
-
VAT rate
Pregunta 145
Pregunta
When might you use SAP HANA Studio? -HA300. Unit4.
Respuesta
-
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
Pregunta 146
Pregunta
Why is knowledge of SQL important to an SAP HANA modeler? -HA300. Unit5.
Respuesta
-
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
Pregunta 147
Pregunta
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.
Respuesta
-
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.
Pregunta 148
Pregunta
What types of user defined function can you include in a calculation view? -HA300. Unit5.
Respuesta
-
Table
-
Column
-
Scalar
Pregunta 149
Pregunta
When would you use an SQL function? -HA300. Unit5.
Respuesta
-
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
Pregunta 150
Pregunta
How should you create a procedure? -HA300. Unit5.
Respuesta
-
Write your code in a source file in the SAP Web IDE with the extension .hdbprocedure
-
Use the CREATE PROCEDURE statement in SQL Console
Pregunta 151
Pregunta
Procedures can be used in the FROM clause of a SELECT statement. -HA300. Unit5.
Respuesta
- True
- False
Pregunta 152
Pregunta
Why should I define my SAP HANA tables using CDS and not SQL ‘Create table’ syntax? -HA300. Unit6.
Respuesta
-
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.
Pregunta 153
Pregunta
The relational model of SAP HANA Live is built using which type of views? -HA300. Unit7.
Respuesta
-
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
Pregunta 154
Pregunta
Why is an integrated deployment approach preferred over the side-car approach to SAP HANA Live? -HA300. Unit7.
Respuesta
-
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.
Pregunta 155
Pregunta
Which version of CDS is used by SAP S/4HANA embedded analytics? -HA300. Unit7.
Respuesta
-
ABAP CDS
-
SAP HANA CDS
Pregunta 156
Pregunta
What are two reasons why SAP recommends developing data models using calculation views versus CDS? -HA300. Unit7.
Respuesta
-
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
Pregunta 157
Pregunta
To work with calculation view debug query, you first need to build the calculation view? -HA300. Unit8.
Respuesta
- True
- False
Pregunta 158
Pregunta
What is the purpose of the SQL Analyzer? -HA300. Unit8.
Respuesta
-
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.
Pregunta 159
Pregunta
Where possible, in your SQL code, always use calculation engine (CE) functions to ensure best performance. -HA300. Unit8.
Respuesta
- True
- False
Pregunta 160
Pregunta
Where do I define a pruning configuration table? -HA300. Unit8.
Respuesta
-
Join nodes.
-
Union nodes.
-
Projection nodes.
Pregunta 161
Pregunta
Which of the following tools is used to analyze dependencies between models? -HA300. Unit9.
Respuesta
-
Data lineage
-
Column lineage
-
Impact analysis
Pregunta 162
Pregunta
Which of the following development layers of an XS Advanced application are provided by an HDB module? -HA300. Unit9.
Respuesta
-
Persistence layer
-
User interface
-
Business logic
-
Data modeling
Pregunta 163
Pregunta
An XS Advanced project can contain multiple HDB modules. -HA300. Unit9.
Respuesta
- True
- False
Pregunta 164
Pregunta
The database objects defined in design-time files located in the same project folder can have different namespaces.
-HA300. Unit9.
Respuesta
- True
- False
Pregunta 165
Pregunta
A HDB module always corresponds to a database schema. -HA300. Unit9.
Respuesta
- True
- False
Pregunta 166
Pregunta
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.
Respuesta
-
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.
Pregunta 167
Pregunta
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.
Respuesta
- True
- False
Pregunta 168
Pregunta
Which database artifact do you use to access external data from an XS Advanced project? -HA300. Unit9.
Respuesta
-
Calculation view
-
Synonym
-
Logical schema
-
User-provided service
Pregunta 169
Pregunta
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.
Respuesta
- True
- False
Pregunta 170
Pregunta
Which phase of a project does SAP Enterprise Architecture Designer support? -HA300. Unit9.
Respuesta
-
Development
-
Design
-
Planning
-
Running
Pregunta 171
Pregunta
SAP Enterprise Architecture Designer can be used as an alternative to develop calculation views in SAP Web IDE.
-HA300. Unit9.
Respuesta
- True
- False
Pregunta 172
Pregunta
What is a dynamic analytic privilege? -HA300. Unit10.
Respuesta
-
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
Pregunta 173
Pregunta
What is data masking? -HA300. Unit10.
Respuesta
-
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
Pregunta 174
Pregunta
Why do you implement data anonymization? -HA300. Unit10.
Respuesta
-
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
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.