C_HANAIMP_12 Online Practice Questions and Answers

You want to report on data from SAP HANA using MS Excel. How can you achieve this? (Choose two)

A. Select an analytic view using the Data Connection wizard.

B. Create a ODBC connection between SAP HANA and MS Excel.

C. Select an attribute view using the Data Connection wizard.

D. Create an ODBO connection between SAP HANA and MS Excel.

Which of the following criteria indicate that you should store data in row tables?

A. The tables have a large number of columns.

B. The tables require frequent write access.

C. The information models search the table based on the values of a few columns.

D. The information models frequently needs to access complete records.

Which engine is used for calculation and aggregation based on star schema

A. Join Engine

B. Calculation Engine

C. SQL Optimizer Engine

D. OLAP Engine

Which steps do you have to perform once before you can create SAP HANA development objects? There

are 2 correct answers to this question.

Response:

A. Create an SAP HANA XS project.

B. Create a dataflow model in the AFM.

C. Create a predictive model using PAL.

D. Create a repository workspace

What character is prepended to a SQLScript variable when it is used as an input variable? Please choose

the correct answer.

Response:

A. _ (underscore)

B. : (colon)

C. ~ ! (exclamation mark)

D. and (ampersand)

Which development tools are available for creating SAP HANA information models? There are 2 correct

answers to this question.

Response:

A. Java applet in the browser

B. Web-based development tool

C. Java-based Eclipse tool

D. iPad app for development

Your newly created information view does NOT want to activate. For which system user must you grant

read access to your schema?

Please choose the correct answer.

Response:

A. SYSTEM

B. _SYS_TASK

C. _SYS REPO

D. SYS

Which actions does refactoring typically use? There are 2 correct answers to this question. Response:

A. Deleting

B. Moving

C. Renaming

D. Transporting

For what SQL keyword is the aggregation node the equivalent? Please choose the correct answer. Response:

A. UNIQUE

B. ORDER BY

C. DISTINCT

D. GROUP BY

What information can you find in Performance Analysis Mode when you view the analysis for a join node?

There are 2 correct answers to this question.

Response:

A. The total number of records returned by the node

B. The suggested filter for the tables in the join node

C. The tables used by the join in the node

D. The time taken by the join