← Back to exam page

C_HANAIMP_18 – SAP Certified Application Associate - SAP HANA 2.0 SPS06

Loading demo links...

Showing 7–9 of 10 questions

Question 7

Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE calculation view?

Diagram Description automatically generated

Select an option, then click Submit answer.

  • ○

    A SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country = United States) on the DIMENSION calculation view
  • ○

    SELECT privileges and Analytic Privileges (Country = United States) on both views
  • ○

    A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION calculation view
  • ○

    A SELECT privilege and an Analytic Privilege (Country = United States) on the CUBE calculation view
Question 8

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?

Select an option, then click Submit answer.

  • ○

    Projection
  • ○

    Union
  • ○

    Aggregation
  • ○

    Join

Question 9

Why would you build a calculation view of type SQL Access only?

Select an option, then click Submit answer.

  • ○

    To enable SQL access to your hierarchies
  • ○

    To provide a data source that can only be consumed by a function or procedure
  • ○

    To provide a high performance model when only attributes are required
  • ○

    To provide a data source that is only consumed by other calculation views