Online Access Free C-HCMOD-02 Exam Questions

When is the first column store compression executed?

• A.When a backup is started
• B.When partitions are regenerated
• C.When the table is created
• D.Question
• E.When a delta merge is triggered

In your calculation view, you want to consume a custom data source defined using SQLScript.In which type of object do you write your code?

• A.Procedure
• B.Scalar function
• C.Table function
• D.Anonymous block

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 a restricted column for each country.
• B.Create 3 calculated columns.
• C.Implement a union node and map each country as a separate column.
• D.Create a filter expression that uses an OR operator.

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?

• A.Union
• B.Aggregation
• C.Join
• D.Projection

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