What must you consider when defining analytic privileges using the DYNAMIC option? Note: There are 3 correct answers to this question.

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.

Why would you use the SQL analyzer? Note: There are 2 correct answers to this question.

What are some best practices for writing SQLScript for use with calculation views? Note: There are 2 correct answers to this question.

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?