E-HANAAW-14問題集、SAP実際の試験問題

質問 1

Name some perspectives that are available in the SAP HANA Studio? (3 ans)

A. The SAP HANA Modeler Perspective

B. The Resources perspective

C. The information perspective

D. The technology & innovation perspective

E. The Administration Console perspective

正解: A,B,E

質問 2

What do you have to consider if you want to use Native SQL in your ABAP programs to access an SAP HANA DB? There are 2 correct answer to this question.

A. The ABAP system check the syntax of the Native SQL statements

B. Client handling needs to be done explicitely in the Native SQL statement

C. The database independency of your report can be lost

D. Hashed or sorted tables must be used with the INTO CORRESPONDING FIELDS keyword

正解: B,C

質問 3

Which of the following take advantage of the computing power of multiple CPUs used by SAP HANA? There are 2 correct answers to this question.

A. Parallel processing

B. Partitioning

C. Column data storage

D. Database table compression

正解: A,B

質問 4

What are the features of New Open SQL? There are 2 correct answers to this question.

A. Supports arithmetic and string expressions

B. Supports conditional expressions

C. Supports specific units of database

D. Supports Code adjustment model

正解: A,B

質問 5

Which tasks does the ABAP managed database (AMDP) framework perform? There are 2 correct answers to this question.

A. Create a new version of the database when the AMDP is first activated

B. Create a new version of the database when the AMDP is first called

C. Delete the obsolete versions of the database procedure asynchronously

D. Delete the obsolete versions of the database procedure synchronously

正解: B,C

質問 6

Open SQL largely standardized, three sub-languages. What are these sub-languages? There are 3 correct answers to this question

A. Data Manipulation Language (DML)

B. The Data Control Language (DCL)

C. Data Transferring Language(DTL)

D. The Data Definition Language (DDL)

E. Data Evaluation Language(DEL)

正解: A,B,D

質問 7

Which form of services is responsible for defining and consuming semantically rich data models? (1 ans)

A. Model-ll services

B. Core Data Services (CDS)

C. It services

D. Conditional services

正解: B

質問 8

You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter on the right-hand side of an assignment operator within the procedure. How do you refer to the parameter? Please choose the correct answer.

A. {it.books}

B. it_books

C. :it_books

D. @it_books

正解: C

質問 9

If the Search Options are enabled, you can set the Search Parameters for an attribute of a view. The following parameters are available?
There are 3 correct answers to this question

A. Fuzzy search

B. Weights for ranking

C. Index search

D. Point base ranking

E. Freestyle search

正解: A,B,E

質問 10

What are the features associated with ABAP CDS? There are 3 correct answers to this question.

A. Read

B. Export

C. Create

D. Update

E. Distribution

正解: A,C,D

質問 11

Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)? Please choose the correct answer.

A. Estimate the new total runtime of optimized code.

B. Create a graph comparing the runtimes of ABAP code before and after optimization.

C. Combine information from static ABAP code scans with runtime data from the SQL Trace tool.

D. Combine information from static ABAP code scans with runtime data from the SQL Monitor.

正解: D

質問 12

Why is a security concept in SAP HANA required? There are 2 correct answers to this question

A. Database administration should be restricted to skilled

B. Need to have selected users in SAP HANA for Information Management

C. Editing of SAP HANA data models should only be possible for "Users" of the model

D. Access to ERP tables must be restricted

正解: A,D

質問 13

You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SOJD). Which SELECT statement would you use in the definition? Please choose the correct answer.

A. select from snwd_so {sojd, sum(net_amount) as sum_amount}

B. select from snwd_so {so_id( sum(net_amount) as sum_amount} group by sojd

C. select from snwd_so {so_id( sum(net_amount) as sum_amount} group by net_amount

D. select from snwd_so {so_id( sum(net_amount) as sum_amount} order by sojd

正解: B

質問 14

Which steps do you have to perform when defining a view using core data services (CDS)? There are 3 correct answers to this question.

A. Create a data definition in your ABAP package

B. Create a proxy object for the defined view.

C. Define the type mapping between ABAP and SAP HANA

D. Specify the name of the SQL view in ABAP Dictionary

E. Use the DDL statement DEFINE VIEW and SQL like Syntax

正解: A,D,E

SAP Certified Development Specialist - ABAP for SAP HANA 2.0 - E-HANAAW-14 模擬練習