SAP Certified Application Associate (Edition 2013) - SAP HANA

Question 1

You receive an activation error in a scripted calculation view that uses the following function:
CE_PROJECTION(:table1, ["AMOUNT"], '"PROD" = A')
What could be a reason for this error?

A. The filter condition contains a field that is not part of the projection list.

B. The filter condition must be specified inside the projection list.

C. The projection list contains a field that is not specified in the filter condition.

D. The filter condition is not set within square brackets.

Correct Answer: A

Question 2

You want to use a UNION to combine two information objects in a calculation view. Which steps do you have to perform?(Choose two)

A. Sort the columns in the output structure.

B. Define a constant column in the target.

C. Connect the information objects to the UNION node.

D. Define the mapping of columns of the information objects.

Correct Answer: C,D

Question 3

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

A. When you want to search in only one column

B. When you want to search with a low fuzziness threshold

C. When you want to search in multiple columns

D. When you want to search with a high fuzziness threshold

Correct Answer: C

Question 4

Two attribute views in the same analytic view contain the same column name (ID from attribute view Customer and ID from attribute view Product). In the output, the system automatically renamed one column to ID_1.
Which of the following can you do to indicate that ID_1 originated from attribute view Product?

A. Create a derived attribute view with an alias for ID_1.

B. Change the label of ID_1.

C. Update the alias in the properties of ID_1.

D. Create a restricted column with a different name based on ID_1.

Correct Answer: C

Question 5

What is the functionality of an aggregation node in a calculation view?(Choose two)

A. It determines the output structure of the calculation view

B. It provides deeper control over which columns are totaled

C. It provides grouping of filter criteria

D. It calculates the sum, minimum, or maximum values for selected columns

Correct Answer: B,D

Question 6

What is the advantage of reporting directly from column tables?

A. It provides multi-language support

B. It shifts complex calculations and logic to SAP HANA

C. It eliminates the need for additional modeling

D. It supports analytical privileges

Correct Answer: C

Question 7

Which programming language do you use for SAP Landscape Transformation based transformation rules?

A. Java

B. ABAP

C. JavaScript

D. SQLScript

Correct Answer: B

Question 8

You would like to authorize a user to see data in an analytic view only for company code 1000 and fiscal year 2000 or for company code 1005 and fiscal year 2005.
Which of the following achieves this requirement?

A. One analyticprivilege:company codes = 1000 and 1005
One analyticprivilege:fiscal years = 2000 and 2005

B. One analyticprivilege:company code = 1000, fiscal year = 2000
One analyticprivilege:company code = 1005, fiscal year = 2005

C. One analyticprivilege:company codes = 1000 and 1005, and fiscal years = 2000 and 2005

D. One analyticprivilege.the combination of company code = 1000 and fiscal year = 2000, and the combination of company code = 1005 and fiscal year = 2005

Correct Answer: B

SAP Certified Application Associate (Edition 2013) - SAP HANA - C-HANAIMP131 Exam Practice Test

Latest Update

Useful Links

Contact Us