Online Access Free C-HCMOD-05 Practice Test

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.In the union node, map both source customer name columns to one target column.
• B.Define a restricted column in a union node.
• C.Add an intersect node above the union node.
• D.Include an aggregation node above the union node.

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.Projection
• B.Union
• C.Aggregation
• D.Join

You create a user-provided service to access tables in external schemas.In which file type do you assign the user-provided service to your database module?

• A..mtar
• B..yaml
• C..hdiconfig
• D..namespace

Why would you partition a table in an SAP HANA Cloud database? Note: There are 2 correct answers to this question.

• A.To improve data replication performance on large row tables
• B.To improve response time when multiple users access the same table
• C.To improve query performance when accessing large column tables
• D.To overcome the 2 billion record limit

What are some of the typical roles in an SAP HANA Cloud implementation?Note: There are 2 correct answers to this question.

• A.Kubernetes expert
• B.ABAP developer
• C.Data architect
• D.Modeler