C_HANAIMP_12 Online Practice Questions and Answers

What does SAP recommend to improve performance of data models in SAP HANA?

A. Move intensive calculations to the front-end application

B. Perform calculation before aggregation

C. Utilize as many different engines as possible

D. Minimize data transfer between the engines

You have an SAP HANA productive system with sensitive data.How can you restrict modeling users from viewing this data?

A. Remove ALTER SYSTEM in the system privileges for the modeling users.

B. Use randomized data for the development of data models.

C. Allow modeling only on the SAP HANA development system and export/import the models to the productive system.

D. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users.

You modify an existing view. How can you determine which models are affected by this change?

A. Use the audit trail.

B. Use the History feature for the changed model.

C. Use the "Where-Used List" feature for the changed model.

D. Use the "Auto Documentation" to compare the object version of the changed model.

You have a list of map locations for clinics. The government wants to build a new clinic, but wants to build

it where there is the greatest need.

You need to find the largest distance between any two clinics. With your current knowledge, how do you do

this?

Please choose the correct answer.

Response:

A. Use a temporal join to find the distance between clinics. Use a union with constant values to "pivot" the values.

B. Use a dynamic join to find the longest distance between clinics. Use a ranking to find the top 10 values.

C. Use a spatial join to find the distance between clinics. Use an aggregation with the maximum option.

D. Use a spatial join to find the distance between clinics. Use a level hierarchy for drilldown.

How do you move code to SAP HANA? There are 2 correct answers to this question. Response:

A. Use graphical data models in SAP HANA

B. Delete the application server

C. Use row tables in SAP HANA

D. Use stored procedures in SAP HANA

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 want to build a hierarchy on a time-based data structure. What type of hierarchy do you use? Please

choose the correct answer.

Response:

A. Parent-child hierarchy

B. Ragged hierarchy

C. Level hierarchy

D. Unbalanced hierarchy

Which words are associated with the log volume? There are 2 correct answers to this question. Response:

A. Synchronous

B. Save point

C. Transaction manager

D. Page manager

Which export option can you use to make backups of your own information models? Please choose the

correct answer.

Response:

A. Delivery units

B. CTS

C. Developer mode

D. SAP Support mode

You are writing a mobile application for the World Series. You have details about all the baseball players

and the baseball scores for all the previous matches.

How do you use the data of the player information and the scores? Please choose the correct answer.

Response:

A. Both the player information and the scores are used as transactional data.

B. The player information is used as master data, and the scores are used as transactional data.

C. Both the player information and the scores are used as master data.

D. The player information is used as transactional data, and the scores are used as master data.