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

Comment: *

Name: *

Email: *

Verification: *

You combine two tables in a join node using multiple columns in each table.Why do you enable the dynamic join option? Note: There are 2 correct answers to this question.

• A.To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query
• B.To ensure that the aggregation always happens after the join execution
• C.To ensure that the join execution only uses the join columns requested in the query
• D.To allow data analysis at different levels of granularity with the same calculation view

Comment: *

Name: *

Email: *

Verification: *

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..hdiconfig
• C..yaml
• D..namespace

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *

You created a table and inserted data in it using SQL statements inside the SAP HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to deploy it.What do you observe in the SAP HANA database container?

• A.The deployment is successful but the data preview returns an error message.
• B.The deployment is successful and the data preview returns expected data.
• C.The deployment fails and the table is dropped.
• D.The deployment fails and the table is not dropped.

Comment: *

Name: *

Email: *

Verification: *