SAP C_HCMOD_05 Exam Questions Instant Access

Question 1

Which tool generates and executes the SQL for a specific node of your calculation view?

ADebug Query mode

BExplain plan

CSQL analyzer

DDatabase explorer

Answer : A

Question 2

Your calculation view consumes one data source, which includes the following columns: SALES_ORDER_ID, PRODUCT_ID, QUANTITY and 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?

AProjection

BJoin

CUnion

DAggregation

Answer : C

Question 3

Why would you use the Transparent Filter property in a calculation view?

ATo include columns that are NOT requested by a query

BTo avoid columns being unnecessarily used in an aggregation

CTo apply filters that are hidden from the end user

DTo allow filter push-down in stacked calculation views

Answer : B

Question 4

In a calculation view, why would you implement an SQL expression? Note: There are 3 correct answers to this question.

ATo generate hierarchies

BTo define a filter

CTo convert currencies

DTo generate a restricted column

ETo generate a calculated column

Answer : B, D, E

Question 5

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

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

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

CThe block must only have one start node.

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

Answer : B, D

Question 6

Why would you choose to implement a referential join?

ATo develop a series of linked joins

BTo define conditions for potential data source pruning

CTo reuse the settings of an existing join

DTo automate the setting of cardinality rules

Answer : D

Question 7

What are the limitations of using a full outer join in a star join node?Note: There are 2 correct answers to this question.

AIt must appear in the last DIMENSION in the star join node.

BIt is restricted to one DIMENSION in a star join node.

CIt CANNOT be mixed in the same star join node with other join types.

DOnly one column can be included in the join condition.

Answer : A, B

SAP Certified Application Associate - SAP HANA Cloud Modeling C_HCMOD_05 Exam Questions