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?

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.

You want to map an input parameter of calculation view A to an input parameter of calculation view B using the parameter mapping feature in the calculation view editor. However, the input parameters of calculation view B are not proposed as source parameters. What might be the reason for this?

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?

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.