You deleted the design-time file of a calculation view in your HDB module.What is the recommended way to ensure that the corresponding runtime object is also removed from the database?

• A.Execute a DROP statement in an SQL console connected to the HDI container.
• B.Execute the refactor function for the calculation view.
• C.Build the project that contained the deleted design-time file.
• D.Build the folder that contained the deleted design-time file.

Comment: *

Name: *

Email: *

Verification: *

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.You did NOT define a valid table type.
• B.Your function includes a TRUNCATE statement.
• C.You did not define at least one input parameter.
• D.Your function refers to a scalar function.

Comment: *

Name: *

Email: *

Verification: *

Why would you create SQL in calculation views?

• A.To enable write capabilities
• B.To fine-tune performance
• C.To implement custom logic
• D.To provide an alternative to graphical modeling

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

Comment: *

Name: *

Email: *

Verification: *

A calculation view includes a rank node that uses the source data and settings shown in the graphic. Your query requests all columns of the rank node.How many rows are in the output of your query?

• A.2
• B.9
• C.5
• D.6

Comment: *

Name: *

Email: *

Verification: *