C_HANAIMP_16 – SAP Certified Technology Associate - SAP HANA 2.0 SPS04

Select all that apply, then click Submit answer.

• ○

  Calculate distance between root and each hierarchy node
  

• ○

  Identify hierarchy nodes that have no parent
  

• ○

  Count the number of siblings for each hierarchy node
  

• ○

  Determine the shortest path between each pair of nodes
  

• ○

  Describe the relationship between nodes using attributes
  
  

Select all that apply, then click Submit answer.

• ○

  Use declarative language instead of cursors
  

• ○

  Use calculation engine (CE) functions instead of plain SQL
  

• ○

  Control the flow logic using IF-THEN-ELSE conditions
  

• ○

  Increase parallelization by using variables to break up statements
  
  
  

Select all that apply, then click Submit answer.

• ○

  Usage statistics of the calculation view
  

• ○

  Joins that are defined on calculated columns
  

• ○

  If the data is in the hot or warm storage tier
  

• ○

  Information about join cardinality