C_HANAIMP_12 Online Practice Questions and Answers

You create an analytic view and want to restrict access to departments with specific values using analytic privileges. Which tasks do you have to perform to accomplish this? (Choose three)

A. Assign restricted values to the attribute view.

B. Assign values to be restricted. Choose at least one information model to assign restrictions.

C. Assign the analytic privilege to a user or role.

D. Assign values to be restricted to a content table.

E. Choose an attribute to define restricted values for it.

You are using SAP NetWeaver Business Warehouse (SAP NetWeaver BW) in your company as the enterprise data warehouse. You want to use SAP NetWeaver BW as a data provisioning tool for SAP HANA without disturbing your BW reporting.

Which of the following are SAP recommended actions? (Choose two)

A. Automate the ETL processes in SAP NetWeaver using process chains.

B. Write data back from SAP HANA into the replicated SAP NetWeaver BW tables.

C. Create new InfoObjects for the SAP HANA InfoProviders.

D. Schedule the real-time data loads into SAP HANA.

You need to create an SAP HANA data model based on a star schema.

Which SAP HANA engine is recommended for analytical purposes?

A. Calculation engine

B. OLAP engine

C. Row store engine

D. Join engine

Of which SAP HANA process are the transaction manager and page manager a part? Please choose the

correct answer.

Response:

A. SAP HANA XS server

B. Name server

C. Index server

D. Statistics server

You want to reuse a decision table on multiple tables with a similar data structure. You design the decision table that passes a specific table name as an input parameter when you execute the decision table. What do you have to use in the data foundation to achieve this? Please choose the correct answer. Response:

A. A scripted calculation view

B. A virtual table

C. A dynamic join

D. A table type

You are loading data into SAP HANA using DXC. Which of the following are executed in the embedded

SAP BW system?

There are 3 correct answers to this question.

Response:

A. IMDSO

B. Extractor

C. Info Package

D. Activation

E. Transformation

You have logs from a website. How do you show the total number of website visitors that used a mobile

phone?

There are 2 correct answers to this question.

Response:

A. Create a filter expression

B. Create an action

C. Create a rank column

D. Create a restricted column

What statement is allowed in a user-defined function? There are 2 correct answers to this question. Response:

A. COMMIT

B. EXEC

C. JOIN

D. INSERT

Response:

A. Adjust references to the information view in graphical calculation views.

B. Adjust references to the information view in analytic views.

C. Adjust references to the information view in procedures.

D. Adjust references to the information view in table functions.

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