You want to use a UNION to combine two information objects in a calculation view. Which steps do you have to perform?(Choose two)

• A. Define the mapping of columns of the information objects.
• B. Sort the columns in the output structure.
• C. Connect the information objects to the UNION node.
• D. Define a constant column in the target.

Table SALES_TABLE contains the columns COUNTRY and SALES.unction calc_tax calculates sales tax based on input parameter SALES.Using a scripted calculation view, how can you call the calc_tax function?

• A. :v_tax = SELECT COUNTRY, CALL :calc_tax(SALES) AS TAX FROM :SALES_TABLE;
• B. v_tax = SELECT COUNTRY, calc_tax(SALES) AS TAX FROM SALES_TABLE;
• C. :v_tax = CE_PROJECTION(SALES_TABLE, ["COUNTRY","CALL :calc_tax(SALES)"]);
• D. v_tax = CE_PROJECTION(SALES_TABLE, ["COUNTRY","calc_tax(SALES)"]);

A corporation with over 15 000 cost centers would like to ensure that only the person responsible for the cost center may view salary information for individuals assigned to their cost center.
How can the corporation achieve this in SAP HANA?

• A. Create a dynamic analytic privilege using the cost center and employee master data
• B. Create an object privilege on the cost center and employee master data schema
• C. Create an analysis authorization using the cost center and employee master data
• D. Create an analytic privilege using the cost center and the salary measure

Which of the following are recommended SAP HANA modeling principles?(Choose two)

• A. Join tables on key columns
• B. Use complex expressions like IF or CASE
• C. Filter the data amount as early as possible in the lower layers
• D. Always do the calculation after aggregation