C_HANAIMP_12 Online Practice Questions and Answers

When loading data into SAP HANA, which of the following tasks can you perform using SAP Data Services? (Choose two)

A. Data filtering

B. Real-time replication

C. Data transformations

D. Upload data via the SAP HANA studio

What is the advantage of reporting directly from column tables?

A. It provides multi-language support

B. It eliminates the need for additional modeling

C. It shifts complex calculations and logic to SAP HANA

D. It supports analytical privileges

Where in the Systems view of SAP HANA studio can you create new SAP HANA models? Please choose

the correct answer.

Response:

A. In the packages of the Catalog area

B. In the schemas of the Content area

C. In the schemas of the Catalog area

D. In the packages of the Content area

Which type of cloud solution is Amazon Web Services (AWS) an example of? Please choose the correct

answer.

Response:

A. Private cloud

B. Community cloud

C. Public cloud

D. Hybrid cloud

Response:

A. Attribute view

B. Calculation view of type cube with star join

C. Calculation view of type dimension

D. Analytic view

You have created a SQL analytic privilege on an information view. Where do you tell the view to enable

SQL analytic privileges?

Please choose the correct answer.

Response:

A. In the SAP HANA studio preferences

B. In the migration tool

C. In the restrictions settings of the SQL analytic privilege

D. In the semantic node of the information model

What engine executes the spatial queries? Please choose the correct answer. Response:

A. Calculation

B. SQL

C. Join

D. OLAP

What can you use to limit users to see only 2016 data? There are 2 correct answers to this question. Response:

A. A view with a filter

B. A SQL analytic privilege

C. An object privilege

D. A view with a restricted column

What feature is similar between an attribute view and a calculation view of type dimension? Please choose

the correct answer.

Response:

A. Fuzzy text search attributes

B. Left outer join

C. Full outer join

D. Derived views

In which SAP HANA solution do you eliminate stored data, like year-todate figures? Please choose the

correct answer.

Response:

A. SAP S/4HANA

B. SAP BW on SAP HANA

C. SAP HANA Enterprise Cloud

D. SAP CRM on SAP HANA