C_HCMOD_01 by SAP Actual Free Exam Questions And Answers

Question 1

What must you consider when defining analytic privileges using the DYNAMIC option? Note: There are 3 correct answers to this question.

A. Only one scalar output parameter is allowed.

B. Output parameters types must be defined as INTEGER or NVARCHAR.

C. The procedure must be READ / WRITE.

D. No input parameters are allowed.

E. The security mode must be DEFINER.

Discussion 0

Correct Answer: A,D,E Vote an answer

Question 2

You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. DIMENSION calculation views provide the attributes. What is the correct approach?

A. Combine the transaction tables using an aggregation node in a calculation view of type CUBE with star join./Use a star join node to join the DIMENSIONS to the fact table.

B. Combine the transaction tables using a star join node in a calculation view of type CUBE with star join./Use the same star join node to connect the DIMENSIONS to the fact table.

C. Combine the transaction tables using a join node in a calculation view of type CUBE with star join./Use a star join node to join the DIMENSIONS to the fact table.

D. Combine the transaction tables using a star join node in a calculation view of type CUBE with star join./Use a join node to join the DIMENSIONS to the fact table.

Discussion 0

Correct Answer: C Vote an answer

Question 3

What are some best practices for writing SQLScript for use with calculation views? Note: There are 2 correct answers to this question.

A. Control the flow logic using IF-THEN-ELSE conditions.

B. Choose declarative language instead of imperative language.

C. Use dynamic SQL.

D. Break up large statements by using variables.

Discussion 0

Correct Answer: B,D Vote an answer

Question 4

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.

A. The imported calculation view and its data source have different namespaces.

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

C. The .hdinamespace file specifies a different namespace property than the one in the identifier of the calculation view.

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

Discussion 0

Correct Answer: A,B Vote an answer

Question 5

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 a union node.

B. Use an aggregation node.

C. Use a minus node.

D. Use an intersect node.

Discussion 0

Correct Answer: D Vote an answer

Question 6

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 7

You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL. Which of the following conditions must be met? Note: There are 2 correct answers to this question.

A. The hierarchy must be exposed by a calculation view of type CUBE with star join.

B. The hierarchy must be a shared hierarchy.

C. The hierarchy must be a parent-child hierarchy.

D. The hierarchy must be a local hierarchy.

Discussion 0

Correct Answer: A,B Vote an answer

Question 8

In a calculation view, why would you choose the DEPRECATED setting? Note: There are 2 correct answers to this question.

A. To lock the calculation view from further modifications

B. To ensure it is not exposed to reporting tools for consumption

C. To warn developers that the calculation view is no longer supported

D. To indicate that it should not be used as a data source to other calculation views

Discussion 0

Correct Answer: B,C Vote an answer

Question 9

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

A. To include columns that are NOT requested by a query

B. To allow filter push-down in stacked calculation views

C. To avoid columns being unnecessarily used in an aggregation

D. To apply filters that are hidden from the end user

Discussion 0

Correct Answer: B Vote an answer

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

Contact Us

Useful Links

Latest Updated