HANA Interview Questions

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

1. Consider the Data Modeling concept in HANA, Which of the below statement is incorrect about Schema?

A. In Star Schema, you can have multiple fact tables and Dim tables

B. In Star Schema, Dim tables are not normalized

C. In Galaxy Schema, you have multiple fact tables and multiple Dim tables.

D. In Snowflakes schema, you have multiple Dim tables in normalized form.

Correct Answer is : In Star Schema, you can have multiple fact tables and Dim tables

2. SAP HANA Administrator is using instance 00 to connect to HANA Studio. Which port is used in HANA system for this instance?

A. Port 30015

B. Port 3615

C. SSh port

D. Port 31015

Correct Answer is : Port 30015

3. A SAP HANA Modeler is using Calculation view with Star Join to add measures from multiple fact tables. Which of the below statement is correct about Calculation view with Star Join?

A. You can only add base Column tables at Star Join level.

B. You can only add Attribute Views or Analytical views at Star Join

C. You can only add Dimension Calculation View at Star Join

D. You can add other Calculation views without Star Join and data type Cube

Correct Answer is : You can only add Dimension Calculation View at Star Join

4. A SAP HANA Modeler is trying to activate an Analytical view and getting the error message- insufficient privilege. Which of the below user should get access on Schema and tables used in HANA view to activate the view?

A. SYS_REPO

B. SYS_READ

C. DATA ADMIN

D. REPO READ

Correct Answer is : SYS_REPO

5. In SAP HANA Job based replication, which of the below can be used to add a schedule, to trace, monitor and error check a replication job?

A. Data Service Designer

B. Data Service Repository Manager

C. Data Service Management Console

D. Data Services Server Manager

Correct Answer is : Data Service Management Console

HANA interview questions