C-HANAIMP141 by SAP Actual Free Exam Q&As

Question 1

In a SQLScript calculation view, one table variable contains the records that are the result of a SELECT * statement from a database table with 10 fields. You want to use this table variable to populate a new table variable with the same result set, which is restricted to 1 of the 10 fields.
Which CE function do you use?

A. CE_PROJECTION B. CE_CALC C. CE_UNION D. CE_COLUMN_TABLE

Discussion 0

Correct Answer: A Vote an answer

Question 2

In a fuzzy search, when would you perform a freestyle search?

A. When you want to search in multiple columns B. When you want to search with a high fuzziness threshold C. When you want to search with a low fuzziness threshold D. When you want to search in only one column

Discussion 0

Correct Answer: A Vote an answer

Question 3

You have two analytic views: one contains actual data and the other contains plan data. You want to combine the two result sets and keep actual and plan data on separate records.
In the SAP HANA studio, which of the following can you use to achieve this?

A. JOIN in an analytic view B. JOIN in a graphical calculation view C. UNION in a calculation view D. PROJECTION in a calculation view

Discussion 0

Correct Answer: C Vote an answer

Question 4

You need real-time profitability reporting from an SAP ECC system running on a non-SAP database.
Which of the following steps must you perform to implement the SAP CO-PA Accelerator?
Note: There are 2 correct answers to this question.

A. Install SAP HANA as a secondary database. B. Build attribute and analytic views in SAP HANA. C. Create an SAP Landscape Transformation configuration. D. Configure an ABAP dataflow in SAP Data Services.

Discussion 0

Correct Answer: A,C Vote an answer

Question 5

Which of the following selection types are available when creating a variable in an analytic view?
Note: There are 3 correct answers to this question.

A. Direct B. Interval C. Column D. Single value E. Range

Discussion 0

Correct Answer: B,D,E Vote an answer

Question 6

Which of the following steps do you have to execute to import models from one SAP HANA system (system1) to another SAP HANA system (system2)?
Note: There are 3 correct answers to this question.

A. Create a schema on system2. B. Import the models into system2. C. Create a delivery unit on system2. D. Export the models from system1. E. Create a delivery unit on system1.

Discussion 0

Correct Answer: B,D,E Vote an answer

Question 7

You plan to migrate your existing SAP NetWeaver landscape with a non-SAP HANA
database.
Which of the following are key considerations for the migration of your database to SAP HANA?
Note: There are 3 correct answers to this question.

A. Resize application servers to handle incremental data volumes. B. Reuse existing SAP NetWeaver application servers. C. Provision hardware that runs SUSE Linux (SLES) for SAP HANA. D. Upgrade all end-user front-end workstations to SUSE Linux (SLES). E. Plan downtime for the migration of the old database to SAP HANA.

Discussion 0

Correct Answer: B,C,E Vote an answer

Question 8

You want to aggregate the grand total sales amount into 1 currency.
In which of the following cases would you select the Calculate Before Aggregation check-box?
Note: There are 2 correct answers to this question.

A. When a line item table contains sales values in 1 currency B. When an aggregate table by country contains sales values in 3 different currencies C. When a line item table contains sales values of 2 different currencies D. When an aggregate table by country contains sales values in 1 currency

Discussion 0

Correct Answer: B,C Vote an answer

SAP Certified Application Associate (Edition 2014) - SAP HANA - C-HANAIMP141 Exam Practice Test