SAP C_HCMOD_05 Exam Practice Test Instant Access

Question 1

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 2

You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails.Which of the following could be a valid reason?

AYour function includes a TRUNCATE statement.

BYour function refers to a scalar function.

CYou did NOT define a valid table type.

DYou did not define at least one input parameter.

Answer : A

Question 3

You want to join two tables in a calculation view.Why do you use a non-equi join?

AJoin columns have different data types.

BThe number of joined columns is different in each table.

CJoin columns need to be ignored when NOT requested by the query.

DThe join condition is not represented by matching values.

Answer : D

Question 4

You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name.How do you ensure that each customer name appears only once in the results?

ADefine a restricted column in a union node.

BIn the union node, map both source customer name columns to one target column.

CAdd an intersect node above the union node.

DInclude an aggregation node above the union node.

Answer : D

Question 5

You have imported a new calculation view in a folder that contains an .hdinamespace file. This calculation view consumes one data source, which is a table. When trying to deploy the calculation view, the deployment fails with a namespace-related issue.What could be the reason?Note: There are 2 correct answers to this question.

AThe namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.

BThe imported calculation view and its data source have different namespaces.

CAn .hdinamespace file is defined in the SRC folder that specifies a different namespace property than the one in the identifier of the calculation view.

DThe .hdinamespace specifies 'sub-folder':'append', so calculation views can only be created in subfolders.

Answer : A, B

Question 6

Two calculation views, A and B, are defined as shown in the diagram. Three analytic privileges have been granted to you.

When you preview calculation view A, what data do you see?

AUS for P1 and GE for P1

BUS for P1 and P2, and GE for P1 and P2

CUS for P1

DUS for P1 and P2, and GE for P2

Answer : A

Question 7

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

SAP Certified Application Associate - SAP HANA Cloud Modeling C_HCMOD_05 Exam Practice Test