C_HANAIMP_18 試験問題を無料オンラインアクセス

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

Why do you create calculation views of data category DIMENSION with type TIME?

• A.To add a temporal condition to a join to find matching records from two tables based on a date
• B.To store historical versions of attributes
• C.To provide additional time-related navigation possibilities
• D.To provide the time intervals required by time-dependent parent-child hierarchies

You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails.Which of the following could be a valid reason?

• A.Your function refers to a scalar function.
• B.Your function includes a TRUNCATE statement.
• C.You did NOT define a valid table type.
• D.You did not define at least one input parameter.

Which of the following approaches might improve the performance of joins in a CUBE calculation view?Note:
There are 2 correct answers to this question.

• A.Limit the number of joined columns
• B.Define join direction in a full outer join
• C.Use an inner join
• D.Specify the join cardinality

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