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

Question No : 1
Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)? There are 3 correct answers to this question.

A.Data base performance monitor (transaction DB50)
B.Code inspector (transaction SCI)
C.SQL Trace (transaction ST05)
D.SQL monitor (transaction SQLM)
E.ABAP test cockpit (transaction ATC)

正解:

Question No : 2
Before migrating to SAP HANA, which Code Inspector check do you have to consider to avoid functional regressions?

A.Standard Web Dynpro checks
B.Search for DB operations across modularization units
C.SELECT statements that bypass the table buffer
D.Use of the ADBC interface

正解:

Question No : 3
Which feature can you use to improve the performance of data transformation in the Extract, Transform and Load (ETL) process?

A.Service Adaptation Description Language (SADL)
B.Process Agent Framework (PAF)
C.ABAP Messaging Channels (AMC)
D.ABAP Managed Database Procedures (AMDP)

正解:

Question No : 4
When are referential joins executed in analytical views? Choose the correct answer

A.When all the tables are optimized
B.When fields are selected
C.When fields are optimized
D.When fields from both the tables are requested

正解:

Question No : 5
You are using a calculated column COUNTS within your Dimension Calculation View and an aggregation node.
This is the data that goes into the aggregation node:

A.AT Vienna 11 AT Vienna 15 DE Berlin 13 DE Berlin 13
B.AT Vienna 11 AT Vienna 15 DE Berlin 13
C.AT Vienna 26 DE Berlin 26
D.AT Vienna 11 DE Berlin 13

正解:

Question No : 6
What is the purpose of an ABAP project in ABAP Development tools for eclipse? (2 right answers)

A.It provides access to all ABAP repository objects in an ABAP system.
B.It represents the connection to an ABAP system
C.It represents the connection to the SAP HANA server
D.It is used to transport ABAP repository objects

正解:

Question No : 7
Which of the following is not an element of Analytical view? Please choose the correct answer.

A.Currency conversion is not applicable
B.Join fact tables
C.Read Data from the joined database tables
D.Used to Joined table

正解:

Question No : 8
What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling? There are 2 correct answers to this question

A.Account-based Profitability
B.Costing-based Profitability
C.Product-based Profitability
D.Service-based profitability

正解:

Question No : 9
Which form of services is responsible for defining and consuming semantically rich data models. Please choose the correct answer.

A.Core Data Services
B.ITe services
C.Conditional services
D.Modell-ll services

正解:

Question No : 10
What are the two types of editors available in ADT? There are 2 correct answers to this question.

A.Eclipse (native)
B.Client (native)
C.SAP (GUI)
D.ABAP (native)

正解:

Question No : 11
What is the scope of the AbapCatalog.Buffering annotation in a Core Data Services (CDS) view?

A.The set of key fields specified in the additional annotation AbapCatalog.buffering.numberOfKeyFie
B.The CDS views used in the FROM clause
C.The entire CDS view
D.The elements in the projection list of the CDS view

正解:

Question No : 12
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 procedure
B.Two result sets
C.One result set
D.As many result sets as there are table output parameters in the procedure

正解:

Question No : 13
What is the main advantage of SQLScript? (2 answers)

A.SQLScript can be better modularized than traditional SQL
B.SQLScript code can easily be translated into modeling view
C.SQLScript is faster than traditional SQL

正解:

Question No : 14
Which components can be a part of a calculation view? (2 answers)

A.BAPIs
B.Analytic View
C.Tables
D.Attribute View

正解:

Question No : 15
Which of the following categories of parameters can you use in the definition of an ABAP manage database procedure (AMDP)? There are 3 correct answers to this question.

A.Returning
B.Receiving
C.Exporting
D.Changing
E.Importing

正解:

SAP E_HANAAW_17 問題練習