SAP C_HANAIMP_18 Exam Practice Test Instant Access

Question 1

Which of the following techniques can you use to improve the performance of calculation views?Note: There are 2 correct answers to this question.

APartition large tables.

BLimit the number of stacked calculation views.

CImplement union pruning.

DAvoid aggregating data early in the data flow.

Answer : A, B

Question 2

What are some of the restrictions that apply when defining parallelization blocks in calculation views?Note: There are 2 correct answers to this question.

AThe block must start with a node that defines a table as a data source.

BMultiple blocks can only be defined within a single calculation view.

CThe block must only have one start node.

DOnly one block can be defined across a stack of calculation views.

Answer : A, D

Question 3

Which of the following are standard options provided to define analytic privileges?Note: There are 3 correct answers to this question.

ADynamic

BHierarchy function

CSQL expression

DAttributes

EGraph

Answer : A, C, D

Question 4

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

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

BTo retain the correct aggregation behavior in stacked views

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

DTo exclude columns that are NOT requested by a query to avoid incorrect results

Answer : C

Question 5

What are some best practices when developing calculation views?Note: There are 2 correct answers to this question.

AInclude all data flow logic within one calculation view.

BModel star schemas using a sequence of join nodes.

CAvoid defining joins on calculated columns.

DAggregate at the lowest possible node.

Answer : B, D

Question 6

Which of the following approaches might improve the performance of joins in a CUBE calculation view?Note: There are 2 correct answers to this question.

AUse an inner join

BLimit the number of joined columns

CSpecify the join cardinality

DDefine join direction in a full outer join

Answer : B, C

Question 7

Why would you build a calculation view of type SQL Access only?

ATo enable SQL access to your hierarchies

BTo provide a data source that can only be consumed by a function or procedure

CTo provide a high performance model when only attributes are required

DTo provide a data source that is only consumed by other calculation views

Answer : D

SAP Certified Application Associate - SAP HANA 2.0 SPS06 C_HANAIMP_18 Exam Practice Test