C_HANAIMP_12 Online Practice Questions and Answers

Which feature is supported by the backup and recovery process within the standard delivery of SAP HANA?

A. Incremental backup

B. Information model recovery

C. Point-in-time recovery

D. Automatic backup of archiving log files scheduled within SAP HANA

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?

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.

A company needs to load external data from a flat file into SAP HANA. How can you do this?

A. SAP HANA Direct Extractor Connection (DXC)

B. SAP System Landscape Transformation (SLT)

C. SAP HANA SQL Import statement

D. SAP BusinessObjects Data Services

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

What does SAP HANA load when starting up and before indicating that it is ready? There are 3 correct

answers to this question.

Response:

A. Some column tables

B. Some row tables

C. All partitions

D. All system tables

E. All row tables

What paradigm describes the SQL language? Please choose the correct answer. Response:

A. Object-oriented

B. Set-oriented

C. Application-focused

D. Procedural

You are working with a currency measure. What is decimal shift used for? Please choose the correct answer. Response:

A. Avoid rounding errors during the conversion

B. To undo the decimal adjustment for ABAP

C. For currencies with more than two decimal places

D. Increase the accuracy of the currency conversion

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

In which deployment scenarios does security stay in the application server, and end users do not log into

the SAP HANA system?

There are 2 correct answers to this question.

Response:

A. SAP HANA as a database

B. SAP HANA as a sidecar solution

C. SAP HANA as a platform with an SAP HANA XS application

D. SAP HANA as an accelerator

You created a calculated column in an analytic view for a table containing the number of units ordered, the

price per unit, and the number of units in stock.

You get the wrong results in your results. What could be the problem? Please choose the correct answer.

Response:

A. You chose the SQL expression syntax

B. You mistyped the calculated column expression

C. You did NOT enable the currency conversion

D. You did NOT enable calculate before aggregation