C_HCMOD_01 by SAP Actual Free Exam Q&As

Question 1

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

A. It is restricted to one DIMENSION in a star join node. B. Only one column can be included in the join condition. C. It must appear in the last DIMENSION in the star join node. D. It CANNOT be mixed in the same star join node with other join types.

Discussion 0

Correct Answer: A,C Vote an answer

Question 2

You are deploying a new calculation view, A, that uses calculation view B, as shown in the diagram.
When you preview calculation view A, the account number is not masked.What could be the reason?

A. The type of the Account_Number column is VARCHAR. B. You previewed the data with the technical user in SAP Business Application Studio. C. You did not define masking in calculation view A. D. The UNMASKED privilege has NOT been granted at the schema level.

Discussion 0

Correct Answer: C Vote an answer

Question 3

Using the table in the diagram, you need to create a CUBE calculation view. What is the simplest approach to create the output shown in the screenshot?

A. Create 3 calculated columns. B. Implement a union node and map each country as a separate column. C. Create a filter expression that uses an OR operator. D. Create a restricted column for each country.

Discussion 0

Correct Answer: D Vote an answer

Question 4

A calculation view consumes the data sources shown in the graphic. You want to identify which companies sold products in January AND February. What is the optimal way to do this?

A. Use an aggregation node. B. Use a union node. C. Use a minus node. D. Use an intersect node.

Discussion 0

Correct Answer: D Vote an answer

Question 5

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

A. To exclude columns that are NOT requested by a query to avoid incorrect results B. To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query C. To retain the correct aggregation behavior in stacked views D. To include columns that are NOT requested by a query but are essential for the correct result

Discussion 0

Correct Answer: D Vote an answer

Question 6

What options do you have to handle orphan nodes in your hierarchy? Note: There are 2 correct answers to this question.

A. Generate additional root nodes. B. Define an expression to determine a parent. C. Assign them to a node at the root level. D. Assign them to a level below the root.

Discussion 0

Correct Answer: A,C Vote an answer

Question 7

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?

A. Define a restricted column in a union node. B. Add an intersect node above the union node. C. In the union node, map both source customer name columns to one target column. D. Include an aggregation node above the union node.

Discussion 0

Correct Answer: D Vote an answer

Question 8

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

A. Only one block can be defined across a stack of calculation views. B. The block must only have one start node. C. The block must start with a node that defines a table as a data source. D. Multiple blocks can only be defined within a single calculation view.

Discussion 0

Correct Answer: A,C Vote an answer

Question 9

What is generated when you deploy a CUBE calculation view design-time file? Note: There are 2 correct answers to this question.

A. An SQL execution plan B. A column view in a container C. Cached results to improve read performance D. Metadata to enable consumption by external tools

Discussion 0

Correct Answer: C,D Vote an answer

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