E_HANAAW_14 実際試験問題と解答 - 模擬練習 - 受験自信を増やす

Question No : 1
Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question.

A.ABAP Dictionary
B.Open SQL
C.Core data services (CDS) data definition
D.Core data service (CDS) access control

正解:

Question No : 2
What are the key points that should be kept in mind while performing the Non-automatic update in SAP HANATr.Cont.? There are 2 correct answers to this question.

A.Automatic release of units
B.Changes to Delta Container
C.You need to refresh the content of the container manually
D.Take snapshot manually before releasing of the container

正解:

Question No : 3
How many result sets are returned when an SAP HANA database procedure is called using the CALL WITH OVERVIEW statement? Please choose the correct answer.

A.As many result sets as there are input parameters in the procedur
B.Two result sets
C.One result set
D.As many result sets as there are table output parameters in the procedure

正解:

Question No : 4
You are implementing an ABAP Managed Database Procedures (AMDP) for SAP HANA.
What do you have to do in the corresponding ABAP class? Please choose the correct answer.
A. Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB.
B. Implement the interface IF_AMDP_MARKER_HDB.
C. Set the visibility of the corresponding class method in the declaration section to PUBLIC.
D. Implement the ABAP AMDPJHDB Event Handler.

正解: B

Question No : 5
The SAP HANA database is a hybrid in-memory database that combines Few technologies within.
What are these technologies? There are 3 correct answers to this question

A.Row-based database technology
B.Time-based database technology
C.Column-based database technology
D.Object-based database technology
E.Value-based database technology

正解:

Question No : 6
What all are the factors involved in Working with ADT.
If the search options are enabled, you can set the search parameters for an attribute of a view, which parameters will be available? There are 3 correct answers to this question.

A.ABAP interface
B.Module interface
C.Workbench programs
D.ABAP programs
E.ABAP Class

正解:

Question No : 7
SAP HANA DB Migration: you want to avoid any functional issues after the migration? There are 3 correct answers to this question.

A.Native sql statement
B.Direct access to a cluster on the database
C.Left outer joins in open SQL statements
D.Order by clause in open SQL statement
E.Code that relies on implicit database sorting

正解:

Question No : 8
You developed an ABAP managed database procedure (AMDP). You want to allow the enhancement of this AMDP using business add-in (BADI).
Which of the following objects must you create? There are 3 correct answers to this question.

A.A BADI definition
B.A BADI fallback implementation
C.An enhancement spot
D.A database procedure
E.A BADI simple implementation

正解:

Question No : 9
In an ABAP Core Data services (CDS) view, what must you do expose an association for use in another CDS view? Please choose the correct answer.

A.Include all fields used in the ON condition in projection list
B.Specify an alias for the target entity
C.Define the cardinality for the target entity
D.Specify the other views in which the association can be used

正解:

Question No : 10
You create a new table definition using the ABAP Dictionary and maintain the database-specific technical settings table?
Why do you create a row store instead of a column store Please choose the correct answer?

A.To allow creation of a full-text index
B.To limit the unpacking and reconstruction of rows
C.To limit the need of indexes
D.To limit the data footprint

正解:

Question No : 11
You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias? There are 3 correct answers to this question.

A.CASTE Expression
B.CASE expression
C.Currency Conversion
D.Nested CASE expression
E.Unit conversion

正解:

Question No : 12
What are the elements of ABAP Database Integration? There are 3 correct answers to this question.

A.Client database handling
B.Application server
C.DB client-server
D.Other DB
E.DB For ABAP

正解:

Question No : 13
How to create a core data services view? (3 ans)

A.Use SQL capabilities for Netweaver
B.Use data services tools for updates
C.Use DDL statement DEFINE VIEW and SQL like syntax to define the view
D.Use the ABAP Development Tools for SAP Netweaver
E.Use additional annotations - marked with the @sign

正解:

Question No : 14
You made changes to an object (X) used by an ABAP managed database procedure (AMDP). You did NOT changes the AMDP itself. Now you execute a program that calls this.
In which cases does the call trigger the creation of the database procedure in SAP HANA? There are 2 correct answers to this question.

A.X is a stored procedure.
B.X is an SAP HANA view
C.X is an ABAP Dictionary table
D.X is an AMDP method

正解:

Question No : 15
You use ABAP database connectivity (ADBC) to issue native SQL calls to the database, the native SQL call? Which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call? Please choose the correct answer.

A.SET_PARAM_TABLE
B.SET_PARAM
C.EXECUTE_QUERY
D.NEXT_PACKAGE

正解:

SAP E_HANAAW_14 問題練習