SAP C_HANAIMP_17 Online Practice Questions and Exam Preparation

SAP C_HANAIMP_17 Online Questions & Answers

• Question 21:

  How do you embed a decision tree in to your calculation view using a table function? Note: There are 2 correct answers to this question.

  A. Call the SAP-provided PAL decision tree procedure from the table function
  B. Use dynamic SQL in the table function to generate the SQL code
  C. Copy and adapt the SQL code generated by a flow graph into the table function
  D. Build a flow graph and call it from the table function using input parameters
  C. Copy and adapt the SQL code generated by a flow graph into the table function
  D. Build a flow graph and call it from the table function using input parameters

  ---

  Explanation/Reference:

• Question 22:

  In a calculation view, where can you insert SQL code?

  Note: There are 3 correct answers to this question.

  A. Hierarchy
  B. Filter expression
  C. Calculated column expression
  D. Input parameter
  E. Currency conversion
  B. Filter expression
  C. Calculated column expression
  D. Input parameter

• Question 23:

  What do you use a hierarchy function for? Note: There are 3 correct answers.

  A. Calculate distance between root and each hierarchy node
  B. Identify hierarchy nodes that have no parent
  C. Count the number of siblings for each hierarchy node
  D. Determine the shortest path between each pair of nodes
  E. Describe the relationship between nodes using attributes
  A. Calculate distance between root and each hierarchy node
  C. Count the number of siblings for each hierarchy node
  E. Describe the relationship between nodes using attributes

• Question 24:

  Which of the following data sources can you include in a graphical calculation view?

  Note: There are 2 correct answers to this question.

  A. SQL view
  B. Table function
  C. Scalar function
  D. Procedure
  A. SQL view
  B. Table function

• Question 25:

  You want to map an input parameter of the calculation view A to the input parameter of calculation view B using the parameter mapping feature in the calculation view editor. However, the input parameter of the calculation view B is not proposed to you as a source parameter.

  What might be the reason for this?

  

  A. You selected the wrong parameter mapping TYPE.
  B. The names of the input parameters do not match.
  C. You already mapped the input parameters in another calculation view.
  D. Your source calculation view is of the type SQL Access Only.
  C. You already mapped the input parameters in another calculation view.

• Question 26:

  You import a project that includes an SAP HANA database(HDB) module to your workspace. You need to create a calculation view that uses data from one table located in an external schema. Which of the following items must you build?

  Note: There are 2 correct answers to this question.

  A. Synonym
  B. .hdinamespacefile
  C. Authorization
  D. Project
  A. Synonym
  C. Authorization

  ---

  Explanation/Reference:

• Question 27:

  When would you develop an SQL procedure instead of a function?

  A. You need to implement Data Definition Language (DDL) statements.
  B. The code should modify data in the table.
  C. Optimal performance is apriority.
  D. You need to use conditional logic.
  E. You want to create a dynamic analytic privilege.
  B. The code should modify data in the table.

• Question 28:

  Why do you create a multi store table?

  A. To improve read performance when accessed by simultaneous applications
  B. To have the opt on to partition the table across different storage tiers
  C. To evenly distribute the data across all available server nodes
  D. To have a table that combines the characteristics of row and column stores
  B. To have the opt on to partition the table across different storage tiers

• Question 29:

  Your Web IDE for SAP HANA was updated to a new version. You want to implement the new features of calculation view modeling in your existing calculation views. You open a graphical calculation view but the new features are not displayed.

  What could be the reason for this?

  A. You need to update the project settings to reference the new revision.
  B. Your calculation views have not been built in the new version of the Web IDE.
  C. The calculation views have not been migrated to the new revision.
  D. The .hdiconfig file has not been updated to the latest calculation view build plug-in.
  A. You need to update the project settings to reference the new revision.

  ---

  Explanation/Reference:

• Question 30:

  You have a cube calculation view that consumes a dimension view. You suspect some dimension columns have been renamed in the cube calculation view. Which function of SAP Web IDE for SAP HANA do you use to check where the output columns originate from?

  A. Show lineage
  B. Database Explorer
  C. Where used
  D. Auto-map byname
  A. Show lineage