E_HANAAW_12 Online Practice Questions and Answers

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

A. Join fact tables

B. Read Data from the joined database tables

C. Currency conversion is not applicable

D. Used to Joined table

Your ABAP program contains an Open SQL join of two client-dependent tables. You want to replace this with a native SQL SELECT statement.

Which of the following changes to the SELECT statement can you use to retrieve the same data as before?

There are 2 correct answers to this question.

A. Include the client field in the WHERE condition.

B. Use the CLIENT SPECIFIED addition.

C. Include the client field in the join condition.

D. Include the client field in the field list.

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

A. Distribution

B. Export

C. Read

D. Update

E. Create

When would you use a column store table instead of a row store table? There are 2 correct answers to this question.

A. When you require aggregation and analysis of values

B. When there are mainly distinct values in the table

C. When you want to enable a full-text search of the table

D. When the table has a small number of records

The source code editor in ADT provides many helpful features. What are these helpful features? There are 2 correct answers to this question.

A. Creating Method Implementations from the Method Definition

B. Creating Method Definitions from Implementation Parts

C. Creating Parts for Interface Methods

D. Creating interface from Method Calls

What are the two main methods to add a system to the SAP HANA Studio? There are 2 correct answers to this question

A. Automatically

B. Manually

C. By Importing a Landscape

D. By Resource console

An Analytic Privilege consists of several restrictions. What are they? There 3 correct answers to this question

A. Analytic restrictions

B. Cube restrictions

C. Activity restrictions

D. Validity restrictions

E. View restrictions

DB-Specific Properties that allows switching between storage types when running on an SAP HANA database. What are these storage types?

There are 2 correct answers to this question.

A. Column store

B. Raw store

C. Re-use component store

D. Development Store

E. Technology store

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

A. Improved hybrid components for SAP HANA

B. Consuming Only ABAP contents for SAP HANA

C. Improved tools for performance analysis

D. Extensions to ABAP Language

Explain how and when to create calculated columns - Using Graphical Modeling Tools? There are 3 correct answers to this question

A. The calculation could be an arithmetic or character manipulation.

B. Calculated columns also support non-measure attributes as part of the calculation.

C. It is possible to nest so that one calculated column, in turn, is based on other calculated columns

D. The calculation will be opened in a read-only mode

E. Time characteristics based calculation columns