Online Access Free C_HCMOD_01 Practice Test

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 parent-child hierarchy.
• C.The hierarchy must be a local hierarchy.
• D.The hierarchy must be a shared hierarchy.

Which database features are typically NOT required by analytical applications that run on SAP HANA Cloud? Note: There are 2 correct answers to this question.

• A.Indexes
• B.Table partitions
• C.Pre-calculated aggregates
• D.Stored procedures

You have generated a calculation view properties file. What does it contain?

• A.Descriptions of all objects defined in a calculation view
• B.All settings defined in a calculation view
• C.Dependencies between calculation views
• D.Documentation to support the calculation view

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

• A.Partition large tables.
• B.Limit the number of stacked calculation views.
• C.Implement union pruning.
• D.Avoid aggregating data early in the data flow.

You are managing your source files using Git. In which sequence does your file progress towards a COMMIT?

• A.Staging area -> Working directory -> Local Git repository
• B.Local Git repository -> Staging area -> Working directory
• C.Working directory -> Local Git repository -> Staging area
• D.Working directory -> Staging area -> Local Git repository