E_HANAAW_17 Online Practice Questions and Answers

Analytic Privilege can be applied to (3 Answers)

A. Calculation views

B. Attribute views

C. Analytic views

D. Table

E. SQL View

What are the two different kinds of Identifiers used to represent names used in SQL statement? There are 2 correct answers to this question

A. Delimited identifiers

B. Limited identifiers

C. Undelimited Identifiers

D. Numeric identifiers

Which of the statements are true for SQLScript? (2 answers)

A. SQLScript is an open standard.

B. SQLScript is used to push down data intensive logic into the database.

C. SQLScript is a collection of extensions to SQL.

While creating a Graphical Calculation view, what are the options available in Tools palette? (4 answers)

A. Union

B. Cast

C. Aggregation

D. Projection

E. Join

F. Distinct

What are the ABAP development guidelines? There are 2 correct answers to this question.

A. Consuming Only ABAP contents for SAP HANA

B. Improved tools for performance analysis

C. Improved hybrid components for SAP HANA

D. Extensions to ABAP Language

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

A. Read

B. Create

C. Delete/Edit Table

D. Update

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)

Which option in SAP NetWeaver Gateway Service Builder (transaction SEGW) can be used to implement the consumption of a Core Data Services view?

A. "Map to Data source"

B. "Consume CDS view"

C. "Relate to Business Entity"

D. "Read from DDL source"

How can you consume a Core Data Services (CDS) view? 2 answers

A. Use the Data Preview in ABAP Development Tools for SAP NetWeaver.

B. Use it as a data source in the FROM clause of an Open SQL query.

C. Use the ABAP language statement WRITE and the CDS view name as the argument.

D. Use the CDS maintenance transaction (SCDSV).

Which of the below statements are true for SAP HANA Studio? (3 answers)

A. SAP HANA Studio can be used to manage the SAP HANA database, to create and manage user authorizations, to create new or modify existing models of data etc

B. SAP HANA Studio is an Eclipse-based, integrated development environment (IDE) that is used to develop artifacts in a HANA server.

C. SAP HANA Studio is a client tool, which can be used to access local or remote HANA system.

D. SAP HANA Studio is integrated in SAP GUI > 7.40