SAP Certified Application Associate - SAP HANA 2.0 (SPS04) (C_HANAIMP_16) Free Practice Test

Question 1

What restrictions apply to a Graph node that you include in a calculation view?

A. It must be the final node in the dataflow.

B. It must be the first node in the dataflow.

C. Its data source must be provided by a projection node.

D. It cannot be included in a calculation view of type dimension.

Correct Answer: B

Question 2

When you create a full text index, why do you specify FAST_PREPROCESS OFF?

A. To generate text analysis results in multiple languages

B. To prevent the creation of a fuzzy search index

C. To enable a full linguistic search

D. To avoid the generation of the term document matrix

Correct Answer: C

Question 3

In which of the following scenarios would you benefit from enabling table partitioning in SAP HANA?

A. Your stacked model consists of multiple calculation views.

B. You have a dedicated table lo generate the lists of help values for an input parameter.

C. You have a large column store table that is consumed in a view with a variable on COUNTRY column.

D. You have a large row store table that is consumed in a view with a variable on COUNTRY column.

Correct Answer: C

Question 4

Your calculation view consumes one data source which includes the following columns :
SALES_ORDER_ID, PRODUCT_ID, QUANTITY & PRICE.
In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY * PRICE.
In which type of node do you define the calculation to display the correct result?

A. Union

B. Aggregation

C. Projection

D. Join

Correct Answer: C

Question 5

Which type of join supports a temporal condition in a calculation view?

A. Inner join

B. Left outer join

C. Text join

D. Referential join

Correct Answer: A

Question 6

You are building a new calculation view B that uses calculation view A as a data source. In the Semantics node of calculation view A, you define a mask for the first 10 digits of a 15 digit Account Number. When you preview calculation view B, the Account Number is not masked.
Why do you see the Account Number unmasked?

A. The UNMASKED privilege for calculation view A has been granted.

B. The Account Number is based on the Integer datatype.

C. The masking is based on the column of a row table.

D. You did not define masking in calculation view B.

Correct Answer: A

Question 7

In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view.
Afterward, you perform the following build operations:
*Build the dimension calculation view as a single object.
*Build the entire SAP HANA database module. What is the outcome of the build operations?

A. The first build fails.
The second build fails.

B. The first build is successful.
The second build is successful.

C. The first build fails.
The second build is successful.

D. The first build is successful.
The second build fails.

Correct Answer: B

Question 8

Why might you use the Keep Flag property in an aggregation node?

A. To cache the results of the aggregation node for drill-down

B. To include columns that are NOT requested by a query but are essential for the correct result

C. To retain the correct aggregation behavior in stacked views.

D. To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query

Correct Answer: B

Welcome to TestSimulate

SAP Certified Application Associate - SAP HANA 2.0 (SPS04) (C_HANAIMP_16) Free Practice Test