Question No. 1

In a calculation view of type cube with star join, you want to join three dimensions to the facts. Two of the dimensions use full outer joins and one dimension uses a left outer join. You did NOT set cardinality of the data sources. Why will this NOT work?

AFull outer joins are restricted to one dimension in a star join node.

BFull outer joins require cardinality to beset.

CFull outer joins CANNOT be mixed in the same star join node with other join types.

DFull outer joins are NOT available in the star join node.

Show Answer

Correct Answer: A

Question No. 2

How can you define a variable that presents its value help hierarchically?

Note: There are2 correct answers to this question.

ACreate a parent-child hierarchy and assign it to the variable.
Ensure the variable's reference column is the parent attribute of the hierarchy.

BCreate a parent-child hierarchy and assign it to the variable.
Ensure the variable's reference column is the child attribute of the hierarchy.

CCreate a level hierarchy and assign it to the variable.
Ensure the variable's reference column is the leaf level of the hierarchy.

DCreate a level hierarchy and assign it to the variable.
Ensure the variable's reference column is the top level of the hierarchy.

Show Answer

Correct Answer: C

Question No. 3

Why does SAP issue warnings about the use of imperative or procedural SQL Script statements?

AThey can harm SQL optimization.

BNOT all reporting tools can consume the results.

CThey introduce potential security risk.

DThey call multiple processing engines

Show Answer

Correct Answer: C

Question No. 4

Why do you implement Active / active read-enabled mode?

ATo enhance security for data access

BTo provide offline access to data

CTo improve query performance

DTo synchronize query results with operational data

Show Answer

Correct Answer: D

Question No. 5

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

ATo cache the results of the aggregation node for drill-down

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

CTo include columns that are NOT requested by a query but are essential for the correct result

DTo retain the correct aggregation behavior in stacked views.

Show Answer

Correct Answer: C

Free SAP C_HANAIMP_17 Exam Actual Questions

The questions for C_HANAIMP_17 were last updated On Nov 21, 2024